Search results

  1. B

    syntax error (missing operator) in query expression

    what it originally wanted this macro to do is to record the date the user put but for some reason it would record a completely different date in the table for some reason it was putting a date from 1899. so instead im trying to get it to put the system date at the time of adding the record...
  2. B

    Creating a Dlookup on a form

    cheers minty been a huge help
  3. B

    Creating a Dlookup on a form

    thanks minty i managed to sort it out through macros and it worked using your code Me.txtFirstName = Me.Combo24.Column(1) im thinking using macros is easier than using functions right now haha
  4. B

    Creating a Dlookup on a form

    =DLookUp("[firstname]","[primeusers]","[userid] = " & [Me].[Combo36]) so took your advice took out the spaces out of the fields and used no special characters when trying out the combo box where it auto updates the other text boxes i had to delete the combo box so the combo box has changed
  5. B

    Creating a Dlookup on a form

    hello i tried both of what you suggested and i cant get them to work i must be doing something wrong
  6. B

    Creating a Dlookup on a form

    Hello everyone i am very new at using access. what I am trying to do is when i type in Someones User Id in this form i want 3 text boxes to auto populate with the users first name last name and shift from a table. if there is a easier way than dlookup please say so for one of the text boxes i...
View older results
Back
Top Bottom