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

Thank you. The three values are in different text boxes, but I want to have them in that format so I can search through a column which has that format. SO if it finds something with the same format a msgbox will pop up. for example lets say we type in Red in the first text box, 66 in the second...

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 inserted the code, but it gives me an error message whether I put a comma in the text field or if i leave it out. Not sure what the problem is.

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

Thats great, Thanks for all your help. I think I will add beeps.

Alot of times, the user will just click ok with out reading the message. The message is pretty important and the user must read it. I know, it would annoy me too, but if blinkin I know I would take some time to read it.

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

That code does not give me the right results. It says "Enter Parameter Value." Not sure what to do with that. Is there anyway I can use my initial code because it gives the correct results but only when I do them seperately. I need a AND so they can find the complete ID (dsuf and dpre).

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

ok so I got it. For future reference for other I added DoCmd.OpenForm "Dockets Data Input Form", acNormal, "", "", , acNormal DoCmd.GoToControl "Patent Type" DoCmd.FindRecord Forms![Invention Disclosure Input Form]![dsuf] to my onclick event. If I want to add another field so it searches...

it is supplementary information to the record. .

Table 1 and Table 2 are not linked. It is just that the ID, name, and date of form1, all automatically get transferred to form 2. So they get inputted in table 2. For example If I put "Sam" for the name in form1. Sam gets inputed in the name field of table 1. When I submit the form1, the name...

Table 2 which is bound to form2 has a few entries from table 1 such as name date etc. I will try the code out at work tomorrow.

sorry for the confusion. I guess I am using the word value loosely. Basically, I have two forms (Form 1 and Form 2). Each are linked to different tables (table 1 and table 2). When the user clicks submit on form 1, it goes to form 2. Now on form 1, there is a text box so the user can input...