Search results for query: *

PHV, I did try it, but now it is working. The only thing I can think of is that it did save when I closed it. I am going to have the employee's try some of their other trouble clients and I will get back to you witht the results. Thank you again.

Thank you both for you resonse. I tried both options and it is still saying that the name is in the table. I am trying to enter the name of Anthony Reyes, and below is a copy of my sorted table with all of the R's that are close. Is there anyother way of checking for records in a table other...

Thank you for any help in advance. I have a form that the employees fill in the first, last, and DOB of a client and I have a the below script to look at the table to make sure that the name has not already been entered. It works too good. It is finding names that haven't been entered yet. There...

Thank you.

Thank you PHV That worked... :) Just for my understanding the ' is for text and the # is for numbers?

Hello, trying to understand what I am doing wrong. I have a DLookup to search the table for duplicate records before update, but it keeps producing an error. Any help would be appreciated. Private Sub DOB_LostFocus() If (Not IsNull(DLookup("[LastName]", _ "tbl_Client", "[LastName] ='"...

I know this will probably very easy to fix but it is driving me crazy.. I have a main form (frm_InventoryData) with a subform (frm_Transfer_sub). On the main form there is a combo box [Location] pulling from (tbl_Cubical, [Section], and I have the [From] Default Value on the subform pulling (...

This is probably is a very simple problem I’m sure, but not sure how to correct it. I have a form (frm_Client) with tabs, and one of the tabs has the product the client is purchasing. I have a field that the owner input the weight of the product. Then I have another unbound field that...

What did you do to get this to work. I have the same need. Thanks

Golom, Thank for replying. Your assistance was perfect. That was what I was looking for. And Daniel i will keep your code for future endeavors. Thank all,

This is probably very simple, but it has eluded me for two days now. What I am looking for is a Between criteria in a query that will allow the user to input the beginning month, day and ending month, day to search for anyone with a anniversary date in the chosen date range. I am trying not to...