Tabular Style Forms/Reports And Information
Jul 20, 2005
Hello all - Working on a form that is supposed to display order approval information. In the database I'm working with, people are stored as in the approvals table by a reference to an autonumbered value. However, I want to display their name, which can be obtained normally through an SQL or DLookUp Command. This tabular form style though is giving me a problem. If I put new textboxes on the form and load it as I normally would, like:
ApprovalName.Value = DLookup ("[UserName]", "Users", "Users.UserID =" str(ApprovalID.Value*))
*ApprovalID is a hidden textbox that stores the number that is used to represent a particular user.
The problem becomes that using an OnLoad or and OnCurrent Form function, the boxes only load one value. I want them to load the different values for the different entries, but I am lost as to how to do this. Any help would be appreciated.
A similar issue that I've been having with reports is that I don't know how I would do this at all... I want to do the same thing (retrieve the Name or whatever that is related to a numerical value) and put it on the report. I'd appreciate any info on how to do this.
Thanks
View Replies
ADVERTISEMENT
Nov 15, 2014
In my current database there seems to be two different types of borders in my pop-up forms! The best way to explain it is that some forms will have the Access style border while others have the glass style border that you see in windows. I can't seem to find any settings that will change this or even determine what causes it.
View 4 Replies
View Related
Aug 25, 2006
Hi
I am trying to create a form that has a tabular main form and a tabular subform. All I can do is to create a main form that just shows a singular record (columnar). I want to be able to see say 10 records in the main form and 10 records in the subform. How do I do this?
Thanks
View 1 Replies
View Related
Jul 8, 2014
I am trying to display upcoming events in an outlook style report.
We have 5 rooms available for bookings, the report loads fine for 4 of these but for whatever reason the Board Room report (Weekly Bookings Board Room) throws up a data mismatch error, and the datasource is exactly the same as the other reports but checking for a different room.
View 10 Replies
View Related
May 16, 2015
I created a database to record lesson information (see attached sample). When there was only one student per record, everything worked fantastic.
However, management would like to have one record per lesson, which means that up to eight students would need to be accounted for.
Adding additional Student_IDs to the lesson record table and the associated links to the student table was simple. Inputting lesson information was pretty straightforward.
The problem arises with output. There is one report to review an individual student's past lessons. Also, there is a form in which to export the lesson's public comment.
Both use different queries, but with the same name as the form and report.
Both the report and exported Excel file are blank, no data.
I'm building this in A2010, but saved as A2003 (working environment).
View 5 Replies
View Related
Jun 26, 2006
Hello,
I'm trying to create a form like the Employee form in Northwind Database, but I'm clueless, I'm getting the different tabs, but when I move from the first page to the second page the fields on the first page is showing on the second and third pages.
Any help is appreciated.
Many thanks.
PS: I created a form & then draw a tab page(from toolbox menu) on the same form & try to move the fields onto the tab pages.
View 3 Replies
View Related
Jul 20, 2005
I'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
View 4 Replies
View Related
May 9, 2013
So you make this nice continuous form (or report) using the tabular layout, layout/format the whole enchilada... and then at some stage you need to add one more field to the display.
You could change the layout to stacked, drag the field from the Add Existing Fields list onto the layout and then change the layout back to tabular.
Is there any other smart way to add a field to a tabular layout in A2007, so that the label winds up in the header section and the textbox (or other control) in the detail section?
View 2 Replies
View Related
Dec 7, 2013
i have a form the control source of form is getting information from table and the type of form is tabular i want when the user input for example 10 person into form when click in the button all the record stored from another table , how to do it ?
look my attachment to see the database
View 9 Replies
View Related
Jul 5, 2013
I have a tabular form which i use to input new payments for tenants.
What i'd like to be able to do, is have another form, with a combo box that i can chose my tenant from, then for a tabular form to show only the payments made for that tenant, sorted in date order.
View 1 Replies
View Related
Jun 28, 2013
Is it possible to move down records with the down button in a tabular form to the same field in the next record.
View 11 Replies
View Related
May 12, 2013
I have made an unbound check box, named "myckeck" in a form which shows data from a table in tabular layout.
1- When I check one check box, all check boxes are checked. How can I solve that? I mean I want to check or clear check boxes independently.
2- I made a text box, named "jobdate" to sow todays date automatically upon checking a check box.
Code:
Private sub mycheck_afterupdate()
jobdate = date
End
But this is not working and checking a check box does not make anything to happen.
3- Then I made this expression in the default value of "jobdate" properties:
iif( mycheck = true, date(), null)
This not working either.
View 3 Replies
View Related
Aug 15, 2013
I have Access db's that were originally created in Access 2003, I have upgraded them no problem to accdb and am using them in Access 2010.
When I create a new form and add a button it is rounded/shaded/white/blue etc - looks good.
When I add a button to an existing form, or reformat the existing form buttons (back colour Accent 1, Lighter 40%, Use Theme Yes etc) it remains an old style button (unrounded, solid colour etc).
How to convert old style buttons to new style buttons ..
View 2 Replies
View Related
Oct 17, 2014
The Quick Style and Change Shape formatting command buttons greyed out. What setting do I need to change to make them available?
View 3 Replies
View Related
May 9, 2013
I have a form with payment information and need a list, what date the payments are due. These can be only 2 or 3 payments up to maybe 24 payments. The result I want is something like this:
Date Amount Total paid
1.7. 500.00 500.00
1.8. 500.00 1,000.00
The list itself is not a problem, but I need a list who only shows the number of payments as agreed, 2 lines (with paydates) if 2, 12 if 12 payments. I have the information of the total amount, the number of installments and the first payment date.
View 5 Replies
View Related
Oct 9, 2014
I need to split out information in a report and I'm not sure how to do it.
The report is based on the following query:
Code:
SELECT tblHazardClass.HazardClass, Product.ProductName, Product.Package, Product.Size,
tblStoreProducts.Cases, Product.Units, Product.ReportUnits, tblStoreInformation.StoreName,
(([tblStoreProducts].[MaxUnits]*[Product].[Size])/[Product].[ConversionRate]) AS QOH, tblStoreProducts.StoreKey
FROM tblStoreInformation INNER JOIN (tblHazardClass INNER JOIN (Product INNER JOIN tblStoreProducts ON Product.UPC = tblStoreProducts.UPC) ON tblHazardClass.HazardKey = Product.HazardKey) ON tblStoreInformation.StoreKey = tblStoreProducts.StoreKey
WHERE (((tblHazardClass.HazardClass)<>"NON-HAZARDOUS"))
ORDER BY tblHazardClass.HazardClass;
My issue is that the products can have a PhysicalState of 'L' (liquid), 'S' (solid) or 'G' (gas). As of right now, only one of the HazardClass entries has multiple physical states (L or S).
My report details each product in the hazard class and totals the amount of that hazard class. Obviously, one cannot add gallons to pounds and come up with an answer that has any meaning whatsoever. How to have the report total the S and the L within a hazard class separately.
Do I do this within the query, or within the report itself? I've already considered making 2 separate Hazard Classes for the one in question (Corrosive). However, since these Hazard Classes are official classifications per the International Fire Code, that's not really an option.
View 1 Replies
View Related
Oct 10, 2014
I am trying to get some totals on a report, but the totals are from a table that the form is not related to as such.I am trying to get a textbox to show how many records in a query match the given criteria and show me the number of records that match. I was thinking DCount, but not sure if it will work?
I have a query called 'VehiclesAllocatedToday' which is already filtering records to show only those allocated today. On a report that shows Unfit Vehicle (and is related to a different query), I would like a text box that shows me how many records there are where the text "Type One" is in the TypeRequired field.
View 8 Replies
View Related
May 28, 2013
I have a Table with Emp_ID and Details of my Employees. I have created a query and set parameter [Enter Emp_ID]. When I pull up a report, I get a pop-up and it asks me for the Emp_ID. When I input same, I get the information I need. Everything is good so far...
My Question... I have designed a report when user will need to enter Emp_ID and click on a button and they will get the report "EMPReport" without having the pop-up window asking for EmpID.
I have been using the below code but I get the pop-up again and I need to enter the Emp_ID again to view the report
See below Code:
Code:
Private Sub Image11_Click()
If IsNull(Me.Emp_ID) Or Me.Emp_ID = "" Then
MsgBox "You must enter an Emp ID.", vbOKOnly, "Required Data"
Me.Emp_ID.SetFocus
Exit Sub
End If
DoCmd.OpenReport "Rpt_HR1", acViewPreview, , "[Emp_ID]= " & "" & Me!Emp_ID & ""
End Sub
View 13 Replies
View Related
Feb 6, 2015
I have a table which now contains a couple of hundred records with more than thirty fields each, and will ultimately contain over 1000 records. Some of these fields use the multiple value feature, and the fields and the forms which fill them work beautifully. Now comes the challenge.
Without going into detail that I'm not at liberty to share, I can say that there are different offices which have different people who are responsible in different ways for the work covered in these records. It is possible for each record to have multiple people assigned to it from the same office. This requires setting the control that shows the people from each office to allow multiple values. I need to be able to create a report which will allow me to hand a list of all the records each person is responsible for in the office to the person responsible, in spite of the fact that this will mean records will show up on more than one person's report.
Before I knew that there might be multiple people in the office for each record, I created great reports grouping and ordering by this office's control and field. Now, since they allow and store multiple values, I can't use them any more. I need to be able, as I said above, to get the same effect. I think the answer lies in some sort of calculated field or formula that applies text filters. What I need to be able to do is look in the field for this office and see if a person's name is contained in the field for that particular record, regardless of who else might be in the field, too. I need to be able to use the results from this filter or calculation or formula to generate something I can use in the group and order by processes.
View 7 Replies
View Related
Apr 2, 2013
I have a popup form that prompts for a value and has a button defined with an OnClick,OpenReport with a WHERE clause. The value the user enters is placed in the WHERE clause.
The report is generated using a Query and the WHERE clause.
I was very surprised -- it works!
Now I'd like to add a chart to the report that represents the information on the report. How can I do this without calling the query again? Can I somehow reference the information that's in the report?
View 1 Replies
View Related
Jul 21, 2014
My report is grouped by a Billing Group #...within each billing group there are sub invoice numbers that are tied to the main billing group # (they all have the same billing group # but different general invoice numbers). I need to pull data if one of the general invoice # invoice dates is greater than or equal to a specific date entered.
In other words: If a Billing Group # and one of the Invoice Dates is greater than or equal to a specific date entered then pull ALL GROUP data to report.
View 14 Replies
View Related
Mar 27, 2014
I have a report that uses a subreport for summary/totals information. It was working perfectly until I made a change to the format. Now, the name of the subreport (e.g. subrBalances) is printing at the top of the section. It was not doing this before. Why is this happening and how do I get rid of it?
View 5 Replies
View Related
Apr 7, 2015
I have a question related with a report i`m using to print labels. I am not familiar with Access and this is quite a challenge to do it alone.
In the attached file there is a report called "MICRA", when started it asks that you want to select (default is 1 and special select in this case is 11) and next it asks "SPS", the value entered there is printed in the bottom right corner of the report.
My question is is it possible if in the SPS field is entered a special value (for example "MASS") to print 30 labels of each selected label with text in this fiels = "val.1"; 15 with text in the field = "val.2"; 10 with "val.3" and 10 with "val.4" and after that to print next label with same rules...
And if not entered "MASS" to print just 4 copies of every label.
View 6 Replies
View Related
Apr 19, 2013
I have a question about summing information on a report. I am developing a report to see have percentage of time Staff work within a certain area. On the data base the time percentages entered as ranges e.g. 75-100%, or 11-25%. We needed to figure out the total percentage of time so I created a report to add the total time. I used a text box which it titled FTE_Total if embedded iif functions to display the total time. Here is the function I used:
=IIf([FTE_Percentage]="76-100%",1,IIf([FTE_Percentage]="51-75%",0.75,IIf([FTE_Percentage]
="26-50%",0.5,IIf([FTE_Percentage]="11-25%",0.25,IIf([FTE_Percentage]="1-10%",0.1,0))))).
This worked perfectly however I cannot get the FTE_Total fields to sum. I tried the following function in the group footer: =Sum([FTE_Total]) but everytime I try to look at the report in report view I get a message asking for the FTE_Total Parameter.
View 1 Replies
View Related
Nov 5, 2014
I have a form (form1) that will populate with records (table1) based on key fields of "Project Number" and at time-points we will update part of the record, and then we create a word document detailing the updates with a couple of other bits of information not in original record.
Basically I want it to go from the original form (form1) into another form (form2) (via a command button) taking the key field of "Project Number" where it will ask the bits of information that we don't need have already and the contact person.
I have got this to store in a different table (table2) using a key field of just "ID" from the original records (table1). A list of contact people are in a separate table (table3) using a key field of "contact name" which will include other details for them such as address and phone number.
So from "form2" I would like to produce a report that contains information form "table1" based on the "Project Number" and "table2" based on "ID" as just been generated and "table 3" which is based on "contact name".
So I want to pull information form the records based on the certain key fields but struggling for it to pull it successfully...
Got relationships between:
"contact name" fields in both "table2" and "table3"
"project number" fields in both "table1" and table2"
In a query for the report I have all the appropriate fields, but only have the "contact name" and "project number" from "table2" is this right? or do I need both in?
Or would it be easier to draw all this information into "form2" but don't really want to select that many drop down boxes or would it be able to pull it from the "contact name" and "project number" boxes????
View 6 Replies
View Related
Dec 20, 2014
I am trying to create a report that has a header ( all ok ) then could have 1 or 15 detail lines ( all ok ) which contain cost for each line
then I have a footer with the subtotals of the costs and also bank details
then I have footnotes
What I need the report to do is keep the subtotals, bank details and the footer notes at the bottom of the page all the time weather I have one detail line or 15 detail lines
What is happening at this time is the footer information is moving up or down depending on the number of lines I have.
View 14 Replies
View Related
