Recent content by cyanidem

  1. C

    problem with ubound textbox

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

    Export with Formatting

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

    Query error 3061

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

    DSUM report

    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")
  5. C

    Bulk email for two email fields

    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]
  6. C

    Corrupt form

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

    File Imports through a form

    Use FileDialog object.
  8. C

    Current variant of the bookmark bug

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

    Current variant of the bookmark bug

    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?
  10. C

    Current variant of the bookmark bug

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

    Date and Time Record always shows as 12:00AM

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

    Concatenated Email Title

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

    Macros Errors: 3270 and 2950

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

    Macros Errors: 3270 and 2950

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

    Is Access Capable of doing this?

    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?
See more
Back
Top Bottom