Search results

  1. C

    Vacation Calendar

    Hi, I was wondering if there was a way to make a calendar in Access 2003? I work in a group of 60 employees and we track their vacation, and personal days in a web-based application. The web-based application is going away, as it it no longer supported. Could I use Access to create a...
  2. C

    Import multiple Excel Spreadsheets into one table

    Hi, I found some sample code that I used by googling for "access vba importing multiple spreadsheets" and found a link to Tek-tips.com. The code looks like so: Dim ImportDir As String, ImportFile As String ImportDir = "C:\Program Files\Alcatel\A4400 Call Center...
  3. C

    Import multiple Excel Spreadsheets into one table

    Hi, I would like to import multiple spreadsheets into a table. I tried to use the TransferSpreadsheets macro, but it will only allow me to import one spreadsheet at a time. It won't let me use wildcards to import multiple spreadsheets. Is there any type of vba code that I can use to do the...
  4. C

    IP Addresses

    I am trying to create a database for devices with ip addresses. The devices will be assigned an ip when it is ready to install. Is there any type of vb code that will generate a list of ip's where I can define the start address?
  5. C

    MS Access Wildcard Search Query

    Hi, I am modifying a database and I want to create a Wildcard Search Query in MS Access. The database has city and the state they reside in. I have about 500 records. I want to see the records that contain Miami anywhere in the record. I also want a dialog box to pop up so I can search for...
Top Bottom