Search results for query: *

Thanks for your help. Unfortunately this didn't work. I don't know if it matters, but I used a message box of my own, to make sure that they knew that the record would be lost for ever. Under the "Yes" section of that message box, I put your code. I am using a query instead of a...

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

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

Hi All!!! I am having issues with a filtered form. Here is the deal: I have a form that has five searchable controls. Once I hit the search button it filters all the records so that I get only the ones desired. I am having problems is when I try another search. At first, I had it so that it...

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

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

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

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

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

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

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

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

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

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

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

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

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

Hi All!! Hopefully you can help me. I am trying to run a search based on certain criteria. I would like the user to be able to fill in as much (or as little) criteria into different fields as they desire. I have five such fields that the user can put their criteria into. I want my database...

Hi all!! When I adapted this code to fit in my database I came up with the problem that it would display results that satisfied either of the criteria entered when I only want results that satisfy all criteria entered. When I use "AND" instead of "OR" I get an empty set...

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