One form multiple databases

[Kennyej]

Background: I taught myself excel from scratch. I would say I am better at it than the average excel user. However, I know there are mountains I have not yet began to ascend. I've started a new job that has to do with accounting and now I want to figure out access. It's not hard: databases, forms, queries... Their relationships and uses. I understand the concept and can google how to do specific things if I can't figure steps out.

QUESTION 1: How do I create a form that I can enter data into different databases with depending on the vendor. Every database has the same fields: vendor, PO, cost, invoice date, cost code. It's just that different vendors are in different databases for a reason.

Thanks for taking the time to read this post.

[ranman256]

Do you mean 'databases' or 'tables' (within 1 database)?
if databases, then can you consolidate them? why different databases?

you can LINK the different tables in the different databases.
this way they are all in 1 database , but separate tables.

[CJ_London]

How do I create a form that I can enter data into different databases with depending on the vendor.

you have one form and just relink the linked tables to a different backend - google 'linking by vba' to find out more.

It's just that different vendors are in different databases for a reason.

must be a good reason, it is probably the most inefficient way of doing it

[June7]

Unless you expect database to exceed 2GB size limit, there is probably no justification for separate files. However, if they use autonumber PK, combining them now would not be a simple task. So have to live with the complication of multiple backends.

Code to reset table links: http://forums.aspfree.com/microsoft-...ue-323364.html

[Kennyej]

The document was created by my predisesor and I agree that multiple tables is inefficient. So let's say I just add an additional column(pardon the excel terminology) and combine them into a signal database. To make the form easier I would use combo(drop down) boxes. Is it possible to make it so that if you select one option in the first combo box that the next combo box will only list applicable choices? For example:

Combo box 1: outside, inside

Combo box 2: car, oven, lawn mower, washing machine

If I select 'outside' in combo box 1; then only car and lawn mower are available for selection in combo box 2.

If I selexr 'inside' in combo box 1; only oven and washing machine are available for selection.

Thanks for he quick responses!

[ssanfu]

Yes. This is commonly referred to as "Cascading combo boxes".

Attached is an example of a dB I created years ago with multiple cascading combo boxes.
There is also a form with cascading List boxes.

It was a learning experience for me.....

[June7]

And if you want a video to guide you http://www.datapigtechnologies.com/f...combobox2.html