Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. LATECHmatt05

    Using the Dmax Function

    Hello Again, Sorry but I need some help I have a number field that I want to increment in a form when a new record is created. That means that I need to make of the dmax function. I do not understand how to use this function. I was hoping one of you could perhaps help me with some code for...
  2. LATECHmatt05

    Autonumber problem

    Hello, I have a problem I want to duplicate a record using a button in a form. The only problem is when I do it changes the autonumber Identifying number. I need this number to stay the same. Is there anyway to code a button in a form that duplicates a record without incrementing the value in...
  3. LATECHmatt05

    Option Button uses an SQL statement

    Hello, I have a problem I have three option buttons linked to three different yes/no fields that I want to have a query done on. I don't know the syntax for option buttons, but I would like to try to allow the user to pick one of the the three and link to an or statement. In other words lets...
  4. LATECHmatt05

    Tables that must be updated by different forms

    Hello, I have a rather odd problem I have one table that has a primary key and ofcourse some other fields. Now I have another table with the same fields ,but no primary key. What I need to do is to create a record in the table with the primary key and have that record go into the table...
  5. LATECHmatt05

    Query / Form Question

    Hello All, I have created a form to query a table with this forum's help I might add thanks. Well now my question is once I get the records I need from the query I want to use another form to modify a few of the fields in the record and then save the modified record as a new record. I am not...
  6. LATECHmatt05

    combo box problems with or statements

    I am having trouble with three combo boxes I want them to be or statements in SQL but within the vba i am writing for the clicking of a button on a form. I am really lost my syntax has to be wrong also how hard would it be to put and or boxes between the three boxes so that they can be (AND / OR...
  7. LATECHmatt05

    Text box problem

    I am new to access. Right now I have a form with a text box so that the user can enter a date and a query is called from the form and finds a record with that date. I keep getting runtime error 2001 each time I use the form. It is really weird I wonder do I need to edit my query. I will...

Part and Inventory Search

Back
Top