Search results

hey, Im afraid that i cannot change the layout of the form. I must have everything in one form and none of the controls are assigned to any fields. After the textboxes have been filled the queries should do the rest. This is the only way i have to do it.

Ok, look: When my order products form closes i have to update 2 tables: 1) tbl_Orders 2) tbl_Orders_Products. they both have a common field called Order_ID. When the form closes, i first run a query to add a row into tbl_Orders which creates a new Order_ID (auto-increcement). Then i run a...

I have already tried the method you are talking about, using DCount()+1. And yes i know that if records are deleted it is all messed up. That's why i came here ;)

hey, Can i use some kind of function to get the next Insert ID for an Auto Increcement field? I need it because im doing some complicated inserts inside a Form and i gotta know the next value that the auto-inc field is going to have. Is this possible using some kind of function ?

thanks for the help..

hey, I made a whole project in Windows 98 and Access XP and when i tried to run the same project on Windows XP with Access XP it got LOADS of ActiveX errors like when pressing buttons, Setting values through macros etc.. I also worked on the project on Windows XP + Access 2000 so the file base...

hey, A few questions here: 1) I want to take a field from a table, and set a label.caption to it. DLookUp("[Librarian_Name]","tbl_Librarian","[Librarian_User]=Forms![frm_Login]![txtUser] AND [Librarian_Pass]=Forms![frm_Login]![txtPassword]") That fails :( How else can i do it? (not using a...