Search results

  1. N

    Macro Error??- ActiveX Calendar Control

    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...
  2. N

    Deleted some code, now nothing works

    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...
  3. N

    Making a form so its not a whole page. Must be so simple

    thanks, that has sorted the problem
  4. N

    Making a form so its not a whole page. Must be so simple

    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...
  5. N

    Help with Simple SQL Code Required Please

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

    Help with Simple SQL Code Required Please

    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...
  7. N

    Help with Simple SQL Code Required Please

    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...
  8. N

    Help with Simple SQL Code Required Please

    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...
Back
Top Bottom