Recent content by will1128

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...

Do I have to rebuild the report or the query the report is based on to do this?

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

Ah! Thank you. It took me a bit to understand what you were saying, but I get it now. I had to use T_Job as for the form and T_IP as the Subform. :D

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...

I guess I'm having a heck of time with this. :mad: This query, which counts the number of services offices where the UNIT start date is NULL returns 24 records. SELECT McQuayInstalledBaseDetailExport.[SERVICE OFFICE], Count(McQuayInstalledBaseDetailExport.[SERVICE OFFICE]) AS [CountOfSERVICE...

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...

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...

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...

I do need ot have the email looked up from the form I'm on and other information. I've seen examples, but I'm so inexperienced with VBA I don't know what to do next. So the body of the email message will have other values from a table.

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...

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...

Yes, it would be possible to do more than one job for a single customer. So a customer can have multiple jobs. JobA would be at LocationA. JobB would be at LocationB. CustomerA could have JobA and JobB. The hardware actually can be picked up and moved, but they go with the customer. So if...

No, there cannot be more than one job for any location. Although, I'm not sure I understand your question. If my job location is at 446 W Main St Timbuktu, IA and the Job Name is Building Construction that is one job. I suppose a Customer doesn't have to be defined by location, but I end up with...

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...