Replies

I’m guessing you have your Public VarName As String in the code module for a form.
Move it to a standard code module – should be ok then

oops!

yes you’re right of course – think thats whats called lack of testing.

Should have used year*12 + month which should give unique numbers

this creates a couple of dummy fields coverting date to a number and then matching on them. I’ve set it just to calc one field . Don’t know how long it might take with lots of fields on a big file .

There is a method of moving the report footer down the page discussed by Helen Feddema in Woodys Access Watch 4.01 or on Helen’s site as her Access Archon column #97

http://support.microsoft.com/search/previe…b;en-us;Q243514%5B/url%5D gives the following

Cannot delete Foldername : Access is denied. The source file may be in use.

CAUSE
This behavior occurs because the Recycle Bin does not understand mounted volumes. For example, assume that the following drive layout is in use:

C: — 1-gigabyte (GB) drive using the NTFS file system
C:Host-dir — The mount point for a separate 9-GB drive
When you try to delete a folder with the path C:Host-dirMydir, Windows Explorer interprets the folder as being on drive C and tries unsuccessfully to place it in the Recycle Bin on drive C.

RESOLUTION
To work around this issue, use either of the following methods:

When you delete the files or folders by using Windows Explorer, use the SHIFT+DELETE key combination. This bypasses the Recycle Bin.

Open a command prompt windows and use the rd /s /q command to delete the files or folders.

NOTE : Both of these methods permanently delete the data. You cannot recover the data unless you have a current backup.
*************************
I get this problem regularly but this mounted volume thing doesn’t make much sense. I just leave it and try deleting later – sometimes 5 min , sometimes after a reboot and they delete fine. Next time I’ll try shift+delete and see if that does it.

Sorry Kerry, I should really have put some explanation with the posting.

If you look at cell B10 in the period 2 worksheet it has the formula
=INDIRECT(GetPrev(A1)&”!M28″)
GetPrev is a function I developed (with help from this site if I recall) which returns the name of the previous worksheet – in this case “period 1”. Ignore the A1 the function needs a cell address any one will do. So with that value “period 1” the formula now reads
=INDIRECT(“period 1!M28”)
which brings the carrry forward value from the period 1 sheet into period 2. Take a copy of period 2 and call it period 3 and the cell formula is copied but now returns period 2 as the previous worksheet. And so on – each copy you make it returns the previous sheet but the formula stays the same.
This gives the same result as copying the sheet then manually editing the formula in each one to read period 2, period 3 etc.
In cell C1 it uses the same fornula but adds 28 to move the start date to the next 4 week period.

hope this makes it a bit easier to figure out.

indirect means what it says – it is an indirect reference to cell C via cell B. Cell B must contain the address of cell C – thats just how the function works.
In your example INDIRECT(report!e17) , the function is looking for an address in E17 and is getting $100 which it can’t resolve to an address.

this is a file I use for our flexitime system.
The fomula (+ code) for cells c1 & b10 in period2/3 might help you towards what you want

i would suggest you get down to the simplest test possible.
Go to the immediate window in VBA editor and type

?right(“abcdef”,3)

which should reply

def

if it does there is nothing wrong with Right() and you need to dig deeper as Charlotte suggested

Check out Helen feddema’s site – http://www.helenfeddema.com/access.htm%5B/url%5D

Article 97 discusses various ways of doing what you want

Well they’ve gone but still not sure what the problem was. Best guess it was a problem with the PDC as they went just after we had to reboot it. Logon scripts were definately being sync’d so can only assume it was some glitch stopping the machine list being sync’d and the reboot cured it.

thanks for your help

Thanks for your help Lief. I’ll give these a look through and let you know.

The ones I’m looking at are all servers. There may well be workstations in a similar situation but to be honest there are too many of them to check which are still active.

thanks

Thanks Lief but no go. I’ve gone round each of the BDCs + PDC and still no joy. I know they;ve sync’d cos other changes I’ve done have gone round.
Any other ideas cos I’m stumped.

there’s a freebie mind map on Son of Spy
http://www.sover.net/~whoi/Apps2.html%5B/url%5D
don’t know how good it is but might be of use