Search results

  1. A

    Non-Existant Data Report

    sorry, but not sure what info you need! I have tblP_BasicDetails - (BD_ID, BD_Name, BD_address, BD_dob etc), i have tblTrainingReceived - (TR_ID, BD_ID, TR_Name, TR_DateRecd, TR_DateExp etc) and the only other table is a look up table with all the training types - (tblTraingType, TT_ID...
  2. A

    Non-Existant Data Report

    I have tried a "null" query but it came back with no records. My training report shows excatly that, all the training on the system. Am i thinking about this wrong?...would i be better basing my report/query on the training type then who has that type v's who doesn't rather than on an...
  3. A

    Non-Existant Data Report

    Hi, i have nearly completed my database and i have learnt a lot with help from here but the last thing i think i am stuck on is.... I need to design reports that show when employees do not have a particlular type of training. EG I have First Aid, I need a report that will show which employees...
  4. A

    'Updated Last' field

    I have now created a logon page where users choose their name and enter a password to get on database. the details: SELECT tblEmployees.[lngEmpID], [tblEmployees].[strEmpName] FROM tblEmployees ORDER BY [strEmpName]; I have many forms with an 'updated by' field (i need to know the last...
  5. A

    Create Log In and Password Page

    got the log in and password to work all great thanks!!!!
  6. A

    Create Log In and Password Page

    Thank you Shadow9449, it was not intentional to post the question twice!!! Thank you Speakers, i will have a look and let you know how i get on!! :)
  7. A

    Create Log In and Password Page

    I did think of that but unfortunately people often use other work stations. What i reallly want, and i did try the Forms![frmLogin]!txtUser etc etc but having no joy, i just need a log in page that opens when the database starts (Done) and then either a box to type in name and password, (like...
  8. A

    Create Log In and Password Page

    Thank you, i have now a combo box with a few peoples names on frmLogIn and a Login button. I choose the name then click login and the form closes whilst opening frmMain. I have a text box which i want to show the name of the person logged in but if i type...
  9. A

    Create Log In and Password Page

    Hi, any help with this would be appreciated as i am not sure what to even search for in help. I have created a log in page which will eventually open on load, it has a drop down field with user names where the user can select their name and then i require individual passwords. Is this possible...
  10. A

    Create Log In and Password Page

    Hi, any help with this would be appreciated as i am not sure what to even search for in help. I have created a log in page which will eventually open on load, it has a drop down field with user names where the user can select their name and then i require individual passwords. Is this...
  11. A

    DateDiff

    thank you so much!!!! i am getting it now i think
  12. A

    DateDiff

    Oh god...please help - i have tried so much.... here is where i am and it still won't work!!! DateDiff("d","TR_DateExpires","Date()"[vbMonday],[vbFirstJan1])
  13. A

    DateDiff

    Hi, i am obviously missing something as i still can't figure it out! :-(
  14. A

    DateDiff

    Hi, I am new to this site but i have a problem which is driving me mad as i think the solution is so easy!!... I have two fields in my table/form - TR_DateExpires and TR_DaysLeftUntilExpired...... I want to have TR_DaysLeftUntilExpired automatically calcualted ie how many days left between...
Back
Top Bottom