Search:

I have been using Tweak UI to sort out some of my security issues and I can no-longer logout of my pc. I can get the logout menu to appear but when I click logout the hard-drive light flickers to...

Have you trieyed using the set Access and defaults tool in the start bar set it to custom and tell the defualt browser to be internet explorer and change the other settings that are in there to your...

I have just brought XP home with service pack 1 and i am trying to set it up so that i can say which files to share and which to restrict to other users i have at the moment hidden the files but if...

I think that I will have to give it ago, just get nervous when I play with things like that LOL
Presumably if worst comes worst I could just reformat the Harddrive back to 1 Partition and then...

This is probably not the right Forum but I could not see which one was :-) and I know that Drive Image users visit here!

I have an elderly version of Drive Image, 4 I believe. What I need to know...

Not quite sure why I would want to copy to Clipboard in other PC's! And I am sure I would get peeved if somebody replaced what I had already put in MY clipboard!!

Peter

<P ID="edit" class=small>(Edited by Bat17 on 15-Aug-03 07:37. )</P> Edited. now I have seen your workbook see <post#=284733>post 284733</post#>


When you are in the VBA Editor make sure that...

I think that the problem is because you are using large fonts for the second sheets then only using a 55% zoom to view the sheet, these things are relative!

As for the macro, it is not code in a...

Check out the Text() function in help. I think that it is what you are after.

Peter

I am replacing a workbook that has grown up piecemeal over the years, I basically have 10 different report pages with graphs that are repeated about 8 times for different production line. It is...

Thanks Hans.

I think that you are right about it being tedious! It will probably be easier for me to maintain if I just recreate the table for the graph on the same sheet as the graph and use...

If you just want to open a specific Access database from the toolbar then create a macro using the RunApp command. You will need to give the path to your Access file as well as the path for the Data...

Is it possible to use Indirect() or OffSet() in the data Range for the source data of a graph? I have been trying but just get an error message

Many Thanks Hans. My code will now get remarkably shorter!

Peter

In Access 97 you can make a copy of your data table, delete all of the records from the original then change the data type of your ID field to Autonumber and use an Append query to replace the data...

I am using VBA in Access 97 to dump records into Excel 2K. Currently I am looping through the recordsets and placing their field data directly into cells. This seems long-winded and I was looking for...

In a similar case to this when having to generate monthly reports in PowerPoint, we used MSQuery to get the data into Excel and then linked the Excel tables/graphs into PowerPoint. This worked quite...

In a case like this wouldn't it be a good idea to store the date so that if the calculation method does change it will not try to alter an already agreed expiration date?

Peter

With the query open you can just copy all the data and paste it straight into Excel.

Peter

The bank that I bank with changed there password system from a password to a setup that asks for just 3 of the letters in random order from the password. I.E 4th, 2nd and 7th letters. I have now gone...

Using A97 and Excel2000 I have no problems copying tables from Excel to Access. It even asks if there is a header row and uses it for field names.

HTH

Peter

Thanks Hans

I can live with the grey, just thought I was missing something when I could not find how to change it. Word is not my favourite Office program!

Peter

It would probably be best if you could post a small sample spreadsheet demonstrating the problem so that someone can work it over for you to see what is happening for you.

Peter

Is it possible to change the background colour in a document form from grey to something a little more cheerful?

Peter

Check out this article at the MVPS web site to see if it covers what you need.

HTH

Peter