Search results

I have a spreadsheet with an External Data link to another spreadsheet, but the refresh behaves differently on some computers in the office. 1. On some, when you refresh the data, it runs a background refresh and returns the data – great :) 2. On others, when refreshing, it automatically opens...

Is there a way to detect if a user has chosen to refresh a pivottable? Ideally looking for something like a Before_Refresh Event. Trying to get some VBA to modify the connection string before the pivottable refreshes the data. [I don't need to know how to refresh a pivottable using a VBA.]...

I have a Word document that has links to multiple named ranges in a single Excel file. This all works fine and refreshes okay. However, if I wish to link the Word doc to a new Excel file (for instance, a new months worth of data) I have to manually tell Word to relink each link separately even...

Does anyone know if it's possible to determine whether a cell is currently displayed on the visiblle part of users screen?

I have a database that manipulates data in an Excel workbook. Everything works okay, unless Excel is 'busy', for instance if a user has left up an open file dialog window and then everything hangs. Is it possible to identify if objExcel is 'busy' so that the user can be asked to rectify the...

I've been trying to improve a databases performance when run across a network and have identified the following that is causing part of the under-performance issue. This code extracts field properties from one table in the BE and adds the data to a new table in the FE (no comments re bloating...

Experiencing problems with the On GotFocus event. I have a form with an event procedure assigned to the On GotFocus event of the form itself. However, when the form receives focus (after returning from another form) the event is not triggered! Any ideas?

Hi I've created the coding required to create a new table, but I also need to set the 'Required' parameter to 'Yes' on some selected fields. Is is possible to do this whilst creating the table with the 'CREATE TABLE...' statement or is there another way of programatically setting the...

Hi, I've been using array formulae (formulae entered with [Ctrl]+[Shift]+[Enter]) for many years now, but can not work out how to get them to work (in just one formulae) if the value you wish to compare the array to is not a single value. For instance, if I wish to sum the value of 'Dog' from...

Hope this is the right forum - seems to be a web problem rather than an Excel problem. I have an Excel file (file A) that links to data from another Excel file (file B) contained on a web-server. The data in file B is updated weekly and usually I have no problem with updating the linked data...

Does anyone know what a QueryDef Type of 3 is? If I run the following code, as well as returning all queries in the db, it also returns a few that are of Type=3. For Each qd In db.QueryDefs Debug.Print qd.Name & " - " & qd.Type Next For the Type 3 ones, the qd.Name returns something like...

I've got an Access frontend that I need to connect through to a SQL db (using SQL authentication). However, I wish to make these links read-only to prevent accidential changes to the data. I can't seem to find a way to do this using the normal link table option and can only assume it has to be...

Can anyone provide a comprehensive list of problems associated with running Access97 alongside the rest of an Office2000 installation (note, Access2000 has not been installed). I've heard (from numerous sources) that running this configuration can cause normally working Access97 databases to...

I'm using the following lines to output a series of reports to rtf format files. While Not rs1.EOF DoCmd.OutputTo acOutputReport, rs1!rname, acFormatRTF, strPath & rs1!rname & ".doc" rs1.MoveNext Wend This works fine. :) However, when I distribute the db with the database window...

Not sure where to start with this, but I'm sure it's possible. I've got a db that creates output into a new Excel workbook (that works fine). But now I want to add some code automatically into the ThisWorkbook module of the Excel workbook. How do I get Access to add VB code to an Excel...

You can set various custom Database Properties (under the File menu), but is it possible to interrogate these using VBA? For instance, if I were to set a custom property called "IssueNo", how could I find the value that had been set for this property via code?

Are there any VBA gurus that could answer this? http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=38400

I thought I had the security issue sorted! This is what I've got. Backend - located in hidden directory, database password protected, shift disabled, shortcut keys disabled. Frontend - distributed as MDE, shift disabled, shortcut keys disabled, database window hidden etc. To prevent...

Here's the scenario: I have a routine in Access that outputs a series of reports as .rtf files into a directory on a network. It then changes all of the file attributes of these files to read-only. This is successful in preventing users from changing the reports, but this doesn't prevent them...

Is it possible to detect if a table is locked (i.e. a query, report or form using a table is open). I'm trying to automatically delete selected tables on a periodic basis, but the code falls over if the table is currently in use. How can I trap for this so the delete line can be skipped?