Search results for query: *

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...

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...

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...

I have one table with a primary key that is autonumber I call that field RedispatchNo. Below is how my two tables look TABLE1 (Primary key)RedispatchNo. Date Time CurrentMW RequestedMW TABLE2 RedispatchNo. Date Time CurrentMW RequestedMW Table 2 needs to take records for...

I tried that and it didn't work I probably did something wrong. all I want is whatever I type as a record in one table to wind up in the other table. I am sorry for the inconvenience but I am very new to Access.

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...

I do have some field that will be static and some that will not be actually it is about half and half. Now the other thing I need to know is after my code how do I open the records query in form view? Here is the code I have for my query form; it works but I doesn't open the record in form view...

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...

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...

thank you all very much. I do have one more thing though how would I write a BETWEEN AND statement in this code if I had another box named DateB?

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...