I've had to change a few things in my database layout. An extra field was added to a table and this one field linking to another table has given a lot of extra functionality to the program. Though some of my querys were now messed up. After editing the querys, they seemed to work in query view...
Hi,
I have a lot of data that needs to be displayed, then edited and finally printed. Because it needs to be edited but not saved in the database, i can't use either form or report. I thought the best solution was to create an excel template with static cells for logo, field names, etc... and...
I didn't know how to describe this problem so i took a shot with multi join. I'll give you the scenario.
Table: Products
-> exists of many fields, 2 of them should be lead_plant and other_plant.
Table: Plants
-> contains: plant_id and plant_name
In the products table i'd like to make a join...
Hi,
I have a form with a few controls, simple button to add some information to a tabel in Access 2003.
I'm using a string "query" for the INSERT statement.
So when i wish to execute the query I just do
docmd.runSQL query.
Now the problem:
Adding the record works fine. It gets a new ID and is...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.