I've created a mdb that i'm trying to run from a command window. When I type "vemacro.mdb" at the command prompt the mdb runs fine. But - after it runs I get a popup error window that says "cannot find the file "f:vevemacro.mdb" (or one of its compenents)." But - it DID find it and ran it just fine.
I'm running ms access 2003 and windows 2000.
Can anyone tell me what is causing this to happen??
Is there a way to use a command button to display the database window. I changed the Startup to not show the database window and want to be able to show it using a command button. I would appreciate any help.
I created a command button from using the wizard so when I click to delete the record the button is for, a window pops up asking if I am sure I want to delete the record. Is there a way to not have the button pop up?
Here is the code:
Private Sub cmdCompleted_Click() On Error GoTo Err_cmdCompleted_Click DoCmd.RunCommand acCmdSelectRecord DoCmd.RunCommand acCmdDeleteRecord
I know this can be done but I'm a novice at VBA. I have a batch file AutoLoop.bat which I run from command prompt at the moment. The idea is to run a VBA routine behind the onClick event of a command button in Access which would run this batch file in command prompt automatically. Say if the batch file path is I:AUTOGENLOOPGENAutoLoop.bat, what VBA code can be used.
I'm currently working through developing my first database.
Basically, what I would like is for a query to run from a command button.
The query should look at a field in a table (a yes/no field) and report back the ones that have been filled in.
I know how to run the query from the access 'Query' window, BUT, I would like this query to run from a click of a command button on a form.
I've looked it up in a book, which explains about SQL, and didn't really understand it. I've also searched on here, but people talk about Macro's, and I don't know anything about them.
I have a parent window which upon clicking on a button will pop-up a child window containing a listbox. The listbox recordsource is a subset of the parent window. I want the user to select a record from the listbox which will load the selected record onto the parent window.
How does one pass argument back from child window to parent window?
From parent window to child window, I used docmd.openform ,,,,,,[argument] and me.openargs in the child window
Can anyone tell me how to get a running balance on a report. I know how to create a running total, by setting the "running sum" property of a text box to "Over all".
I can't however see how I can adapt this to give a running balance (as in a bank statement for example). Attempts to do so end up in failure!!
My application is developed in Access 2003 version. Recently we moved from Access 2003 to Access 2010. Now users are facing usability issues like - in Access 2003 all the forms are opening in different windows and they can move to forms easily. But in Access 2010 all the Forms are opening in same window, if they want to move to different forms then they need to close the current window or press ctrl+F6. How can I enable/open forms multiple window in Access 2010.
I am rewriting an old Access 2003 database in Access 2010. When creating new command buttons, the current theme gives them a default appearance. I need to apply this appearance to old command buttons. I know there is a way to select the default button and apply its properties to others quickly. I have done it before but didn't write the process down .
For my Access DB, I have unselected the relevant options in Tools – Statup to hide the Objects window so that inexperienced users don’t corrupt the design of the forms, reports etc. However, I find that hitting F12 key brings a pop up window ‘Save Form (name of the form open appears here) To: ……….(blank text box). As ……(form or data access page options here)’ with OK and Cancel buttons. Hitting OK saves the form as it is and typing something after ‘To’ saves the form in that name. Though it doesn’t corrupt the DB in any way, I find this pop up window an irritant. Is there a way to stop this?
ive been disabling the database window from the startup tab in MS access, just now when ive tryed to show it on startup it appears but its stuck in the top left hand corner and i cant move it! so i cant access the tables
I've imported somebody's access db which hides the database window by default. When I click the db window button in the toolbar, the db window pops up high up and is somewhat hidden by the toolbar. I can't pull it back down as the top is hidden and when I try to move the toolbar,the db window simple moves up so I can't grab it and move it. Any suggestions?
In order to prevent inexperienced users corrupting the design of the Forms, Reports etc. of my Access DB, I have unselected the relevant options at Tools – Startup and it doesn’t display the Objects window. However, I find that when I press F12 key, a pop up window appears with ‘Save As’ ‘Save ‘frm……’ To: As …..’ with OK and Cancel buttons. Though a user can save the form with a different name and this does not interfere with the proper functioning of the DB, I find this an irritant pop up window. Is there a way to stop this pop up window?
Hi, I have been using Access 2000 for quite a while now. I have been using the Immediate Window to call my code, but for some reason, this window won't display now, no matter what I do - I have repaired the installation and reinstalled it but to no avail
This may seem silly and I've seen no mention of it in this forum yet but the "Database Window" from previous versions of Access is now called the "Object Browser"? I had code to hide the database window on startup but can't seem to find a way to hide the object browser on startup. Any ideas? Also, is there another way to view my objects in ACC07 because this way is slowing me down tremendously! It's much more difficult to find the objects I'm trying to work on and visually see where I left off. Any help would greatly be appreciated! Thanks in advance.
I have a button on a form that opens up a report. However, the report always opens in the background. How can it change so that once the button has been clicked on, the report comes to the foreground and the form in the background. Please see attached example. The button is called 'Label'.
I have one button for doing the above action, it works.
when the form come out, there is only close window (x), it doesn't have minimize window (_) option. How can I make minimize window button at the top right corner?
Hello all you experts and thanks in advance for your help.
I want to issue a message box after a window (a form) is displayed. I have attached it (in VBA code) to the onOpen event but the message displays before the window is displayed. So I tried, OnCurrent, then onLoad, but in each case the event triggers the message box before the window is displayed.
Is there an event which triggers AFTER the display of the window. Note that I don't want the message box displayed several times so onGotFocus is out.
How do I stop a new window opening everytime I open a new form. When I get going on the latest project, inputting data I can have up to 6 different windows open.
hi guys, easy question. when the DB is open a login form comes up. The issue is that the properties window for that form comes too. any suggestion? thx max.
HI: I have a db with about 70 tables in it. I am trying to see the relationships among say, 40 of them, all at once. I like the view of the relationship window but: I cant scale it, select multiple tables and reposition them, use the mouse wheel to move it (only the window sliders), and, I have to click on a table entry to allow me to reposition the table (should'nt I just have to click on the table outline itself?). This is a really awakward thing to use. Also, I can't seem to 'Shrink to fit' the relationship window when I print it. Is it cockpit error or just really broken? Any way to make it easier to work with? (or, did I choose the wrong DB tool for the job?)
Is there a way to remove the design window from your project ?
I have made a program but, the problem I am having is that when I run it and say the query results show up I close that window and then the design window shows up. I need the close button on the other windows but I need to block out the design window when I use the program. I also know about the start box where you can uncheck items and they are removed. Am I missing something ?
Dear Friends I made my a stupid mistake and I don't know how to rectify it.
There is a inventory software built in access xp. In order to protect database I've cleared all the options from that is
a) Display Startup form b) Display status bar c) Allow Full menus(Changed with Custome Menu) d) Allow Default shortcut keys e) and foolish thing cleared Use special key also
I've given a task to modify program where I may have to add New form. I don't know how to unhide database window. pls suggest me what to do....
