Search results for query: *

Yep, you were right. I removed "Exit Do" and changed "basFind = fldList(Idx)" to "basFind = basFind & " " & fldList(Idx)" Works great... Also, once I got rid of the null values in the cells it Goes through the whole table. Thanks for the Help..

I need to be able to search a small table and return the field names that the data is found in. (I know this is highly unusual-- but I still need to do it for an existing datatbase) The script below was given to me in another post.--Which I'm greatful for.(At least I know it can be done) It...

Also I notice it gets hung up on empty fields. Anyway to fix that? Once again, thank you...

I think this will work. It works great when I manually put the "token" in. "=basfind("table","studentname")" I'm having a problem getting a form to put the token in. On the form I have a dropdowm box with the list of names (It pulls them from another...

I would greatly appreciate the examples. My e-mail is appleton@odsy.net I do understand how you are explaining I should set it up. I did start that way, but I ran into some problems, so I switched to the way I have it now. If you will send your e-mail address I could send you my database so...

The last part didn't come out right. Can you put multiple entries in one field on a single row.

I need to be able to see the whole schedule (instructors and open and occupied time slots by day) when assigning students their time slot. I have roughly 10 instructors and around 100+ students. Only two students can be with an instructor at one time. I know it is a mess. It is hard to explain...

Need some advice on how to get started. I have three variables. "Instructor","Student",and "Time" The instructors and students can/will change. The times will remain the same. This is my setup now. I have a table that has the first field as...

I pulled it from a query. I have other forms pulling it from the same query throughout the database. They all see it and pull it fine. Reports on the other hand give me the error. Yes, I've tried selecting it from the drop down box. (And the report wizard) -- Same error. I even deleted and...

I made a report with the report wizard. The field is displayed in the wizard and the drop down of the control source. I get an error "Can't find the field". It says the field might have been deleted or misspelled, but it is right there in plain view. Any idea?

Is there a way to query a table for specific information and then just have it display the field name only, where it was located. I can do the query part.

Thanks. That was simple enough...

I have a large table that I imported into an Access (97) database. Everything is working great, However I need to combine two of the table's fields into one field. (Or I'll have to re-enter all the information by hand.) For example: Field 1 is "LastName", Field 2 is...