Search results

the code in that article shows you hot you can print the doc thru code. but what we want to do is actually bring up the printer dialogue box. such as the one that comes up when you print from Word. i belive you can make your own by grabing the data using the commands in that article but there...

The only thing i could figure out was using the docmd command funtion after opening the report in the background. so use the open report in a preview mode and then the command for the printer dialgue box. also i had to use setwarnings false before using the command so access wouldn't bring up...

never mind it works! had a bad reference - removed it and it works fine... my bad! hehe

Hi there, does anyone know hot use the Chr function to format strings?? i've used it just like the help says and it wont work - i need to use a carrige return chr(13) - but every time i use it i get an error stating that the project or library cannot be found - yet if i check the references its...

Thats great! thanks, it did work but i had to use the value option of the tab control not the page index ie - tabcontrolname.value and not tabcontrolname.page THANKS!

Hi there, i have 4 pages on a tab control and one command button - i would like that command button to print the report that coressponds to each of the tabs....therefore i need to check which tab is selected before i can print the report....is there anyways to find out which control tab is...

I'd like to know how i can print a report but by using the printer dialogue box. how can i bring it up and let the box control how many reports are printed, and where its being printed..... i know of the docmd.runcommand accmdprint option brings up the dialgue box but how to i use it with a...

great! thanks

thanks for the input, i thought i was doing that? the 1st with statement is the parent and the 2nd with is the child - i've updated my code to place the primary index # from the first table into the foreign index field of the 2nd table Set db = CurrentDb() Set rstcaldata =...

you might be able to get away with taking out the delimiters - apostrophes - being a number it doesnt need them. however if the field the number is in (in the table) is a string it would need them. also it might have to be converted from an number to a string before the sql statement can be...

i'm curious if it is possible to save the information in a subform which is in a datasheet format....i'd like to save it programatically and not thru linking the subform to the main form - is this possible?? thanks, Topher

Hi, im kinda new with record sets and i hope you can help me out with this. i have a form with multiple text boxes - i want to take the info from the different text boxes and place them into different tables.... ie txtbox1 info goes to table 1 and txtbox2 info goes to table2 the problem is...