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 ...
I've got a MS Access db, with one table "tblMaster" three fields: "Value","MTG", and "Equity"
The Equity field is currently empty (null). I want Access to take the {Value-MTG} and place th...
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...
I know this question is asked daily, but for some reason I can't find a solution that actually works! I am simply trying to add a record to a table (SQL SERVER Back-end) and get the ID for th...
I have the following Code that IS working:
Function fncBatchImport(strFolder As String) As Boolean
' function to import multiple .xls files into one table
' just make sure all fields are ...
This code below gives me the error "Syntax Error in JOIN operation". I am attempting to modify a "pass-through" SQL Query in Access using VBA (SQL Server back-end). The SQL statment is copie...
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...
Does anyone know how to write an excel macro that brings up the print dialouge box and has 'Print entire workbook' selected.
I have a macro that prints the entire workbook from a button pr...
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...
When the user changes the data in a field in a form I'd like to display a message like
"Are you sure?" with a OK and Cancel button.
My attempt hasn't worked. When I change the SubCateg...
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 this code in a module:
Public Function FindLikeTable(strTableName As String, offset As Integer) As String
Dim i As Integer 'counter for loop
Dim k As Integer 'counter for a...
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 ...
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 ...
I would like to ZIP a file with VBA. The following code from Ron de Bruin:
http://www.rondebruin.nl/windowsxpzip.htm
Unfortunately the following code doesn't work all right. I get an endle...
I code normally in Visual Basic 6.0. The textbox control in VB has a multiline parameter and the maximum text length seems to be very large (64kb I think) However, in VBA (Visual Basic Acces...
Greetings to all experts,
I have an issue that I would love to resolve and move on with. The main goal is to format an excel spreadsheet within the export code. I have a formatted sheet I ca...
In an Access 2003 program, I'm using the code located at http://www.mvps.org/access/api/api0001.htm to Browse for a file. This code is beyond my level of expertise, but I do have it working b...
Hi All,
I am developing an Access 2003 application. The application runs from XP clients in a Windows 2003 domain environment. The app is broken into Front-end mde (XP clients) and the Back...
I have a large text file with about 100 fields that I import into Access 2007 with a Macro and a Import Spec that works fine. However I would like to write a VBA procedure to import this and ...
I have a MS Access database opening daily, loading a form, running some VBA code on the form open event and saving some reports to a folder then closing the form.
I am having trouble shuttin...
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...
Hopefully an easy one this, believe it or not I cannot find anything that gives the solution!
I have a VBA sub that will continually check something at set times, so needs to run forever, a...
Hi experts,
I am trying to create a macro that outputs an SNP report file and then converts the SNP file to PDF. I can write the first but to output the SNP file but do not know how to aut...
I have the following:
Hi, I have two forms namely Dossier and Facture. Facture will contain the Dossier number. Now on the Dossier form, I have a textbox which should display the facture ...
