Search results

Your form is unbound so oncurrent event doesn't fire at all. You need to use textbox1 and textbox3 events (after update or onchange) to calculate value of textbox5.

I would create a query containing that JobRefNo field and export query instead of form.

Also check if any of subqueries (queExpSum, queInvoiceWorkDays) doesn't require parameter.

You have incorrect number of opening and closing brackets, and some in wrong place as well. try: TotalExpenses: DSum("[tblExpenses]![ExpDeclarationValue]";"queInvoiceExpenses";"Month([tblExpenses]![ExpDate])=1 And [tblExpenses]![EmployeeID]=1")

Are you sending exactly same email to both addresses? If so, then (regardless of what method you're using to send emails): EmailTo=[Email 1] & ";" & [Email 2]

Can you open only VBA editor without opening form first? Alt+F11 Or import form to new blank db?

Use FileDialog object.

That wasn't my intention and you know it. I tried to save everybody's time answering same question on three different forums. Meanwhile you turned it into "meaningful" conversation which I'm not going to continue.

I'm not. I just read all three forums and spotted a crosspost and decided to inform you among others. I apologize if I crossed the line. That being said - are you a mod and want to decide what am I allowed to post?

Crosspost: http://www.utteraccess.com/forum/index.php?showtopic=2035120 http://www.accessforums.net/showthread.php?t=58336

Problem lays perhaps in how date picker in date/time fields works. When you click Today it inserts today's date at midnight. So if you want to record current time exactly you need to create custom button and use Now() function instead.

strTitle="New Work Order #" & Me.WorkOrderId

It's hard to advise anything without seeing your code or even db. If you won't find a solution I'd suggest uploading your database and be more specific about when and what happens, what your macros do, etc.

Where have you been searching for solution? First results from google: Macro error 3270 Macro error 2950

So what was the problem with doing your calculations in AfterUpdate or OnChange events of each L, W and H and putting result in Price textbox? You were asking about that yesterday AFAIR and...? That's how you want it to work, right?

It was and it will be. This db is still work in progress.

Hi All, Now it's my turn to ask for your help. In attached db there's a query "qAppsList" based on table "Apps". Query returns calculated field FullPath2 and in that field I'm using a function retFullPath() I created. For some reason it returns #Error in most rows apart from one and I can't...

With Nz() function you need to specify "value if null" parameter so it returns i.e. 0 (zero) when a value is null. So instead of: Nz([Tot Prc]) use: Nz([Tot Prc],0) Also it's not recommended to use spaces and special characters in field names, like your [NEW UNIT PRICE (NET)], that's asking for...

I never managed to get rid of those warnings completely, there's many solutions but only some of them work. Try to google "access suppress followhyperlink warning" or something similar.

Application.FollowHyperlink Pubpath & "\" & PubDoc