Search results for query: *

I am a very beginner Excel user and I need to print an excel 2003 worksheet in multi-column layout, similar to a traditional newspaper column. It has 1544 records of 3 columns "Code" "Qty" and "Desc" and I would like it to print like a newspaper column so that it will print multi-column layout...

This is a 2 question thread in regard to Excel PivotTables: Question #1: I have an Excel pivot table with an external datasource -an access 2003 table. Just a month ago I went in and made a change to the SQL Statement within Excel from the Microsoft Query screen. The pivot table has been...

I want to delete inventory records that have no qty in stock and no qty on backorder and are not present in 4 other tables (Sales Orders, Invoices, Quotes & PO's)- basically unused inventory item recs. This is the delete qry I'm trying to use, but get the error "Could not delete from specified...

This may sound elementary, but I have a simple question. I have access03. When a form or subform 'Locked' property is set to Yes, does it also prevent deleting records or do I need to address that separately? Linda in MN

Using A2003 and trying to run this update qry, but get 'Operation must use updateable query'. I know there is a way to not use a join, but not sure how. Any suggestions? UPDATE [Check Writer] INNER JOIN CheckWriterEntriesWithGLAccts ON [Check Writer].[Trans...

I have a pivot table with 16 rows at the bottom containing financial info that the user can Hide or Unhide (using buttons). The problem is, when these rows are hidden, as the user pulls page flds down into the column area, it bumps down the bottom rows that should always be visible into the...

In Access 2003, the ODBC refresh interval is set at 1500 (sec) - that is 25 minutes. That seems high to me, but I am not an expert. What are the implications of changing to a lower setting? My situation is a network shared backend mdb with a local front end mde. Linda in MN

I need to pass the user's defined date range from an access form to an Excel spreadsheet. The spreadsheet is a pivot table based on an external data source (a dynamically built Access 2003 table) Everything seems to be working properly except the dates from the access form are not getting into...

I have an Pivot Table that I need to allow user to do a "save as", but don't want them to be able to just do a "Save". I don't want any user changes/manipulations to be saved, but I do want them to be able to utilize the PT and close without saving. Is there some way that I can disable the...

I have an excel 2003 pivot table that is based on an external access 2003 table. From an access form button I open the pivot table. It does not automatically refresh the data or prompt me. However when I try to refresh it manually I get this Microsoft Excel error message: "[Microsoft][ODBC...

I am using Access 2000. Is there a way to do an append query using a wildcard character instead of having to name all the fields? I know both table structures have to match. If this could be done, it would make one less query to have to address if/when table structure changes were made. Is...

I have converted an Access 97 database (front and backend)up to 2000. There is a function to import a file that was exported from another vendor's payroll database. Importing works fine in 97 but I always get the error in 2000 "Cannot update. Database or object is read-only." THis can't be...

I have an existing table with records where the PK is a number type field and I need to change the field to autonumber type. Can this be done without renumbering the existing records, which would really be a HUGE pain because this number field (BidderID) links to records in several other...

I need to be able to do a compact and repair on demand. I know it can be done from the tools menu, but I have been asked to have it automated so user can simply click a button. But alas, code cannot be running while compacting. Is there a way to do this or am I barking up the wrong tree...

I would like to use PgUp and PgDown on a subform and have it move to the previous (pgup) or next(pgdown) record on the main form. I think I need to set the KeyPreview on the subform to Yes and set code on the subform on keydown event based on keycodes, but I keep running into an error on the...

I am using access 2000 and would like to know at what point is a table's autonumber value updated? I ask this because I have a one to many relationship between 2 tables and the autonumber is the link and in a multiuser environment I want to avoid any possibility of having duplicates due to the...

I have an Access 2000 pivot table form and I want to add a new fld or change the name of an existing field in the record source table (which is built dynamically with a make table qry), but when I do, neither the new or changed field names are reflected in Excel 2000 as available to add to the...