Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
no current record?
Another more user friendly way is to add validation code to your button that saves the record. Before doing the Save, check for required fields. This example tests for Null values but you can text for whatever you want. If IsNull(Text0) Or IsNull(Text1) Then MsgBox "These are...- mcatet
- Post #3
- Forum: Microsoft: Access Other topics
-
How to Import Data Without Headers
Import the data using Access. (Get External Data). The Wizard has an option to let it know that the first row in the delimited data has field names. Check this and that record will not be imported.- mcatet
- Post #2
- Forum: Microsoft: Access Other topics
-
How to share an Access DB over a network
One thing to watch is when using Access with multiple users (even if the DB is split) you can get corruption. The more users hitting the same data the more likely it is to corrupt. A routine repair and compact of the data.mdb with help some of this.- mcatet
- Post #8
- Forum: Microsoft: Access Other topics
-
How to share an Access DB over a network
In general when sharing Access apps, it is best to split the database in data.mdb and program.mdb. Create a new DB. Import all the data tables that users will update. If there are staic tables (like a table consisting of all 50 states) that don't usually change and are used for looking up...- mcatet
- Post #7
- Forum: Microsoft: Access Other topics
-
ACCESS License Problem
This is a problem with the HATTEN.TTF file. FOr some reason, the version of this file is not compatible with Office 97. A new version is installed with later versions of Office (2000, XP). The solution: Make sure Office 97 is uninstalled. Rename the HATTEN.TTF file in the foonts folder to...- mcatet
- Post #3
- Forum: Microsoft: Access Other topics
-
Application '' failed to launch.
I installed Visual Studio 6.0. InterDev debugger worked fin. Then I installed Visual Studio.NET. Then in Studio 6.0, InterDev debugger fails. It give a message saying, "Application '' failed to launch." I know both versions of Visual Studio can be run at the same time. Anyone...- mcatet
- Thread
- Replies: 4
- Forum: Microsoft: Visual InterDev
-
VBScript Status
An HTA would be cool to display my status, but I need to update it as my app runs. How can change the hts file's content from a VBS file? Thanks, mcatet -
VBScript Status
I am creating a BAT file on steroids using VBS. It is a stand alone program not used with HTML. Basically, it is used as a way to backup files to a newtwork drive. I need a way to show progress, like a progress bar in VB. I want this to be as simple as possible. My thought was to use notpad...
