I have a front end that I have distributed to four users. The front end sits on a shared drive and when I make design changes I just replace it and have the users copy it over to their desktops.
I set up a main menu for them to access the various forms, reports, etc. When I first open the front end on my desktop the main menu form is small and not taking up the entire screen. I put the cmd.maximize command in the on open event and still does not maximize the form when I open the database. I tried to size it and saved changes but still not working.
I just did a share session with a user and she opened the form and it was maximized on her desktop.
I have a database with a Main Menu Form, containing a Button that loads my main data entry form. When the Button is Clicked portions of the data entry form that is loading shows through the Main Form Background (e.g. portions of the navigation bars, and portions of the boarder on the form that is loading.)
I 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.
Hello 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.
I'm using overlapping forms in my Access 2010 database.
When the form(s) open I want them maximized and I don't want the restore buttons to be available.
I have the Min Max Buttons set to None.
I have DoCmd.Maximize in the On Load.
I want the border style set to thing.
Is there any way to prevents the Restore button to be enabled?
I open the first form it's maximized as per the DoCmd.Maximize in the On Load. I then open another form (which has nothing to do with the first form) and it opens maximized. When I close the second form the first form is no longer maximized, it's restored.
I have been trying to figure out how to make a main menu that link to certain tables I have. I want the links to go to the tables/forms so that they can be edited, but I don't want the user to be able to enter design view. I have attached an image of what I want to have below.
Is there any way of deactivating the main Menu Bar ("File","Edit","Insert","Format") when a form opens?
I need to implement this for a single form to stop an idiot user from trying to break the system! :mad: He's not doing it on purpose - he's just ignorant and doesn't listen or understand when I try to explain to him NOT to add a record by using the "Insert - new record" command, but to use the command button on the form which has some built in safety features (such as password protection).
I've managed to get rid of some of the other ones by using the coding below: Application.CommandBars("Form View").Enabled = False Application.CommandBars("Formatting (Form/Report)").Enabled = False Application.CommandBars("Formatting (Page)").Enabled = False
I am writting a database and i am have difficulties with forms.
What i need to do is have one form (Main) maximized and the other windows set to a standard size, the main form is always visible the others need to be opened and closed via buttons on the main form and sub forms.
I am not sure if this can be done so any help would be good.
I have recently created a small inventory database just for fun, but I am looking to expand my knowledge with Access since I have not dealt with it hardly at all. I would like to know how to create a regular main menu to the database that gives you options on what you want to do. I would like to be able to look up inventory by serial number, edit inventory, add inventory, and run reports from the main menu. If anyone could help, I would greatly appreciate it.
On this form I have a button to open another form, this works fine. On the second form I have a button to close the form. When I press this it closes, and the first form is still there which is what I want, but somewhere along the line it has unmaximised itself and is about half the desired size. Basically I want it to stay Maximized the whole time it is open.
The way I can think to get round this is to close and re-open the forms as I navigate through them but just wondering why this is occuring?
I have a db app that has all forms maximized continually (I have set the vba code to do so on Open, Close and GotFocus events). From my app Home Page form the user can browse to other forms in the db. When another form is opened the window automaically maximizes. However, when the user navigates back to the Home Page it goes in restore mode. I haven't told it to do this anywhere. I have also tried saving the form stretched out to fit the full screen, so that if it goes into restore mode it at least still fills the screen, but it still reverts to a restored window (about half the screen). It doesn't matter what configuration I use in the AutoResize, AutoCenter properties either.
I have been developing custom db apps in Access for over 8 years. However, this seems to be a stupid (albeit simple) problem that is annoying me. I currently use Access 2003 and this issue is new (or so I believe since I never ran into the problem in previous versions).
Thanks if anyone can offer a suggestion, I cannot find a similar problem described on the forum.
I have a form which runs at startup maximised. Pop-up and Modal are set to 'NO', Auto Resize and Center are also set to 'NO', Border style has been set to various settings, and Moveable has also been tried at 'YES' and 'NO'.
A command button on this form opens another form with the same settings which I want to take the original form's 'place' in the application window.
This all works fine, just that when I close the second window (using DoCmd.Close), the original window is then no longer maximised underneath it. I want to make sure certain windows are maximised at all times.
I know I could hack this with a DoCmd.Maximise somewhere, (or by switiching to full Pop-up/Modal mode and hiding the Application window) but the results of these are all a bit of a hack.
Can anyone shed light on the mysteries of Access's default form maximisation behaviour?
Or does anyone do what I have described successfully?
Currently I have a basic database with the following
Table 1 = "EmployeeT" with fields "Employee_ID", "First_Name", "Last_Name" etc. Table 2 = "NewLabReportT" with fields "Report_ID", "Report_History", "Submitted_By", "Reviewed_By", "Date_Submitted", "Report_Title", "Abstract"
Form 1 = "MainMenuF" this is where I would like to have the search Form 2 = "NewLabReportF" with fields "Report_ID", "Report_History", "Submitted_By", "Reviewed_By", "Date_Submitted", "Report_Title", "Abstract" Form 3 = "EmployeeF" with fields "Employee_ID", "First_Name", "Last_Name" etc.
Problem:I would like to have on the Main Menu a drop down list with all of the fields described in NewLaBReportF ("Report_ID", "Report_History", "Submitted_By", "Reviewed_By", "Date_Submitted", "Report_Title", "Abstract") and then allow the user to click a button to the side of it to alert a pop up.
In this pop up:
If they originally clicked "Report_Id" then have the message prompt then to "Enter a Report ID" If they originally clicked "Submitted_By" then have the message prompt them to "Enter an employees Last Name" etc...
Further More, after they enter the respective value in this box, have a FORM not a REPORT generate that lists all of the records that match the criteria. This way then can specifically click on each record individually and have it open directly up to it.
I have a table called exiting staff data and a field called Follow up required. I want to count the number of Yes entries and display it on the main menu. Have tried
Code: =Count([Exiting Staff Data].[Follow up required]="Yes")
I want to create a main menu page for my database. I have tried the Navigation form and obviously I am doing something wrong....because the tabs won't open the forms. We have Access 2010 at work and I would like to create something similar to this:
Cardinal Rap - Main Menu
[button] Input Monthly data This button would take me to another screen that would list the tables for appropriation, expenditures and revenue, each with their own respective button
[button] Reports This button would take me to another screen that would would list the reports available each with their own respective button
[button] Monthly reconciliations
This button would take me to another screen that would list the tables necessary for my monthly reconciliations each with their own respective button that open that table.
The tabs in the Navigation form don't seem to do anything.
I have fields on the main menu where folks put in a start and end date prior to running a report. I'm doing a monthly report that pulls current month, and two prior months of data. For example, the user selects a date range of 10/1/14 to 10/31/14 the report will show August, September and October results.
I need the column headings to change each month depending on the date range they select to run the report so in November they will pull 11/1/14 to 11/30/14 and get September, October and November.
The headings for the columns would then adjust.
I put an unbound text box with the formula as follows in the control source of the report page header to pull the month that is equal to the current month minus two (I'm just showing one of the column headings formula):
I have a main menu "MainMenuF" in my database and I would like the database to be able to be searched by any of the column headings. For example I have a table titled "NewLabReportT" this table has many column headings like "Submitted By" "Reviewed By" "Title" "Abstract" etc...
I would like my users to be able to click a radio button with the same column headers on this main menu and have a box that pops up to say "Enter search parameter" and have that parameter be searched in the table "NewLabReportT" and generate a FORM not a REPORT of all of the listings in the database that have that keyword associated to that certain category searched. That way they can "CLICK" the exact field they are looking for and have it open right up to that form.
I 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!
I created a form that has a drop down menu to select a name. I attempted to set it up so that once a name is selected, another form is opened with that person's information. I was able to get it set up so that the first form closes and the second form comes up, but I can't get it to filter the name. I tried using SetTempVar and then SearchForRecord, but got nothing. I tried using OpenForm and Where Condition equals the search, but just got the automation error. It is currently set up using SetTempVer, OpenForm, SearchForRecord.
I have a subform which makes a change to a field on the main form. When focus is returned to the main form, the BeforeUpdate and AfterUpdate events fire. Why? I thought from the form's perspective, the subform is just another control.
BTW, I get the same behavior if I modify the field from within the Exit event of the subform control.
In either case, the main form's Dirty event is NOT triggered.
currently i'm trying to implement a right click menu which will show a simple messege box.
My problem is that the list box is on a pop up form which opened up maximized. Now when i'm right clicking on the list box i see the right click menu but when i'm clicking on one of the menu options, nothing happenning (it seems that it don't go to the function as it should). i've also putted breakpoints on the function but it never tips.
It's important to mention that if i'm setting the form popup option to no the right click menu works perfectly (when i'm clicking on one of the options i see its matching messege box).
I'm running the following vba code:
This is the mouse up event handler for my list box:
Private Sub Song_List_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As Single) ' Call the SetUpContextMenu function to ensure it is setup with most current context ' Note: This really only needs to be setup once for this example since nothing is
[Code] .....
setting up the "SetUpContextMenu" sub:
Public Sub SetUpContextMenu() ' Note: This requires a reference to Microsoft Office Object Library Dim combo As CommandBarControl ' Since it may have been defined in the past, it should be deleted, ' or if it has not been defined in the past, the error should be ignored
In the default property of a subform control I want to use a control of the main form without using names of forms, but using me and parent.
I used in default property of cboVATDetail: =Me.Parent!cboVAT, but it is not accepted. My aim is to use cboVAT of parent as default in cboVATDetail of child.
New to the navigation form: I need several forms in the navigation form to all relate to the same client ID field. I have this information on the main form but the form with in the navigation form will not pick it up.
I have tried =[Forms]![Frm Client Information Navigation Panel]![ClientID] But just cant get it to pick up that information...
I would like to have something like the master link fields and, child link fields but when I add a form to the navigation form this option in not available.
