I have code in the On Not In List event of a combobox. After the event fires, focus is regained on the combobox and the list is automatically "dropped down" (if this is proper terminology). ...
Does anyone know of a way to combine multiple Access queries into one? Assume I have two queries, a make table query and a second query that updates a field in the newly created table based o...
I have some VBA Code that goes to a specific directory, and allows the user to choose a file (excel spreadsheet) to open. I need to include in the VBA code, once the spreadsheet is open, it d...
I have a text box called Txt_Date_Opened.
Rather than have the standard error message that if a use does not enter the proper date I would like to prompt with a more helpful message such as...
I am trying to insert a bunch of dummy records into an Access Database table using VBA in a module called survey_results. Below is the code I am using. I'm getting the infamous Object variable...
Hi
I need to create an Excel VBA statement to query an Access Stored Procedure. I can get it to work with one parameter but I have a query where I need to pass two parameters. The query cod...
Windows Vista Ultimate, Access 2003. My Access application consists of a main form with a subform. The record source for the subform is a linked table. Users enter partial/approximate data as ...
Dear EE members,
I would like to call an access macro. This macro will call the vba function with the following code
to insert record from MS Server to Access table, but I failed to make it....
I need to change the way a certain field calculates data, but at the same time not endanger the 5 years worth of historical data that reside in the underlying table.
I need to create a for...
I have a command button intended to save the record and subform records on a form.
The subform has code in the before update event that test for null values and prevents the user from pro...
VBA for Access (but as a larger question for VBA and VB in general.)
The documentation I have access to gives a rather vague explanation of exactly what the property set function in a class...
Hi! For my Access database, I am looking for a VBA code that would:
- Open a windows dialog box and let the user select an excel file
- create an empty table called "Import"
- copy the cont...
I am a newbie trying to create a form in Access based upon the following table/fields:
TABLE=Data
FIELD1=Carrier_Name
FIELD2=Total_Receivable
FIELD3=Total_Weight
FIELD4=Close_Out_Date
...
I built an Access application that worked just fine for some time. I package the application with ms access developer extensions and include the ms access runtime version. Recently, I made a f...
I have two tables in Access. One each will have a string like this
County of Broward
and the other
Broward County
This is a very simple example. What I'm trying to do is find a m...
I built an access 2003 database. Our IT department upgraded to Office 2007. Now when my users launch my application, they get a security alert message when they start access and warning messag...
I'm trying to do the following:
Enter your name
Enter you password
[submit]
After submission with button and authentication, populate the appropriate data based off a query on the pers...
Hello Experts,
I have developed an access database, along with all the vba code, using Access 2000. One of my users recently upgraded to Access 2007 and is now receiving error number 2950 wh...
Is it possible to create an Excel file in Access using VBA that has multiple tabs. I have code where I can pass in a recordset and it will create an Excel file with it, but it can only put da...
Hi all,
I'm using Access 2007 and I'm attempting to address an issue with a continuous form seemingly taking whatever height it feels like when I open it (and changes on different PCs). I'...
Hi, Having just executed a do.cmd transferspreadsheet called say "My_New_Sheet" how can I select the sheet to start formating it. I can open a new workbook and sheet with dim and set obj etc....
Dear EE members,
I have a link table in ms access, where it links to ms sql table in remote site via odbc.
Currently, my access application is running by scheduling the macro and batch file,...
Hello. I am using Access 2003 and Word 2003. From a previous question I have the code below which is opening a Word mail merge document, producting a protected mail merge result, and saving ...
I currently have code that opens and updates Oracle tables. Need to modify to update a single field for Comments into the Oracle table. I am use to DAO What is the proper syntax to set the r...
Hi All,
I need to run a vbscript from MS Access 2003. I generate the script in VBA and store it in an external vbs file. I then want to run/open/launch the vbs file. (The file checks to s...
