Recent content by GDGarth

"To elaborate on the security issue. If the db was copied from work and taken home, he/she would not be able to used it after a period of time. It's a minor effort in securing the db. " Not to pick on you, but I think there are lots of better ways to accomplish the same thing. First of all...

When I add time, I usually convert everything to seconds, do the math, then convert it back to hours and minutes.

I understand where you're coming from. A lot of database design has to do with anticipating errors, and avoiding them. It's easy to tell people to enter the year, but if they find out they don't have to, they may take shortcuts. I created a text box called "TestDate", and put this code in the...

You can shell out and use the Net Use command: net use T: \\nt_le\temp I use this in a batch file all the time, and it works OK.

I think you'll have to rewrite your apps. Some of the cammands are similar, but the syntax is slightly different. Depending on what you're doing, you may be able to cut and paste your code, but you'll still have a lot of correcting before anything will work. I tried doing this, and ended up...

Frantik: I've had this happen a few times. What causes it, I think, is a user locks the file when they're writing to it (when they first open the database). Something happens so they don't release the file, so everybody is locked out. I end up having everybody reboot, and it works. The...

Before you try that, download a copy of Jetcomp.exe from the Microsoft website. That will fix almost every corruption problem I've come across.

=IIf([textbox1]<=95,[textbox1]+5,100)

I just change the text box format to Currency, and it displays the value as currency, rounding to two digits. This doesn't change the underlying value, so rounding isn't a factor.

If you're just putting the file into a different folder on the same drive, you can use the Name command: Name (Filename) as (Newname)

If each of the separate apps contain only one form, couldn't you just import each into your app and designate them as mdi child forms? You may have some work tidying up references, etc., but it seems like it could work......

DBName is a list box, with the record source being a table containing the database name (column 0), location (column 1), description (column 2), path (column 3), and MDW file (column 4). If you double-click a database in the list box, the database opens up. If the "Path" column is "c:", it...

I've got both split and unsplit multi-user databases on our network. Those that are split are less likely to suffer from corruption, and much easier to fix when they do crash. The unsplit databases will crash, usually inflicting damage, when a network error gives them the "disk or network...

The Jetcomp utility from Microsoft works very well - much better than the bult-in versions. Make sure to check the correct version of the Jet database (3.x or 4.x).

Here's where I got it: http://support.microsoft.com/default.aspx?kbid=273956