I have an Access application (originally created in Access 2003 and now running in Access 2007) that runs a series of queries and then does a docmd.transferspreadsheet. When I run the queries...
We have a runtime application that has been distributed to many users. We have a new user who is running our software, runtime in Access 2002 on Windows XP Pro. When the program opens the fi...
I have tried implementing the code provided in the following solution for multiselect listbox:
http://www.experts-exchange.com/Database/Miscellaneous/Q_21989025.html
My code is attached to...
Can anyone please help with the code below.
I have a table with a number of columns with different cost buckets, and I want to get it into a format where I have all the costs in
one field,...
I am having an issue with the Open Method (ADO Recordset).
The line:
rsStudents.Open stQuery, con, adOpenDynamic, adLockBatchOptimistic
In the snippet below returns an error of "...
Hi
I'm setting up an Access DB for easy distribution to my colleagues. Trying to avoid having to setup the DSNs and the linked tables over and over again.
Have a good script which sets u...
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...
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 ...
Hello Experts,
I have developed an access database, along with all the vba code, using Access 2000. One of my users recently upgraded to Access 2007 and is now receiving error number 2950 wh...
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...
Option group (optTransportType) is on a form is and is set to null by default. In the Before Update Event of the form, I want to check optTransportType to make sure that the user has selected...
I need to find code that will create a reference to another Access DB which contains generic code used throughout several other company applications. All of our user's applications are shared...
Using Access 2003 VBA. I need to take a table that has one record in it. It has 10 fields.
Each field contains a number.
I need VBA to read the numbers in this record and then create ...
I am using MS Access 2003. I want to have my database open up in maximized view when opened. I have a form open up on startup and I need it to open maximized. I created a macro and in that mac...
Thanks in advance and please let me know what add'l info you need
I have an Access 2003 parameter query (see attached file). In that query is a parameter in a criteria field that in some cas...
I've pasted my SAP GUI script into a Microsoft Access module. the script works if I run the .VBS file from my desktop, but when I try to run from within Access, I get a comile error 'Method o...
I am trying to automate chart creation using VBA in MS Excel. I want to eliminate the chart legend and set background colors in the source data cells of the chart to match the fill color of t...
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- 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...
The below code is intended to delete the form record. The subform data is deleted via the "delete cascading records" relationship option. The button works with no errors and the final messag...
My old employer built a slick little tool that built an ODBC connect string in Access and then used that string to connect the Access front-end to a SQL Server backend. I know he used some op...
This works
CurrentDb.Execute "CREATE TABLE MyTable ([FindText] TEXT, [ReplaceText] TEXT, [WholeWord] TEXT);"
strQuery = "SELECT * FROM MyTable"
Set rstMyTable = CurrentDb.OpenRecordse...
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...
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'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...
