Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Abi1
  • Content: Threads
  • Order by date
  1. Abi1

    Runtime error 1004: Pastespecial method of range class failed

    Hi, I keep getting the above error message when pasting values. What am I doing wrong? The exact situation is that I'm trying to copy individual rows of data from one workbook to another. The code looks at the source workbook, records each team number in the variable import_team (Dim as...
  2. Abi1

    Not working: ActiveWindow.WindowState = xlMaximized

    I've got an on-open macro in my Excel workbook which is supposed to maximise Excel and maximise the workbook within Excel. Should be simple enough. My code is: Application.WindowState = xlMaximized ActiveWindow.WindowState = xlMaximized Excel maximises itself ok, but the workbook...
  3. Abi1

    Cross-Hairs on Excel Chart?

    Has anyone managed to add cross-hairs to an Excel chart? I mean full-sized cross-hairs that move with the mouse, not just turning the mousepointer into a cross. Thanks Abi
  4. Abi1

    Upgraded to Internet Explorer 5.5, Now my Ipaq Can't Sync Avantgo

    I'm using a Compaq Ipaq. I've just upgraded in Internet Explorer 5.5 (another program upgrade forced me to), and Avant-go sync hasn't worked since. The ActiveSync works for files, Inbox, etc, but not for Avantgo. Has anyone else experienced this, and found a solution? Thanks, Abi
  5. Abi1

    A Macro as a Before-Close Event

    How do you set a macro to run every time a database is closed? Is there a Beforeclose event as in Excel VB? Help would be much appreciated Thanks, Abi
  6. Abi1

    Getting a shared database to always open as exclusive

    My database is on a shared drive, and I need to ensure that only one person can use it at at time. There is an /excl switch I am supposed to be able to put in the command line, but it doesn't seem to make any difference. Is there a database property I can alter so that it always opens as...
  7. Abi1

    An IIf Statement as criteria for query: select all?

    I'm trying to write a query that selects according to details on a form. For one field, I want to be able to select the field value (from a combo) or select all. I'm put a check box for selecting all. How do I write a query whose criteria are: If the checkbox is ticked, select everything in...
  8. Abi1

    Linked forms: I can't add records to the subform

    I have two linked forms - one is launched from a button in the first. The forms are based on two tables which are linked in a one-to-many relationship. When the second form is launched, it displays filtered information based on the primary key number of record that was being used (I got the VBA...

Part and Inventory Search

Back
Top