Search results

  1. W

    Error message when tryin g to run a macro

    I re-built an Access 2003 database using 2007 and tried to make it compatible with Access 2003. I created a Switchboard button which is meant to Export table data to Excel 2003 using the OutputTo macro. From my PC, which as Office 2007, I can run the macro from the button without a problem...
  2. W

    Macro exports report to Excel 2003 format

    I have a Macro which will successfully export data from an Access Report to Excel. I would like to know why the column headings are the field names from the tables and not the updated field names of the reports. Can anyone explain this to me? Thanks
  3. W

    Enter information into one form hoping to see it in another

    I have two tables. T_Job and T_IP T_Job has a PK of Job_Id and T_IP has a PK of L_IP and a FK to the T_Job talbe of L_Job_ID. If I enter into a form a new job creating a new Job_ID why do I not have the new record in table T_IP? I have two forms built of these tables and I can't see the...
  4. W

    issue with Join

    I'm having issues where this query returns all the service offices I need (26): SELECT McQuayInstalledBaseDetailExport.[SERVICE OFFICE], Count(McQuayInstalledBaseDetailExport.[SERVICE OFFICE]) AS [CountOfSERVICE OFFICE] FROM McQuayInstalledBaseDetailExport GROUP BY...
  5. W

    unhide a hidden subform

    I'm new to Access 2003 and should have figured out how to unhide this before I hid it, but alas I need to know how now. I hid a subform from Content Window by right-clicking, choosing Properties and then checking Hidden. If I want to display the subform again, how do I un-hide it? I've...
  6. W

    issue connecting two non-primary keys

    I have a table TblEqup & TblHardware. For various pieces of equipment they can have the same piece of hadware. Ie. EquipSerialNumber 78 & 79 can belong to 0019 (78, 0019) (79, 0019) I want to be able to establish this relationship so I can have (78 & 79, 0019) and not have to do duplicate...
  7. W

    Sending email to one user

    I've managed to create a button and get it to send an email through outlook for one specified user, but I don't know understand how to get it to choose the user of the form I'm currently on. I've done some research and it appears the DLookup is the way to do this. I don't understand how to...
  8. W

    Adding VB module to command button

    I'm trying to understand how you can add VB modules to an Event in access. So far all I have seen add a macro to a command button upon an event. If the name of my module was send_txt(), how do I add the module to the event? I know you can add a command button, click on properties, events tab...
  9. W

    Issue withe Relationships and form

    Customer can also have multiple jobs. (1 to many) I have a Jobs table and each Job can have only one location.(1 to one) For each JobLocation they can have multiple chillers. (1 to many relationship) I'm trying to create a form which will allow me to enter in a job, then the Job Location and all...
  10. W

    Help with elapsed time function in form

    I have a table with a star time and end time with values entered in like this Start Time EndTime 10/23/2008 6:15:51 PM 3/25/2009 9:27:40 AM They are of date/time type and a general date format string. If I try to use DateDiff(endtime-start time) I get an #Name error...
Back
Top Bottom