Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. DraGo150

    DLookup working too good...

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

    DLookup working too good...

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

    DLookup working too good...

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

    DlookUp Run Time Error 3464

    Thank you.
  5. DraGo150

    DlookUp Run Time Error 3464

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

    DlookUp Run Time Error 3464

    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] ='"...
  7. DraGo150

    Defualt value in subform

    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 (...
  8. DraGo150

    Simple Form Problem, Not sure what to do. Data not going in.

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

    Check if record exists and then advise user

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

    Simple Anniversary Date query.

    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,
  11. DraGo150

    Simple Anniversary Date query.

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

Part and Inventory Search

Back
Top