Search results

Thank you very much. We are using Windows 2003 Server. I'll talk to our Network Admin and see whether that can be handled by the server.

Is there a way (code or otherwise) that one can prevent unauthorised users from deleting my database from the hard disk?

I’m in need of help here. I’ve applied for a job and have almost got the appointment. But my prospective employer is asking that I present them with LETTER OF COMPLETION for each and every project I have undertaken. I’ve approached my past clients and they are willing to give me these if only I...

I want to add some security to my application and I was just wondering if this is possible with Access. Is there a way one can ask an Access application to Save All and Quit if the cursor is not moved and no key is pressed for a specific period, say 30 minutes? You see, my users deal in very...

Meltdown, you've been very helpful. THANK YOU VERY MUCH. The article you directed me to was just too apt. THANKS.

I am not sure where to post this question. Please help. I have a form on my application which has gone bad. Any time I tried loading it, I get the following error message. “ERROR ACCESING FILE. NETWORK CONNECTION MAY HAVE BEEN LOST.” I also get the same message when I tried accessing its code...

Please help! I am stock here. I am developing a Payroll System for my office. I am looking for a VBA code to calculate the Interest on a loan using the Reducing Balance technique. It should be such that all we need to do is supply the Principal, Interest and Duration in months (even if the...

You see I have to develop the whole application in Access (company rules!). And I have seen an Access app. doing just that but that was years back and there's no way I can contact the author now. I need another suggestion please.

Can someone out there help me? I’m developing a Payroll System for my office and I would like to use a table to capture the PAYE tax structure (for employees) so that I won’t have to go into the codes/queries to effect changes whenever the tax changes. Of course, the tax changes almost every...

Worked perfect. Thanks.

Please help. Does anyone out there know how to subtract 1 hour (60 minutes) from the current system date and time and give the result in the same format using VBA? What I have in mind is using the Now function in VBA to retrieve the current system date and time, subtract 60 minutes from it, and...

You guys never cease to amase me with how well you can handle VBA. Great!

Thanks a million! Just what I wanted. It worked perfect!!!

Is there a way to code in VBA so that on reaching a particular line of code, the application will wait for a specified duration, say 45 seconds, before moving to execute the next line of code. Quite desperate here! Please help.

How do I format a date which displays both date and time to show only the date and discard the time? That is, a date like 14/11/02 12:45 should only show 14/11/02. Thanks!

Finally got it to work. The problem was that to use the FOR command in a batch program, one must specify the %%variable instead of a %variable. So my final .bat file was as follows: ************************************** C: cd\ cd Bam for %%1 in (*.doc) do type %%1 >> Kotor.txt Exit...

Yes, I use this MS DOs command to my liking in DOS but can't get it to work in a bat file. I tried double-clicking it and then running it from the Start/Run... button but stll no luck. So I figured maybe I didn't write the bat file correct.

Sorry if didn't make myself clear but what I really wanted to know is how the .bat file will look like. This is what i wrote and saved as a bat file but didn't seem to work. ************************************** C: cd Bam for %1 in (*.doc) do type %1 >> Kotor.txt Exit...

I use the following MS DOS command to convert, append and rename all .t files in the C:\Bam folder to a .txt file named Kotor.txt It works perfectly. C:\Bam> for %1 in (*.t) do type %1 >> Kotor.txt My problem now is to create a .bat file that will do precisely this. That is, on calling the...

Tim K, thanks very much for the effort but I'm still having problems with it. I wrote the code as you did. In fact, I just pasted it and called it from a click event. But it didn't copy any files and it gave no error message either. Indeed, there are files in these folders which were created a...