Search results for query: *

wow, thanks, I'll start with the 3rd option because I don't require any formulas

Does anyone know of a way that you can export multiple tables to the same excel spreadsheet?

That's fine with me because only I modify the code, but what is the actual VBA code to do this?

Hello, I'm trying to use DLookup() in my VBA code to access an ODBC table. When I run the code, it pauses and manually asks me for a user name and password. Is there any way to automate this? Thanks, Mike

hmm, it still won't update the text boxes. What event should I place the script in regarding the combobox? And is there any update or requery method I need to call afterwards?

Hello, I'm trying to create a page where the user selects an item from a combobox and the rest of the textboxes on that page will display the fields that conains that record's info. I'm using the find method: MSODSC.CurrentSection.DataPage.Recordset.Find ("[CRF ID] =" & cbox.value)...

wow, that's exactly what I'm trying to do. Both methods worked just fine. Thanks for the help.

Hello, I am creating a DAP with a combobox and about 7 text boxes all linked to the same table. I want to be able to select a value from the combobox and have the textboxes be automatically populated with the corresponding info. I figured this could be done through a select query in the...

I have a button on a form that opens a report, but the report opens in the background. Is there any way I can get the report to open on top?