Recent content by sdelgado

Groupwise email Were you ever able to solve this? I'm looking for anyone that has been able to successfully send an email to groupwise from an access form. Thanks

What Finally worked :) If Me!BatchNumber < 1 Or Trim(Me!BatchNumber).Value = "" Then With PeriodEndDate .SetFocus With Me!btnNewKid .Enabled = False End With End With GoTo Exit_btnNewKid_Click Else DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70...

I gave it a try but when I try the button on the form it says 'Object is Required' With that table, that is actually a line of code I need to delete but had forgotten it till I sent it out to forums for help this morning. Thanks for pointing it out though. :o

In the code below, I want this button to disable if data is missing in the 'batchnumber' text box. The setfocus is because I can't disable a button that has the focus. The problem is the script is apparently ignoring my if and running the else. Can anyone see where I messed up????? :confused...

more on Last Check Number query problem tblBatchExport and tblCheckRegister link up by batch number, except that in this scenario the current batch of check hasn't been printed yet so it would be the last check number of the last batch or the last check number in the check register

How do I use DMax? Ok, my query is using two tables. tblBatchExport and tblCheckReg BatchNum, BatchRunDate come from the first, CheckNo comes from the last. I want to make a single row table with these three pieces of data. (the table they make is used by Crystal Enterprise to run a series...

Part of a query is looking for the last check number in my check register table. I have tried doing it in the Totals row by 'Last', I have tried using criteria last, I have tried a formula in the field using both DLast and Last. Every time I get check numbers 100 to 300 checks back in the...

The provider/vendor chosed at top of form can have multiple entries for a given batch. When the parent ssn in the subform is filled in, a query runs to find all (unique) children found in tblWarrentHistory matching that ssn. That part works fine on the first subform record and populates the...