Recent content by Accessme2

I need to print a report, This report is print on three different color paper(Yellow, pink and white) so I need to print the first page 3 time the the second page 3 time and so on what ever the pages are. I was able to do it if I preview the report select the printer and tell it hoe many copies...

HI everyone, I have a form where I use a calendar on the corner of the screen some forms I am using the pop up calendar to populate dates. My problems is that I have some users that have office 2000 and some using 2002. I am one of them that uses 2002 when I work on my application I save the...

Okay I just notice it that everyone gets an import error table data convertion on that field. how can I not get that error same data.??

Hi everyone, I am having some problems and I am not having any luck solving it. here it is: I am using MS access 2002(XP) and some user are using access 2000. When I run a process that import a xls into an access table and one field(text) containg "**" two asterisk, it imports just find on...

THAT IS IT!!!! Thank you Kryst51 you are the best!

HI. Ii have autoexpand= Yes. what this autoexpand do. I would like to when I go the the field to display the list even before I type anything or even if they click the first letter to see the list without have to click on the arrow

Hi everyone, I wonder if there is a way to when On got focus event that the drop down list would display automatically. right now when they start typing the fills automatically but they need to click on the arrow to display all options. Is there a way to display the list automatically? Thanks...

Great samples... it work for me.. thank SOS I really Appreciated till next time

Hi everyone, I have a question, I have a couple of forms for each form I have a button that would run a report. this report looks at a field on those order. So the way I do this I have 3 report with 3 queries. It must be a way to use the same report not matter on what form I am. right? Any...

SOS thank you very much .oldvalue ahgggg need to hit the books. I really appreciate the help..

but how can I click on a text box that have already a qty like 2 and if I go back and I enter 5 i want to display 7 on the same text box. so lets said I have only one text box that i want to enter a number and I want to add it to the number that is already there.

I have a textbox that is use to enter a qty of items that has been completed there are three other text boxes ; the qty needed, the qty still needed and the last one that calculate if there were more items made. My question is, on the one that I use to put how many items are been made; I want...

I just want to show on the main form the grand total by adding the subtotals of each subfrom, but like i said sometimes some of the subforms have no data so I couldn't add the total because of the #error. But the function works great..! Thanks guys I really appreciate the help.

Hi everyone, I am using Access 2002, windows XP Sp3 I have a question.. I have a form with 4 subforms... depends what is on the main form some of the subforms would be empty. so I need to add the totals on each subform but when some of the subforms are empty I get and #error... How can I check...

make sure you change the name of the textbox. if you have the name and Control Source with the same name you would get and error.