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...
Working on databases (multiple) that are linked via ODBC.
Getting the error message listed when trying to open link.
Can set up the link and open it fine while in Access, but once user gets ...
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...
Experts-
I have a third-party utility that automatically generates an Access MDB. I have a series of queries and reports that I want to run against the MDB each time it's created. Currently...
Hi,
I am trying to write some code for a form with pull down combobox and a subform in Access 2003. The subform is a datasheet. The pull down combobox contains a list of groups and the dat...
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 ...
The following post pretty much addresses my question but I have some details that I can't quite figure out.
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_22095635.html
...
This works
CurrentDb.Execute "CREATE TABLE MyTable ([FindText] TEXT, [ReplaceText] TEXT, [WholeWord] TEXT);"
strQuery = "SELECT * FROM MyTable"
Set rstMyTable = CurrentDb.OpenRecordse...
Hi, I currently have Sales information stored in an Access Data table. This table has the names of all the Salesman in the field "Salesman". I want to export this data to excel on seperate s...
I have an issue with one of my computers.
I installed Access 2000 and not able to open switchboard.
I have compiler error. When I go to VBA Code/References
Library DAO 2.5/3.5 Compat...
Hi There,
I need to edit existing linked tables to change the DSN. They were created by a previous employee who has since left and now various reorts using these tables are no longer workin...
I have a form that a user selects certain fields and a button that will run the code. What I want to do is when they click on the button it checks each record or row in a table that matches th...
Hi- I am a beginner in Access and need to do the same thing as below- Except instead of months, i have 3 years of wks ( so 156 columns)
Could you walk me through the whole code? starting with...
I need the ability to import an Excel Worksheet into a specific access table. The tables are identical except:
1) The destination table has an additional Date Field. This field needs to be ...
"User-Defined type not defined."
The text is highlighted at Dim Target As Range
/////////////////////////////////////////////////////////////////////////////////////////////////
Private...
I'm sure I did a terrible job describing my question and hopefully I can do a better job here.
I have a query (final query) that is the result of several other queries. There is a unique fi...
Hi everybody,
How do I delete a record from the recordset, I wanted to check if my record on my table exist on the other table? I am using ADO and MS access VBA. The problem is I wanted to ...
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...
Convert VBScript to VBA - so code can be used in an access project.
Yesterday I had a problem whereby I need some vbscript code - to search text files in a given folder and sub foler for a te...
I'm looking to write a function to call via a query which will clean up some unwanted characters in some data I was given. I can successfully strip out the first occurrence of the first chara...
Hi,
I have used the attached code to add an outlook appointment from Access to outlook and it's working nicely, but I want to assign the appointment to different employees who are involved. ...
I need to have a function that will allow me to use lists of tables and ODBC entries to allow VBA driven linking of tables. The ODBC entries will be created before the code is executed.
I h...
I have a query that need to be exported on Pivot Table for Analysis proposes.
The required pivot wanted is called "finalpivot.jpg"
I just got an error, "see runtime-jpg"
the code below only...
I have a form that my consultants use for contact management. On the form I have a sub form that is used to log each contact with the client. I have added a new command button called "Left Me...
We have the following bit of code originally created in Access 2000 (Windows XP). Now that we are upgrading to Access 2007 the code is no longer supported.
Set fs = CreateObject("Scripting...
