Subform Without Data Printing As A Blank Space
Nov 2, 2004
I have an Access 2000 form containing several subforms that needs printing on a regular basis, which works fine when the subform contains data, but sometimes the subforms contain null values. We want to print the subforms without the data to maintain consistency, but when printed they have disappeared and a blank space in the form is printed. The subforms view perfectly in print preview... any help would be appreciated, I have spent a good deal of time researching this issue without any leads
View Replies
ADVERTISEMENT
Sep 11, 2013
I have a report which contains 3 subreports. Now I require to do the following:
1. Hide the subreport if there is no data.
2. Remove the Blank space created when the data in subreport is null.
I tried to Set Can Grow and Can Shrink to Yes but still the blank space was not removed.
When I reduced the height of the subreports in the design view the blank space was reduced but it was still there.
What can be done so that the complete report auto adjusts itself if any sub-report is null? Something like the whole page auto fits itself in the available space?
The option of reducing the size of sub report in design view to minimum is there but it makes the report very un-handy for future reference.
View 3 Replies
View Related
Jan 17, 2014
All i want to do is to print my report (with the records ideally!) which has a subreport header at the top but all i am getting is a single blank record?!
Surely this is not too much to ask but it is holding up the whole project!!!
View 2 Replies
View Related
May 19, 2005
I am trying to break out a field where city, state and zip codes have been consolidated. I want to create a field where I am able to ready the consolidated right either right or left until the first blank space. For example:
"pittsfield ma 01201"
I want to read the field to break out "pittsfield"
Thanks in advance for any help I can get on this :)
View 3 Replies
View Related
Feb 20, 2014
I have a continuous pop up form which, at the most, will contain about 10 records. The ten records take up less than half the screen space - but there is a bottom half to the form - even though there is nothing there. How can I get rid of the unused space on my form?
View 2 Replies
View Related
Oct 4, 2013
How can I replace a '0' to a blank space and '1' to 'X' in 'Text Box' in a report ? The 'Data Type' is 'Yes/No' in the table.
View 6 Replies
View Related
Jul 7, 2005
I have a main form where the user chooses a BoxID. There is a subform on this main form that has a relationship between BoxID on the main form and subform. The users are entering data in the subform and when they have entered 10 lines of info I have a message that tells them to start a new box (I could not work out how to do it any other way as I lack VB skills). The user closes the form or clicks add new record to create a new box. If I view the previous record there should only be 10 lines of information in the subform but there are 11 as it takes the blank line as a new record....
View 8 Replies
View Related
Sep 1, 2004
I created a form that opens to a blank form. I also have a print button on the form. I want to be able to print the blank form, but nothing happens unless the primary key has a value in it. Is there a way to print just a blank form? I have been working at this problem for a few weeks. Please help!
View 1 Replies
View Related
Aug 23, 2004
I have a bound form that I created. I want to be able to print a blank form. When I click on my print button, nothing happens. Also, when I click on the print icon, I get the following error:
PCL XL error
Subsystem: KERNEL
Error: IllegalStreamHeader
Operator: 0x0
Position: 0
Here is my code for the print button that I created:
Private Sub cmdPrint_Click()
On Error GoTo Err_cmdPrint_Click
DoCmd.PrintOut , Me.CurrentRecord, Me.CurrentRecord
Exit_cmdPrint_Click:
Exit Sub
Err_cmdPrint_Click:
MsgBox Err.Description
Resume Exit_cmdPrint_Click
End Sub
Am I using the wrong code? I really need to be able to print a blank form!
View 3 Replies
View Related
Jan 26, 2005
Hello
Here's the problem:
I'd like to print multiple reports using a button in a form.
I guess I could use something like that:
DoCmd.OpenReport "report1", acNormal
DoCmd.OpenReport "report2", acNormal
DoCmd.OpenReport "report3", acNormal
DoCmd.OpenReport "report4", acNormal
etc
in the command.click sub but here's the tricky section:
Some of my reports (they are all based in select queries) do not contain data.
How can I make access print only these forms that include records ?
For example if the query that provides records to the "report2" returns nothing, I would like on the commabd click event mentioned above, only the report1,3and 4 to be printed. Am I asking too much?Hope you guys understand what I'm talking about. Sorry , if my English isn't too good
Thank you in advance
View 7 Replies
View Related
Aug 13, 2015
I have a non standard size report (for printing labels)
The report is just over 10cm wide and just over 15cm deep.
I have solved the blank pages caused by exceeding the width but I'm still getting a blank page when I move some data down. I am still within 15 cm but it's throwing me a blank page. Even if I extend the in design mode depth to say 20cm (ie the height in Detail) it's throwing a blank page (I can see this in print preview).
I initially set up the report (it's a long time ago so memory fades) using the label wizard setting up a label 4*6 inches (10.16 * 15.24 cms) and it is this i'm trying to tweak. Is there a property I'm missing somewhere?
View 5 Replies
View Related
Feb 10, 2014
I've been asked to make sure only certain users in my database are able to print anything (i.e. Administrators). Is there any option/property to do this?
I have already built in User Access controls using the ctl.Tag property. The only way I can think off the top of my head is when a 'general user' uses it, to ensure that every control is displayed 'on screen only'. This of course doesn't stop them printing - just makes them print blank pages!
View 12 Replies
View Related
Jan 16, 2014
The first report example is what I get when I start on the main form and select an organization, run the report, opens report - BIG SPACE between the details and my footer section which holds a subform.
The second report is what I need it to look like, what's strange to me is I get the report correctly when I just run the report (I don't pass the organization into the report from the main form)
I tried changing the background color of the detail section and the footer section to figure out where my problem is but the space just stays white.
View 7 Replies
View Related
Oct 21, 2013
I have one-page forms which print a second page, blank except for a block of grey shading at the top. I have tried moving the content of the form up but that doesn't eliminate the second page. If I look at print preview, every second page of the entire database shows up as blank, regardless of where that happens to appear in the record.
View 2 Replies
View Related
Feb 16, 2006
Could anyone give some assist on how to print only the subform in a form. I'm looking to create a print preview command button that will allow only the sub form to be printed... Thanks for the assist.....
View 6 Replies
View Related
Jan 2, 2007
I have my subform on my main form and when I press the print button that I created it prints the main form 200 times due to the amout of records in the table.
When I open the subform by its self then press the print button that I created it will print what I want, the subform only.
Please help!! I want to print this subform from the main form.
Thanks,
View 1 Replies
View Related
Sep 19, 2005
Need to know if there is a way to exclude a subform from printing when I print forms?
Here's what I'm trying to do - Have a form that contains multiple subforms that are linked back to the master form. One of these subforms is a memo which they would like to see on the "preliminary or draft" copy of this form but would like to exclude it from the "final" copy.
I would think there is some why to do it but I'm stumped at the moment.
Any ideas would be greatly appreciated.
Thanks,
View 7 Replies
View Related
Dec 12, 2006
I have a database that has a form with 3 subforms. Once a user has entered date, there is a command button to print the current record. The problem is, the 3 subforms have a very thick black boarder around them. Is there anyway to remove the thick boarder? Any help would be appreciated.
View 1 Replies
View Related
Aug 24, 2007
I am trying to develop a service dispatch DB and would like to have a print workorder control button. I have it working OK until I enter subsequent records into the subform. OR..am I better off creating a report for the specified workorder? IF so, how? Any direction would be appreciated.
View 4 Replies
View Related
Jan 8, 2008
While using a relational database in Access 2003, I am writing a letter to people, reminding them what resources they have been allocated. The short letter is in a form and a subform has been used to list the resources - between 1 and 5 lines.
If I isolate one person by filtering, I get x identical pages, where x = the number of resources that have been allocated to them. Therefore, some people get one page, others could get 5 identical pages.
Can anyone advise how I can just show and print one page per person, irrespective of the number of resources allocated to them? I can get the correct result in a report but need it in a form so that the users can edit and select the letters to be printed easily.
Many thanks.
View 5 Replies
View Related
Jan 11, 2006
Hello,
I have done a search on this forum and found all the postings relating to printing only the current record for a report. I have a command button and have followed what these posts say. The report prints the current record but leaves out the data from the subform.
The database is a recipe organizer. The main form is called Recipes and the subform contains the ingredients for each recipe. This subform is called Ingredients.
I set up a command button with the following code:
Private Sub Print_Recipe_Click()
On Error GoTo Err_Print_Recipe_Click
Dim stDocName As String
stDocName = "Family Recipes"
DoCmd.OpenReport stDocName, acNormal, , "[RecipeID] = " & Forms!RECIPES![RecipeID]
Exit_Print_Recipe_Click:
Exit Sub
Err_Print_Recipe_Click:
MsgBox Err.Description
Resume Exit_Print_Recipe_Click
End Sub
Since the RecipeID is used in both forms and the report, I thought it would be the best field to use since it linked all the information together.
So what do I need to do so that the subform data prints out on the report?
Thanks
GeekyGirl
View 3 Replies
View Related
Oct 4, 2006
I have a subform that displays results based on selections from cascading boxes on the form. I am trying to print them to a report. I think my procedure is correct for the print button and Im afraid my problem is that the form is not based on a seperate query. Is that they only way to be able to print? It is based on procedures defined in the cascading boxes. How can correct it so it will print the results to a report? Thanx.
View 2 Replies
View Related
Apr 15, 2014
I've got a piece of VBA scripting which runs as an event linked to a button on my MS Access form.
I maintain a database of members of staff at my organisation. It's pretty outdated...
I'm basically wanting to pull in their updated data (extracted from on our payroll system) from a spreadsheet, into a form, when clicking a button on a particular person's record.
This is what I have so far.
Code:
start = Forms!frm_main2!txt_start_row.Value - 1
conv = DDEInitiate("EXCEL", "Staff List.xlsx")
cell_employee_number = "R" & start & "C1"
cell_surname = "R" & start & "C2"
[Code] ....
The function "CStr(DDERequest())" converts the cell number into the readable data, however I seem to have whitespace below the value.
What would I need to do to strip out this whitespace? Would I use strtrim? If so, I am unsure of the syntax... how would I incorporate strtrim into the above?
View 7 Replies
View Related
Aug 31, 2006
Hi there,
I am trying to save my form that i have created as a report by right clicking on the form and choosing save as report. However, my form includes a subform but the subform does not show up in the report. Any ideas as to why this and how it can be shown????
Thanks in advance
Lucy
View 2 Replies
View Related
Oct 21, 2006
I currently am trying to print the current record that I have selected on my form and the subform that I have on the same page. If I try to print selected record it will only print out the main form correctly and will print out the first record on the sub form. I have tried to make a reprot of the current form and it only will do the main form and nothing from the sub form. I am willing to try whatever method would work in getting this to work. Thanks
View 2 Replies
View Related
May 30, 2013
I'm using access 2003
I've successfully printed a report from a main form control and now I'm trying to do the same with a subform control.
I'm using a query to filter the report, with the criteria of:
Code: [forms]![MainForm]![Subform].[form]![textbox]
Is there something I'm missing?
View 10 Replies
View Related
