I'm creating an Access program such as when a button is clicked, it will open 50+ word documents, one by one, then perform a procedure such as getting all the data the document contains. Gi...
I get several excel files each month that I need to extract data from and put into Access:
Source folder = S:\NYC Reports\- Working Reports Folder\Inventory SWIP\Data_from_NFTS\Raw
Each work...
I have imported an excel file into access. One field is being read as numeric if the user entered only numbers into that column, but in fact in the Access application it is a text field. Whe...
Hi,
I'm trying to copy all records from one table into another (append query) using:
INSERT INTO tempTable (myName, myAddress)
SELECT testTable.F1, testTable.F2
FROM testTable
how c...
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 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...
I have code in the On Not In List event of a combobox. After the event fires, focus is regained on the combobox and the list is automatically "dropped down" (if this is proper terminology). ...
I am working on a piece of code that I obtained from my last question on this site. Here is the code:
Function DateDiffs(EarlierDate As Date, LaterDate As Date, one as integer) As Long
'Ret...
I am using access 97, I would like to be able to make use of a hash-function in my vba code. Does anyone have any examples?
Many thanks
Matt
I want to send data from a large recordset in VBA, MS Access 2000, into MS Word 2000. The data gets put into cells in a table. The user can set up the table in Word and in the Access program c...
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...
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 ...
I have a Access table with a string field ("comments") set to max. 255 characters. I am simply trying to read this value in VBA for a particular record and write it out to a text file. Here'...
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...
Access 2003 VBA
I want to create an array where each index has three elements. I have the following code to load the array:
DIM arrAssessors(2) as string
strSQL = "SELECT x, y, x fr...
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...
In an access query I would like to display only the first 20 characters of a 40 character text field. I don't want to change the size of the field in the underlying table just display the firs...
I have two tables in Access. One each will have a string like this
County of Broward
and the other
Broward County
This is a very simple example. What I'm trying to do is find a m...
I am a novice with Access, the error I get when running my iif statement is expression is too complex.
The iif statement is in a query...
thanks for any help
I am trying to run an update query on all items selected in a simple-multiple selection List Box on a form. I'm not sure what to put as the criteria in my query.
I have a hidden memberID c...
Using Microsoft Acess 2003, VBA coding on Windows XP Professional with Microsoft Outlook 11.0 Object Library.
Trying to find the VBA code to (1) look up a person's name in the address book ...
Hello Experts
I developed a small application in Access that allows to select all in a webpage and paste in a Notepade file. I have two problems in manipulation the Notepad:
1. I would l...
Automatic Export of a Access 2007 in a Tab Delimited format.
I have a program that I need to export a table T_ExportToAccounting that I need to export in a tab delimited format on to a floppy...
Hi,
I have inherited some Excel Sheets and Access databases which use the BLP Add-ins to retrive data from Bloomberg.
The Access database is using the Subscribe method - example code below....
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...
