Search results for query: *

how do you do this part of his question? i can only set up access to email reports and whatnot..

I keep on getting a Runtime error with a type mismatch on the first set rst line. Why would that be? I replaced TableNum2 with the appropriate table

What I want to do is populate a form with the data of one table through the use of a combobox and after doing so be able to click a command button that would add that data to a record in another table. Any Ideas?

I've also discovered that the only time the #Num! disappears and the values are actually filled in is when I have the Excel file containing the data open. Obviously, that's a problem and doesn't really make much sense. It's only certain values for some reason and it's not as if they were...

I currently have tables in an access database that are linked Excel spreadsheets as the backend. For some odd reason after using the db a couple times some of the values in records are replaced with #Num! When first linked the values appear fine. They haven't been changed at all so I have no...

I think I screwed up in describing what I want...maybe it's not a subform after all. What I really want is basically the query table to be embedded in the form somehow and by a selection pick which one i want to view.

The queries are querying different tables, would that make a difference? I didn't think that would really matter in terms of what I was trying to do.And wouldn't me.subform.rowsource = combobox selection somehow which I could make a table of the names of the actual queries. You know what I mean?

Basically my question is how can I control which of the several querys i have created appear in a subform by either a selection in a combobox or by a series of different command buttons. Thanks in advance. More or less choosing what form/query appears in the subform

<quote>You can have as many columns as you like in a combo box. I would have a column with a width of zero and in that colum I would store the table name that entry is associated with. Then the query would use that column for the table name</quote> That sounds like a good idea. What I need to...

This Maybe a Shot in the dark but in your opinion do you think it would be easier if I included merged all the data from the four tables into one and where the data is the same type but just different rename it's field. For example if I had a field named Code in all the tables but the data in...

Can you give me an example on how one would look, I'm pretty new at this.

Ok In a form I have four comboboxes. One allows you to choose a code number, the second allows you to choose the name associated with that code number, the third allows you to pick what product line this item is is going to be made in, and finally the fourth is linked to the third and narrows...

Got it to work, it was the missing UNIONs. I feel like an idiot but that's what you get for cutting and pasting! :) Thanks.

If what you're referring to is my ID field data, the data is numeric just like your Key field. I'll try what you said anyway though. Thanks.

Ok I have a similar table; just sub Golf course for Pline and Tee1, etc. for Finish1-Finish 6 and ID instead of Key; used the code you posted with my information and keep on getting a syntax error. The name of the table is MProductLines2 Here is the code: Dim strSQL As String strSQL =...