Search results

  1. S

    Multiple Criteria in a Query

    Hello, I want to create a query with multiple conditions. See attachment..Basically if the person Passes any of this trainings they need to show up in my query..how do you do it? SELECT tblMasterUsers.userid, tblMasterUsers.Licenses, tblMasterUsers.firstname, tblMasterUsers.lastname...
  2. S

    vba iif statement

    hello, Here is my code, I have a check box "Complete" that when selected i want only those records where the Complete field (check box) is True..if else only those completed field is False..How do I use this in VBA? Also I have several conditions on the tblUsers that I want to show on my check...
  3. S

    Queries to Extract Multiple Criteria

    Hello, I need help desperately:( I have 2 tables (tblUser) and a Linked Excel spreadsheet (CMPReport) . "I attached a relationships screenshot" TblUser has all users register to our site. CMPReport has all Training (4-5 Certificates) those users need to complete and has to be uploaded...
  4. S

    link data

    Hi, so here is my situation. I have 2 tables tbluser and tbltraining, the user table has all people register to our site and training table all training information( they must complete 3 modules at any given date). The tbltraining is a linked excel spreadsheeet because it changes daily and I...
  5. S

    Dlookup in form

    Hello, I have a question, I want my form frmintake to lookup with values from another table and populare county once the zip codes has been entered. I have a table called tblintake and another tblcounty. tblintake has zip codes entered manually tblcounty has zip codes and counties for...
  6. S

    Sending mail via Lotus Notes R5 using VBA

    hello, How can you run this code from a Form..New to Access. :banghead:
  7. S

    Database Security

    I researched throughout the Web the security wizard in access 2003 and agreed. How can unsecured the database
  8. S

    Database and Lotus Notes

    Hello, I have a database designed in 2003 that I want to be able to click on a command button "cmdsentemail" and populate a text in the body of a new Email in Lotus Notes 8.5; Can someone provide the code so I can format it and work around to help me with my problem, I have a table called...
  9. S

    Database Security

    Hi, Im new to Access Security, I created a DB for for about 12 people and I just set up the security using the Wizard. Some could not access and are getting this error message, I use this the following path for admin only, but I want to give view rights to others. Im lost:banghead: "C:\Program...
  10. S

    New Member

    Hello, I am delighted to find an active access community. My name is Enrique and I work in Sales Support. I live in the Los Angeles Area in Calif. I'm still going through early stages of Computer Science at Pierce College, but I learn a great deal about programming.
Back
Top Bottom