Search results for query: *

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...

We have a MS Access form that contains some sub-form objects. We do NOT want to allow edits in this form once a record is entered - when we set "Allow Edits" on the form to No, it works fine for all objects except for sub-forms. Is there some way we can set it up so no edits are allowed on a...

Thanks, Skip. When I concatenate the series and point names, I'm back to having a "series" for every series-point combination, and no common data markers for what I'm calling a series. So I must be missing something - can you fill me in? Also, Excel seems to be automatically setting the...

Thanks so much for the help, Skip. The code you provided sort-of works - some of the points display labels fine, some of them get errors, and some of them display the wrong label. I just did a quick test, so perhaps I didn't plot the data the same way you did, or perhaps I missed something in...

Thanks for wanting to help, Skip. Here's the sample data I'm using to try to make this work: Series name Point name X-coord Y-coord Friday FriName1 37 39 Friday FriName2 89 44 Friday FriName3 64 12 Monday MonName1 55 51 Monday MonName2 23 30 Monday...

I have a table in Excel with 4 columns: (A) Series, (B) Item, (C) x-coordinate, (D) y-coordinate. There are multiple Items (and data points with the specified x-y coordinates) within each Series. I want to create a x-y scatter-chart in Excel that plots each row in the table using the SAME...