Forms :: Generate A Subreport Base On Two Fields?

Jun 10, 2015

Ok so I want to generate a subreport for my deacons that show what families have been assigned to them.

Using the wizard I created a subreport that pulls the name & phone number(s) for each member with the same family ID, and Deacon ID (which pulls the name, number and FID from the member table, then checks the family table and gets the deacon ID). My question is, how do I tell the report to check if the current member I'm looking at is a deacon and if so use their deacon number as the reference number for "Deacon ID"?

I have a table for my deacons that links the member through their EnvNum (if they're a Deacon). Not sure if I'll need that table for this, but thought I'd mention I do have one.

View Replies


ADVERTISEMENT

Reports :: Change Specific Subreport Visible Property Base Of A Select

May 6, 2015

I have stumbled across an issue in my report involving the Report.SourceObject property. The section of the report contains a subreport that needs to change dynamically to display the report that relates to the corresponding test. When trying to change the subreports.Sourceobject property I get the error Run-time error 2191: You cant set the Source Object Property in the print preview or after printing has started.This is very clear to me what the limitation is, however I was wondering if there was some way around this.

I have currently tried creating multiple subreports that are stacked on each other with visible property set to false. Then I change the specific subreport visible property base of a select. This worked, but was extremely hard on the machine and printer as there is about 15 different possible subreports.

Secondly I have tried exporting it to RTF and just manually copying and pasting the tables. The down side with this is all the formatting and work I have put into the report as a whole goes out the window so if possible would like to avoid this situation as well.

View 8 Replies View Related

Reports :: If One Subreport Has Empty Fields Then Show None

Aug 20, 2013

I have some fields in form that most of the time have data in them. Now comes that when there is no data, there should be one different field filled in with "None."

The client could have 3 types of products, but when he does have none, the "None." should appear. Another catch is that I have the titles for the products on a textbox above the products. Is it possible to have them not appear in the report if the client has no products?

I guess that it could work like in excel with an IF statment. If no values found, then keep those text boxes from appearing on the report and put a text with "None."

View 2 Replies View Related

Reports :: Grid Line Of Fields In Subreport

Aug 22, 2013

I am using Access 2003. Is there any way to put grid lines among fieldnames and contents just like in Excel in the output of subreport?

View 1 Replies View Related

Using Two Fields In A Form To Generate A Third Field

Oct 9, 2015

I've got a form where I want to add an employee and I have three fields (EmpFirstName), (EmpLastName), and (EmpCode).They all have their own control source from a table but what I want is EmpCode to automatically fill in after they type a first name and last name and not be editable. Smith, John and the empcode will fill in with smijo (3 of last and 2 of first). I understand this is probably completed using Expression Builder (not sure on the command) and how do I make it so Empcode still receives the data entered??

View 2 Replies View Related

Forms :: Auto Height Of Subform On Base Of Records

Apr 28, 2015

i have a subform (A) which shows records after an query..i want to set height of subform on base of records as some time query shows 2 records and some time it shows 10 records..how can i set auto height of sub form

View 5 Replies View Related

Forms :: Using Same Subreport But With Different Queries

Jun 15, 2014

I am creating an end of week report, which needs information from Sat-Fri, so basically it will be one sub form, but used 6 times.

I'd prefer not to have to make 6 subforms, with 6 queries, but rather using 1 subform and 1 query 6 times.

For example, on the parent form, I will add the subforms, and name them "Sat", "Mon", "Tue" etc...

I want to make one query that filters the information based on the name of the subform:

Day: Format([Date],"ddd")
Where: Day = Me.Name

I can't figure out what to ask the query to refer to, to retrieve the name of the subform it's currently sat in.

View 3 Replies View Related

Tables :: Calculate Some Additional Data And Generate Quotations - Too Many Fields

Jun 2, 2015

I have a database that will take lots of data entered by an employee and calculate some additional data and generate quotations. Within each quote there is a possibility for 15 different metals (5 Precious Metals, and 10 Base Metals). There is also 5 fields that need to be filled out about each Metal (What the metal is, the market being used, weight, whether it is included in a different price, and the price). I currently have 75 fields to address each Metal and their 5 fields respectively. Is there a better way to Normalize this data, and accomplish what I need accomplished? I want at the form level the employee to tell the database whether they want to add a Precious Metal, or Base Metal, or Move on to other data entry.

Here is a Screenshot of the design view of one of my tables with too many fields : table screenshot1.PNG

View 14 Replies View Related

Forms :: Opening Report And Subreport To Current Records

Jun 10, 2013

I have a main form (ZooMobile Booking Form-New Client) with a subform (ZooMobile Event Booking-New Client) within it. In the main form I have a button to open up a report displaying the main form's current record.

The report that is opened has a subreport that needs to display the current record from the subform.

So far I've managed to get the report to open to the main form's record using the following On_click command:

DoCmd.OpenReport "ZooMobile Billing Invoice", acViewPreview, , "[Client_ID]=Forms![ZooMobile Booking Form-New Client].CustIDTxt"

I can't manage to get the subreport to open to the current record in the subform, however. I've tried to integrate it into the above event and to use On_load events in the report and subreport but everything either comes up as a bug or has no effect on the subreport's record.

View 4 Replies View Related

Forms :: Vertical ScrollBar Of Subreport (on Main Form) Not Shown

Jul 16, 2015

I have a main form with a subreport.

Mainform width is 22"(Maximum)
Subreport Wdth is also 22" (Maximum)

When i run the mainform, the subreport shows correctly but the vertical scrollbar is at most right side of main form so i have to scroll main form horizontally first to access the vertical scroll bar of subreport.

To solve, changing subreport orientation to right-to-left shows vertical scroll bar at most left but still if i scroll horizontally on mainform, that scrollbar hides as its not freezed.

Consider ActiveX Control of Microsoft ScrollBars 2.0 .....

View 14 Replies View Related

Forms :: Requerying Subreport On Tabbed Control - Show Related Data

Jul 4, 2014

I have a form with a tabbed control on it. The tabbed control has 4 tabs that each have a report on them. When I select a company name on the main form, I requery these 4 reports to show data related to that company.

For some strange reason, 2 of my reports requery with no problem, and 2 of them give me a message that the report can't be found. Here is the code:

Code:
Private Sub cboCompanyName_AfterUpdate()
On Error GoTo cboCompanyName_AfterUpdate_Err
' DoCmd.SearchForRecord , "", acFirst, "[CompanyID] = " & str(Nz(Screen.ActiveControl, 0))

' After selecting a company, requery the subreports to display the appropriate data

' These 2 work

Forms!frmCompanyHistory!RptCompany_Projects_Brief.Requery
Forms!frmCompanyHistory!RptEmployeesSpecificCompany.Requery
'These 2 Fail
Forms!frmCompanyHistory!SubRptCompany_Payback.Requery
Forms!frmCompanyHistory!SubRptCompany_Revenue.Requery

'Other things I've tried

'Forms!frmCompanyHistory!TabCtl66!SubRptCompany_Payback.Requery
'Me.TabCtl66!SubRptCompany_Revenue.Requery

As a side note, if I chose the company, say "ok" to the error, and then go run the queries that these reports are based on, I get the correct records. Also, if I chose the company and run the 2 failing reports standalone, they work fine, so I know the problem isn't the reports or the queries themselves.

I have also checked and rechecked for any spelling mistakes and have found none. I should mention that the error message is "Programs cannot find the field 'SubrptCompany_Payback' referred to in your expression".

View 8 Replies View Related

Dynamically Generate Content On Forms

Apr 10, 2006

Hi,
Does anyone know of a way to dynamically fill the content of a form at runtime. I want, for example, when a user clicks a button, a textbox is dynamically added (but I would prefer not to use hidden objects). I've tried the "CreateControl" option but I can't seem to get this to work. Any coding examples would be much appreciated.
Thanks,
Mark.

View 4 Replies View Related

Forms :: Disable Tab And Generate Report

Jun 9, 2015

I have a form "Member's Details" that has a few tabs. One tab is titled "Deacon Families" and I want to be able to either lock it, or grey it out, or something along those lines base on if the member is a deacon or not (I do have a yes/no field asking if they're a deacon). If they are NOT a deacon, the user should not be able to open the tab (because there would not be any information to show) and a pop up saying something like "This tab is empty because the member is not a deacon". If they are a deacon, I would like it to show all the members who have been assigned to them. I know this needs to be done in a subreport, but I don't know how to set it up. There is a deacon table which is linked to a family table which is linked to the member table, but the member table and deacon table are not directly linked.

View 10 Replies View Related

Forms :: Update Query And Generate Report

Dec 26, 2014

I am building a form that updates a query and then generates a report based on the updated query. I am having two problems;

1. I have successfully concatenated the "First Name" and "Last Name" fields in the query to appear as First space Last, but in the actual report I get a compile error. I've tried everything I can think of with no luck. This is what it looks like in VBA:

"SELECT [VoCSurveys].[First Name] & " " & [VoCSurveys].[Last Name] AS Name, ... " & _

2. I am trying to figure out how to update two labels (lblDescription and lblSecondaryDescription) on my report with the information the user types in the text boxes (txtDescription and txtSecondaryDescription) on the form. I tried calling a variable for each label and setting it equal to the corresponding text box, but I didn't think it would work and I was right.

View 3 Replies View Related

Forms :: Generate Autonumber For A Group Of Records

Aug 5, 2014

I've got a table, where each record is a group of students. So the fields include Student1, Student2, Student3, etc. I know this is bad database design, but I've done this because I want the group number (primary key) to be automatically generated.

Now, I want to add more information for each of these students as if they're seperate records but I also want an autonumber for the group.

View 5 Replies View Related

Forms :: Using Two Combo Boxes To Generate Report

Jun 25, 2013

I have a database with a table name tblTeachersProfile and a report format based on the table. I also have a form with two combo boxes name cboState and cboCounty base on field from the table and a control button called Get. Now, I would like to make selection from the two combo boxes and generate a report after updating both combo boxes based on my selections.

This is what I have but it is not working: For my Get button

Code:
DoCmd.OpenReport "rptInServiceIndividualSchoolAndTeachersInformation", acViewReport, , "strCounty = '" & Me.cboState & "'" And "strDistrict = '" & Me.cboRegion & "'";

View 14 Replies View Related

Forms :: Generate A Unique Reference Number Record Wise

Jun 10, 2015

Need to generate a unique reference number each record wise while data entering by a form. How to do this by using a command button ? After entering all fields related to the record, when click on the command button, unique reference number for that record need to be generated and save with all other data of the records. in a later event, need to recall the record by using this reference number and also need to make relation ship with some other table by using the reference number.

View 6 Replies View Related

Forms :: Employee Training Database - Generate A Class Roster?

Jul 3, 2013

I am building a database for employee training. In the FrmNewTrainingGroup I am trying to create a form that will allow selection of a single class, a completion date, one or more instructors (or none at all) and a list of students by LName, FName, MI, EMP#. in my latest attempt, I have tried using a query of the TblEmployee to act as a go between, and dropped a subform into the FrmNewTrainingGroup, and that is not working.

Trying to get the student roster to work has been frustrating. I have been attempting to make it a check box select list that is also searchable by LName and FName [which would perhaps display a reduced list of names, as the name was typed?. This list would update a class roster text box to reflect all the selected employees for training so far, prior to the class being committed (I am planning on a button on the form).

View 2 Replies View Related

Forms :: Generate Custom Form Based On Query Results

Dec 11, 2013

I'm trying to track daily production at a manufacturing company running many different processes at different locations each running multiple parallel "lines." The tricky part is that the number of lines running and the shift schedules e.g. 2shifts 10hrs/day 4days/week or 3shifts 8hrs/day 5days/week change frequently for each process.

Right now I have a form for process data that specifies the schedule and number of lines running each day. Then I'm running an append query to a "production" table that generates blank production records associated with each item made in each process for the correct shift/line combinations.

Up to now I've been manually changing the date on the append query each time I run it. Then I have a seperate query for each process that pulls out the production records for each day. My problem is that the preferred interface for production data entry is a spreadsheet with the following layout:

--------DAYS LINE 1 DAYS LINE 2 SWING LINE 1 SWING LINE 2
ITEM 1 100
ITEM 2 2250
ITEM 3

which changes each time the shift/line schedule changes for each process. The only way to achieve this layout I know of is a crosstab query which isn't updateable. Ideally, each day the manager will specify the shift schedules and forms will be automatically generated with the correct structure and sent to the process supervisors. I'm open to different form layouts and even redesigning the database completely.

View 2 Replies View Related

Still On First Base

Dec 6, 2006

I have a theoretical solution to making a basic form for an Access Database, but how can I create a form from the VB IDE?

The toolbox cannot be selected from the dropdown menu.

I have 3 small tables in the database and am trying to create a form which will enable me to update a total on one of them, but as I say I can't even make the basic form, let alone program it.

Please advise.

View 7 Replies View Related

Forms :: Auto Generate File Number Based On Number Of Records In Year

Jan 21, 2014

I have a form [IUDATA]

I have a add record button.

I have a date field [DATEIN]

I have a text field [DRPNO]

If the [DPRNO] field is empty, I would like the user to have the [DPRNO] field be automatically populated after the user enters a date.

I'd like the format of [DPRNO] to be "dpr YY-XXX"

Where:
YY is the year of the [DATEIN] field and
XXX is number of records in that year.

So for example, if it was the 4th record with a 2013 date the [DPRNO] would be dpr 13-004.

View 12 Replies View Related

I Would Like To Use The Data Base For...

Jul 11, 2006

Hello all,
I am a new registration chair person for a small convention for 200-250 persons.
I would like to set up a database that I can access to print out address labels and name tags, by selected specific cells or sections.
Is there a way to do this with a Microsoft Database or Spreadsheet programs?
Any help would be appreciated
Thanks
Leneda

View 2 Replies View Related

Base Question

Mar 22, 2007

Hi people...:)

I create a form with 2 buttoms
The first running in VBA and the second In MACRo

Why the MACRO buttom don't work?

Thanx in ADVANCE...

Johann

View 4 Replies View Related

How Set Up Data Base....

Dec 13, 2007

I am just beginning to design a small data base, where end users will mainly use an Access Form to search and view data.

The (lab) data will be arriving to our group occasionally over the next 2 years, and will be put into an Excel file (formatted the same, each time). The new data could be appended on the end of a master file...so I could link just one file to a table in Access. I need to build a Form, based on this data.

But, I am not sure if I should link the file from the beginning (since I've read that I cannot change data types or field sizes, if I link)....

Maybe I should import one existing file, manipulate the table parameters as needed, then design my Form....then link later?????? :confused:

what would you do in this situation?

thanks!

View 6 Replies View Related

Data Base Help

Oct 29, 2004

I am very new to Access, I do work for different companies inputting data.
I usually use excel and then I have to retype the information into another database.

One of my companies is a school. I have to print certificates when the class is complete, but what I'd like to know is,
is there a way I can take the names of the students and using Access just have the names appear on the certificates without having to retype all of the names individually?

I would appreciate any information you can provide for me, this sure would save lots of time.

I hope I explained my question clear enough.

Tim

View 2 Replies View Related

Forms :: Generate Random Number To Use As Invoice Number

Mar 17, 2014

I am working on a form and need it to be able to generate a random number to use as an invoice number. The only parameters i need it to meet is that it is at least 5 digits in length. I was hoping i could use a button to make the number generate in a separate box.

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved