Recent content by nicky1234567

Hi, i searched the forum for code on how to get my ActiveX calendar to automatically update todays date and for this to be shown every time the main menu form is opened. The code that I obtained was Me.Calendar2.Value = Date Calendar 2 being the name of the object I entered this code as it...

Can someone please help me. I was in the code view of my database and accidentally deleted a few lines of code and now everything i do is coming up with the same error message Module Not Found For every form I try to open it does this and even my buttons to close form and to exit system do not...

thanks, that has sorted the problem

i have created a form based on a query and basically the form comes up as a whole page spread and i would like it to just come up as a small form instead of a whole page. i think i go into properties and then choose the actual form but i just need to know how to make it so its small. Hope this...

thank you SJ you have saved me hours of trouble. i really appreciate it

I have tried entering that code and am still finding the same problem that when I enter a new member of staff the staffID is coming up as STA0000. Is there any way that the code that you sent could be incorrect or would it be an error on my part? I have followed all instructions correctly but...

Hi, i looked at the information for DMAX and have created this code which is not correct. Every time I go to enter a new staff member the staffID is coming up as STA0000. Would you please be able to advise me where I have gone wrong. Thank You Nicholas (Copied from Access) Private Sub...

Hi, I have a database with 8 tables. One of these being staff I have staffID as a Primary key in the table staff The format of this is "STA"0000 and input mask "STA"9999 I would like staffID to be automatically generated by taking the value of the previous staffID (eg STA0001) and creating a...