Search:

Type: Posts; User: Bat17; Keyword(s):

Page 1 of 16 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    0
    Views
    266

    Unable to logout ((XP Home (SP1))

    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...
  2. Replies
    6
    Views
    2,411

    Re: Can't Uninstall AOL--ANY VERSION (WinXP Home)

    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...
  3. Replies
    4
    Views
    474

    folder sercurity (Windows XP home SP1)

    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...
  4. Replies
    2
    Views
    331

    Re: Drive Image after partitioning

    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...
  5. Replies
    2
    Views
    331

    Drive Image after partitioning

    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...
  6. Re: Copycat--Clipboard For More Than One Computer

    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
  7. Replies
    5
    Views
    387

    Re: Where is the Macro? (office 2000)

    <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...
  8. Re: What is up with these drop down buttons? (office 2k)

    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...
  9. Replies
    2
    Views
    291

    Re: Changing Dates to Text (Excel 2000)

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

    Peter
  10. Replies
    4
    Views
    315

    Re: Offset() in Graph (XL2K)

    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...
  11. Replies
    4
    Views
    315

    Re: Offset() in Graph (XL2K)

    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...
  12. Replies
    14
    Views
    567

    Re: USING MACRO (A97)

    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...
  13. Replies
    4
    Views
    315

    Offset() in Graph (XL2K)

    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
  14. Replies
    2
    Views
    393

    Re: Transfer record set to Excel (A97, XL2K)

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

    Peter
  15. Replies
    5
    Views
    322

    Re: Change Number to Autonumber (2000/SR1)

    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...
  16. Replies
    2
    Views
    393

    Transfer record set to Excel (A97, XL2K)

    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...
  17. Replies
    5
    Views
    448

    Re: Access Report in Powerpoint (2000/SR1)

    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...
  18. Replies
    12
    Views
    641

    Re: Access Expression (Access 97)

    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
  19. Replies
    3
    Views
    383

    Re: Export Query Results to Excel (2000)

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

    Peter
  20. Thread: AI-RoboForm

    by Bat17
    Replies
    10
    Views
    705

    Re: AI-RoboForm

    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...
  21. Replies
    6
    Views
    398

    Re: Paste from Excel (2000)

    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
  22. Replies
    2
    Views
    487

    Re: Form field backgrounds (Word2000)

    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
  23. Replies
    8
    Views
    593

    Re: Date / Time calculation (2000)

    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
  24. Replies
    2
    Views
    487

    Form field backgrounds (Word2000)

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

    Peter
  25. Replies
    1
    Views
    342

    Re: 2-page Layout (2000 SP-3)

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

    HTH

    Peter
Results 1 to 25 of 398
Page 1 of 16 1 2 3 4