Questions tagged [autoexec]

18 questions
3
votes
1 answer

Access 2010 VBA Error 2425 "The expression you entered has a function name that database can't find"

In Access 2010, I have an Autoexec macro that calls a function (not a sub, a function) called CloseAllToolbars(). In the .MDB file, when I open it, it runs the function just fine. I Save & Publish it to an .MDE, the .MDE runs the function just…
Rexxrally
  • 323
  • 1
  • 3
  • 12
2
votes
1 answer

Emulating a SHIFT key press when using VBA to open an ms-access database secured by an mdw file?

I want to run recursively through a directory of *.mdb files and search them to see which ones have a specific linked table. These files are secured using several *.mdw files. I did not write any of them, but I am their maintainer. I've found a…
leeand00
  • 25,510
  • 39
  • 140
  • 297
1
vote
1 answer

Suggested startup tasks for access split DB (AutoExec)

I am working on a MS Access split database and I read in many places to create AutoExec macro to automate a few startup tasks like securing front end (hide ribbon etc.). I am learning as I am going through the project so I am fairly a newbie to…
Aniq Ahmed
  • 23
  • 3
1
vote
1 answer

How to execute a function at start in Emacs

I want start following function (from Replace one space by two after sentences in Emacs) to run when I right click a file in file-manager to open the document with Emacs. (defun space12 () (interactive) (save-excursion (goto-char…
rnso
  • 23,686
  • 25
  • 112
  • 234
1
vote
1 answer

DOSBox autoexec menu design

I'm trying to make a (somewhat) stylish DOS menu as a present for my father. I was able to get the whole menu system to work, but I wanted to gussy it up with some box drawing characters and, possibly, colored text. In this YouTube video, the user…
jeffjenx
  • 17,041
  • 6
  • 57
  • 99
1
vote
1 answer

How to open an Access database that has an error on AutoExec?

I created an AutoExec macro on Access 2007 and wanted to try a new function I created on VBA, but the function throws an error and everytime I open the database I get an error and the database closes, so I can't edit the code or the AutoExec macro…
user3614001
  • 13
  • 1
  • 5
1
vote
0 answers

Make Visual Studio execute macro code when loading macro module

Our development group is using Visual Studio 2010. I have created a library of various macros that our development group uses. The library is a typical XXX.vsmacros module. The module has code (a macro) that also creates a menu item in the manu…
David I. McIntosh
  • 2,038
  • 4
  • 23
  • 45
0
votes
0 answers

Is there a way to automatically execute a Python file when quitting Spyder (sort of like the opposite of startup)?

Spyder can execute code on startup; one can even run a whole .py file when Spyder is first launched. I was just wondering if there was something similar for when Spyder is closed? That is, automatically execute a .py file when you close/exit Spyder…
0
votes
0 answers

VBA Access User-Defined Type not Defined when Running my AutoExec Macro

I am trying to test out my code that I have written, and when I go to run my AutoExec macro, I get the error "User-defined type not Defined" on the following line of code: Public Sub WFR_Style(xlBook As Excel.Workbook) I have the following…
Jenna Terral
  • 67
  • 2
  • 11
0
votes
1 answer

MS Access - "Cannot Find the Name... In the Expression" error - IIf CDbl statement

My Problem I have a fairly straight forward autoexec macro to perform a version control check for my split database. I have a table in the frontend called LocalVersionNumber, and a table in the backend called LiveVersionNumber. Each version number…
TMY
  • 471
  • 1
  • 7
  • 20
0
votes
0 answers

Call an auto compact after event

I have some code, which works perfectly fine, that compacts an Access database when the database is opened. However, I'm a little stuck as to how to do the next bit. What I want to happen is that when an item within the DB table gets marked for…
0
votes
2 answers

Windows 7 and autoexec.bat

I am not sure whether autoexec.bat is supported under Windows 7. I need to run some commands at startup but before any user logon.
i486
  • 6,491
  • 4
  • 24
  • 41
0
votes
0 answers

Advice batch-File should open origin with data

I have never worked with batch-Files, so I´m sorry for that stupid question: I have a batch-File containing these 2 lines of code. echo def autoexec{ run C:\Users\s\Desktop\BBB\Temp\amiX_VectorPlot_GasVel#1.scr;} >%TEMP%\amix.cnf …
user3443063
  • 1,455
  • 4
  • 23
  • 37
0
votes
2 answers

What is the consequence of using my own autoexec.sas file?

I want to write my own autoexec.sas file, but I don't want to lose any functionality that I might have had from the default autoexec.sas file(s). When I do a SASHome directory search, I find many files with this name. Do all of these files execute…
swirlingsara
  • 105
  • 1
  • 4
0
votes
1 answer

adodb, AutoExecute update field with field

i have table "users" like this id | firstname | lastname ========================== 1 | Ujang | ahmad 2 | Jajat | sudrajat and have data : $record = array('firstname'=>'some value', 'lastname'=>'some value'); $table = "users"; and…
a.fauzi
  • 163
  • 1
  • 2
  • 11
1
2