Opening A Form From The Program Start Menu
Jun 10, 2006Hi,
I would like to be able to open a customer form without starting MS Access.
Is there a way to make a form an executable module?
John
ADVERTISEMENT
Forms :: Closing Opening Form With Timer Then Opening Main Menu
Apr 7, 2014I have a Form opening from Access Options. I would like to close this Form using the Timer. The following is the code I have used but it is not working.
Private Sub Cover_Page_Form_Load()
OpenTimer = Timer
End Sub
Private Sub Cover_Page_Form_Timer()
If (Timer - OpenTime) = 5 Then DoCmd.Close acForm, "Cover_Page_Form", acSaveYes
End Sub
Next question. If I can get this to work can I then use a DoCmd to open new Form within the code above or do I need a new process.
Forms :: Menu Form Keeps On Opening?
Jul 28, 2013I have a series of forms. The 1st form is my main menu. On this form I have 5 command buttons which gives the user options to ...
Button1 - Enter Station Scores
Button2 - Print Performance Sheets
Button3 - Print Audit Sheets
Button4 - System Administration
Button5 - Quit
When the user clicks one of the buttons (with the exception of the Quit button) I perform the following code (This code is for the 1st button)...
Code:
Private Sub cmdEnterStationScores_Click()
' Open select workstation
DoCmd.OpenForm "frmSelectWorkstation", acNormal, , , , acWindowNormal
' Close main menu
DoCmd.Close acForm, "frmMainMenu", acSaveNo
End Sub
So far so good...
The "Select Workstation" form opens fine with no sign of the main menu. I have a "Continue" button on this form which opens yet another form using the following code...
Code:
Private Sub cmdContinue_Click()
' Delete workstation name
Call DeleteWorkstationName
' Store selected workstation
Call StoreWorkstationName(strSelectedStation)
[Code] ....
...For some reason the "Main Menu" form reopens itself at the same time as the "Enter Sort Scores" form, so I have 2 forms on the screen, with the "Main Menu" screen on top.
Why does the Menu form re-open?
I have set breakpoints in every bit of code I have and stepped through it all, but nothing I can see references the Menu form!
OOPS. I've Erased All My Menu Items Upon Start-up
Jun 16, 2006Hello all, (Access 2000)
I had a problem with one of our users getting a little too involved in our data base so I went to Tools and to Start-up. At the bottom-left of the window I de-selected:
Allow Full Menus
Allow Default Shortcut menus
I did this so the bare minimum shows up and the users can only use the intended functions. I now see my mistake as I cannot do anything with the db. The only menu options it gives me are
File
Window
Help
I tried to create a macro to restore my menu items but according to the help menu that only works for forms and reports. I've gone through every option in the help section. Problem is they all say to start with the 'View' menu item which I now no longer have.
Any thoughts?
Open Database Without Opening Full Program
Feb 18, 2008Im trying to open my database switchboard without having the whole Access program open. Is there a way to have only the database open without the whole program?
Thanks
Opening An Access Program Without Opening Microsoft Access
Jun 11, 2007I am very close to completing a DB Program.... How can I create a desktop Icon that will Launch my Program without Loading Microsoft Access along with it???
View 6 Replies View RelatedCan I Map A Program (.exe) To Abutton In A Form?
Mar 3, 2008I would like to place a button on a form that maps to a program on a user's computer. For example, the button says PROGRAM and then the user clicks on the button and it opens an executable located at c:PROGRAMprogram.exe
I am assuming that I can do that with access, but how?
Thanks for any help!
Calling Another Access Program From A Form
Jul 27, 2005How do you use a button on a form to call another access program? We have 8 access programs that we want to be able to call from one form.
Thanks
Exectue Java Program From Form
Dec 14, 2005Hi all,
I wrote a vba program which I couldnt get to work correctly, so I redid the whole thing in java and now I get the output I'm supposed to get. I'm wondering now if I can execute this java program from a button on my forum in access? and how should I do this if this is possible?
Thanks
Only Show Form Application When Open A Program
Aug 17, 2006Hello,
I once used a program, when you click this .mdb file, it opens a main Form interface that user can run programs such as view report etc. That is, all tables, querys reports, other forms are behind the sence (user does not need to know them).
Could anyone tell me how to do this? Thank you for yoru help.
Form Load On Database Start
Dec 7, 2005Hi
how do I setup a "welcome" form to start on database start?
miha
How To Stop Query Execution At The Form Start
Dec 19, 2005Hi
I am a new user to Access. I created couple of forms using wizard, but when I view them, they show me all the available data by default. I want to stop this, if anyone can help me plz.
RMA
How To Auto Load(on Start) A Form In Access 2000?
Jun 17, 2005Hi guys. I have some forms in my access database and i want load one of it automatically
when i double click on my access.mdb . I be happy if some one teach me how i can do that.Thanks
Forms :: Loading Only Default Form On Start Up Of Database
Mar 23, 2014I need to load my Default Form at start up of my database while office button,the Ribbon and the Navigation pane will be hidden. And when i go to form design view then i can use the ribbon and navigation pane.
View 2 Replies View RelatedForms :: Adding Breaks On A Form - Start And End Time
Jun 18, 2014I have an input form for production. I need to be able to have a unbound box look at the start time and end time. I need it to determine if the times fall during a break or lunch. My fields in my table are - ID, Start Time, End Time. Example of what I need the control source formula to do is this. If I start at 6:00 AM and work till 10:00.AM and my break is Start Time 9:00 AM... End Time 9:10 AM. I need it to then show 10 in the box as result of the break. I have this so far as in my formula builder.
IIF([Start Time]<9:00 AM AND [End Time]<9:10 AM, 10, 0)
When I press enter it says I have an syntax error and I have checked to make sure the fields are correct. Also how would I go about adding on to this formula to add a lunch break on to it.
How To Show A Full Menu On The Menu Bar
Feb 19, 2007Hi everyone,
I was trying out the options on the startup item of the tools item on the menu bar and my access window has gone except the following menu items: File,Window and Help.
Can someone kindly show me how to bring back these seemingly lost items?
Thank you for your willingness to help me out!
Forms :: Start And End Date Text Boxes In Search Form?
Nov 7, 2014I have a pair of captioned text boxes for taking the criteria for the search result. Currently the text boxes are tied with a date field. I would like to give the user's choice of a number of date fields. After some research, I believe option group control fits for this purpose. Unfortunately, I never try this function before.
View 1 Replies View RelatedMenu On Form
Feb 24, 2006I have searched and read and figured out how to make a custom menu bar. I see how I can use the forms property sheet to change the menubar that is available when it is open.
I've also seen code to hide the database window so that the form appears as a stand alone application. Like these links:
http://www.access-programmers.co.uk/forums/showthread.php?t=100545
http://www.access-programmers.co.uk/forums/showthread.php?t=98163&highlight=hide+access
If I do that will my custom menubar is hidden?
Is there a way to add a menu bar directly to the form? Make it part of the form?
I found similar questions unanswered here:
http://www.access-programmers.co.uk/forums/showthread.php?t=75316&highlight=menu+bar+form
http://www.access-programmers.co.uk/forums/showthread.php?t=14722&highlight=menu+bar+form
It was answered here but I must be missing something.
http://www.access-programmers.co.uk/forums/showthread.php?t=55582&highlight=menu+bar+form
When I change the forms menubar property to me menubar, my menu bar is dsplayed when I open the form. It is displayed in the Access window, not in my form.
Menu In A Form
Nov 11, 2006I have a form that I want to display at startup and in that form I want to have a menu that will allow me to show outer forms and reports.
Can anyone tell me how to do that?
Main Menu Form
Nov 26, 2006Hello all, i'm trying to create a database just now and i'm banging my head a little on the forms side of things.
Can anyone tell me how, or if its possible, to create a "Main Menu" form, that gives you options to say, add a record to a table, to delete a record etc.
any help would be greatly appreciated.
cheers guys
Form Dropdown Menu
Nov 4, 2005In an Access Project I have a form with a drop down menu linked to a parameter query. How would I set the query parameter to Environ("userName")? Any help would be appreciated.
Thank you
Open Form On Menu Then Close Old Form
Feb 19, 2005I've a custom menu bar from which I can choose any of my forms. However when you choose a new form the old form stays open, sloppy in my mind. Is there any way i can choose the new form from the menu bar & close the previous form? I've tried to close on deactivate, w/ no luck.
View 2 Replies View RelatedSub Menu In Form Based On Above Field
Feb 21, 2005Hi it possible for lookup in 1 column to be dependant on the lookup on another columns depending on what is clicked in a form to make it easier
brand table
field 1: Number auto
field 2: Drink linked to lookup table called
drinks
field 3: type of drink linked to lookup table called
subdrinks
Drinks table
Pepsi
Coke
other
Subdrinks table
original coke cola
diet coke
coke with vanilla
coke with lemon
original pepsi
diet pepsi
persi max
pepsi with lemon
now in a form looking at the brand table. the person clicks on Drinks = picks coke from drop down menu
what I need is if the person picks on coke the next drop down menu type of drink it should only show those related to coke.
original coke cola
diet coke
coke with vanilla
coke with lemon
what i am getting is the second drop down shows everyhting and if the user makes a mistake the reports ie chose coke but in the next field chooses diet pepsi, the data does not make any sense. is there any way to limit the second drop down based on the choice in the first drop down.if there are any ideas to help in this matter maybe some VBA or macro may be required, i am not too sure open for suggestions and help would be appreciated.
Thanks
Close Popup Menu Form
Sep 17, 2006I've created a popup menu form to be loaded when you cick on another form. I need to know how to get the popup menu form to close when you click off it. I've tried using lostfocus and deactivate but that didn't work. Modal is set to no. What code should i use and where would it go?
View 8 Replies View RelatedOpen A Form From Drop Down Menu
Nov 15, 2006I have an MS Access problem I need some help with. I am trying open a form for input from selection in a drop down menu in an access database. Any ideas on how I should do this??:confused:
View 3 Replies View RelatedCreating Drop Down Menu In A Form
Aug 6, 2015In the Lesson 22 tutorial presented here: [URL] .....
They create form where the called Countries toward the end where:
The have a textbox for Government Type. It is a drop down menu of choices that the database creator can choose such a capitalist, socialist, and communist etc.
However, in the form (with the records source as Countries) there is only a space for input no drop down menu. I know this may seem awful elementary to the seasoned database designer, but how does one get it to be a drop down menu?
I have made the input in Countries table to be a look-up which I typed (see above choices) and the is the control source for the Countries Form government type. But there is still no drop down menu with choices on the Countries form. What must I do additionally?
If this is already talked about in one of the MS Access 2010 tutorials earlier lessons then a referral to that source is all that is needed.