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

    Deleting Records...

    ...I put your code. I am using a query instead of a table, as my control source for the form. So this is my sSQL statement: sSQL = "DELETE * FROM queryname WHERE [table].[PartID] = " & Me!PartID This did not work. When I try to use the button, the message box comes up and then I...
  2. waldo7474

    Deleting Records...

    I am pretty new to the whole Access thing, here is my question: I have a form with a subform. I am trying to make a delete record button. I would like to be able to delete the main record, as well as any underlying record in the subform (not as concerned about the subform, but it would be...
  3. waldo7474

    Resetting a filter...

    That didn't seem to work. It still doesn't find any records. At best it finds one. Is this a normal problem?? Any more help would be greatly appreciated. Thanks!! Wally
  4. waldo7474

    Resetting a filter...

    ...the function know if there's more than one criteria If Not IsNull(PartNumberLookup) Then FilterString = "[PartNumber] Like '*" & PartNumberLookup & "*'" multVar = multVar + 1 End If If Not IsNull(DescriptionLookUp) Then If...
  5. waldo7474

    Making numbers in text behave like numbers...

    Thank you both for your quick responses. I tried both solutions. And unfortunately there are letters in some of these part numbers and to make it even more complicated, sometimes there are more than two dashes. Why do people do this to me? So BeeTee, your code won't work at this time because...
  6. waldo7474

    Making numbers in text behave like numbers...

    Hi Beetee!! Thanks for the quick response. I have come across a couple of questions while I look at your response. I want to get the numbers in sequence based on a query. I tried to write an expression, and I am missing an argument. I do not know what to put there. This is what I have in...
  7. waldo7474

    Making numbers in text behave like numbers...

    Hi All!!! I had posted this in the "forms" forum previously and got some help, but had some problems, and got no responses. I was hoping someone in here could help. I have a part number that in a table, it is a "text" field because I have hyphens in it. There are three...
  8. waldo7474

    Making numbers in text behave like numbers...

    Thanks for your help guys. I tried both methods and still have errors. I don't think I am doing anything wrong, but I must be or else I wouldn't get errors. I am going to try to copy the things out of my database so you can see if I have typed anything wrong. I should probably state that...
  9. waldo7474

    Making numbers in text behave like numbers...

    Thank you both again for your puick responses. I have tried Jeff's suggestion because the dashes don't always belong in the same spot. Here is my problem. When I run the query I get a type-mismatch error in the public function that I wrote. When the debugger runs this is the line that is...
  10. waldo7474

    Making numbers in text behave like numbers...

    Thanks for your quick response Jeff. I understand where you are going with the split idea. It sounds like it would work. I have never heard of it before and I don't know how to go about doing what you are saying. I put "split field" in to help, and it was a far cry from help. It...
  11. waldo7474

    Making numbers in text behave like numbers...

    Hi All!! I have a little problem that I can't seem to get around. I am using part numbers in my database. These part numbers have dashes in them. Because the part numbers have dashes in them, I must use a text field, however when I try to organize them in ascending order they go by the first...
  12. waldo7474

    FORM TO DISPLAY SEARCH RESULTS

    In your form properties, under the data tab, put the "Allow Additions" property to "No". This should solve your problem. Also, you should be able to use navigational buttons(if you would like) to go from one record to the next that follow this criteria. This would also...
  13. waldo7474

    form data source

    Hopefully others will answer this post. I have found this site to be extremely helpful. Look at other people's questions and answers. Try them out yourself. Try to understand what the program is doing, and then try stuff on your own. Check out the visual basic forum inside Tek-Tips. You...
  14. waldo7474

    form data source

    hjm, You can use the "Record Source" property in the form. You get to this "property", by right clicking the mouse, and on the menu at the bottom is properties. Once inside the properties menu, you need to highlight the form so that you get the form properties. Either...
  15. waldo7474

    Newbie: Running filter as function

    That fixed it!!!! Anthony you are THE MAN!! Let me ask you one more question, if I may. Once I put in my search criteria, and hit the search button. All of the header controls (the lookups) are all locked until I get to the end of the recordset (a new record). I have locked all the controls...
  16. waldo7474

    Newbie: Running filter as function

    I'm sorry Anthony. I really don't know how to put that function in to the OnClick event. Whenever I try to get around having Private Sub routine, then it tells me that my OpenForm event is screwed up. I am not sure why this happens. Right now, I have in the OnClick event the filter and the...
  17. waldo7474

    Newbie: Running filter as function

    Thanks for the help Anthony, and the quick response. I changed all the FilterStrongs to FilterStrings and nothing changed. I still hit the "Search Button" and nothing happens. It acts like the button doesn't do anything. Am I missing something? If you have any more suggestions I...
  18. waldo7474

    Newbie: Running filter as function

    ...the function know if there's more than one criteria If Not IsNull(PartNumberLookup) Then FilterString = "[PartNumber] Like '*" & PartNumberLookup & "*'" multVar = multVar + 1 End If If Not IsNull(DescriptionLookUp) Then If...
  19. waldo7474

    FORM TO DISPLAY SEARCH RESULTS

    ...Or PartNumberLookup = "" Then search1 = "[PartNumber] = 'xxxx'" Else search1 = "[PartNumber] Like '*" & PartNumberLookup & "*'" End If End Function Function search2() As String If IsNull(DescriptionLookUp) Or...
  20. waldo7474

    Filtering Records using multiple fields

    I appreciate your resonse FancyPrairie. Unfortunately when I added the "As String" to each Function it did not help. When they are all ANDs it returns an empty set. Even when there is only one field of criteria. However as soon as I change them to ORs then it returns results that...

Part and Inventory Search

Back
Top