Search results for query: *

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

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

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?

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

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

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

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

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

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

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?

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

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

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.

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.

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

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?

i've never used them before.

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

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

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