Search results for query: *

Thanks for the help guys. Will try the above and test it out Blackcat9000

Hi there alvechurchdata Thanks for your response. What I am looking for is some kind of time setting in order to automatically transfer the data to another location overnight - Do you know a way to do this? Again, thanks in advance Blackcat9000

Greeting bro's. Is there a way to automatically backup an access database to a different location by a specific time? Thanks in advance. Blackcat9000

Hi folks, I am a little new at this so hope you can help with this one. Basically, I want to store a backup of a database to a different location on the server at the end of each day. Can this be done by setting a specific time to start back-up proceedures during the night or are there better...

It sure does. Thanks for that. that was a great help.

being a bit of a novice simon, can you put it into a example. thanks in advance

Hi yer bro's. My problem is i am trying to produce results based on a selection. Now it brings up the first page of the results ok, but if there are more that one page of results and i proceed to see further pages I seem to lose the recordset connection and it brings me back to my main menu...

Sorry for not replying sooner guys. It seems I did have my logics a little mixed up after all. Thanks for showing the error of my ways as it now works perfectly. Thanks again for the help.

Hi yer folks. I have a form to showing a list of people who have paid membership fees for a year by having a value in the fees checkbox. I am trying to provide a IIf statement or criteria to say if the year the fee was paid is not equal to the current year then change the fees checkbox value...

Thanks. that's exactly what i needed.

Hi there folks, I have another problem. The formula below works out the week based on the date you put in Me![scrweek] = Format(Date, "ww") The problem is that say the date entered is 03/02/2004 (UK Format) the week result will show 6. I want it to show 06. Can anyone...

Many thanks for that tip bro. That work a treat.

Can anyone help me with this problem. When you used the autonumber function the numbers will start 1,2,3 etc. How do I create an autonumber so it starts 01, 02, 03 Thanks in advance

Thanks for that Vic. That worked great. Your the man. Blackcat9000

I want to show the week number when i enter a particular date. i.e 23/02/2003 = week 9. Can anyone help?