Search results

Thank you so much, that worked!!! Now let's just hope the users like it when I show it to them!! Thanks again for all your help and patience with my many questions! Laura

I apologize, I am not very good at writing code so let me see if I have this right. I create an unbound text box, this is what the users type the number in they wish to search for. I also create a command button and place the following code in the On_Click() event: Me.RecordsetClone.FindFirst...

The users could type in a text box. Could you explain it a little bit more though. Where would the code go, on the text box or on the command button??

Thank you, that would work, but the problem is there are currently about 3000 records in the table and that will continue to grow. It will be difficult for the user to scroll down and search for their number. I would like a way that prompts the user to just type in the specific number they...

I have a form that is password protected. Once the correct password is entered it asks the user for the IRR # which they want to update. The user enters the number and is taken to that record. The problem is the user may wish to edit another record while in the form. As of right now they...

I have placed the code in the before_update() event of the form and removed it from all the other places. This displays the error message when the form is closed, however, after the user hits ok on the error message the form closes anyways. Is there any way to stop this from happening? If you...

I already tried that with no luck but thank you. I now know not to use spaces but this db was designed about 10 months ago. Any other suggestions??

Back to original problem Well I am sorry for all of the posting, I am a basket case today, trying to get this done before I leave for vacation. I am back to my original problem. I figured out the code to do the check however, if the wrong number is entered I would like the cursor to return to...

Bigger problem!! What I am trying to accomplish with the code I posted is earlier is perform a check. I have a list of about 10 employee numbers. I need to do a check on the employee number field to make sure one of those numbers was entered. I was going to do If Not .....1234 Then MsgBox...

I have used code to check a field after data is entered. I placed the code in the After_Update of the field: If Not Orig_Employee_Num = 1234 Then MsgBox "Not a valid Employee Number, Try again" DoCmd.GoToControl "Orig Employee Num" Cancel = True End If The problem I am having is the cursor is...

Thank you both so much for all your help.

Thank you, that worked like a charm

This may be a not so smart question but I will ask anyway. Is there a way to copy or move a screen into Microsoft Word or Power Point? The reason being, I need to make up a training manual to teach users how to use a database. I need to display the form where the info in entered and than be...

I don't think it worked, in the field that was added with the formula I am getting values like 37216, 37219 when I run the query.

I am not understanding entirely, could you be a little more specific. Do I create a new query with only the date field in it and put that formula in that query?

Thank you. Well, the format was set to Short Date. However, I wanted it to automatically fill in todays date so I used the Now() not knowing that it put the time as well. I changed it to Date() about a week ago for another problem it caused so the most recent records do not include the time...

I figured out the problem, no solution I think I have figured out why it is not pulling all the records. For some reason in the combined field of Part Num and Orig Date that the query creates with the select statement, the date is displayed with the time as well (even though it is not like...

Thank you so much. I tried it out and it did pick up some records with the same Part Num on the same day, however it did not pull out all of them. Any suggestions as to why it missed some??

Could you please type out exactly what I have to put in there. The fields are Part Num and Date Orig. I have not written SQL statements before so I am a little lost. Thank you so much for your help. I really appreciate it. Laura

I need to create a query that shows if any records with the same part number were created on the same day. I am not looking for a specific day or part number. I need it to go through all records in the table and only display those records that have the same part number AND were created on the...