Search results for query: *

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

I am setting certain fields as being required. I would like for the cursor to automatically go to the field that is required, but not filled in. This is what I have so far. Private Sub txtFirstName_BeforeUpdate(Cancel As Integer) If IsNull(txtFirstName) Then 'Checks to see if Information has...

Well, the "If Nz(Combo0) = "" Then" worked. The combo box now works. I still have a problem with the ReportTo field not working. Does this have something to do with it coming after the combo box? This is what I have for the required field coding so far. Private Sub...

I have to agree with Elizabeth. I have never under any circumstance seen a situation where it was a good thing to have all users using the same login. What is the point of having a login at that point??? I also agree with Elizabeth on using Access security to make everyone log into your...

This may not help and may not be the thing to do, but here is what I do. I take away all rights from the admin account, remove it from the admin group, and make an account for myself with full admin rights. This way they will have to enter a valid user name and password to log in. Even if you...

Sleep???? Is that something new? :-) From 7am to 3 pm CST my e-mail is f613493c@mailfxhome1.fedex.com During that time and the rest of what everyone refers to as my life, the address is mrfilez@midsouth.rr.com. If you could, try to CC my mrfilez account with everything. That way I can get to...