Search results

Ctrl-Break???

It really depends on what you're trying to do, you could use a query based on the temp table using appropriate selection parameters and "update the appropriate records. Or you could use a record set as shown below. We really need more information to give you specific guidance. Record set...

That was it. Thanks! **************** Forms!MainMenu.Controls("ServerList").SetFocus Forms!MainMenu.Controls("ServerList").ListIndex = 3 ****************

My Main Menu has an unbound listbox. The listbox has a "Record Source" select query that shows the records in a table (four columns with x records). If I click on a record I can obtain information, say the server name which is the bound field in the listbox with this code: strServerName =...

I've tried this code: DoCmd.GoToRecord acDataForm, Forms!MainMenu!ServerList, acGoTo, 3 But it errors out because the value of "Forms!MainMenu!ServerList" is the name of the first server listed in the list box on the form.

I have a form with an unbound ListBox that has a "Record Source" select query. The list box displays as needed. What I'm trying to do is move the selected record to the next record via code. How can I do this? The form-listbox is describe as shown: Forms!MainMenu!ServerList I can use code...

That did it, thanks. I was able to execute the module and compact the back-end database. ********************************* Function CompactBackend() On Error GoTo Err_CompactBackend '******************************************************************************* 'Name: CompactBackend...

Spoke too soon. When I run the code raw (from the visual basic editor), the process works. However, when I click the "cmdCompactTables" command button on the MainMenu, I still get the error: "You attempted to open a database that is already opened exclusively by user 'Admin' on machine...

That was the answer. I closed the "MainMenu" with the command: DoCmd.Close acForm, "MainMenu" then re-opened the form with the command: DoCmd.OpenForm "MainMenu"

I have many databases with Front-End (Forms, reports, modules) and Back-End (Tables) design. All tables in the Front-End are linked to the Back-End. What I've tried to do is use this code to "Compact and Repair" the Back-End database, but receive the following error message: "You attempted to...