Search results

  1. A

    Button text alignment

    I am using big buttons on my forms and have a lot of text to say what the button does. The text is doggedly centre aligned. Is there a way to left align it? Thanks in advance Tony
  2. A

    Single vs multiple instances of Access

    I want to swap between any one of four Access databases on my system. I can do this with buttons on a form using "call shell" etc. Is there a way of restricting Access to only a single occurrence, rather than Access opening each time in a new window. I know I can do it from the file menu and...
  3. A

    Closing a DOS window

    Hi all I have a button on my Form which On Click runs an Event Procedure which among other things has a "Call Shell" instruction to run PKpak. PKpak is a DOS program and runs in a DOS window. PKpak then zips up several tables which have just been exported as dbase3 files. (I am using PKpak so...
  4. A

    Run VBA code from Switchboard

    Beginner needs help again. I have written some vba code to do some external file handling and attached it to a button on a form. This all works fine. However I really need to run this code from a button on my switchboard. I think I need to convert it somehow so I can use the "run code" option on...
  5. A

    msdos file operations

    I need to be able to import a table (dbase3) from a floppy disc to update a table in Access. To do this I would like to do the following file operations using a macro. 1) check for presence of the file on the floppy (a:\Tillsale.dbf). 2) Import the floppy to Access then update the Access table...
  6. A

    Code for Append and Delete

    In my Stock Control projectI have a table called Master and a table called Removed. From a Form based on Master, I want a button to move the current record from Master to Removed, i.e when the button is pressed the current record from Master is appended to Removed and then deleted from Master...
  7. A

    Button to change value in a field

    I have a form to show values in from a table called Master. One of the fields in the table is called TSmin and contains integer values. I need to attach a macro or something to a button so that when I push the button TSmin increases by 1. Sorry to be a Newbie here. All help welcome. Tony
  8. A

    Filter data in a Report

    I have constructed a Query form to edit two tables. The main table is a list of items in shipments received from many different suppliers and each shipment received is given a login number. In the Query form I do a Find and Filter by Selection to restrict the data to a particular Log number. I...
  9. A

    Address Labels

    Well, not really address labels, but similar. I own a shop and all my products are on a database. At present I use Lotus Approach to print out display tickets showing description of item, price etc. These print out like address labels, e.g. 3 labels across the page & then down etc. I am...
Top Bottom