Forms :: How To Add More Sections To Form
Jul 28, 2014Any way I can add more sections to my form? For example right now I have a section named "Header", "Detail" and "Footer". Can I add my own?
View Replies
ADVERTISEMENT
Forms :: Highlight Sections Of Continuous Form?
Feb 9, 2015I have a continuous form that shows the results from a query like:
Red
Red
Red
Green
Green
Green
Yellow
Yellow
And I wanted to know if I can some how highlight in a white/yellow alternating color like for instance starting with the three reds being white then the three greens being yellow then the two yellows being white and so on. Maybe through conditional format?
Tabular Forms And Detail Sections
Jul 20, 2005I'm curious if anyone know's a way to access a specific data section on a tabular form. I'm attempting to have each section update a specific data item based on its position on the form, but am having problems since I do not know how to differentiate between one details section and another on the form. Any help would be appreciated.
Thanks
Conditional Form Sections?
Oct 10, 2005Hi there,
I'm trying to do a new membership database for a local group who take monetary subscriptions.
Basically, there's a form for creating a new member, with a few tabs - Contact Info, Payment Info, and one other.
Basically, in the payment tab, i've got a dropo down box to select the individual package from a packages table, another to select the payment term (Monthly, Annually), and a final one to select the payment method.
Now in there i've got a list of possible payment methods: Cash, Cheque, Credit/Debit Card, Direct Debit.
Now obviouslly, each payment method is going to have different requirememnts for what info the club actually needs. Cash simply needs amount of payment and date of payment. Cheque needs payment amount, payment date, cheque details. Card is obviously going to need the CC number, Valid & Expiry Date, Card Type, CCV Number, etc.
So basically, i want to be able to have the relevant section display when that payment method is selected from the Payment Method drop-down box.
What's the easiet way of doing this? Could i create another tab-set inside the payment tab, and then only display the one tab relevant to the selected method?
Cheers
Fatmcgav
Expandable Sections In A Form
Feb 17, 2006Request from the higher ups to have several expandable sections in a form. Ideally only the title of the section would show, like when using a DAP, then the user could click and expand out the section and enter data. I tried the Tab option, but they are set on an expansion section.
Any tips on how to make this happen?
Move Controls Between Sections On A Form
Dec 19, 2004Using Access XP
I have a continuous form that shows the main fields in my table. In the page footer of the form I have a tab control that has 4 additional fields for each record. I want to give the user the option of “Show Details”. When the user clicks on “show details” I want to move the tab control with the additional fields to the detail row so the user can see them.
I know how to move controls with VBA by setting the Top and Left properties and how to expand the detail size, but how do I move controls from one section on the form to another section on the form i.e. from the page footer to the detail section
Form With Three Sections To Show Side By Side
Jan 26, 2012Form with three sections. I have three queries selecting different set of set in a table, I would like to show all three in a form side by side. How can I do this? I use form wizard bit it only uses one query as a source.
View 2 Replies View RelatedCollapsible Sections
Dec 2, 2004I have a switchboard form with a left menu bar similar to windows explore wi
th three sections (Configure, Tasks, Print)
How can I have each section collapsible like in window explore?
Can it be done through the VBA scripting in MS Access? If so can someone pro
vided examples?
Basically I divided each section to three parts
one part is the header which is an image and a label (name of section)
the second part is the button to click to hide/show the context of the secti
on
the third part is the text (labels that open other forms) with a background
image
something like this
http://www.viksoe.dk/code/collapsiblepanel.htm
http://www.viksoe.dk/code/screensho..psiblepanel.gif
but that will work with an MS Access form
Lock The Object Sections
Nov 8, 2005Hi
In MS Access:
Objects:
Tables
Queries
Forms
Reports
Pages
Macros
Modules
Groups:
...
I want to lock the Objects section, because I made the Groups in the groups section. How can I lock the objects section.
Please let me know, thanks a lot.
Multiple Details Sections?
Jan 29, 2007Hello,
I have not used access that much, but what I am looking to do is basically have 2 details sections within a report that will have different records in them.
I first used a subreport but that really did not work as intended. It left large gaps in between the records and just plain didnt work.
Here is a image of what I am trying to achieve:
hxxp://img379.imageshack.us/img379/9471/accesshelpnx9.gif
As you can see theres two different sections. One is for regular campaigns and one is for extended campains. There is a field in the table that has the extended date. For the compaigns that field should be blank or null and for the extended campaigns it is not blank or null.
Is there anyway to achieve this in Access 2003, if so can you tell me or describe me the steps?
Thank you!
Reports :: Keep Two Sections Together On One Page
Mar 7, 2014Is this possible? How?
View 4 Replies View RelatedReports :: Emailing From Report Sections?
Aug 30, 2013I have many reports that are structured differently, many are grouped by semester.
What I do now, is put a button on each grouping of the report I want to email from and use the current semester (Sem) which is also a query parameter to filter the report.
Here is my current code which works fine:
Sub EmailFromReport(rpt As Report, Optional Sem As Variant)
Dim db As Database
Dim qry As QueryDef
Dim rs As Recordset
Dim Bcc As String
Dim Subject As String
Set db = CurrentDb
Set qry = CurrentDb.QueryDefs(rpt.RecordSource)
'set query parameters
[code]....
The problem is, I need to be able to filter these queries on other criteria besides the semester.
My first idea was to use if statements to skip the records I don't want. This is messy and the report structures are different so I run into issues when using optional parameters because not all the reports are structured the same.
The best solution I have come up with so far is using a wherefilter parameter, stripping the semi colon off the querydef sql and surrounding the sql with a qrydef.SQL = "SELECT Email1, Email2 FROM (" qrydef.SQL ") WHERE " & wherefilter.
The problem is this, changes the original query, and I can't figure out how to copy a query with db.CreateQueryDef If i do db.CreateQueryDef("tempqry",qrydefSQL), I lose the query parameters.
Is there a better way to do this? If this is the best way, how do you take an existing query and make a copy of it?
How To Use Sections Of One Table In Multiple Tables
Dec 1, 2013I have quite a limited knowledge of MS Access (2007).
My question is; How do you use sections of one table in other tables?
For example: In tbl_One I input a users Name and Age and then say Weight, Height, BMI, etc.
Then in tbl_Two it uses the same Name and Age in tbl_1 but has other information such as Job, Skills etc.
This is not my actual database, however this analogy works, and they must be in separate tables, even though above they could all just be in a single table.
Grouping Data Into Sections From A Field?
Oct 10, 2014I have a database with a list of clients. One field is for their date of birth.
I have to report on equality and need to know how many clients we have within the following age groups:
16 - 24
25 - 34
35 - 44
45 - 54
55 - 64
65+
I have looked through the group and sort functions and cannot see anything obvious.
Help Creating Report With Multiple Detail Sections
Mar 27, 2008Hi,
I need to create a report for each employee in my company of all compensation information. The report is going to need to have multiple detail sections on the report for example to list all benefits specific to the employee and all beneficiaries.
I tried using a subreport to produce those detail sections that I needed but once I placed this subreport inside a box on the main report each detail I created increased the size of the box. I also thought about making the detail section a list box and writing all of the information there. Would there be a better or easy way to accomplish this?
I am also thinking I am going to have to save all of this information in a table and based the report on that table?
Any help would be greatly appreciated.
Thanks,
tones
General :: Add Result From Different Sections Into One Combined Stock?
Feb 3, 2013i have a production database application in which there are many sections. every section's product stock is generated by running a complex query.
now when i want to add the result from different sections into a one combined stock , i could not design the query as it become too large and on running it produces the error "cannot open anymore database".
i think reason might be too many queries executing at same time .
so do i need to create a table from the stock queries of each section? and then add the tables to generate the combined stock query ?
Modules & VBA :: Create Multiple Expanding / Collapsing Sections
Mar 25, 2015I found a post where it shows how to create a single collapsable/expandable section. I am needing to do this for 10 sections with a lot of information in between each section. The coding that this post provides does not seem doable for that many sections. How to create a collapsable/expandable subform?
View 1 Replies View RelatedGeneral :: Access 2003 Report - Purpose Of Having Sections?
Feb 10, 2015I am redesigning an invoice format with access 2003 report.While coding in Microsoft Visual Basic, I realized that there are two drop down menus.
The right drop down menu has the sections as below:
Detail
GroupFooter1
GroupFooter2
GroupHeader1
GroupHeader0
PageFooterSection
PageHeaderSection
Report
ReportFooter
ReportHeader
The left drop down menu has options below.
Format
Print
Retreat
May I know where can I read up the purpose and use of different sections in the right drop down menu, especially "Report" section?
Are these sections in-build in Access 2003 or created by user?
Forms :: Button In Form To Open Different Form And Chose A Customer Based On Last Form
Mar 26, 2013Basically I have a Customer Form, which I have a New party button on it,this button opens up the party form to a new party, what I would like it to do is open up a new party but make the new party for the customer I had selected in the previous form.I have tried the GoTo macro's but cannot seem to get it to work.
I am thinking on clicking the button it will need to get the Customer ID, and then open the party form, create new party, and paste in the Customer ID, which then updates the Name - Date - Address - Company Fields.
Forms :: Opening A Form From Another Form Via Combo And Auto Loading Form Data?
Apr 14, 2015I have been tasked with creating a tool to analyse mobile phone bill data and present the analysis, and our recommendation, to a customers. Being new to Access (other than basic tuition) this has been a slow uphill task, which is finally nearing completion, however there is a problem which I have not yet been able to overcome.
The requirement is for the DB to open first on a splash screen (lets call it Form A) with fancy picture where our customer is selected from a combo box, the customer is then telephoned, a linked computer screen is established and our staff then click "Go" to proceed to a second form (Form B) showing an account overview and more details.
The problem I have is when "Go" is clicked, the second form loads via on click event, and even populates the correct customer in its combo box. Unfortunately that is as far as it gets - the combo does not look up the information. The customer needs to be selected again for the subforms and subreports to load with the customer overview. To clarify, form B just sits there blank until the customer is re-selcted from the combo box in form B.
Forms :: Send Data From Pop-up Form To Main Form (sub-sub Form)
Aug 27, 2014On the form: User enters first name, then last name. Upon updating the last name field, I would like another form to pop-up and display all the people with that same first name and last name that the user just entered.
On the pop-up form: All of the matching first names/last names are listed with a button control beside each record that says 'Select'. The user clicks the select button beside the record he/she wants. This pop-up form closes and all of the data from this selected record is now showing on the original form.
So far, I have a query/form that pops up only showing the matching first/last names. I'm having a hard time getting my original form to auto-populate with that record that the user selects on the pop-up.
(Also my main form is actually a sub-sub form - so in my trials I could've been massacring my syntax trying to point to it.)
Forms :: Continuous Forms - Looping Through Records / Manipulating Fields On Form
May 29, 2015I have a bound continuous tabular form,However, based on data content in one field of a record, I want a checkbox in the same record enabled, so the user can check it if necessary. I have created a record set using the form as shown below, and I am looping through each record. To show that my code is referring to the field with required data content, I display it as a message box and it works, yet my checkbox does not enable.
I have the code in the form_load event, however, for testing purposes I have it behind a button.If I am seeing this properly, the code behind the button enables the checkbox for ALL records once the criteria in the required field is true, and based on the last record, which has no data content, it disables the checkbox in ALL records. I also have the PK ID for each record hidden in the form. Can I utilize that to target the checkbox of each individual record??
Form Detail
-Form does not allow additions or deletions. Edits allowed
-All fields are disabled and locked
-I only want the check box to unlock if data is found in the "RequiredField" as referred to below. I have also tried if not isNull(requiredfield.value) then -enable checkbox, which yields the same results
Here is my code
Code:
Dim rstMyForm As DAO.Recordset
Set rstMyForm = Forms!MyForm.Form.Recordset
rstMyForm.MoveFirst
Do While Not rstMyForm.EOF
If Not RequiredField.Value = "" Then
[code]...
Forms :: Default Property / Using A Control Of Main Form Without Using Names Of Forms?
Nov 8, 2013In 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.
Forms :: Pull Calculated Values From Approximately 10 Forms Into Another Form
Mar 21, 2013I need to pull the calculated values from approximately 10 forms into another form. This is a summary form that should have all the totals pulled from the other forms.e.g. Form A has a textbox that reflects the sum of the amount. This is the total balance of form A.Form B, Form C, etc. all have a total Balance.Now, i need to pull all these totals into a summary form
-Form A Total Balance: x
-Form B Total balance: y, and so forth.
How and what is the best method to approach?I have tried using Forms![Formname]![Total] to get the data. This necessitates the need to hide all these forms and I ended up with blank forms, etc.Even so, the total sometimes appear and sometimes it does not. so it is very unstable.
Forms :: Form Working Properly Alone / But Gives Error When Combined With Other Forms
Jun 5, 2015I have a form "NewMetalF" that has three combo boxes. The first one is used to choose "Precious Metal" or "Base Metal". The second one shows all the metals based on the first combo box. When I open the form in form view alone the combo boxes work flawlessly. I run the form "NewMetalF" within another form "NewExternalPartF" by clicking a button "AddMetal". When the button is clicked "NewMetalF" opens. The first combo box is selected, and when the second combo box is clicked the error "Enter Paramater Value" "Forms!NewMetalF!cboPreciousOrBase".
View 13 Replies View RelatedForms :: Relating Information Between Main Form And Navigation Forms
Apr 11, 2013New 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.