Search results

  1. I

    Combo Box update Text Box

    Hi, I need help getting a text box to update when I change the value of a combo box. I currently have a table called 'PURCHASE_SERIALS' which will be used to store the serials of purchase order items. It has two fields, 'PURCHASE_ORDER' & 'SERIAL NUMBERS'. I have created a very simply form that...
  2. I

    Open excel file within same directory as access database

    Hi, I have an access database and an excel 2003 (.xls) file in the same folder. I want a button on the access database switchboard to open the excel file, but it wants a full file path. Due to certain circumstances this path may be subject to change, and I don't know how to refer to an external...
  3. I

    Sendobject to addresses in a query

    Hi, I'm designing a database for a computer shop and one of the features is a report showing all the customer information. I put a button up the top of the report labelled 'Mass Mailout' and want it to send an email to every address listed. I created a query of just email addresses with the...
  4. I

    Help with a filter

    Hi, I'm currently creating a database solution for a computer shop. Basically, I'm having issues with a filter I'm using so that a user can easily 'jump' to a certain record based on the ID (primary key). My issue is that I can enter an ID into the search field, press the 'Apply Filter' button...
  5. I

    OutputTo help

    Solved: OutputTo help Hi, I'm trying to make a little vba script that will export 'Repairs_tbl' to an excel file elsewhere in case the database decides to explode. My working code is featured here: Private Sub Command0_Click() BackupDir = InputBox("Enter the directory for the backup to be...
Back
Top Bottom