Search results

Works like a charm. Sometimes I don't think outside the box enough. Thanks

My SELECT statement is pulling from my external data source. I want the selected records to be imported to my local access MDB into a table I have already set up. How would I let access know which table is local/external in my query?

Import subform filter results to table I have a form with some combo's and subforms that are filtered based on combo selections. I want to import a filtered record set into a table. I have an export button with events. I can't seem to find a method that is suitable for working with this...

When you say 'line' are you talking the output from these queries are placed onto a new line on a web page or a form perhaps? I don't know if I see what your question is really. Are you asking how to place a new line or asking how to write the 2nd query? I would assume line but I dont know...

Wondering how I can do a SELECT INTO into my access database from oracle. Import table wizard doesn't work because I am selecting from dba_tab_columns and it tells me to qualify the table name but I never receive a chance to qualify it as I am only given the option to select it from a list...

I have a query that connects to oracle. I have a dsn connection profile with a saved password to automate this process as much as possible. I want to have the query automatically select the connection profile, is this possible?

I have a form that has two dropdown lists. First ddl specifies table to work with. Second ddl is populated dependant upon the table that has been selected in the first ddl. I know how to specify form elements inside a query, however this first ddl is selecting the table that I want to pull a...

bump Still stumped on this. Thanks

It does have a PK and I am not updating, only selecting. Maybe walking you through my steps would help us solve this issue. Tables -> New -> Link Table Files of type -> ODBC Database New -> Microsoft ODBC for Oracle/Oracle ODBC Driver (Have tried both) Link Tables -> DBA_TAB_COLUMNS (see...

Yea, the problem is the link table wizard doesn't let me type in the qualification. I select the table from a list (no textboxes at this point) and hit next, gives me the error (textbox is behind the error, cant click/type) and hit OK. The wizard quits.

Running Access 2000. Tried using a link table however it gives me an error saying that I must specify owner because several tables with that name exist. I hit ok and the window closes, I never receive a chance to specify owner (sys?). Is there a way around this or another way to create a...