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...
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 & " ,...
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'
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...
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...
Create a Excel document using VBA or VB using specific MS ACCESS Data tables and fields to create a variety of excel worksheets with specified names on the sheets and data placed in specified...
*************
* 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...
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 need a VBA Function to retrieve all File Names in and below a directory root. So if I browse to a folder root say S:\Office_Files\ A Text Box named TxtPath will contain the value S:\Off...
I have a button on my form that automatically generates a report based on a query. Except for the address field (which should be filled in by the system) the data on the report is all previou...
Hi
I have a form which allows the user to enter a new record into a table.
I've used the HOWTO: Create a search form posted by Shanesuebsahakarn to then find possible matching records an...
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...
In Access 2000 I used to be able to do:
MyOptionGroup.value=3, which would select the Option Button that has the OptionValue of 3 assigned to it.
But now in access 2003, I've created an Op...
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 am accessing an excel sheet through VBA I want to set the focus to a specific sheet in the excel workbook. Everything works except for the fact that if the workbook opens to a different she...
easy excel vb question... i'm trying to copy a worksheet from an existing workbook into a new workbook and then rename the worksheet in the new workbook, rename the workbook, save it and close...
I have a listbox with 3 columns. I want to populate all 3 columns from a recordset.
I have the following code which works.. but only for one column.
i have fields - proj_id , wbs_short...
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...
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...
I would like to pause an execution of VBA code in the MS ACCESS, I have a loop that will run multiple times and update a table records with each loop. I would like to pause for 10 sec after ea...
Hi Experts....I have a combobox (Plan_ID) on my form that gets its data from a Table (Tbl_Affordent). The values in this fields are:
Plan_ID (autonumber) Plan_Code: Plan_Description
...
I have a incredibly simple batch file that calls MicroSoft Acces, opens a specified database, then calls a Macro within the opened database. Once this macro completes, I want to use the batch ...
Hi Experts,
I need your help!
I am creating a function to help me to extract information from a messy data set.
I tried to use a select statement in vba.
however, i tried to use the...
I am comparing the field in a table to one in a combo box on a form.
I can't call the function Like in the query design view. Access 2003 and 2007 is replacing the function with the call to a...
