Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by kahless
-
Generating purchase orders for each supplier adding relevant products!
Thanks for the reply. I found a work around in the end which resulted in a massive data structure redesign. It doesn't work exactly as I intended but it does the job! Ta- kahless
- Post #3
- Forum: Microsoft: Access Other topics
-
Generating purchase orders for each supplier adding relevant products!
I am working on a database system for a small furniture retailer. I have uploaded a picture of the relationships because I don't know how I'd describe it otherwise! http://www.geocities.com/petehunt2000/relationships.gif I've hidden tables which aren't relevant. The StockTracker table...- kahless
- Thread
- Replies: 2
- Forum: Microsoft: Access Other topics
-
How to check if data already exists in a table?
Thanks for the quick reply. Works perfectly! Ta- kahless
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
How to check if data already exists in a table?
I am trying to construct an if statement which will perform a function on a string if that string does not does not already exist in a table, so that duplicates can are avoided. I am using the code: If IsNull(DLookup("[ID]", "testtable", [ID] = IDtest)) - [ID] is the field to check -...- kahless
- Thread
- Replies: 7
- Forum: Microsoft: Access Modules (VBA Coding)
