PRINT INVISIBLE FORM
Hi All, I have a form A that I sometimes print using the printout command, after passing some parameters and making calculations. I want to print the same form A from another form while making form A invisible. How should I do this? -- Glint
|
0 |
|
Utf
3/13/2008 2:04:01 PM
access.formscoding
7493 articles. 
0 followers.
4 Replies
686 Views
You should create a report from form a and print that instead of the form. That way you don't have to hide anything. Reports are meant to be for printing. Forms are meant for data-entry and showing data... -- Maurice Ausum "Glint" wrote: > Hi All, > I have a form A that I sometimes print using the printout command, after > passing some parameters and making calculations. > I want to print the same form A from another form while making form A > invisible. How should I do this? > -- > Glint
|
|
0 |
|
Utf
3/13/2008 3:47:09 PM
Thanks for your response, Maurice. I decided not to create a report because of the complexity of the form, and that the report would not be needed often. Moreover, the form allows me to filter anyway I want. I just want wanted to avoid all the extra work needed to create the report(s). Is there a way I can print the form from another form? -- Glint "Maurice" wrote: > You should create a report from form a and print that instead of the form. > That way you don't have to hide anything. Reports are meant to be for > printing. Forms are meant for data-entry and showing data... > -- > Maurice Ausum > > > "Glint" wrote: > > > Hi All, > > I have a form A that I sometimes print using the printout command, after > > passing some parameters and making calculations. > > I want to print the same form A from another form while making form A > > invisible. How should I do this? > > -- > > Glint
|
|
0 |
|
Utf
3/13/2008 10:58:00 PM
"Glint" <Glint@discussions.microsoft.com> wrote in message news:17710D7C-BB1A-4D50-9FB1-726570053B65@microsoft.com... > Thanks for your response, Maurice. > I decided not to create a report because of the complexity of the form, > and > that the report would not be needed often. Moreover, the form allows me to > filter anyway I want. I just want wanted to avoid all the extra work > needed > to create the report(s). > Is there a way I can print the form from another form? > -- > Glint FYI you can simply save the form as a report. Select the form in the database window and choose File -> Save As, then select 'as report' from the dialog's combo.
|
|
0 |
|
Stuart
3/13/2008 11:23:20 PM
Stuart, you are wonderful! I would not have thought of that in a million years. Thanks for your help. -- Glint "Stuart McCall" wrote: > "Glint" <Glint@discussions.microsoft.com> wrote in message > news:17710D7C-BB1A-4D50-9FB1-726570053B65@microsoft.com... > > Thanks for your response, Maurice. > > I decided not to create a report because of the complexity of the form, > > and > > that the report would not be needed often. Moreover, the form allows me to > > filter anyway I want. I just want wanted to avoid all the extra work > > needed > > to create the report(s). > > Is there a way I can print the form from another form? > > -- > > Glint > > FYI you can simply save the form as a report. Select the form in the > database window and choose File -> Save As, then select 'as report' from the > dialog's combo. > > >
|
|
0 |
|
Utf
3/14/2008 12:53:00 AM
Similar Artilces:
Autofill In Linked Forms
I have created a couple of forms by selecting all the fileds in the form wizard from two tables: 1. Suppliers (Fields: Supplier, Address, Contact, etc.) 2. Products (Fields: Supplier <Lookedup from Supplier Table>, Product, Rate, etc.) Upon clicking the toggle button on Suppliers form I have the Products form opened. However, as I enter the data in it, I want the Supplier filed in the same be automatically be filled with the Supplier name as in the opened Supplier form so as to be filtered and displayed the next time I open the same instead of manually inserting the sa...
Can see form in design view but not in open or layout view
I have set up the tables, relationships and forms. When I first created the form I was able to view when clicking open. I made a couple of changes and now when I click on open a box pops up to enter perimeter value. Also, I can no longer see the form in opne or layout but if I click for design view, I can see my form and all the tabs. There is either something missing or somthing is named incorrectly. Had a similar problem recently where a new version was installed in the front end, but the table in the back end had not been updated properly (a new field) and the new version of the...
Name Range with using Data Form
I first created a variable with A1:D1, four columns with named variable Data. How to expand this Data range to A1:D2 after using the DataForm to add one row data in the worksheet?? The same, the Data range should be A1:D3 when adding one more data row... million thanks Hi use the following formula in the name definition dialog =OFFSET($A$1:$D$1,0,0,COUNTA($A:$A)) >-----Original Message----- >I first created a variable with A1:D1, four columns with named variable >Data. How to expand this Data range to A1:D2 after using the DataForm to add >one row data in the worksheet?? The...
Defaults on Print Sales Documents screen
Is there a way to set defaults on the boxes selected under the Picking Ticket column on the Print Sales Documents screen? Currently when we open the screen, we have to select which boxes to tick and since we always select the same boxes we wondered if there was a way to have them default when the screen is opened so we don't have to click each time. We want the "Picking Ticket Per Site" box, the "Include Kit Components" box and the "Bin Sequenced" box selected as default values. Thanks!! LMG, You can accomplish this with a small VBA customization, b...
Amount in words to be printed on the invoice
Hi Mates, I need to print the invoice amount in words in MRMS 2.0 Any suggestions Thanks this is available through Microsoft. check out the following site: https://mbs.microsoft.com/customersource/support/downloads/reportslibrary/rms_reportslibrary.htm "RK" wrote: > Hi Mates, > > I need to print the invoice amount in words in MRMS 2.0 > > Any suggestions > > Thanks ...
Printing
Hope you folks can help me out with a strange one. I have several worksheets formatted in exactly the same way as follows: Col A - width 4 Col B - hidden Col C - width 4 Col D - Width 108 Col E - Width 3 Col F - Width 11 Col G - Hidden Col H - Width 11 & Empty My print range should be Cols A:G (I have used page setup to set the scaling to fit 1 page wide by [blank] pages tall, thus each sheet will print as many pages as required depending on number of rows] When I have the print range set to A:G only columns A:E show on the print preview (and also on the actual print out) and when I m...
Subtracting value from main form
I have a borrow module which will alow user to return item separately. So, I have get the structure of returning it separately. In my main form is the borrowing item, with the loaned quantity and the owed quantity (will be calculated). In the subform, there is the returning transaction. User will need to key in the quantity returned and it will be automatically deducted from the quantity owed. But how am I supposed to get the quantity deducted while it 1 is in main form and the other is in subform? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-fo...
Entourage 2008 DAILY calendar crashes once I hit the print button
Every time I attempt to print my DAILY calendar it crashes. The weekly calendar prints okay. I've run Repair Permissions and restarted Entourage again and again. Below is the Error Report I receive whenever I try to print daily calendar: Microsoft Error Reporting log version: 2.0 Error Signature: Exception: EXC_BAD_ACCESS Date/Time: 2010-03-14 14:12:44 -0400 Application Name: Microsoft Entourage Application Bundle ID: com.microsoft.Entourage Application Signature: OPIM Application Version: 12.2.4.100205 Crashed Module Name: Microsoft Entourage Crashed Module Version: 12...
Outlook/Access 2003
I've been doing a lot of research and purchased (but haven't completely read) Sue Mosher's book. However, before I spend much more time I'd like to find out if my idea is even feasible. The basic idea is to create an appointment system for multiple therapists that can be used by a receptionist and other staff. Using Outlook and Exchange is very nice but the appointment data needs to end up in an Access table immediately. We can purchase SBS 2003 with Exchange 2003 or we can buy a third party tool for calendar sharing whichever would be the easiest to use. I currently...
Keeping forms in order they are entered?
I am working with a database that was designed for us and have pretty much just used without having to change much in but have now run into a problem and hope someone can help. We track and number complaints we recieve by number using last digits of year recieved then next number, i.e. a complaint recived 12/31/09 might be 9234 and first one received this year would be 10001 and the next would be 10002. The problem is now when I open my forms and go to the last one it is the 9234 instead of the 10002 which I need. How do I keep that last form I entered last the next time I open the data...
How to print a graph of x=y at 45 degrees
How can I make it appear correctly on paper? Gordon, Set up two sets of points: 0 0 1, 1 Plot them with an x-y scatter chart, line style. Set the x and y axis scales the same, if necessary, to get the resulting plot to be at 45�. Print it, and hope for the best. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "gordon158" <gordon158@discussions.microsoft.com> wrote in message news:2C5B1255-334F-41A3-A5E5-55516CFABA6A@microsoft.com... > How can I make it appear correctly on paper? ...
increment through controls on form
I have a form that I've name the controls on it in such a way that I could determine through open args if it should be locked or not. Example any text box that begins with txtd would be unlocked with open args of 1. I was hoping there was a way I could just move through the controls in a loop and set that property with one function.....I'm not for sure how to accomplish this though. Does anyone have some sample code on how to "loop" through all the controls on a form and set the locked property? I can write the criteria portion if I could get a sample of how to ...
label printing
There should be a way to print labels from all P.O. being received the same day. to avoid wasting labels. ...
Attach Trigger to Save Function of Form
I am in the processes of trying to attach a trigger to the Save function of an already existing GP form using Dex. In one of the documents, it states that the CM_Checkbook_Maitenance has a SaveRecord function. I am trying to acces the function that is similar to this on the PM_Vendor_Maitenance form. I tried using SaveRecord and when I tried to compile it it says that it is an unknown reference. Is there some documentation with a list of the functions for each form? Mike, PM_Vendor_Maintenance is an older form and probably doesn't have a SaveRecord function. Try running t...
look way to map form at CRM frontend to tables at CRM database
How can I find out what tables which new record has been added on when I enter data through a form in CRM front end? I try to find way to map form in the CRM frontend to the tables at the CRM database at backend? It is CRM 3.0 Thank in advances for help! ...
Insert Acount# in the PO print
Can some one please let me know where I should place this variable: "PurchaseOrder.Supplier.AccountNumber" in the PO.xml file I woud like to be able to print the Acount # in the PO Thank you jm wrote: > Can some one please let me know where I should place this variable: > "PurchaseOrder.Supplier.AccountNumber" in the PO.xml file > I woud like to be able to print the Acount # in the PO > Thank you > Into receipt header? Open your XML.. and find field date of receipt.. but why you have no AccountNumber into your PO.xml ? Antonio Thank you for a...
Printing a worksheet on 11x17 paper
I want to print a worksheet on 11x17 paper. When I try to change to that paper size in print options, there is no size like that available. What do I do??? thank you for your help in this matter. Katie It's the printer that decides that.. Do you have that option on the printer it should be available in Excel -- Regards, Peo Sjoblom "Katie" <anonymous@discussions.microsoft.com> wrote in message news:9fca01c4345c$bcdca970$a301280a@phx.gbl... > I want to print a worksheet on 11x17 paper. When I try > to change to that paper size in print options, there is ...
upload form problem / server question
www.icingpictures.co.uk / win xp / frontpage 2003 Want to create a form with upload file form field - i read on this forum that the server type i use is important - it should be a windows type server with frontpage extensions - i currently use a linux server with front page extensions - do i need to change to a windows server? Thanks for taking a looka t my question. Joyce Yes, you must have a Windows Server, just like you stated you read. -- Tom [Pepper] Willett Microsoft MVP - FrontPage Since 1997 --------------------------- "threademporium" <threademporiu...
Printing #2
I understand that NLQ printing is default in windows. Is there any way one can get a quick draft print of excel reports on a dot matrix printer by changing the printer driver or fonts for instance? Thank you. Hiren, I'm not sure about this setting, but try "Draft quality" in File - Page setup - Sheet. -- Earl Kiosterud mvpearl omitthisword at verizon period net President Bush on sovereignty: http://www.tastefullystated.com/sovereignty.wmv ------------------------------------------- "Hiren Shah" <hiren_shah50@hotmail.com> wrote in message news:054901c4961...
Is batch ID is required in payables transaction entry form?
Is batch ID is required in payables transaction entry form? How about if I just have 1 invoice and do not want to create a batch for it? can I still process the invoice? Hi Bab, A batch i.d. number is not required. You have to post your invoice both in the Payables module and also in the Financial module. I check weekly for any "series batches" that have not been posted in my A/P, A/R, P/R, and Financial modules. If they go unposted it can create havoc. I hope this has been helpful to you. -- Diana "Bab" wrote: > Is batch ID is required in payables transa...
Import Print Shop files into MS Publisher
Is there any way to import files created in Print Shop into MS Publisher? I need to convert all of my old(er) Print Shop files and am not sure how to accomplish that. Thanks in advance for any info and help. Sigrid What kind of files are you talking about...images? If so, then probably yes, just export (or save) them as standard graphic files. Are you talking about Broderbund's Print Shop? You need to explain exactly what you are trying to do, and what is/is-not happening when you try. -- ~~~~~~~~~~~~~~~~~~ Rob Giordano Microsoft MVP Expression Web ...
Fixing coloumn title in datasheet forms
I have a form which has a subform. Is there anyway to fix the length of the column heading in the datasheet view? I can expand it when viewing but when I close the form and open it again it has shrunk back to its smaller size. Thanks Tony Are you referring to the column width? If so check out columnwidth properties in help. Damon "Tony Williams" <tw@invalid.com> wrote in message news:%23RCxCN$4HHA.5844@TK2MSFTNGP02.phx.gbl... >I have a form which has a subform. Is there anyway to fix the length of the >column heading in the datasheet view? I can expand it when...
Dynamic Access Report from filtered Form
I need help. I have succuess fully applied the "how to create a dynamic crosstab report in access" from instructions off of microsofts web site to my own report and query. My problem is this. I have a form in datasheet view, based off a query. When the form is open I can hide / unhid columns as needed and apply filter by form. That all is great. But now I want to beable to send the filtered data on the datasheet form to the Dynamic Report I created showing only the filtered records and also only show the columns that I did not have hidden on my form. How do I do this? I have t...
Print individual forms
I have created a form with several subforms in it. The form contains the same information for a number of different individuals. I would like to print the form for each individual separately. When i try to print it, if prints out the information for all the individuals. How do i do this. I have attached a screen shot of the first page of the form. The problem is that forms are used for user interface, and have things like buttons, radio controls etc. that often hinders the ability to print a form. furthermore you'll often find that the form has background sheeting, and I can waste...
Form Sizing 08-06-07
-- Thanks David G Albury, Australia DoCmd.Maximize ...
I have created a couple of forms by selecting all the fileds in the form wizard from two tables: 1. Suppliers (Fields: Supplier, Address, Contact, etc.) 2. Products (Fields: Supplier <Lookedup from Supplier Table>, Product, Rate, etc.) Upon clicking the toggle button on Suppliers form I have the Products form opened. However, as I enter the data in it, I want the Supplier filed in the same be automatically be filled with the Supplier name as in the opened Supplier form so as to be filtered and displayed the next time I open the same instead of manually inserting the sa...
Can see form in design view but not in open or layout view
I have set up the tables, relationships and forms. When I first created the form I was able to view when clicking open. I made a couple of changes and now when I click on open a box pops up to enter perimeter value. Also, I can no longer see the form in opne or layout but if I click for design view, I can see my form and all the tabs. There is either something missing or somthing is named incorrectly. Had a similar problem recently where a new version was installed in the front end, but the table in the back end had not been updated properly (a new field) and the new version of the...
Name Range with using Data Form
I first created a variable with A1:D1, four columns with named variable Data. How to expand this Data range to A1:D2 after using the DataForm to add one row data in the worksheet?? The same, the Data range should be A1:D3 when adding one more data row... million thanks Hi use the following formula in the name definition dialog =OFFSET($A$1:$D$1,0,0,COUNTA($A:$A)) >-----Original Message----- >I first created a variable with A1:D1, four columns with named variable >Data. How to expand this Data range to A1:D2 after using the DataForm to add >one row data in the worksheet?? The...
Defaults on Print Sales Documents screen
Is there a way to set defaults on the boxes selected under the Picking Ticket column on the Print Sales Documents screen? Currently when we open the screen, we have to select which boxes to tick and since we always select the same boxes we wondered if there was a way to have them default when the screen is opened so we don't have to click each time. We want the "Picking Ticket Per Site" box, the "Include Kit Components" box and the "Bin Sequenced" box selected as default values. Thanks!! LMG, You can accomplish this with a small VBA customization, b...
Amount in words to be printed on the invoice
Hi Mates, I need to print the invoice amount in words in MRMS 2.0 Any suggestions Thanks this is available through Microsoft. check out the following site: https://mbs.microsoft.com/customersource/support/downloads/reportslibrary/rms_reportslibrary.htm "RK" wrote: > Hi Mates, > > I need to print the invoice amount in words in MRMS 2.0 > > Any suggestions > > Thanks ...
Printing
Hope you folks can help me out with a strange one. I have several worksheets formatted in exactly the same way as follows: Col A - width 4 Col B - hidden Col C - width 4 Col D - Width 108 Col E - Width 3 Col F - Width 11 Col G - Hidden Col H - Width 11 & Empty My print range should be Cols A:G (I have used page setup to set the scaling to fit 1 page wide by [blank] pages tall, thus each sheet will print as many pages as required depending on number of rows] When I have the print range set to A:G only columns A:E show on the print preview (and also on the actual print out) and when I m...
Subtracting value from main form
I have a borrow module which will alow user to return item separately. So, I have get the structure of returning it separately. In my main form is the borrowing item, with the loaned quantity and the owed quantity (will be calculated). In the subform, there is the returning transaction. User will need to key in the quantity returned and it will be automatically deducted from the quantity owed. But how am I supposed to get the quantity deducted while it 1 is in main form and the other is in subform? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-fo...
Entourage 2008 DAILY calendar crashes once I hit the print button
Every time I attempt to print my DAILY calendar it crashes. The weekly calendar prints okay. I've run Repair Permissions and restarted Entourage again and again. Below is the Error Report I receive whenever I try to print daily calendar: Microsoft Error Reporting log version: 2.0 Error Signature: Exception: EXC_BAD_ACCESS Date/Time: 2010-03-14 14:12:44 -0400 Application Name: Microsoft Entourage Application Bundle ID: com.microsoft.Entourage Application Signature: OPIM Application Version: 12.2.4.100205 Crashed Module Name: Microsoft Entourage Crashed Module Version: 12...
Outlook/Access 2003
I've been doing a lot of research and purchased (but haven't completely read) Sue Mosher's book. However, before I spend much more time I'd like to find out if my idea is even feasible. The basic idea is to create an appointment system for multiple therapists that can be used by a receptionist and other staff. Using Outlook and Exchange is very nice but the appointment data needs to end up in an Access table immediately. We can purchase SBS 2003 with Exchange 2003 or we can buy a third party tool for calendar sharing whichever would be the easiest to use. I currently...
Keeping forms in order they are entered?
I am working with a database that was designed for us and have pretty much just used without having to change much in but have now run into a problem and hope someone can help. We track and number complaints we recieve by number using last digits of year recieved then next number, i.e. a complaint recived 12/31/09 might be 9234 and first one received this year would be 10001 and the next would be 10002. The problem is now when I open my forms and go to the last one it is the 9234 instead of the 10002 which I need. How do I keep that last form I entered last the next time I open the data...
How to print a graph of x=y at 45 degrees
How can I make it appear correctly on paper? Gordon, Set up two sets of points: 0 0 1, 1 Plot them with an x-y scatter chart, line style. Set the x and y axis scales the same, if necessary, to get the resulting plot to be at 45�. Print it, and hope for the best. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "gordon158" <gordon158@discussions.microsoft.com> wrote in message news:2C5B1255-334F-41A3-A5E5-55516CFABA6A@microsoft.com... > How can I make it appear correctly on paper? ...
increment through controls on form
I have a form that I've name the controls on it in such a way that I could determine through open args if it should be locked or not. Example any text box that begins with txtd would be unlocked with open args of 1. I was hoping there was a way I could just move through the controls in a loop and set that property with one function.....I'm not for sure how to accomplish this though. Does anyone have some sample code on how to "loop" through all the controls on a form and set the locked property? I can write the criteria portion if I could get a sample of how to ...
label printing
There should be a way to print labels from all P.O. being received the same day. to avoid wasting labels. ...
Attach Trigger to Save Function of Form
I am in the processes of trying to attach a trigger to the Save function of an already existing GP form using Dex. In one of the documents, it states that the CM_Checkbook_Maitenance has a SaveRecord function. I am trying to acces the function that is similar to this on the PM_Vendor_Maitenance form. I tried using SaveRecord and when I tried to compile it it says that it is an unknown reference. Is there some documentation with a list of the functions for each form? Mike, PM_Vendor_Maintenance is an older form and probably doesn't have a SaveRecord function. Try running t...
look way to map form at CRM frontend to tables at CRM database
How can I find out what tables which new record has been added on when I enter data through a form in CRM front end? I try to find way to map form in the CRM frontend to the tables at the CRM database at backend? It is CRM 3.0 Thank in advances for help! ...
Insert Acount# in the PO print
Can some one please let me know where I should place this variable: "PurchaseOrder.Supplier.AccountNumber" in the PO.xml file I woud like to be able to print the Acount # in the PO Thank you jm wrote: > Can some one please let me know where I should place this variable: > "PurchaseOrder.Supplier.AccountNumber" in the PO.xml file > I woud like to be able to print the Acount # in the PO > Thank you > Into receipt header? Open your XML.. and find field date of receipt.. but why you have no AccountNumber into your PO.xml ? Antonio Thank you for a...
Printing a worksheet on 11x17 paper
I want to print a worksheet on 11x17 paper. When I try to change to that paper size in print options, there is no size like that available. What do I do??? thank you for your help in this matter. Katie It's the printer that decides that.. Do you have that option on the printer it should be available in Excel -- Regards, Peo Sjoblom "Katie" <anonymous@discussions.microsoft.com> wrote in message news:9fca01c4345c$bcdca970$a301280a@phx.gbl... > I want to print a worksheet on 11x17 paper. When I try > to change to that paper size in print options, there is ...
upload form problem / server question
www.icingpictures.co.uk / win xp / frontpage 2003 Want to create a form with upload file form field - i read on this forum that the server type i use is important - it should be a windows type server with frontpage extensions - i currently use a linux server with front page extensions - do i need to change to a windows server? Thanks for taking a looka t my question. Joyce Yes, you must have a Windows Server, just like you stated you read. -- Tom [Pepper] Willett Microsoft MVP - FrontPage Since 1997 --------------------------- "threademporium" <threademporiu...
Printing #2
I understand that NLQ printing is default in windows. Is there any way one can get a quick draft print of excel reports on a dot matrix printer by changing the printer driver or fonts for instance? Thank you. Hiren, I'm not sure about this setting, but try "Draft quality" in File - Page setup - Sheet. -- Earl Kiosterud mvpearl omitthisword at verizon period net President Bush on sovereignty: http://www.tastefullystated.com/sovereignty.wmv ------------------------------------------- "Hiren Shah" <hiren_shah50@hotmail.com> wrote in message news:054901c4961...
Is batch ID is required in payables transaction entry form?
Is batch ID is required in payables transaction entry form? How about if I just have 1 invoice and do not want to create a batch for it? can I still process the invoice? Hi Bab, A batch i.d. number is not required. You have to post your invoice both in the Payables module and also in the Financial module. I check weekly for any "series batches" that have not been posted in my A/P, A/R, P/R, and Financial modules. If they go unposted it can create havoc. I hope this has been helpful to you. -- Diana "Bab" wrote: > Is batch ID is required in payables transa...
Import Print Shop files into MS Publisher
Is there any way to import files created in Print Shop into MS Publisher? I need to convert all of my old(er) Print Shop files and am not sure how to accomplish that. Thanks in advance for any info and help. Sigrid What kind of files are you talking about...images? If so, then probably yes, just export (or save) them as standard graphic files. Are you talking about Broderbund's Print Shop? You need to explain exactly what you are trying to do, and what is/is-not happening when you try. -- ~~~~~~~~~~~~~~~~~~ Rob Giordano Microsoft MVP Expression Web ...
Fixing coloumn title in datasheet forms
I have a form which has a subform. Is there anyway to fix the length of the column heading in the datasheet view? I can expand it when viewing but when I close the form and open it again it has shrunk back to its smaller size. Thanks Tony Are you referring to the column width? If so check out columnwidth properties in help. Damon "Tony Williams" <tw@invalid.com> wrote in message news:%23RCxCN$4HHA.5844@TK2MSFTNGP02.phx.gbl... >I have a form which has a subform. Is there anyway to fix the length of the >column heading in the datasheet view? I can expand it when...
Dynamic Access Report from filtered Form
I need help. I have succuess fully applied the "how to create a dynamic crosstab report in access" from instructions off of microsofts web site to my own report and query. My problem is this. I have a form in datasheet view, based off a query. When the form is open I can hide / unhid columns as needed and apply filter by form. That all is great. But now I want to beable to send the filtered data on the datasheet form to the Dynamic Report I created showing only the filtered records and also only show the columns that I did not have hidden on my form. How do I do this? I have t...
Print individual forms
I have created a form with several subforms in it. The form contains the same information for a number of different individuals. I would like to print the form for each individual separately. When i try to print it, if prints out the information for all the individuals. How do i do this. I have attached a screen shot of the first page of the form. The problem is that forms are used for user interface, and have things like buttons, radio controls etc. that often hinders the ability to print a form. furthermore you'll often find that the form has background sheeting, and I can waste...
Form Sizing 08-06-07
-- Thanks David G Albury, Australia DoCmd.Maximize ...