Search results

Thanks alot. It did help.

I have a form. On the form is a pull down menu. When I select a certain value called "Ready" in the pull down menu, I would like to make the cursor go to another text box on the form named dpre. This will make the user fill out that section of the form which is required to fill out if 'ready' is...

I am not sure how to write the code for this. I tried, but the cursor did not appear in the text box I wanted it to. The form is Invention Disclosure, the text box i want the cursor to end up is 'dpre.' Where would I put it in my code. Would I put it where I put the code for the message box...

I have a form. On the form is a pull down box. When the user clicks a submit button on the form, it displays a message box if the name field is not filled out. I want to make it so that after the user clicks 'ok' on the message box, the cursor goes to the name text box so it makes it easier for...

I get a runtime error and I am not sure what is wrong with the code. The error says Run-Time Error 3075 Extra ) in query expression '([ID]=)' The code is DoCmd.SetWarnings False strquery = "DELETE * FROM [Docket Projects] WHERE ([ID] = " & ID & ")" DoCmd.RunSQL strquery...

Im really unfamilliar with access, how would I go about doing that? Im not sure how to use Dlookup.

I have a form, where the users choose a name from a pull down box and enter the date and other information. The pull down box has more than 100 names. The information such as the name, date, etc. gets stored into a table. It is fine if a certain name appears more than once on the table. I want...

I have similar text boxes on two different forms. On the first form when I add a value and click the add button it automatically submits that value to the second form. However, on the second form when I select a value and click add, it deletes the previous value given by the first form. I have...

On my first form I have a pull down box and when I select an item and click the add button, the item appears in a locked text box above the pull down box. After I click the submit form button, it goes to another form. On the other form is a similar pull down box and locked text box. So far I got...

On my first form I have a pull down box and when I select an item and click the add button, the item appears in a locked text box above the pull down box. After I click the submit form button, it goes to another form. On the other form is a similar pull down box and locked text box. So far I got...

I did not get an error message. In the one box where the first and last name combined should be is "#Name." The box where it should be combined is unbound. Basically the first form has two seperate fields for the first and last name. After the user is done inputing information, he/she clicks...

I tried that but for some reason it did not work. The value for the first and last name in one box also gets updated into the table. Im not sure if that matters.

Sorry for the lack of information. My first form is opened first and it is bounded to a table. Whatever information I put in this form, gets updated to a table. On the bottom of the first form is a button. After you are completed with this form, you click the button and it takes you to the...

I have a form with a box for the first name of a user and another box for the last name of the user. On another form, I want the first and last name to appear in the same box. Any ideas on how to do the code for this. I am very new at this. Thanks for your help.

The first and last name are in the same column. The last name is capitalized while the first name is in lower case. Thank you

I have a combo box which has a list of names. The last names are all capatalized, while the first names are lower cased. I was wondering in the Row Source code under properties if it was possible to just take the capatlized letters. Is there a code for that? Example SMITH, john I want the...

I have a combo box on one form filled with inventor names. There are 10 of these combo boxes. If any number of these are filled, I want it to take the names and automatically put it in another form under inventor names. RIght now I have used a If then statement, but it only transfers the names...

Each form I have has a ID number. I have created another form which is used for a different purpose. This form is based on the first form. Each form has similar text fields such as First Name, Last Name, Date, and Phone Number. I wanted to know how to insert the similar data from the first form...

I am very new at Microsoft Access. I have two forms, A and B, that are filled out by two different users. Form A gets filled out first than form B gets filled out. Each has a name box as well as a birthdate box and a few other similar text fields. However, each form also has a few distinctive...

I am very new to Microsoft Access and I needed some help. I added a combo box to a form and I want the value in that combo box to appear in a table. I was wondering if anyone knew the correct code to do this. I would really appreciate some help. Thank You.