Search results

  1. C

    Dcount within SQL Select statement

    I have a reference database, where the references need to be screened by two independent reviewers. I need the references to load as the rowsource of a combobox only when the user has not already reviewed the reference or the reference has not been reviewed twice already. I thought I could...
  2. C

    SQL SELECT not recognizing table

    I am working on a project where two independent reviews screen literature (study) within a form. I created a combobox to allow the user to select the study, but can only select a study which they have not already reviewed and where the study was not already reviewed by two other people. For some...
  3. C

    Date in recordset leading to Update Edit error

    I have the following code to retrieve a recordset, which works perfectly. The issue comes form trying to assign the DateofClear data. It is retrieved correctly with the stored Short Date format, but when I run this where I assign the data to the text box on the form I get an 'Update or...
  4. C

    Public Variable losing value

    When the user logins in, I have a value in the profile to determine their access to the database. I edited out the code that doesn't apply Option Compare Database Public strUserID As String Public strUserAccess As String '------------------------------------------------------------ '...
  5. C

    Update SQL Date Issue

    I am building a password table that when certain criteria are met, the user must change their password. Everything works which is nice, but this update statement goes bad for some reason. I put a code break on the line of code and everything shows the correct information for the variables, but...
  6. C

    Verify password does not match previous 10

    I have compiled this code from plenty of previous posts and it nearly does everything I need. The last part I am missing for compliance is to verify that the employee's new password does not match any of the previous 10 passwords. Does anyone have any suggestions for efficient code or a sample...
  7. C

    Data Type mismatch

    I have the following query built and I get a "Data type mismatch in criteria expression" error. frmEmployeeBackground.EmployeeID is set to Format>General number, tbl_Employees.EmployeeID is a text primary key so I have identified that as the cause of the trouble, I just don't know the...
  8. C

    Find recordset based on form selection

    I have been trying to have a form that would push data from Access to a Word document with bookmarks. (I would make a report, but the forms are controlled by the government.) On the form the user selects the ProjectID (displayed as the project name on form) and I need to export the project...
  9. C

    Junction Tables - Required Training by Position

    So moving this from the forms section. I have a table (tbl_CourseList) of training course (CourseID, CourseName, ExpirationPeriod) and I have a table (tbl_NCS_Role) of Job Roles (NCS_Role, TDLR_Code). To clarify the TDLR is a code which could be made of multiple NCS_Role records (e.g. roles...
  10. C

    Combobox to add new column

    I am fairly new and have not found what I need through searches. If you have a link to something that could help, that would be great. I have a form for a Required Training table. The table contains the Course ID, Course Name, Job Titles. Each Job title is set to a yes/no to indicate if the...
  11. C

    Fill Form to Update Record from Combobox selection

    I am a total noob to Access (this is day 1), though I did teach myself VBA in Excel. I am having a lot of trouble with this and I am not sure if it is my thought approach or that I am not comfortably finding the automation in 2007 fun. I am trying to make a simple employee training dB and...
Back
Top Bottom