Search results

missinglinq, Thank you for your kind thoughts, The closest fire to our homes was about 5K’s (3 Miles) , it was only a small one and no home lost. Latest news here is 108 confirmed dead and about 750 homes gone. You may wish to read here: , it is Melbourne's main newspaper. Maybe the OP will...

missinglinq, I do not have GameVance on my computer - I have checked the registry and program files. With reference to the post, I understood that he wanted to record the key (auto number) and not just increase the number by 1 ..... but I may be wrong.

Have a look at the attached sample - is this what you wanted?

Here is your database back and the printing is working. Have a look at the code behind the "Print" button and you will see who it works.

I don't have access 2007 so know nothing about it, but I would think that on the PC's that have access 2007 and 0utlook 2003 you would have to reference Microsoft Outlook 11 Object Library (which is outlook 2003) in Access. Hope this is the answer.

Sorry I have not idea what you are trying to do, maybe you should start another thread.

If you have a look at my sample, you will see that both of the controls that do the summing are unbound; these are the one on the subform and the one on the main form. You do not (in this case) store the value of either in tables. Post a copy of you db and I (or someone else) will have a look...

Is the main form a single form or a continious form?

Which one is gving you the "Visible = No" problem, the "Total" on the subform or the main form?

Is frmContactDetail based on the same table as the subform? If so then you can use code similar to below to open the second form when you click on a control in the subform. Put the code in the OnClick event of the control (eg ClientName) on the subform. Change the "blue" to your control...

Have a look at my sample I posted Here

Have a look at the sample I posted Here You should be able to change it to suit your needs.

In my opinion you don't print forms you print reports. Forms are for entering /editing data.

Attached is a working sample. compare it with yours and see what may be wrong.

Go into your code screen (Alt+F11), from tools click references and then find Microsoft Outlook xx.x Object Library and select it. xx.x is because I don't know what version of Outlook you are running, mine is 2003 and therefore it is 11.0

Use the query to merge to MS Word and have the signature in the word template.

1> Change the data type (in the table) of your email address to text. 2> Put the code below behind the OnClick event of the email control on the form. 3> Change this in the code to suit. .To = cusEMail (change cusEmail to the name of your control) Dim outApp As Outlook.Application, outMsg...

Keith, What Garry said is the way that I have done it. This little bit of code from my subform may assist you; Private Sub PartNumber_AfterUpdate() Dim iAllow As Integer iAllow = DLookup("[NumberAllowed]", "tblNumberAllowed") If Me.RecordsetClone.RecordCount >= iAllow Then MsgBox...

If I understand you question; you want to restrict the number of entries to the subform to 4................am I correct. If so then post back, I have sample db that restricts the number of entries to a subform.

Have a look at the sample now. It now exports a query to excel instead of a report and the formatting is fine. There may be a way to make it work using "export report" but I don't know how. I have never exported reports, only queries & tables. I have made it so that each time it exports the...