Search results for query: *

"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

Download a copy of "Jetcomp.exe" from the Microsoft website. It's a compact/repair utility that's a lot better than what's built into Access. That's worked for me every single time I've had the "unrecognized database format" message.

You can put a text box where you want the message, then make it visible only when you want it to be seen. You can also change the message, if you want to. For example: Text box name is "Message1" Message1.visible = True Message1.Value = "Your Text Here"

I fixed the problem, I guess...... I noticed the problem didn't happen when I opened the form from the database window - only when I opened it from my main menu form. I deleted the command button that opened the form with the problem, then recreated it exactly the same way - no problem. I...

I've got a form with a few command buttons on them that were working fine. All of a sudden, when I click one of the buttons, nothing happens (at least sometimes). The code behind one button is just "DoCmd.Close", and that doesn't even work. If I go into design view and try to look at the...

You need to either join the correct workgroup, or make your shortcut point to the correct workgroup. Here's an example of a shortcut to direct you to the correct workgroup file: "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "C:\yourdatabase.mdb" /WRKGRP "n:\new...