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 ...
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...
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 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'm trying to take the value in a textbox on a form into a table using an update statement. The textbox value is populated by a calendar control, but when this is passed into the date/time fi...
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...
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...
Is it possible to dyanamically add controls to a report w/ VBA in its open event?
Do not want persistent controls, just want to add them on the fly as needed on each report run (they do not g...
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. ...
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...
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...
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 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...
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 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 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...
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 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 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 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 ...
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 ...
Hi, I'm hoping someone can help me with copying a table from a corporate Oracle database to an Access 2003 database on a file server. I've installed the Oracle OLEDB Provider and Instant Clie...
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 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...
