Search results for query: *

I'm trying to find a way, using VBA, to copy a table from one external Access database to another external database. In other words, there are three Access databases involved (source, destination and code). Most of the copy commands are methods of DoCmd and only work when the database that is...

I have VB code behind a form that uses the Execute method to run a query: db.Execute "qryAppendMovement" Within that query I reference a user-defined function named GTIN2UPC that I wrote. In one database the code executes perfectly. I put the form, the query and the function into a second...

I have a Windows XP machine with a 70GB hard drive. I'm using only 7 or 8 GB (by adding up the file sizes from a DOS DIR command). However, when I look at the C: drive under "My Computer" it says that almost all 70GB is used! I've cleaned out the Recycle Bin, deleted the contents of all...

I have a subform that the user can filter. If the user selects a record from the filtered subform and presses a command button I want to "unfilter" (Docmd.ShowAllRecords) the subform, then position the user back on his/her selected record so he can see the record in relationship to those above...

I am trying to develop an Access application that will use VBA code to open another Access database and create an ASCII file of the names of all forms in that database and the names of the controls contained within each form. When the forms are in the local database I can walk through the Forms...

In Tools | Startup on my database I specify a form name in the "Display Form" control. This, of course, opens that form when the database is opened without holding down the Shift key. I have some coding that I want to bypass if I open the form from the Database Window while I'm working on the...

I have a STRANGE problem that I cannot figure out. I have an Excel97 worksheet linked as a table in Access97 I'm comparing prices on the worksheet to prices in an Access table. When I run the comparison checking for [AccessPrice]<>[ExcelPrice] the query returns rows where the [AccessPrice] and...

I am trying to create an Outlook 2002 VB procedure that, when one or more messages are selected in the Inbox, will automatically execute the menu item: Actions | Junk Email | Add to Junk Senders list and then permanently delete the message(s) (not just move it to the Deleted folder). Although...

I am opening an Excel spreadsheet using the GetObject function. In order to reference the cells, I need to make Excel and the spreadsheet visible. When I do this, Excel moves to the foreground and Access moves to the background. I've tried to use SetFocus and Visible, but neither brings...

I used to be able to scroll through module coding using my mouse's wheel. My hard drive crashed and I had to reinstall everything onto a new hard drive. Now I can't scroll through module coding using the mouse's wheel anymore. I can scroll everything else in Access (the lists of objects...