Modi Printout Shrinking 2nd + Pages
Apr 29, 2008
Hello,
Anyone know why my MODI printout code is shrinking the 2nd + pages? This is only happing with the vba printout. If I open the file right from Office Image Document and print it comes out fine. Below is the code I am using.
The c: emp est.mdi is an exsiting file.
I have also tried miPrint_Print and just printout and all do the same thing.
The document is 3 pages and only the 1st comes out normal the 2nd and 3rd page are very very small in the upper left corner. But if I print these from Image Document itself it prints fine on all 3 pages.
Code:Set MyDoc = New MODI.DocumentMyDoc.Create ("c: emp est.mdi")MyDoc.PrintOut miPRINT_ACTUALSIZESet MyDoc = Nothing
Thanks
Joe
View Replies
ADVERTISEMENT
Oct 25, 2006
I have this probably ridiculously easy problem on one of my forms. i have a subform that has a combo box in it. but the field is not large enough... i've dragged and dropped and changed the field size and it still shrinks back to what it was before.
anyone have any idea why?
View 2 Replies
View Related
Mar 12, 2007
How do I get the Print Range: SELECTION to print only specific pages? When I enter page from and page to it still prints the entire selection.
If I use Print Range: Pages, and enter the page from and page to, it prints all records, not just the selection.
Is there Visual Basic Code that can do it?
View 3 Replies
View Related
Feb 21, 2005
Ok, I am new to Access 2000, or any Access, so I don't know the lingo.
I'll try to explain my question as well as I can :
The user enters information into a record...a medical record, like a name, an address, and some
particulars like what type of medications this person is taking...asprin, amoxcicillan, whatever.
Ok, now I want to print out an instruction sheet for this person with regards to the types of
meds they're taking. This sheet would contain recommended dosage, side effects, drug interactions,
whether to take it with a meal or not. This sheet would contain all this information by looking at
"aspirin" in the peron's database file, and then expand on this information in a printout.
In other words, I type in "aspirin" and in return Access prints out a whole bunch of information
on asprin, which the person will find useful.
Now technically I know I'd have to have a (I'm assuming) seperate database with the keyword "aspirin"
and then all this information somehow stored under it. And again somehow they'd have to be linked or
queried, or mined, or whatevered into order to make it work.
Basically I think I'm asking for the equivilant of a computer-librarian. Where I can ask for information
by word (like "aspirin"), and the librarian will give me all the information available in the database.
So how do I do it? lol.
Thanks. - Eric
View 1 Replies
View Related
Sep 15, 2005
here's my macro
after each print out line i get this
can i disable this prompt from appearing?
View 1 Replies
View Related
Jun 1, 2005
I have seven (sub) reports put on to a large report. How can I get the reports to shrink or grow according to how much info they have in them. I have tried Detail - Can Shrink, Can grow - but this doesn't seem to work. At the moment I have them all lined up but they are all overlapping each other.
View 3 Replies
View Related
Sep 3, 2014
I have a report that has the addresses from the client and auditor on the same level. The address of the auditor is on the left side and the client on the right side. They have both the same layout:
Auditor - client
Attn auditor - attn client
etc.
When the Attn for the auditor is empty, it will show and empty space between auditor name and auditor address.
All the fields have the can shrink to yes, but if they are on the same level in the report, the one have text in it, forces the empty space.
Is there a workaround for this?
View 1 Replies
View Related
Dec 13, 2014
I have a continuous form with 4 text boxes
txt1,txt2,txt3,txt4
if txt1 has more than one line how to let it grow and in the same time the other txt boxes will grow to the same size
all the textboxes should have the biggest size
I did this but in report
I put this code in the event OnPrint
Code:
On Error Resume Next
Dim lngCounter As Long, dblMaxHeight As Double, i As Integer
dblMaxHeight = 0
ReDim strcontrol(10)
For i = 0 To 10
[Code] .....
Is there anyway to let this done in forms?
View 1 Replies
View Related
Sep 21, 2013
What I want to do is have the SQL printout list all the fields in a table that I have already created. Also how would I enable SQL view? Im new to Access.
Using Windows Vista and Access 2010.
View 1 Replies
View Related
Apr 3, 2006
I have a database with 4 tables One for agent info and 3 for property info.
I have linked the agent table to the property tables.
I need to setup a link for the agents. If I have an agent and they click on see my property, Do I have to have a page for each agent or can it be done with one page?
View 2 Replies
View Related
Aug 29, 2006
Hi,
I want to open up a certain page of a tab control using VBA code.
For example: when user presses a button in a form, tab number three of a tab control opens in an other form.
Any help will be very much appreciated.
B
View 14 Replies
View Related
May 6, 2007
This might be a question that isn't possible, but I have three html pages made in my database, and i was wondering if there is a way to link the pages into the switchboard somehow because then everything would be accessible from one central location?? if you have any answers or sugestions they are greatly appreciated! thanks
View 4 Replies
View Related
Nov 13, 2007
Hi im trying to see if there is a way to put a timer in tab pages. so that when the time expires it changes to another tab. I have it working fine with the command button. I have like 20 tabs all hidden until the user clicks the cmd. Now is there a way to put a timer? I know that i can do it with the Form_timer, but that dont seem to work with tabs.
thanx
View 8 Replies
View Related
Sep 23, 2005
I am using the "Tab Pages" on a form. On one of the pages I have a subform. If I'm doing a routine in VBA regarding that subform, do I need to reference the Tab Pages object as well as the form and the subform?
View 2 Replies
View Related
May 26, 2006
Hello,
I have a form with a lot of controls. To make it much more clear for users, I was thinking of adding tab controls or page breakes.
I have placed a tab control with two pages on my form and tried to move the existing controls on the required page but of course the control will show on all the pages.
Is there a way to bypass this without having to create a new form and placing controls one at the time?
Thanks
View 2 Replies
View Related
May 9, 2005
Hello visitors,
I have a report base on a select query but in the report i get the following:
page 1 = record 1
page 2, page 3, page 4 = are empty (nothing to see on the pages)
page 5 = record 2
page 6, page 7, page 8 = are empty (nothing to see on the pages)
page 9 = record 3
...........etc...
So there are three empty pages between every two pages(records).
I have checked in the settings of the report and all properties but cannot find the solution.
Can any one help me to solve this ?
Thanks in advance
View 3 Replies
View Related
May 13, 2005
Hello Experts..
I am new to Access. I have Access 2003.
When I try to create a data access page using Wizard, I am getting the following message.
'The wizard is unable to create your data access page'
When I click on Database and select Refresh, I get the other msg
"Microsoft office access is unable to connect to the data source specified in the connection string of this page"..
I am very badly stuck here..Please help.
Thanks in advance...
Arun.
View 1 Replies
View Related
May 13, 2005
I am getting very frustrated(and surprised) to see there was no answers to my question regarding Data Access Pages yet. I searched the web and manuals and help in Access, but no luck yet...
Can anyone tell me if Data Access Pages really works? I just came to know about it while developing MS Access application...I just thot it will be cool to go web with less effort...
Thanks very much...
------------------------------------------------------------------------
Hello Experts..
I am new to Access. I have Access 2003.
When I try to create a data access page using Wizard, I am getting the following message.
'The wizard is unable to create your data access page'
When I click on Database and select Refresh, I get the other msg
"Microsoft office access is unable to connect to the data source specified in the connection string of this page"..
I am very badly stuck here..Please help.
Thanks in advance...
Arun.
View 7 Replies
View Related
Aug 9, 2005
I'm setting up data access pages that will be accessed over the internet. Because of this I want to make sure that everything is secure. I am using IIS 5.0 (Windows XP) as the web server. I used the three-tier authentication approach discussed in the microsoft article here (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/deploydap.asp) So I'm pretty sure that the authentication is secure. But what about the communication between the browser and MSDE during databinding? Is that secure?
Wanting to make sure I set up a SSL certificate which secures the page and set the Remote Server in the connection settings in the data access pages to "https://domain.com". Does this secure the comminication between browser and the server?
Thanks in advance
View 1 Replies
View Related
Dec 6, 2005
If I build an access database that uses data access pages, are all users required to have a copy of the MS Access software, or does the database run strictly off of the browser?
View 1 Replies
View Related
Aug 21, 2007
This is the first time ive used the switchboard so hopefully this will be just a quicky!
Bascially i have a main switchboard which has 3 buttons. These buttons all link to different switchboard pages.
THE PROBLEM :- I have labels on the main switchboard and these are all appearing on the consequent switchboard pages. Is there a way of assigning these just to the main switchboard and not the other pages?
Thanks, any advice would be most appreciated!
View 11 Replies
View Related
Nov 19, 2007
Novice user here. I have created a database with tables,queries,forms and reports. I'm now trying to create a webpage that will run the reports i have created. At the moment i'm the only user that will run these reports (via webpage) so the database is on my computer.
I have created a data access page using a query but the records are displayed 1 by 1. I need it to display like my reports.
Sorry if you're confused. Thanks for any feedback.
View 1 Replies
View Related
Jan 20, 2006
Please can anyone tell me how to make this pages editable when displayed as a web page.
I don't know what property to set that would allow data entry.
View 1 Replies
View Related
Jul 16, 2005
I have a number of tabbed pages and I was wondering if you could increase the size of the tab to make it (Vertically) larger so you could write the headings over two lines.
Also what does "Multi row" mean in the tabbed row pages?
View 1 Replies
View Related
Jul 14, 2005
I have created a form which has a main section (Client demographics (bound to tblClient) and then five tabbed pages with subforms.(Data associated with the Client- all forms derived from tblAssociatedDetails). The subforms on the tabbed pages are all linked via a ClientID number.
In the form header I have put a a combo box and with the wizard said that I want it to select data from my form (in the case search via Surname). This works but only for the top part of the form (ie it will load the demographics) but will not load any of the data from the tabbed pages (subforms).
Any idea where the missing link could be?
View 1 Replies
View Related
Sep 9, 2006
I have generated a data access page from a table. I want this page to be used on the Internet where users can enter their data and the info is automatically sent to the access database.
But when I accessed the page in the browser, I can not edit the fields and do any inputs. Have I missed something?
tks
View 1 Replies
View Related
