Recent content by Plumber

Sketchin, Thanks for all your help.

:DThanks Boblarson That works fine. I am so grateful.

:D Thanks, I'll try this.

The RecordSource for the form follows: SELECT CustomerTbl.*, TestRecordTbl.* FROM CustomerTbl INNER JOIN TestRecordTbl ON CustomerTbl.CustomerName=TestRecordTbl.CustomerName;

The two tables on which the form is based are CustomerTbl and TestRecordTbl. CustomerTbl has 'BillingAddress' field and TestRecordTbl has DeviceAddress field. Both fields are on the form that I am using

I am running Access 2010. I need to fill in data on a form from one table to another on the lost focus event. Here is the code created using Expression Builder, which doesn't seem to work: =IIf([Device Address]=" ",[Device Address]=[Billing Address],[Device Address]) Any and all advice will be...

The locations may be used more than once.

With some Customers the customer address and job address are the same. Other Customers may have multiple job locations. For instance a Real Estate office may have a job performed at the office address or at several other rental properties. Where a job is performed at their office, I want to...

Bob, There are instances where the Customer may have several locations where jobs are performed.

Bob, Thanks for getting back to me so quickly. What happens when to information in the Jobs table is different from that in the Customers table?

I have a form using name, address, phone, etc. from Customer table and job details from Jobs table. The Jobs table also has address, phone, etc. There are instances when the address, phone, etc., are the same on the Customer table as on the Jobs table. I want a control (button, check box or...

Neither. I'm copying from a file that is in a separate directory that contains JPGs and PDF files.

I have existing Access 2007 databases which I would like to add photos and PDF files to. I want to add pictures and PDF files to individual records. Please help:confused:.

I have a MS Access 2007 database with 4 attachment fields containing jpg's. I need a way to show filenames for each picture. Any help is greatly welcomed.

I am trying to create runtime apps with Access 2007. I have downloaded and installed the Accessdeveloperextensions.exe and the AccessRuntime.exe. However, I cannot find 'Developer' when I click on the Microsoft Office Button. Any help is greatly appreciated.