Search results

Thanks I have resolved the problem. I had some duff code in there which I picked up by mistake.

I have a field 'Customer Name' on my form 'EstimatesNew' and I retrieve records from my Customer Table to autofill my form. If I wish to create a NEW customer it pops up with a new Customer Details Form. However it doesnt inherit the Data I've inserted in the original field on my main form. What...

Thanks thats just what I need

I have a Form which contains a sub-form. I wish to limit the number of records entered/viewed on the sub-form to say 10. This is because I have pre-printed stationery which will only allow a limited number of sub-form records. Any ideas ???

Problem resolved thanks. I was missing an Add-on to create PDF documents

I am using Access 2007 and Outlook 2007 and I am using the SendObj command to send a PDF document as an attachment to an individual e-mail. I have 5 computers within the office and the command works fine on 2 machines but not on the other 3 machines. They are all running Access/Outlook 2007. I...

I'm using SendObject to send an e-mail containing a PDF, how can I add an autosignature. i'm using Access 2007

I need to print info on the bottom of the first page of a report but no the subsequent pages. Can I hide page footer if its NOT page no 1 ???

The Form 'Project Details' and sub-form 'Project Expenses Sub-form' are an example in Test Database attached. Please ignore total errors

These are NOT fields/labels they are just blank columns. Basically my sub-form has about 8 fields/columns of data which doesnt quite fit on a normal size screen, so I have a horizontal scroll bar along the bottom. As I scroll along past the 8th field/column it displays these BLANK columns. Its...

I have a form with 2 sub-forms side-by-side. The sub-forms are too big to fit on a normal size screen, so I have scroll bars both vertically and horizontally. However, on each of the sub-forms I have a number of BLANK columns at the end of the data, thereby making the width of the sub-form...

I am using the following bit of VBA code now to retrieve 'Job Desc' onto a line within my sub-form. It retreives it ok but I get the following error message ;- The object doesnt contain the Automation object 'Header' Private Sub Project_AfterUpdate() Me.Job_Desc = DLookup("[Job Desc]"...

You're right I think I've sorted it but I am getting a strange error now 'The object doesnt contain the Automation Object "Header" ' Not sure where this is coming from

I have the following piece of VBA code which is called AfterUpdate Me.Text62 = DLookup("[Job Desc]", "Projects Extended", "[ProjectID]=" & Nz(Me![Project], 0)) This retrieves Job Desc and puts it in field Text62 on my sub-form. However, when I enter another record with a different ProjectID...

Thanks you've sorted it

Here's the Tables/Forms concerned. The Form and subform are used for Data Entry only and thet populate the Project Expenses Table. I only created the Header Table as I was trying to speed up the input process, when there is more than 1 line per delivery note and i need to replicate the data...

Checked that its set to continuous

Why does my sub-form only show one record after I've hit enter. It seems to save the individual records OK but it only shows the new record ???

The Window mode was set to Dialog instead of Normal. Just changed it and it works fine. Thanks