Search results

I am gettin ga "write conflict" error and i am not sure why this error is popping. It has three options "save changes", "copy to clipboard", and "Drop CHanges." How can I get rid of this error. Any information would be helpful. Thanks

I have three text boxes that are not linked to any tables. I want to combine the three text fields so that I can use this to search through a column in the table. The format I want is text1-text2 text3. I am not quite sure how to combine the three texts. I ahve tried " & Me.dpre & "-" &...

I was wondering if there was a way to automatically click a button upon entering a form. I have a form, and when I enter into to it, I would like it to automaically click one of the buttons on that form. Any suggestions would be nice. Thanks for the help.

I have two forms. When I enter a textbox on the first form and enter a date and exit the text box (on exit event), it opens up the second form, which already has previously entered data in it. Upon entering this second form, I would like to automatically change one of the fields from a "Yes" to...

I have a message box that displays numbers. I was wondering if it was possible to make the numbers in bold or in a larger font? Thanks for the help. MsgBox("Please add the Invention Disclosure Number " & right(Me.Discl_Year, 2) & "-" & Me![Discl Number] & " to the Docket Form.", vbOKCancel +...

Not sure what is wrong with my code. I am trying to open a form based on the siffix and prefix. It just opens up the first form created. They are both text fields. Any suggestions would be appreciated. Thanks. Dim stLinkCriteria As String Dim strdsuf, strdpre As String strdsuf = Me.dsuf...

I have a text field and the user enters is supposed to enter a name in the format Last Name, First Name. However if the user does not enter with the correct format, then I want an error message to pop up. Basically if the user does not enter a comma (,) in their input, then I want an error...

Is It possible to have a blinking message box or a blinking button. If so how would I implement it. I want some type of message box that will get the users attention. Any ideas would be appreciated. Thanks

I am trying to execute this code. I have a edit form and when I click edit, it should open up the form "Input Form." It should open the specific form based on what the user enters for "name." I get an error (RunTime 2137) saying "You cant use Find or Replace Now." I am not quite sure why this...

I have this code which pulls up specific forms based on 'dsuf'. If dsuf = RGA, it pulles up the forms with RGA. I have another field called dpre. 'dpre' and 'dsuf' make up the forms ID. dpre and dsuf are stored in a table. Is there a way to combine these two groups of code so that if a form has...

I have two forms. They are both linked to different tables. In addition form 1 corresponds to form 2 through an ID value (text box). If the user inputs a ID value that already exists in form 1, I want the corresponding form 2 to open. Basically I want to open a specific form. I have written the...

I have a form with a certain ID number that the User enters. The ID number is 3 fields (2 text and 1 numeric). The two texts are pull down boxes. If the user enters an ID number that already exists, I have a message that says "This ID number Already exists." I have the code that searches for the...

I keep getting an error on my code. the error says, cant find the field " refered in your expression. Basically i am trying to compare 3 fields with the same fields in the All Data Table. The three fields are dpre, dsug, and dnum. The data table is All Data Table. If the 3 fields are the same as...

I have one form (called Sheet 1) that has a pull down box called status. On a second form (called Sheet 2), I also have a pull down box called status. However they have different values in the pull down box. If the user in form one selects "Ready, " and clicks submit, I want the form 2 status...

I have a form with a pull down box which has a list of about 50 names. The last names are capatilized and the first names have the first letter capitalized and the rest lower case. For example, SMITH, John DOE, Sam The user can input their own name if it is not included in the pull down...

I have a form with a pull down box which has a list of about 50 names. The last names are capatilized and the first names have the first letter capitalized and the rest lower case. For example, SMITH, John DOE, Sam The user can input their own name if it is not included in the pull down...

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

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