Browse by Tags

How to use VBA to uninstall a program with msiexec.exe

I am trying to imitate the uninstalling of a program with VBA to save the user doing it. The program is a plugin so it only has an unistall shortcut with the following target. It is the google earth plugin. "C:\WINNT\system32\msiexec.exe /x {2862C000-331E-11DF-89BF-005056806466} FEEDBACK=1"...

Posted to Access Coding/Macros (Forum) by microsoft on 05-23-2010
Access wont let me save changes to vba module

I am the sole user and developer of an access 2003 database on a vista PC. I have an unbound form that allows adding/editing/deleting of records in a table. If I open the form and add a new record and then close the form , access wont allow me to make any changes to the forms vba code. If I try and save...

Posted to Access Forms (Forum) by microsoft on 05-12-2010
Open Form and GotoRecord issue

Hello experts, I have a menu that when I press a command button a set of VBA code is launched to open a form in hidded mode, to set the value of a textbox. Then open a second form in normal mode. In the second form I have VBA to filter a tab container down to show only the tab that is associated with...

Posted to Access Coding/Macros (Forum) by microsoft on 05-04-2010
ACCESS 2003 - HOW TO REFRESH/REQUERY THE QUERY IN SUBFORM AFTER RECORDS ARE DELETED

USING VBA TO DELETE A RECORD ON A TABLE/QUERY BEING VIEWED IN A FORM, HOW CAN I REFRESH (NAMES IN PARENTHESES) THE TABLE/QUERY WHILE THE USER IS STILL VIEWING IT IN THE FORMS' SUBFORM ..... HERE'S THE HIERARCHY OF CONTROLS, ETC. A QUERY (QRY_ASSIGNED) ...ON A SUBFORM (QRY_ASSIGNED_SUBFORM) ....

Posted to Access Forms (Forum) by microsoft on 04-15-2010
How do I Create db3 from db2 while in (FE) db1, and lose security?

I Have a Frontend DB(FE1) with linked tables from 2 Backend db's BE1 & BE2. All are .mde's in the production db. The purpose is for auditing. I use a custom security file located on the server with the BE files. ("mySecFile.mdw") To open the db, users click on a link to a batch...

Posted to Access (Forum) by microsoft on 04-10-2010
How to reference my .NET .dll I made in a VBA program

I am testing/trying to write my first .NET dll which I can reference in a MSAccess 2003 MDB. Thus I am making it COM interop. I have made an "empty" dll following these instructions here; (empty meaning just what is below nothing else) http://msdn.microsoft.com/en-us/library/x66s8zcd%28VS.80...

Posted to Visual Interdev (Forum) by microsoft on 03-21-2010
The Close Action was Cancelled when I use an on click event

Hello Experts, I have a form I am using to add users to my database. When I press "Add User" it fires an on click event. The code for this event is below. Once all the actions are done I want the form to close. However when it tries this I am getting a error "The Close Action was Cancelled"...

Posted to Access Coding/Macros (Forum) by microsoft on 03-18-2010
Copy cell (>255 characters) to multiple records results in Run Time error 3271

Hello All, I have a big problem and need to resolve it quickly. I have a Database that has been moved out into production with my small group of engineers. However, I have a function that is giving me this 3271 run time error. Recently, I had this question posted on EE and got the resolution I needed...

Posted to Access Coding/Macros (Forum) by microsoft on 03-05-2010
Searching file system using Microsoft Windows Search and Access VBA

Hi, I have an Access 2003 ADP (Project) application that I would like to be able to use to search a file store containing 1,000s of Word documents. I have found the details of Windows Search SDK and wondered if anyone has managed to get this working with Access VBA (or any other Office VBA for that matter...

Posted to Access Coding/Macros (Forum) by microsoft on 02-20-2010
How to assign a control of a subform equal to the control id that is an autonumber on the main form.

I also want to autopopulate a text box on my subform base on a combo box selection, and when the text box get’s auto-populated a new line get’s added for a new selection and the changes are stored for that particular control id on the main form. I want to be able to do this using ADO recordsets. My situation...

Posted to Access (Forum) by microsoft on 02-18-2010

Page 1 of 8 (74 items) 1 2 3 4 5 Next > ... Last »