This macro works fine in Access 2003. It is attached to a button on a form. When the button is clicked the user is asked to enter the parameter for NC number. The query runs and the record...
how do I pass a value to a ms access macro from a batch file
I running a batch file like this:
"C:\Program Files\Microsoft Office\OFFICE11\msaccess.exe" "E:\agview\data\scoutingContracts07...
I copied an Access database from one folder on a seperate server to networrk drive where users can access it. When the users click on the macro, it does not work on their computers. Instead, i...
Access 2003 - Eliminate duplicate rows from table. In my table rows 1,3, and 5 are the same and rows 2 and 4 are different. I need to identify rows 3 and 5 as duplicates and remove them. I h...
Microsoft Access Open Email Message (Outlook) and populate it with data from the database!
I need to be able to open an outlook email message and populate it from a button click, I know that ...
I have a subform that the user wants to be able to enter the data once in RecordID = 1 and have the option to update the remaining records for a particular mainform.RecordID ( may have multipl...
I am writing a VBA module and I would like to create a table that contains some records from an existing table. I do NOT want to specifiy the field names because I want to use the module to c...
Hello,
I know how to stop in Acces the warning "Security Warning; Unsafe expressions are not blocked"
everytime on startup by going to Tools-->Macro--> Security and setting it to...
I am not sure if the problem below can be resolved...I just want to explore the possibilities of a solution.
The Form's Load Event Function "DateFilingLoad " issues a command to close FrmMa...
I need a Access 2000 VBA solutions for the following:
Determine if a table is present - Commitment_Outlook_bak
If not present then copy Commitment_Outlook to Commitment_Outlook_bak
Done.
How do I get the selected index of a listbox?
Hi Guys
I am using Access 2003 / XP-Pro
ref: VBA Replace function
The code below is giving me grief
Basically the replace function is supposed to search the specials.htm file below
find t...
I have two tables, however, there is no relationship between them and there is no common field.I would like to merge these two tables. for example first table might have 2 records and the seco...
Hi guys, i need a query similar to the Duplicates query wizard which can find duplicate entries in a field called "Letter" in a table called "tbl_inventory". The only exception is that i need ...
I am going to go to tools-->Startup and...
disable...
"Allow Full menus"
"Allow Built in toolbars"
This is so that nothing appears on toolbar menu in my Access mdb.
Nonetheless I al...
(It was suggest I ask in the VBA section.. this appears to be the closest to VBA for Access)
I'm using Access 2003. I have different reports printing on different printers. One of those pri...
A lot has been written about unzipping files using VBA. All I can find require third-party tools to do this.
Has anyone managed to get VBA to unzip a standard Windows ZIP file without anyth...
I am looking to be able to export from Access to and Excel template using VBA. I have read where you can't format an Excel file on export from access, but I thought maybe if I designed a temp...
I am getting this error when I try to create an Excel spreadsheet through VBA. The code is:
Set wbXL = GetObject("file.xls")
This had been working in the past but I have been getting this ...
I've got a system whereby if a user navigates to a record that is 'locked' i.e. a field value is -1, the user is alerted and should be put back to either the previous record or the first recor...
How do I create a variable in an Excel Macro referencing a certain cell A1 and then use it in a concatanate statement. I have the following concatenate statement and need to add the variable...
In VBA in Access 97 how do I change the vertical scroll bar position of a list box?
Preferably I need to be able to get the vertical scroll bar position, store it, and then return the list ...
I am using a subform which I bound to an SQL string to display a filtered datasheet of records for a specific client. I am using the code shown below to bound the form to the SQL. The tbl-pe...
Convert this "1192043444" to 10/10/2007 3:10:44 PM
I posted my code below. I am trying to adapt the commented filter code to use two variable for both the column to filter and the criteria for the filter. I am having trouble getting the quot...
