I am pulling a large amount of information and I am trying to dump them into a new table. However now it seems that once it goes for a while and fails it gives me an Invalid Argument error. Af...
I've searched through all of the solutions so far and haven't found one for my particular situation.
I have a database that I'm using to scrape invoice information from a mainframe screen a...
Hi
I am a newbie to VBA.
I am working on access 2003 database.
I have a table which contains data for employees.
I want to create a simple form which will have 1 text box and 1 comma...
I have an Access database, central.mdb
I have been tasked to put my access tables on sql for performance sake. Apparently
more users can access a sql db at once than an access db? I've pu...
I have a report that calcualtes a total and displays it in a textbox, I will also like to have the number in the text box spelt out i words in another text box. Is there any code to perform ...
I'm looking for a convienent way to plot several hundred addresses on a map. I've looked at Google maps and Yahoo maps but I wanted to get some additional ideas about which option would be be...
I can't seem to get my head around how to do this in a query or series of queries in Access. I am extracting some data and I need to show the weekly average price and a season to date average...
My question may seen rudundant, but I am a novice at this and need some guidance. I work for a security company and track persons with security access badges. Our office inherited an Access da...
Hi Experts,
I have 1 query that extracts e-mail addresses from clients that have made a booking, in order to e-mail them for their feedback:
SELECT First(Clients.Lead_Name) AS FirstOfLead_...
I have 6 excel files, that are in the same format, that I have to import into Access each month. Can I write a macro to import all of the files into Access as individual tables or even as a m...
Hi,
I have an append query that is working fine, but i can not see on one field the decimal places
On my target DB the format field is:
Type: Number
Format: Standar
DecimalPlaces: 2
...
I need a script that will loop through an Access mdb and for each linked table: copy contents & definition, drop the linked table, and rename the new local to the original. I am somewhat famil...
I found a piece of coding that I would like to use to prevent duplicate values before the record is a saved.
The table that I created is called "tblCWSHIPDIRECT". The primary key is called "...
The following code is not working. I have tried several variations of the code and the error occurs at the line Set MyRS = MyQry.OpenRecordset() the error is runtime 3151 ODBC - connection to...
I get the following error when I send an (update) Collect Data form from MS Access 2007:
Microsoft Office Outlook 2007 was unable to send the message to the following recipients because of ...
I am building a query that prompts for parameters, and I know how to have a box pop up so the user can enter in parameter(s). To control the input, I would like to have the user select a para...
I'm trying to loop through a listbox on an access form. How do I do this? I want to loop through all the values, not just the selected values. The code below only gets the selected rows...
While working on a database, I somehow deleted my main menu toolbar. I'm able to turn it back on if I run VBA code, but it won't save the changes if I exit out of Access. The Menu Bar is mark...
Dear,
I made a program where I am connecting a mdb file with adoconnections and adotables and queries.
On my laptop I can run the program and there are no problems.
I am connecting the a...
I have a listbox containing "Descriptions" of attachments that have been added. (Don't worry, only storing path). I also have command buttons for the following: Open File, Attach New File, Ren...
I have recently upgraded my Access project to have the backend running in SQL server. There is a lot of ADO in there. Some of which runs some update queries that are in the Acccess front end. ...
Is there a fast method of getting the number of records in a recordset besides:
rs.MoveLast
N = rs.RecordCount
I have a report and I want to change the recordsource from qryWPPI_Funding to qryWPPI_Funding_Null.
I can't seem to do it.
Can I only do it in design mode? If so, could I open the repor...
I use the Dir function to retrieve a file list for a certain folder containing files that match a criteria.
Previously I was just using Dir(path & "*.xls", vbNormal) to retrieve excel files...
Hi Everyone-
I am fairly new to developing with VBA and I am stuck on a problem. I have an Access database that current runs a screen scraping process to get data. The screens are being retir...
