Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Serpno11

    Access report won't print multiple copies

    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!!
  2. Serpno11

    pass list of values into queries and macros from table

    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...
  3. Serpno11

    using date format

    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!!
  4. Serpno11

    using date format

    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.
  5. Serpno11

    Nulling a field after copy

    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!!
  6. Serpno11

    Nulling a field after copy

    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...

Part and Inventory Search

Back
Top