Recent content by mrfilez

That would be wonderful. I would like to take a look at this in action. Thank you for your help and time. It is greatly appreciated!!! Thanks, Don please CC both addresses f613493c@mailfxhome1.fedex.com mrfilez@midsouth.rr.com

But does it show all of the information for all records searched for using the keyword? Does it work with a table where all of the fields are lookup fields consisting of an ID field and a text field? Thus if I searched in a NameField for Dave. Would it return all of the information for each...

I believe that if you already have a form setup for the doing the search you just create the button on the form. I tell you what... I will highlight in Red what you substitute with your own fieldname or table name. 'You can name the button anything you want, just make sure that the name in...

This is about the closest thing I have found to be a solution to my problem. Right now I am only looking to get records from one field. It will expand to a total of eight. I used the code you provided and get an error every time I hit the button: Run-time error '2001'. You canceled the...

I figured out where my problem is. I have a several tables. I have a table that my main form is based on that is made up of lookup fields to my other tables. This is the table that I am using to do my searches on, since it is the only table that contains the "full" records. Each field...

Ok, I got the form made the way you said. I set everything up. When I type in the name and hit the button, it gives me one blank row. I tried several records. I really hate to take up anymore of your time, so do not worry about it. I will get something figured out. I should be able to buy...

Ok. I feel really stupid. I have not even gotten started and have hit a brick wall. I have roaylly confused myself. Am I supposed to create a SQL Query with this code, or build a form and put this code in somewhere? I assume that I would build a form, because of the Me.RecordSource, and then...

Ok, I am in the process of trying this out. I will let you know how it comes out. Thank you for your help and time. It is greatly appreciated!!! Thanks, Don please CC both addresses f613493c@mailfxhome1.fedex.com mrfilez@midsouth.rr.com

Ok. Let me make sure I am understanding this correctly. Me.RecordSource = "Select * FROM YourTable" _ Me.RecordSource is setting the record source to whatever table or query I wish to use, Correct? &"Where Firstname LIKE '*" & Searchtextboxname & "*'" _ This is...

If I am understanding the SQL OR approach correctly, it allows you to select more than one criteria to find a record. If this is the case, I would like to be able to do this. Unfortunately, I do not know SQL. I have been unable to dedicate time to learning it so far. I am having to learn all of...

I just realized I am not populating from a table. I am populating from a query. Basically what I have is this. Common Name Order Family Scientific Name Seen Date Place All of these could have multiple listings. Could see the same animal in multiple places on multiple dates. I want to search...

I have two questions. 1. Would this work with list boxes? The info that I want to populate the other fields may be numerous. 2. Is it possible to use this same format to pull from multiple tables? A couple of fields from one table, a couple of fields from another table. Thank you for your...

Yes, that is it. Thanks. I thought that that was the answer, but I like to make sure. Thank you for your help and time. It is greatly appreciated!!! Thanks, Don please CC both addresses f613493c@mailfxhome.fedex.com mrfilez@midsouth.rr.com

I have a question. How do I tell if code is set at the control level or at the Form level? Thank you for your help and time. It is greatly appreciated!!! Thanks, Don please CC both addresses f613493c@mailfxhome.fedex.com mrfilez@midsouth.rr.com

Thanks for the info. I am about to make the changes you have told me about. I changed the IsNull for the combo box to NZ, because I could not get the combo box to be a required field. Lonnie told me to try the Nz and it worked. It may not work on the Forms BeforeUpdate, but it did work for the...