Printer Brother MFC8220 drivers just updated
OS Vista
Access 2002
Other apps from Office 2002 (word,...) can print Mutliple copies
Printer only outputs 1 copy even if Copies in Print... window is set to 2 or 3.
Anybody have a tip for me?
Thanks!!
I have 4-5 queries I'd like to run from a transfer spreadsheet macro both of which I'd like to have replaceable parts and have the macro repeat for a list of such values that are stored in a table. Is this possible?
My list is 175 values long and I don't want to create 700-900 queries. Thanks...
Anubis3000,
Thanks for your prompt reply. I am familiar with the DATEADD fcn, but my problem is that the data are numeric where today is the equivalent of 20,050,207. How do I get that into a true date format? Can I convert it to a STR then use another function? Thanks again for all your help!!
I have imported date fields that are numbers with YYYYMMDD format.
What function and what is its syntax (parameters) can I use to convert it to a date field or value?
I want to be able to add 7 and 14 days to the resulting field or value.
Asiandoll,
Thanks for the help!! Now I have to choose between it being a required field, and nulling it out, because I can't do both. Nor can I set up a validation rule. Copy goes forward but doesn't change the field.
Thanks again!!
I am not a VB jock, but have used a wizard to generate code to copy the current record. Now I have the requirement to blank out a field on the new record, and since it's a required field, the user will be prompted to consciously populate this field.
I'm looking for some simple code to pull...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.