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

...dim strSQL as string dim strWhere as string 'Make SQL clause ' Replace MyTable with your table's name strSQL = "Select * From MyTable " 'Make Where condition text'This is an example of searching in a Numeric field. If your FileNumber is a numeric field then you...

...lookup fields 'and is the table from which I wish 'to pull my information strSQL = "Select * From tblMix " 'Make Where condition text... Right now I just wish to get 'search working on one field...

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