Recent content by wop0703

I have a form, created from a query. The query contains and links about six tables using an AutoNumber ID. The query also has fields from each of these tables. OK, so when users enter their data into this form, I would like the autoincremented number to increase in each of these tables. The...

I have a form, created from a query. THe query contains an links about six tables using an AutoNumber ID. OK, so when users enter their data into this form, I would like the autoincremented number to increase in each of these tables. The catch is that when the user enters data he/she does...

Can I have a primary key in my table as an autoincremented number that starts at, say 618 instead of 1??

I would like to have a form that simply has 4 or 5 due dates for certain things. I would also like to have a countdown field that takes todays date and all of the due dates and tells me how many days i have until then. Is this possible? And, if so, can anyone help?

The reason I wanted another table was that some information the user has inputted is used elsewhere and must show up in another form and the user will have to input more data depending on his selection in the first form feeding the first table.

I have a table that is linked to a form. The user can enter information in the form and it is saved in a table. I want to make another table that only pulls certain information from the table that is being updated by the form. This new table must be able to be updated as well. Any suggestions?

Yes I did. I have the value of Freshman in a text box that is not enabled, is this ok?

OK, another visibility question. The same form's information is placed in a table. It takes 3 pieces of information from that table. One piece of the information is a year field (has either freshman, sophomore, junior, or senior). I want a text box to appear when the field has freshman in...

You two are great. Thanks for your help!

For some reason, it is not working. It doesn't make much sense to me. Here is my exact code: Private Sub Type1_AfterUpdate() If Me.Type1 = Check Then Me.Check1.Visible = True Else: Me.Check1.Visible = False End If Me.Refresh End Sub Type1 is my combo box Check1 is my text boxI want visible

I put the code in the after update of my combo box and nothing happened. Do I need to put it somewhere else?

Check this out. http://www.access-programmers.co.uk/forums/showthread.php?t=92050 I think this thread will help you.

In my form, I have a combo box with one of three options (cash, check, reimbursement). If the user chooses check, I want a text box to become visible, so the user may input the check number. I thought I could use another invisible text box to store the value of the combo box and then in the...

I have a form that had two active x calendars on it. The form itslef is pretty simple. I want the user to choose a begin date by clicking the appropriate date on the first calendar and then choose an ending date by clicking on the second calendar. here is what I cannot figure out. I would...

And I fixed it. User error. I was typing Columns instead of Column. I apologize for all of this. Thanks for your help.