Search results

Ok. That works. One more question (for now). Is there a way of telling the auto number field, which is my primary key, not to be a negative number. To only use positive numbers? If not is there a way of incremental numbers to start for a certian number and not 1?

How do you create a bound form or bind my existing form?

I dont what to bind the whole form because when I do it opens with table data already in it and I don't want that. I just want the user to input data. Click on Add and have the form refresh with the data they just entered and the new autonumber that is assigned to that row populate in the...

Ok. What about this then. When the data is entered it creates a new row with a random ID#. How do I get the ID number to populate in the form after the update?

Holy crud. That actualy worked. Thank you very much.

Hello again. This is probably going to be and easy one for you all but I just cant figure it out. I'm trying to get the inputed data from a forms test boxes to be put into a new row in a table. Here's what I've got: Private Sub AddNewUser_Click() SQL = "INSERT INTO tblUserInfo(FirstName...

Ok. I figured it out. I needed to put in [Forms]![frmDataUsage]![cboEmployee] into the critera for the query. Thank you for your help.

That's what I do have. I have it that when you click on the select button in the query that it creates a table useing a make table query.

Hello, I am having an issues where I have a form with a start and end date combo boxes and also an employee combo box. I want the user to be able to select a start and end date and an employee name and display an excel sheet with the stuff that was done for that date range for that person. I...