Recent content by binny45

  1. B

    Trying to set text box value within Form_Current()

    The VBA isn't picking it up.
  2. B

    Trying to set text box value within Form_Current()

    Ok, so basically use a form instead of the query itself. I'll give it a shot.
  3. B

    Trying to set text box value within Form_Current()

    I've confirmed by hardcoding in a value to test the validity of the Me.ItemCode statement and it works. I literally just need to see how to reference the Access 2002 database. I always thought I could use [Queries]![QueryName]![FieldName] to reference that value, but it doesn't seem to work.
  4. B

    Trying to set text box value within Form_Current()

    Alrighty, so I have a form where I select a "New" button and it provides a blank record for the user to fill out. I'm trying to have it so the Item Code (think barcode) is automatically provided by taking the value from a query that only has one entry, the newly created max item code value, and...
  5. B

    Question Access 2002 linked with MSSQL Server 2008

    Good Day Folks First time poster here. I've been searching through your forums for an answer to my question, but I've yet to find it so I'm hoping you can help. In MSSQL, I have three tables, one holding notification types, another for notifications, which includes an ID, a type (joined with...
See more
Back
Top Bottom