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'
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...
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...
*************
* 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 have a form that is driven by a query to display data based on a numeric value passed from a hidden form. Once my users input data into this form, in the footer of the form are a series of c...
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...
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 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 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 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...
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...
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. ...
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...
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 ...
Is there a way of commenting out many lines at once in the Access vba editor?
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...
I have a large database running just fine in Access 2003 on my computer. I copied the entire database and sent it to a colleague for him to use. The import portion of the database works fine ...
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 need to create a csv file, pipe delimited from a query.
I created a macro
Transfer Type: Export delimited
Table Name: MyQuery
File Name: c:\tmp\MyQuery_pipe.txt
Has Field Names: Yes
...
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 ...
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...
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...
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...
