Freezing Header Of A Form In Overlapping Tabs Instead Of Tabbed Documents
Feb 16, 2015
I have a form (frmMain) which has a header with some basic links and text boxes I would like to keep as a frozen pane on top as the user are scrolling down the detail section of the form. The detail section does include a subform if that makes a difference (frmhome). When going to Options>Current Database> tabbed documents, the form header stays frozen perfectly.
I however would like to use "Overlapping windows" as the form center aligns in the Access window instead of left aligning when using "tabbed". So either :
1) how do I keep the header frozen in "overlapping" or
2) how do I center align the form in "tabbed" view, as right now the form just wants to go as far left as possible in the full Access window.
How to set a single form's property to act as it's own "overlapping window" in a database that is set to use tabbed documents. I want most windows to have the tabbed layout but there are a few that I would like to have pop out and be their own windows.
I noticed that the Northwind database did this somehow. if you click on one of the products from the home screen a form pops up in its own window. I tried reverse engineering it, but no luck so far.
I have a tabbed form built in Access 2007. It's a series of about 32 different questions, with some being fill-in, some drop down boxes to select from, some radio buttons to choose a rating from 1 to 5. The reason I used a tabbed form was just to keep things consolidated on one screen where no scrolling was involved. All of the entries on each of these tabs are deposited into the same single table. I have 7 tabs, and all of the fields on the 7 tabs compose a single record in the table.
I have the actual tabs hidden, and instead use a button to switch to the next tab (Continue button at the bottom) once all the fields on that tab have been completed. I have all of the necessary fields set to be required, but Access does not validate the entries until the very end of the survey when they click a 'submit' button that actually saves the responses and returns to the opening splash page to start the survey again.
What I want to happen is for the fields on the current tab to be validated before it lets the user move to the next tab with the continue button. If they click continue and have left any fields blank they should get a message that all required fields must be completed or something similar to that.
I have found a thread here entitled "Form Validation before Moving to another Tab" which sounds similar to what I'm doing, but using the button method to navigate to the next tab, there is no BeforeUpdated event to assign that code to.
Because of certain design considerations and the amount of data I'm maintaining, I have chosen to use tabbed documents rather than floating windows or subforms.
The hierarchy is supposed to be a person who is categorized as either a client, family member, donor, etc. Further, a client may use one or more services. In the example, our client uses Specialized Home Care. However, the tabs are intuitively out of order: the people tab is left-most, followed by the Specilaized Home Care tab, and lastly the Client tab. It should be People, People:Client, People:Client:Service. If a person uses a lot of our services, there will be separate People:Client:Service tabs and the People:Client tab will scroll off to the right. I'd like Access to order them properly but see no way to do it.when the forms are opened, it's people first followed by the high-level classification (i.e. Client), and the lastly the specific Client:Service tabs. I would expect Access to open and display them left to right, but, as you can see, it doesn't.
Public Declare Function LoadImage Lib "user32" _ Alias "LoadImageA" _ (ByVal hInst As Long, _ ByVal lpsz As String, _ ByVal un1 As Long, _ ByVal n1 As Long, _ ByVal n2 As Long, _ ByVal un2 As Long) _ As Long
[code]...
I can load the little icon on the left on CaptionBar.It works very well on overlapping mode but no on Tabbed documents. How to works with tabbed documents mode?
I'm wondering if it is possible to create a module to hide the navigation pane and document tabs? I know this is possible via the Access Current Database options however I'd prefer this to be done via an Auto Exec that runs the sub. (i already have it for the ribbon)...
I have an on click event that checks if entered number values on my first tabbed subform are not null. I then pass the values to three other fields each on a different tabbed subform using If Then Else syntax that seems to work. When I click through the tabs after the code has finished I can see the updated values on their respective tabbed subforms. However, when I click back through the tabs or requery the record all but the first and last subform values have saved.
I have tried inserting If Me.Dirty Then Me.Dirty = False in the subform after update and on data change events as well as in the on click event. I have also tried RunCommand acCmdSaveRecord and neither seems to work.
Ex. If IsNull(Me.AMT1_AF) Then Else Forms![SCH_ENTRY]![ENT1subform]![AMT1] = Me.AMT1_AF End If If IsNull(Me.AMT2_AF) Then
I am working on fixing up someone else's Access database. There is one combobox on a form with 4 tabs that is appearing on all 4 tabs, though I only need it on one tab. When this field is deleted it deletes from all 4 tabs.
I'm trying to clean up a form a bit and have it only show certain subforms/graphs if the data exists. I already have columns in a combobox query to show an "X" for if certain data appears:
Now, I know I could build another query and have some system go through and identify these things, but the easiest thing would be to reference the "X" in the columns of the combobox. Is there an easy way to reference values in the other (non-primary) columns? Or can you think of an easy way to make these subforms only be visible when the data exists? Maybe have an on load event for the subform?
I am about to give this database to a client. It basically manages deliveries. Everything on my form is functional. The problem is Access seems to freeze indiscriminatly. I have no idea why. I don't believe Access is processing code when it freezes because control-break does not even work. I am hoping some of the locals here can take a look at my DB and maybe find the issue. This was written in A2K3.
The freeze can be broken by clicking into another program then back to access again. The freeze seems to occur onload, on new record and on filter.
I have 7 tabs on my frmQuestions. They all the same layouts (see attached). Each tab has its Save_Button (e.g. CmdSave1, CmdSave2, ... ,CmdSave7). I do not want to write the same procedure on each CmdSave1_Click(), CmdSave2_Click() ..., CmdSave7_Click(). Are there any alternative ways to do this such as concate the string or ?
When I load my tabbed form, it always scrolls it down a bit and cuts off the tab. The user has to scroll up to show the tabs. I have tried any number of things and cannot get the form to open with the tabs showing. Is there a setting I am missing??
I am attempting to create a database where I can input a number that will display a word document, and pdf's, and be able to toggle through them. I have all the data compiled. I just need to present it in some type of a front.
I have a database that I have setup to compact and repair every time I close the program. The database will begin the process of compacting and repairing then when the status bar gets about half way across the process will simply freeze on me. I have let the program run for up to 10 or 15 minutes. I end up click the close button and closing the database. Also there does not seem to be any error with the database since I can open the database and work with it and run reports, it just won't compact and repair.
I am very new to Access and am designing a multiuser database with tabbed forms. One of the tabbed forms has 7 tabs; the first tab contains the part number and other information about a product and the remaining 6 contain additional information about that product. Is there a way to have the part number field/control remain visible when the user changes tabs, ideally without using VBA?
If I have a tabbed from of say 3 tabs, can I use each tab to populate 3 different tables or can each tab only populate one table, hope this is clear.
I have 3 tables
a) General b) Process Design c) Mechanical design
By putting the tabbed form on a plain master form, I have to select one table for the record source for the master form, thus it would appear is the only table I can populate. :confused:
Hi folks, I've got a questionnaire which has about 80 fields in 5 sections. all sections are linked to a person Id - which is the unique identifier.
I'm thinking that a tab form is the way to go in putting this form in Access in order to facilitate data entry. Is this the best way or is there another way to accomplish this task?
Does anyone have a sample form that I can modify to meet my needs?
I have a Tabbed form where one of the tabs shows about 20 rows of a table. Another tab shows a single record from that table with all the fields for that record.
I want to be able to move from tab to tab and and stay on the same record (hopefully that's clear).
Once a year we have a conference that has about 400 people attend. These people will participate in several classes, randomly, over a four day period. Each class hands out an evaluation form. This form has six categories and asks you to rate each from 1 to 5. This is done with a grid on the form labeled with 1 2 3 4 5 across the top and the attendees will put a checkmark or X in the appropriate box. This results in approximately 3000 evaluation sheets.
I will take these and manually enter the scores into a database I created in order to tally the results and generate reports. I have been asked to see if this process can be expedited by using a scanner to pull the scores from the sheets.
:confused: Hi all - hope someone can help I dont know where to start.
I've got a cmd button that imports data from a excel sheet - that actual code is working fine, however when it runs it causes Access to freeze.
The data in imported correctly - so it must complete the process but Access locks up and has to be ended via task manager.
Any one got any clues why this is happening and how I can stop it?
This is an Access 97 database running mainly on NT and 2000
Private Sub LoadActualsDataButton_Click() On Error GoTo Err_LoadActualsDataButton_Click
' This procedure performs a two file match between the Actuals table (the Master file) and ' The Actuals spreadsheet file (the Transaction file). ' ' Keys : Study Code|Work Package|Period ' ' If the Master key < Transaction key then ' Read the next Master record. ' If the Transaction key > Master key then ' Add the transaction record to the Master file ' Read the next Transaction record. ' If the Master key = Transaction key then ' Update the value on the Master record with the value on the Transaction record ' Read the next Master Record ' Read the next Transaction record. ' ' End of File processing ' At End of File on the Master file, set the Master key to "ZZZZZZ" ' At End of File on the Transaction file, set the Transaction key to "ZZZZZZ" ' Continue processing until both keys are equal to "ZZZZZZ"
Dim MyDB As Database, MySQL As String, MySet As Recordset Dim appExcel As Excel.application Dim MyFiles As String Dim MasterKey As String, TransactionKey As String
Set MyDB = CurrentDb() Set appExcel = CreateObject("Excel.Application")
' Set up the transaction file (Actual Data Spreadsheet)
MyFiles = appExcel.GetOpenFilename("Excel Files(*.xls),*.xls", , "Open Actuals Spreadsheet") If MyFiles = "False" Then Exit Sub
' Check that this is a genuine Actual spreadsheet On Error Resume Next Let Err.Number = 0 appExcel.Sheets("Sheet1").Range("B1").Select If Err.Number = 9 Then MsgBox "This is not a valid Actuals Spreadsheet." appExcel.Quit Exit Sub End If
If appExcel.ActiveCell <> " Extracted Actuals Data" Then MsgBox "This is not a valid Actuals Spreadsheet." appExcel.Quit Exit Sub Else appExcel.ActiveCell.OffSet(1, 0).Range("A1").Select TransactionKey = appExcel.ActiveCell.OffSet & appExcel.ActiveCell.OffSet(0, 1) & appExcel.ActiveCell.OffSet(0, 2) End If appExcel.Visible = True
' Set up the Master File (Actual Table)
MySQL = "SELECT Actuals.[Study Code], Actuals.[TBCS Code], Actuals.[Year/Month], Actuals.Actual " MySQL = MySQL + "From Actuals " MySQL = MySQL + "ORDER BY Actuals.[Study Code], Actuals.[TBCS Code], Actuals.[Year/Month]; " Set MySet = MyDB.OpenRecordset(MySQL) If MySet.EOF Then MasterKey = "ZZZZZZ" Else MasterKey = MySet![Study Code] & MySet![TBCS Code] & MySet![Year/Month] End If
Do Until TransactionKey = "ZZZZZZ" If MasterKey < TransactionKey Then ' Read the next master record MySet.MoveNext MasterKey = MySet![Study Code] & MySet![TBCS Code] & MySet![Year/Month] GoTo Next_Loop End If If MasterKey > TransactionKey Then ' Add a new record from the Transaction to the Master MySet.AddNew MySet![Study Code] = appExcel.ActiveCell MySet![TBCS Code] = appExcel.ActiveCell.OffSet(0, 1) MySet![Year/Month] = appExcel.ActiveCell.OffSet(0, 2) MySet!Actual = appExcel.ActiveCell.OffSet(0, 4) MySet.Update ' MySet.Requery appExcel.ActiveCell.OffSet(1, 0).Range("A1").Select TransactionKey = appExcel.ActiveCell.OffSet & appExcel.ActiveCell.OffSet(0, 1) & appExcel.ActiveCell.OffSet(0, 2) GoTo Next_Loop End If ' Keys are equal so update the Master with the Transaction value MySet.Edit MySet!Actual = appExcel.ActiveCell.OffSet(0, 4) MySet.Update ' GoTo Next_Loop appExcel.ActiveCell.OffSet(1, 0).Range("A1").Select TransactionKey = appExcel.ActiveCell.OffSet & appExcel.ActiveCell.OffSet(0, 1) & appExcel.ActiveCell.OffSet(0, 2) MySet.MoveNext MasterKey = MySet![Study Code] & MySet![TBCS Code] & MySet![Year/Month] Next_Loop: Loop
my requirement was for a control in a subform and I needed all this to affect a first column freeze.The code was in the Onload for the main form.
Code:
Dim ctl As Control Set ctl = Forms("frmPlanner").Controls("subfrmTempCtrl") Me.SetFocus ctl.SetFocus ctl.Form.Controls(0).SetFocus DoCmd.RunCommand acCmdFreezeColumn
It does work but I can't fathom why I need more than the last .SetFocus. Leave any of the prior ones out and it gives an error to the effect that can't do it in those circumstances. I understand the control has to have focus for it to work but why are the other's required?
I have been using a calendar control on a subform and have now split the data into a tabbed form with 4 subforms. The calendar is now entering the date selected into the first record of each subform instead of just the one on the subform that has the focus.
Do I need to add the calendar control to each subform now or is there a way to reference the correct form in my current code?
Private Sub Calendar_Click()
' Enters the selected date into the DateCompleted field