Thanks, I swapped that piece of code and disposed of lines 10,11,13and all's working well. Also sorted the incorrect text reference to TblOffices, but can't find where on earth I have something declared as CLOSE? I noticed that's returning uppercase when selected, I'll keep searching.
On the other matter, yes would really like to discuss... how do I go about that?
Mandy Medcraft
Last Activity: May 3 '12, 11:54 AM
Joined: Jun 22 '11
Location:
-
Thanks NeoPa
I'm very new to writing code as you've probably realised, is this looking better? The only thing in your advise that I can't get my head round is your comment on line #24 re ChDir, when I remove line ~24 the following 2 outputs go to folder\CopyPR called by the previous ChDir and not \\NPFS2\Payroll ? If I leave it in it works ok, is there something else going on here which is forcing it to revert to the default directory,...Leave a comment:
-
Hi
Thanks for your help. Fairly new to forums, so hoping all that contributed can see this reply?
I probably should have given more history, but didn't want to bore! I have several Branches on each server \\NPFS3,5,6 and Head Office on \\NPFS2. We have a P:\\ drive mapped from each server to NPFS2\\Payroll, this is the default directory for the application (I'm still using 2003 because of the custom toolbar issue)....Leave a comment:
-
Save query on the local drive before outputting .
Hi there
I have a process that outputs weekly payroll batches across the server. I want to save a copy of the batch on the User Server before outputting to the Head Office Server. Tested at home, unnetworked ChDrive and ChDir works perfectly. The Server is Windows Server 2008 R2 with SP1 and I have changed the path to use UNC, but the code fails at the first ChDir?
...Code:Function PAYROLLREP() On Error GoTo
-
Hi Nic
Thanks for your response. I've tested the values when I run the code from different row positions and get the following:
On the top subform for which runs ok
OriginalSelTop, RowsfromTop, OrigCurrentSect ionTop
Row1 1 0 1380
Row2 2 1 1680
Row3 3 2 1980
Row4 4 3 2280
But from the lower subform, which falls over
Row1 1 10 3345
...Leave a comment:
-
SelTop query
Hi
I am using Access 2003 - any help very much appreciated, I seem to be going nowhere with this!!!
I am using Stephen Lebans Seltop code to hold the cursor position after requery. I have 2 continuous subforms (Child 143 and Shifts Allocate)embedd ed into the main form (Shifts NP), the SelTop code runs ok on the Top form but always fails on the top row of the Second form (runtime error 2101)... but only if the top row...
No activity results to display
Leave a comment: