Recent content by banza

Try >Now()-8 OR IS NULL

If hiding the tables may be the solution for you, then have a look at this thread : hide table

Shanghai Hi Pat Shanghai is a wonderful city. I loved this city since my very first visit back in 1989. I believe you'll love it! Looking forward to c u . Meanwhile I will be around this forum as I have decided to learn this powerfull tool : MS access.

Correct Syntax Thanks Pat..... I got it. I wanted it just for display. Once again thank you. Hope to have the opportunity to return the favor. Whenever you come to Shanghai (China) I will be happy to have a drink with you. Banza

DMax() and autonumber Wayne thanks for taking the time to help. I finally got it to work. Don't know why, but I have to use the AfterUpate of the category field Me.Sequence = Nz(DMax("Sequence", "tblScreen", "CarModel = '" & Me.CarModel & "' And " & "Category = '" & Me.Category & "'"), 0) + 1...

Hello access friends, the following update query UPDATE Screen SET Screen.ScreenID = [CarModel] & "-" & Left$([Category],1) & Format(100,"000"); gives me duplicate values. How to avoid this and increment the next number? I have attached the database to show what I wanted to achieve in the form...

DMax() and Module for sequential autonumber Hello Access friends, Trying to have a sequential autonumber for the ScreenID with the DMax () function. Please advise on what is wrong with the following : =Nz(DMax("[ScreenID]","[Screenprep]","[ScreenID] = '" & [CarModel] & "-" & Left$([Category],1)...

the lostfocus event thanks Ruralguy, the lostfocus event solved it.

Hello Access friends, I have an unbound date field named txtDate with the following afterUpdate event. When I manually write the date the AfterUpdate works fine but does not work (the lblStock field doesn't get the value in the txtDate field) when I populate the txtDate field from a pop up...

Runtime error Hi Wayne, you have saved my day. It works.....thank you very much! May God bless you.

Hello Access friends, What is wrong with the following code (modified the module from http://members.iinet.net.au/~allenbrowne/AppInventory.html ): I Keep getting a runtime error 3061 Too few parameters . Expected 1 on the line highlight below. I have the reference MS DAO 3.6 selected and I am...