Search results

Hi Karim Your tables have some design issues. You should not use Lookup Fields in table. Check Google for "The Evils of Lookup fields in Access Tables" You have not set referential integrity between tables. You should not set the Format of your Autonumbers to 000 You should not set the record...

It might be a better option to explain your more complex case.

Can you upload a copy of your database?

The attached is another way of doing it.

Can you upload a copy of the Db?

Hi See the modified Order Form in the attached. Now when you create a New Order and add multiple items you can then Click the Command Button "Preview order"

Well you learn something everyday.

Hi Ken Please ignore my ignorance but I was always under the impression that if you have a ProductID as the PK Long Integer Autonumber you would not be able to have a 0 value

Hi I noticed a slight problem when trying to set and enforce Referential Integrity between your Tables OrderDetailT and ProductT. I get the error shown in the attached. This occurs because you have the field named "ProductID" in the OrderDetailT with a Default Value of 0 Your ProductT does...

This is a year old thread.

Hi All I have used it for is just to send Emails

Hi Colin I have used Thunderbird with Access and it works a treat.

Just a comment. A lot of your Tables contain Lookup Fields. You should not use Lookup Fields in tables. Google "The Evils of Lookup Fields in Access Tables"

Can you upload a stripped down version of the database with just the tables and query?

Hi John Your tables/Relationships should be as shown in the attached.

yes thanks

If you don't mind me asking but what is the point of this as an Access Database?

Hi I believe you need to have a rethink on the structure of your tables. The attached is an example Relationship Diagram produced by Github. See this Link

Hi Barbara The database you uploaded has a table named "Investments01_tbl" with 18 Records. The other related table named "Investments01_tbl_SubForm" has over 24000 Records. We need the original "Investments01_tbl" with all current records. Also the Form with the error is based on a Query? The...

No it is not. The process is that you click the Reply button and enter your answer. Then click the "Attach Files" button and navigate to the database file you want to upload. Make sure that you compress the file into a zipped format. Then select the compressed/zipped file and click Open. The...