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!

Register Log in
  • Congratulations derfloh 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. rpangel

    INCREMENT THEN INSERT A FIELD INTO TABLE???

    hi everyone, i'm trying to increment a previous value in a table and then insert in the same column when the query is executed. for example: number description 6001 blah blah blah 6002 ..... <---last and largest existing value in table <END OF TABLE>...
  2. rpangel

    Multiple Inserts Query?

    will an update statement insert the new 13 services into the table even if the services never existed? example of output: Table: UserService GroupID Service 111 Execute <-- already in table 111 None <---| 111...
  3. rpangel

    Multiple Inserts Query?

    i wanted all 13 services to be inserted into each groupID (profile). i apologize if i'm confusing you but that case statement didn't look like it was doing that :o) do you know if that is the only way possible or do i have other options?
  4. rpangel

    Multiple Inserts Query?

    thanks terry, do you have any suggestions as to how i can do the same thing, but kind of flipped... for example if in the table UserService I want to insert 13 new Services in the Service field for all the GroupIDs... something like update UserService set Service = &quot;None&quot...
  5. rpangel

    Multiple Inserts Query?

    thanks, i'll try that but what if it isn't actually 1 through 5, can i have where GroupID = 1 and 4 and 9 or where GroupID in(1,4,9) or where GroupID = 1, 4, 9 which one of these do you think would work? and just to be clear: an update can work to insert &quot;None&quot; even though there was...
  6. rpangel

    Multiple Inserts Query?

    hi everyone, i was wondering if anyone knew the syntax for creating a query that will do multiple inserts. for example: in tabel UserService i want to insert the value &quot;None&quot; in the Service field of the table where the GroupIDs in the table equals 1, 2, 3, 4, and 5. if anyone has...
  7. rpangel

    Automate Queries?

    it finally works!!!! thanks for all of your help. i went into WINNT and found the GUI task scheduler which is so much easier to use and it works perfectly. it just ran my report at 9:00 am just the way i wanted it. thank you all so much for all of your help. i appreciate it very much...
  8. rpangel

    Automate Queries?

    oops,i did have one, i must have let it out when i pasted it... this is the most recent statement i've gotten so far. i'm not getting anymore &quot;invalid command&quot; statements and it's accepting it but it just isn't doing what i want it to do. maybe i'm just missing something. my task...
  9. rpangel

    Automate Queries?

    i keep getting invalid command, this is what i've typed to test and what i keep getting: C:\> AT 09:49 /every MONDAY,TUESDAY,WEDNESDAY,THURSDAY,FRIDAY &quot;C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\MSACCESS.EXE&quot; &quot;MYDB.MDB&quot; Invalid command. i also tried this just to test it to see...
  10. rpangel

    Automate Queries?

    thanks, but do you know what i should type in the command prompt for the AT command? i want the report to be created everyday at 9:30 a.m. i have the macro figured out now, i just can't seem to figure out the correct syntax for the AT command to make it do what i want above. any suggestions?
  11. rpangel

    Automate Queries?

    guess what i figured that out as well, one last question, i promise this time, ormaybe i shouldn't.... but how can i have it so that when i do the AT command to open Access, the macro automatically runs. is it enough if i just put my database name at the end of the path? will it know to find...
  12. rpangel

    Automate Queries?

    never mind, i think i figured it out with your help of course. i can't thank you enough but i have one more question. is there someway to turn the notification off so that it won't ask if i want to update or run or , etc. after each query is opened? i was hoping that it would run without...
  13. rpangel

    Automate Queries?

    the macro won't let me type anything in. i have to pick from a list and i don't see an openquery or openreport option.
  14. rpangel

    Automate Queries?

    thanks pjm, but where you have openquery1, openquery2, etc. would that be the actual names of my queries and am i supposed to type those names in under the Action column in the Macro design screen? i'm sorry if i'm being too clueless, but i've never used macros before, let alone in Access.
  15. rpangel

    Automate Queries?

    well i have 5 different queries that i want to run in Access. the first four do all the updating and computing and the last query selects the values that i use to create the report. is there something i would have to do in Access to run the queries in a specific order? like a macro? and if so...
  16. rpangel

    Automate Queries?

    i don't know if i'm just not looking in the right place but i looked in the control panel for Scheduled Tasks but i still cannot find it. i'm on an NT workstation, could it be possible that it isn't installed on my computer?
  17. rpangel

    Automate Queries?

    i've never used them before.
  18. rpangel

    Automate Queries?

    thanks, but where is the &quot;task scheduler&quot; or &quot;The Automatic Scheduler&quot; located?
  19. rpangel

    Automate Queries?

    hello everyone, i was wondering if anyone knew if it is possible to automate queries in MS Access to run daily and create a report? thanks in advance, angel
  20. rpangel

    Calculate Dates

    THANK YOU, You were right all along. I appreciate the help.

Part and Inventory Search

Back
Top