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?
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
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
here's my macro
after each print out line i get this
can i disable this prompt from appearing?
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.