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!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: WaltW
  • Order by date
  1. WaltW

    Errors after BeforeUpdate event in form (Access 2007)

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

    Errors after BeforeUpdate event in form (Access 2007)

    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" -...
  3. WaltW

    How to tell who's using Access 2007 database?

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

    Compact & Repair doesn't compact

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

    What causes Excel not to recognize a formula?

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

    What causes Excel not to recognize a formula?

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

    What causes Excel not to recognize a formula?

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

    How to create Format and DecimalPlaces properties?

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

    How to create Format and DecimalPlaces properties?

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

    How to turn off sequential "auto fill"

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

    Dynamic data validation

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

    Dynamic data validation

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

    Dynamic data validation

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

    Dynamic data validation

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

    Dynamic data validation

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

    No-edit on form doesn't work for sub-form objects

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

    Labels on Excel xy scatter-chart data points

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

    Labels on Excel xy scatter-chart data points

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

    Labels on Excel xy scatter-chart data points

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

    Labels on Excel xy scatter-chart data points

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

Part and Inventory Search

Back
Top