I have the following:
strSQL = "Select a ton of stuff"
Set rstTonOfStuff = db.OpenRecordset(strSQL)
db.Execute "Insert Into table (field, field...) Select " & rstTonOfStuff!Field & " ,...
I have table (supplier) which simply combines two primary keys from two other tables Contacts and Items, supplier uses the primary key from items as its own primary key. In a certain form ther...
MS Access 2003 writing MS Access 2000 database.
I just started trying to write VBA and put two previous code pieces together and of course it does not work. I want to pass a three letter code...
Is it possible to call a private sub let's say 'mysub' on 'myform' from another form 'myotherform'?
The call statement would look something like: myform.mysub in the code for 'myotherform'
Microsoft Excel Queston
VBA Code Request
I have a software package that exports data in a text file in the following format. It is split into 7 columns each column seperated by 5 spaces. ...
Hello all,
I have struggled with this for the past few weeks. All I am trying to do is transfer data from Access to excel via a command button. There are 2 Things I would like to do:
1.D...
Hi Experts -
I am loading data into an access db that is starting in Excel using the docmd.transferspreadsheet method in access vba.
Usually the excel file has several sheets and there i...
Conditional formatting:
I'd like to format cells in a tabular form based upon the value in a header field. I've reviewed the conditional formatting dialog and it appears that I can only for...
*************
* Background *
*************
I need to store and update data in a load of global variables:
- When I load up forms I pre-populate the fields with this data.
- When control...
I can't seem to get pass-through queries to accept arguments from text boxes in forms. Additionally, I have many queries and would like one location to change DSN/UID/Password info, rather th...
I've got the following VBA coding to open up a specified Excel document and I want to add a combo box with 2 columns of values from an ADO recordset.
What coding do I need to include in order...
I have a tool that references linked tables from 2 other tables. I know both the locations of the MDBs and the table names where they reside. I am further using a macro to link the tables by...
In Access 2003, I have a field called DeptCode already created and want the display control be converted from Text Box to Combo box. Row Source to be: SELECT PROJ_DPT.Dept_Code, PROJ_DPT.Dep...
Is there a way of commenting out many lines at once in the Access vba editor?
HELP! I'm about to demonstrate my application to some people and all of the sudden its not working.
In the afterUpdate event, I'm selecting item_total from a table and everytime I run this ...
I have a program for sending emails through Outlook I got from BlueClaw. It sends out the same message to about 300 email addresses one at a time. The problem is sometimes Outlook gets backe...
I NEED VBA CODE TO HIDE STATUS BAR AND MENU ITEMS. DATABASE NAME IS CREVIEW. THIS DATABASE DOES NOT HAVE "TOOLS "MENU ON TOOL-BAR ON THE TOP. I NEED VBA CODE TO IMPLEMENT WHEN CLIENTS OPEN ...
Hi,
Quick question here. I am executing some make table queries by opening a recordset as shown below.... is there any need to close the recordsets when done..... I get an error when the ...
Hello, I have 7 text boxes Task1 - Task7, and I would like to put a command button called "clear" beside each one of them so that if they want to clear the contents of that box then it would d...
I'm looking for some VBA code that would loop and find all existing queries and reports in a database then delete them.
The main reason why I want to do this is I have 50 databases that ...
Experts,
Can you please help with the code below.
I have a query that returns the number of rows, and I want to assign that value to the variable lnCountReload.
When I try to execute,...
I need to import data from an excel file into an access table. I will need to import only certain columns from the excel file, columns A C D and E, but all of the rows that have data from al...
this code generates the automation error: "The specified module could not be found.", but only on our Windows Terminal Server. Folks running same MDB from the file server, do NOT get this err...
I have been coding in Access 2007 and it has been coming up with the errors;
"There isn't enough memory to perform this operation. close unneeded programs and try the operation again"
Exam...
Hi people - long winded explanation follows...
I have an access application which prompts the user for the location of an Excel file, and imports the data into a SQL table. However some of...
