Recent content by adammorrisey

  1. A

    Need to do an SQL "UPDATE [Table] INNER JOIN" operation in VBA

    What doe the "= False statement mean" ?
  2. A

    Need to do an SQL "UPDATE [Table] INNER JOIN" operation in VBA

    Hey guys, I'm trying to add some SQL to a button click subroutine in VBA, but I'm not really sure how to use SQL in VBA, esspecially an UPDATE or an INNER JOIN operation. So I was wondering if someone here can help me or even write out what I need to put in my subroutine. Here is my SQL...
  3. A

    Adding new record, not visible in table

    woops, heres the file
  4. A

    Adding new record, not visible in table

    Hey guys, I am having trouble here and can't seem to find the problem. I am trying to add a new record to a table called "SIGN_OUT" Where an employee can sign out a tool from an inventory of tools. The SIGN_OUT table has the following properties SignOutID (PK) - autonumber EmployeeCode (FK)...
  5. A

    Adding new record, not visible in table

    Hey guys, I am having trouble here and can't seem to find the problem. I am trying to add a new record to a table called "SIGN_OUT" Where an employee can sign out a tool from an inventory of tools. The SIGN_OUT table has the following properties SignOutID (PK) - autonumber EmployeeCode (FK)...
  6. A

    Need Help creating Global Variables in a Module

    Let me start off by saying that my coding experience if fairly limited, I have used Access for about 4 months now for a course. Now to my problem.... I want to create a global variable "EmployeeCode" so that once a user signs in using their password on a form, all the additional forms would...
  7. A

    Problem Please Read

    I have never created a Module before and my experience with coding is pretty limited,
  8. A

    Problem Please Read

    So I created an inventory management database, where a user has to log in with a password using a form, from there they can sign out or sign in a tool that is in the database. I have a table EMPLOYEE - PK(EmployeeCode) linked via a 1:M relationship to a table SIGN_OUT - PK(SignOutID)...
See more
Back
Top Bottom