Tagged Questions
0
votes
1answer
10 views
Macro Bulder MS Access Insert textbox value into msgbox
I have a macro built through the macro builder that has a msgbox that says "success, you've been assigned task number:" I would like the task number taken from a "tboTaskNumber" to follow this ...
1
vote
2answers
39 views
Export Access database with multiple tables to Excel with multiple sheets
The title says it about all. I'm trying to write a VBA script that would allow me to run inside Access and it would export all database tables as separate sheets into and Excel file with the same name ...
0
votes
1answer
37 views
Calling a Function from Macro Design In Access
I have written some sql queries, some sub procedures and have some saved imports. Now I am trying to use the Macro Design in Access to provide a run button which will run these objects sequentially.
...
1
vote
1answer
34 views
Arranging data in access or macro
I have some data in the excel sheet and I am trying to get those data to Access. But the data is really in bad shape. This is the what the excel has.
country, product, id, 1qtr 2010 flash, 2qtr 2010 ...
0
votes
0answers
34 views
VBA Macro Code Stopped Executing
The Setup:
I have an Access 2007 front end (Forms, Queries and Reports) with my data hosted through Azure.
I have the master front end on my desktop that i do development on and when major ...
0
votes
1answer
42 views
I'd like to make “Any Part of Field” Default (Access VBA)
In a simple Find action dialog box on an MSAccess (2007) form I want to make "Any Part of Field" the default value when the Find and Replace box appears. The actual default value is "whole field". I ...
1
vote
1answer
43 views
scheduling execution of MS Access DB
I have a MS Access 2007 DB that is being executed via Windows NT scheduler. Basically, I created this entry in Windows Scheduler that is run every night at midnight.
...
1
vote
1answer
177 views
Opening an MS-Access database from the command line without running any of the startup macros?
Is there a way to open an MS-Access 2003 database from the command line without running any of the startup macros or displaying any errors?
I looked at the command line arguments for MS Access and ...
1
vote
1answer
77 views
“ #Name? ” error in access using DLookup
What I am trying to do is to have a value("Element" which is a primary key) from my Elements table be inserted into the time text box based on the result from the previous combox box is this the ...
2
votes
1answer
80 views
How to list DataMacro objects in an Access database?
Is it possible to programmatically enumerate the Data Macros in an Access 2010+ database? If so, how?
Note: Data Macros are trigger-like procedures that are created in the context of the table ...
0
votes
1answer
30 views
MS Access transfer text throws unparseable errors when quotes and apostrophes are together
A section of what I'm parsing is this
E,"1"".""0""1","1""/""1""1","3""4""5""6","6""5""4""3",'1"'1"'1"'1","1""1""/"
The parse always stops at '1"'1"'1"'1" right on the first quotation. Nothing after ...
2
votes
1answer
104 views
preventing Autoexec macro from running after Compact & Repair
Seems such a simple thing, but I can't find the answer anywhere.
Every time I Compact & Repair, my Autoexec macro runs again. Is there a way to prevent it from running here, as part of the reason ...
0
votes
1answer
140 views
“File not found” at the execution of any VBA code in Access 2007
I'm working on a big Access 2003 project with Microsoft Access 2007. Recently, some users have started to experiment problems with the buttons in my forms. For example, without any specific reason, ...
0
votes
2answers
330 views
Updating Access Database from Excel Worksheet Data
I extract data from my Access database into an Excel worksheet using a macro. I first open a connection to the database, define my sql statement in a string var and then dump that data in a recordset:
...
-1
votes
1answer
41 views
Export every entry for a given identifier to an excel workbook by that identifier
I have a database containing over 4,000,000 intra-operative temperature readings (4354499 x 8). The database is therefore to large to copy and paste.
Variables:
caseID - the unique identifier for the ...
