I have made 3 queries..the first one makes a table (HLPFILENEW) from an existing table (HLPFILE) where certain values are null...the 2nd query append records from the same existing table (HLPFILE) to my new made table (HLPFILENEW) with different criteria...the 3 query selects records from my (HLPFILENEW) for my reports...this is the code i have for the button..
dim stDocName As String
DoCmd.SetWarnings False
DoCmd.OpenQuery "OPENMYUNASGN1Q", acViewNormal, acEdit
DoCmd.OpenQuery "OPENMYUNASGN2Q", acViewNormal, acEdit
DoCmd.OpenQuery "OPENMYUNASGN3Q", acViewNormal, acEdit
DoCmd.Close acQuery, "OPENMYUNASGN3Q", acSaveYes
stDocName = "HLPCALLS_OPEN_MYTECHS"
DoCmd.OpenReport stDocName, acPreview
DoCmd.SetWarnings True
the thing is I have alot of users running this sometimes at the same time..I need to do these query's in vb code so it creates temp files for that person running it without inteferrring with each other...I don't know if I use qrydefs or tbldefs or how to do each one of these right after the other ...please help...
dim stDocName As String
DoCmd.SetWarnings False
DoCmd.OpenQuery "OPENMYUNASGN1Q", acViewNormal, acEdit
DoCmd.OpenQuery "OPENMYUNASGN2Q", acViewNormal, acEdit
DoCmd.OpenQuery "OPENMYUNASGN3Q", acViewNormal, acEdit
DoCmd.Close acQuery, "OPENMYUNASGN3Q", acSaveYes
stDocName = "HLPCALLS_OPEN_MYTECHS"
DoCmd.OpenReport stDocName, acPreview
DoCmd.SetWarnings True
the thing is I have alot of users running this sometimes at the same time..I need to do these query's in vb code so it creates temp files for that person running it without inteferrring with each other...I don't know if I use qrydefs or tbldefs or how to do each one of these right after the other ...please help...