Recent content by WaltW

After a little more testing, it appears to give the error messages only when the form is in Datasheet format. The exact same VBA code works fine if the form is in normal "Single Form" mode. Any suggestions would be very much appreciated! Thanks, Walt

I'm working on a form in an Access 2007 database. I'm using the BeforeUpdate event to validate the data entered into several fields in the form. In every case, no matter how simple the data check, an error message is displayed - generally either "Property not found" or "No current record" -...

Hopefully a simple question ... our company has an Access 2007 database on a server that is used by several people. I can tell someone's using the database when I see that a .laccdb file has been created. But is there a simple way to identify WHO is using the database? Thanks! -Walt

All of a sudden, when I do a Compact & Repair on any of my Access 2007 databases, it doesn't reduce the size at all, even when it should. I've even gone so far as to remove all tables in a db, and the size of the .accdb file remains the same after Compact & Repair. This function used to work...

Found my "problem" (if you can call it that). The "Show Formulas" option was selected ... now I feel dumb. Sorry! -Walt

Thanks Skip. I had already tried that - first it was formatted as Number, then I tried General, and Text, and none of it made any difference. I'm stumped! -Walt

I have an Excel sheet that doesn't recognize the = sign as a formula. For example, I type "=SUM(B1:B12)" into the cell, and instead of the sum of cells B1 thru B12, I get the text "=SUM(B1:B12)" displayed in the cell. Same for any other formula. How do I get this Excel sheet to start...

Thanks very much for the responses. I had it coded pretty much like Remou suggested - turns out I had an ActiveX library as an active reference in the database that made things behave really screwy. Removing the ActiveX library reference cleared everything up.

I'm using Access 2007, and I have VBA code in a form that creates a new table. For one of the fields in the table, I want it defined as Double, Fixed, with 2 decimal places. Default when the field is created is Double with Auto decimal places. In the Access help, it says that after you create...

Sometimes I'll open a table in Access in datasheet mode, and manually update the same field in that table in multiple records. Whenever Access detects a "sequence" to the data I'm entering from one record to the next, it automatically fills in the next record with the next value in the...

Thank you, John. Haven't had time to work on this again, but what you posted here definitely clears up some of my confusion and gives me a good direction to go in. Thanks for the help and your time. -Walt

Thanks for the tips, Skip. I'm sure you're right that the main issue for me is I'm unfamiliar with the OFFSET and MATCH functions. So I'll check out those functions more closely and get it figured out. Thanks very much for your time and help. Thanks to John too. -Walt

Sorry for being so dense, but it's still not clear to me. A better analogy for my data goes something like this: Car Chevrolet Impala Car Chevrolet Malibu Car Dodge Challenger Car Dodge Charger Car Dodge Viper Minivan Chevrolet Uplander Minivan Dodge Grand Caravan The way I understand it...

Thanks for these references. I've used one of them before to create dependent data validation based on a single cell, but I'm having trouble adapting it to make data validation dependent on TWO cell entries. I'd appreciate any help or direction you can give me in that area ... Thanks! -Walt

I have a sorted master list containing 3 columns that I want to use for data validation. Here's the issue I'm trying to resolve: I have three cells that need data validation - in Cell 1, any valid entry from column A can be selected. The entry in Cell 2 is then restricted by what's entered in...