Search results

First let me say that while I’ve been writing code for 30 years, my understanding of the mechanics of computers is just what I’ve picked up, here and there. I usually leave that kind of stuff to the techies. Have a home setup with two ‘stationary’ laptops running on WIFI with a standard setup...

When a record is accessed, the first time any bound control on a bound form has data entered/edited, the form becomes Dirty and the OnDirty event is executed. Sounds simple, but this is Access, so naturally it isn't! This occurs only the first time! If the same control has data entered a second...

Was writing a little routine for someone who needed, with a datasheet or continuous form, to have FieldTwo's back color change when FieldOne has focus. I added a boolean field, FFlag, and set it with the following code: Private Sub FieldOne_GotFocus() Me.FFlag = -1 End Sub Private Sub...

Important notice from Micro$oft's Knowledge Base: When you open or are using a Microsoft Office Access database on a computer that is running Windows Vista, you may encounter one or more of the following issues: • Access appears to stop responding. • Access responds very slowly. • Access exits...

This is kind of unusual, but since it's about a potentially really bad thing I thought I'd put it here. A poster on another forum took the Access 2007 online "testdrive" today and since has not been able to open up any of her Access 2003 databases. The real kicker is that M$ offered the online...

I've got a field in a table formatted as a Short Date. How to I set the Default Value to the Short Date designation for the current date? I've tried several differrent things and keep getting a "type mismatch" error. Thanks The Missinglinq

This is driving me nuts. I recently had to replace my hard drive. When I started working on my db I encontered problems (not exactly unexpected). Background: When I "delete" a patient record it's not actually deleted, but rather has a checkbox called IsInactive that is selected on "deletion"...

I just finished doing an Access2000 to Access97 "previous version" conversion for a posting from Mincher earlier today. The conversion was a snap, taking only a couple of minutes for the whole thing, and appeared to work post-conversion (although I don't have an Access97 environment to really...