HI
i have this code
"Shell "C:\WINDOWS\system32\wiaacmgr.exe -SelectDevice", vbNormalNoFocus
Call GetAllFilesInDir("c:\InOutGroup")"
the first line trigger the "Windows Scanner And Camera ...
I have recently had to reinstall Windows 2003 Server due to a problem with the current box. I have everything up and running except for a few Crystal Reports. The reports are linked to a Acces...
Dear Experts,
when I open an Access 2003 database in Access 2007 and tell Access to hide the navigation pane (see attached file), the pane keeps reappearing everytime I open the Access appl...
I have a combo box that I would like to access the users' selection and set it to the variable TblSelect as I have attempted below. The combo box that I want to get the selection from is call...
I have an Access aplication that was written using Access 2000. There is a billing module in ths application that uses vba code to merge data in a table to a Word document. This billing module...
I've set up a VPN and created a mapped drive P:\ where I put the Design Master file for my database. I have computers at several locations throughout New Orleans that have indepdent local ver...
is there a way to do an IF/else/endif statment inside of the Expression Builder?
Hi, I have a make table query [qryOutput] in Access that filters results when a user chooses the criteria. When the form [assessment] filters the data I would like a command button on it to ex...
Hello, I have altereed a macro that we use to spit out a dat file for import into a database. At the moment the macro is not checking for unwanted space characters left or right of the cell c...
Hi!!!
I've been searching this site for about 3 days now trying to get my problem solved. Here's the situation: I have a combo box that I want to populate 2 other text boxes. I got the c...
I have a fairly complex form that I would like to create in VBA. In essence this form will be utilized to run a query. This form is made up of 5 list boxes, labeled List0, List1, List2, List...
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...
I'm cleaning up data in a table imported from a linked table. I need to make a variety of changes to values in one field. For example, I need to replace double spaces with a single space, remo...
From a previous question (Relink access table), I received the code below where 2 functions are missing.
ahtAddFilerItem and ahtCommonFileOpenSave
Where can I find the code for those fun...
I would like my VB code to sort all data in my table in the following way: Sort column1 then column then column3. The VB code is below.
DoCmd.RunSQL "SELECT Table1.* FROM table1 ORDER BY ta...
I'm trying to create a table using the attached VBA code. However, when I try to execute it I get the following error
run-time error
-2147217859 (80040e3d)
The error occurs at line 30 ...
A 'black' highlight appears over the activated task as as shown. This highlight does not appear when the task is first entered (newly activated). I would like to avoid the black text highlig...
PIPE INVENTORY TABLE
===================
Pipe ID
ASL #
...Other Pipe ID Details
Two peices of Pipe are welded together and the information is stored....
DOUBLE JOINT TABLE
=========...
hi, i am using m2sys biometrics m2s1scanner,the problem now is if the fingerprint scanner is not connected, we can manually press a hot key & can manually give username &password , now i want ...
When coding in VBA (Specifically MS Access 2007) how can I get a list of a folder's security permissions, specifically what users/groups have access to them?
Hi experts,
I'm trying to insert records from tbl_A to tbl_B. Each record in tbl_B contains a unique caseID. I want to prompt an error message if any of the records in tbl_A that I want to ...
I want to press a button to go from the IssuesDefinition form to the SoftCosts form. The field that ties the databases and is used on both forms is the IssuesID. It is the primary key used for...
Hi,
As the final command in a For-Next loop I want to export the table I've just made into Excel (and thus export a series of tables into the same Excel file as the loop prgresses).
How...
I have an Access database with tables linked to SQL Server. I'm using Access as a front-end for forms with Visual Basic.
Using an ADODB connection, I am getting an error executing an UPDAT...
Below is my code to print a report. I was wondering how I would pull up the Print Prompt to allow the user to select which printer to send it to. Any suggestions?
Private Sub cmdPrint_Cli...
