Search results for query: *

Help, if anybody can!..please. I was trying to install a DVD from an Open University course last night. However it failed to install. This was traced to XP (Pro SP2) 'seeing' long filenames on the DVD as 8dot3 DOS format. This occurred even when copied to the hard drive (NTFS formatted). I...

I have a vb6 (sp2) program that uses several ActiveX controls and components. It runs fine on XP and win 2K but after installing on Win 2003 server, 2 parts of the programme (responding to click events) cause the error "Run time erro 429 - ActiveX components can't creat error". I have installed...

Can anyone help me do this as I've not deployed to 2003 before. My application (VB6) will deploy fine to XP on several PC but I need it on the server to enable Citrix access accross our network. Uses Access 2000, Excel 97 and data environment references with Jet 4.0 OLE and DataControl and MSH...

We are experiencing the problem as descibed in the Microsoft article. There appears to be a fix for the problem but it is no longer available from Microsoft, so I'm told. Does any body have it so that we can apply to systems still running Excel 97. -There are technical reasons why we do not...

Apologies for such a basic question but I'm right at the bottom of the learnuing curve... If I creat a user function to return a varchar representing thre financial year (eg. "2006/2007") from a passed in parameter (date column from a record) how can I debug to find where the function is...

I have at least two databases (SQL and Access'97) and I'm trying to define a model to map the changes required to enable the new source tables to be used when the Access tables are replaced by (similar) SQL tables and Views. i.e. a diagram that will show similarities/differences and and have...

With Outlook 2003 is it possible to automatically print an attachment to the default printer (assuming the attachment's application is on the recipient pc), possibly via a rule or a bit of code?. The attachments most probably will be an excel or word document with no macros/code attached and...

In access 2000 running a query to make a table in another database (access 97) intermittantly fails to run to completion and hangs. Both dbs are in the same folder on a drive. Any clues as to why? Could it be a compatability issue? TIA Alex

A small program to monitor links between two databases ans stores status results in a table. Works fine as code from within Access 97. When I try to run the code after opening the database as an access application object an error message that the action was cancelled by the user appears "Run...

There are several threads with content on a simlar theme of how to increase performance, Does anyone have any ground rules or guidance? Such question as the following might arise: It is presumable quicker generally to work on a PC's hard drive than work accross a network with the same PC? Is...

Any method or code to solve this problem appreciated. From large tables we are dislaying filtered records on a form which shows the records corresponding to a users selection - which must be a common activity for a dbase?. We wish to take VBA code action depending on the number of records...

Tearing hair out time again! This problem is in Excel 97 and vba code With a workbook linked to several data sources that change values i have graphs. Despite setting them not to do so (chart formats) they seem to resize. So I've put the control of formatting in code to set all chartobjects to...

AlexmacG (TechnicalUser) Aug 12, 2004 Excel 97. Cross posted from Excel forum. I've a rather complicated series of linked workbooks/sheets and graphs show incorrect data values even though the source data series show the correct data 'bracketed', with the correct values such as 300, 400 500...

Excel 97. I've a rather complicated series of linked workbooks/sheets and graphs show incorrect data values even though the source data series show the correct data 'bracketed', with the correct values such as 300, 400 500, but the chart column (stacked)individual values are incorrect e.g...

I think this should be easy but my brain forgets too easily !! Office 97 by the way. I have several cells and chart objects from workbooks linked (together) into one word document. Code in one of the excel sheets does some manipulation on the underlying data. I wish to update the links (if...

Having saved email for some years to a personal folder I now find that there is a 2Gb limit (I'm told) and outlook will no longer open once that size is reached. Any ideas how to recover or even split into smaler files? other than just cut the file size losing unknown emails.... TIA Alex

I hope someone can help with this please! I have several workbooks that have charts definerd by classes in VBA. They pick up data from the same sheet that they are displayed in. When I switch on Track changes the graphs (mixture od line and colums) stop updating and the lines become disjointed...

I have a VBA function that is used in a query. The function is self validating using data entered on a form. When validation fails I inform the user or take appropriate action. This all works fine from code but if a user runs the query [e.g. from the query design mode], if there is a...

I have tried the link to faroukmusa as advised by a response to a previous thread "Visio Database Table Linking & Dynamic Updating" and can now reverse engineer a database in a few minutes! I'm impressed as it would have taken me a day to analyse and draw. Does anyone know how to automatically...

Excel '97. Can VBA code in one workbook turn on Track Changes in another workbook and if so how, please?