Search results for query: *

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

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

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

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

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

I have a pivot table that currently has 3 columns (among others): (1) Hours (as a sum), (2) Hours (as % of total), and (3) total $ amount. In each row of the pivot table, I'd like to be able to multiply the percentage calculated for the hours as % of total by the total $ amount, but can't seem...

I have a form where I need to use VBA to reset an unbound text box to its default value after the info in the form has been processed. I've tried statements like "Me.txtField=Me.txtField.DefaultValue", but I get the literal value of what's in the default value field. For example, in a year...

Seems like a very basic question, but how do you set up MS Access to print multi-wide labels? I have a Zebra printer with 4-inch-wide print head - labels are 1 inch wide by 10 inches long, so 4 labels are printed at a time. I want the text to print "sideways" (so that printing goes from top to...

Is there any way in MS Access to link to an Excel file in such a way that you can update the data in the Excel file from the Access database? Thanks. Walt

I have an Excel macro that works perfectly on two PCs but not on a third PC. All three PCs have Windows XP and MS Office 2003 installed, and all three use the identical macros and identical Excel files. What are the possible causes for the macro not to work on the third PC? Are there any...

Is there a simple tool for documenting what tables & queries are used by forms, sub-forms, reports, etc - without having to go through the forms one by one? In particular it would be nice to easily identify all the forms, reports, etc in which a particular query/table is used. Thanks for any...

I have a simple form that contains a couple text boxes and a command button. The command button, when clicked, runs VBA code that imports data into the Access database from a series of Excel files. One of the text boxes on the form is supposed to be a status display - it shows the name of the...

I've encountered two problems when using the "Import Spreadsheet Wizard" in MS Access 2003 to import Excel spreadsheets: 1) When I get to the screen that shows the fields and sample data, I can't change the "Data Type" in the "Field Options" area at the top. There are times I'd like to change...

Using VBA in MS Access 2003, how would I go about changing the criteria for a single field in an existing query? This process would be initiated by a click event on a form. Thanks for any help offered! Walt

In Excel, is there any way to customize data validation for one cell based on the data entered in another? For example, if I enter "AAA" in cell A1, I want one set of data validation choices for cell A2, but if I enter "BBB" in cell A1, I want a different set of data validation choices for A2...

Is there any simple way to set up an Access form and subform(s) so that the subform displays records in more than one column? It's a standard form-subform setup - when a field is changed in the form, corresponding records from a linked table are displayed. Since there are only a couple of...