Search results

Thanks again.

thanks Paul. That did it. I tested it through the txtReceivedDate_LostFocus() event procedure and txtEmailID would update correctly every time. May I have your thoughts on the best place to handle updating txtEmailID if a user manually changes txtReceivedDate to a different year? I've...

I'm using the following code to generate a sequential number" Private Sub Form_Load() Me.txtReceivedDate = Now() 'assign an EmailID when form loads Dim CurMax As Long Dim NewMax As Long 'poll the current EmailIDs for the largest number from current year and add 1 If...

maybe this is looking too broadly, but your first bit of code contains two IFs and only one End If.

If IsNull(Me.txtDateBack) Or Me.txtDateBack = "" Then Update: Don't forget about the End If

Once the database is in use it will be open 99.9% of the time, making the odds of multiple messages firing off almost nonexistent. Are there any pros and/or cons to having the query as a permanent object in the navigation pane vice creating it on the fly during recordset creation?

Yay! the code below appears to be working as intended! Private Sub Form_Timer() Dim db As DAO.Database Dim rs As DAO.Recordset Set db = CurrentDb() Set rs = db.OpenRecordset("qryReminders") With rs If .RecordCount <> 0 Then Do Until .EOF...

Sorry to spam this thread, but it helps me work through it. (And it offers more chances for you guys to catch me before I go too far in the wrong direction) For step 1, I decided to build a qry. The sql view of which is: SELECT tblReminders.ReminderID, tblReminders.RemindTime...

I need to get a handle on what I'm trying to do, before I can sort out how to do it... step 1) search tbReminders looking for something like TimeValue(Now()) >= .RemindTime AND Day(Now()) <> Day(.LastRemindTime) step 2) If there is a match capture the .ReminderID of that match step 3) Create...

the good news - my DCount code looks like it was accurate the bad news - I still don't know how to make use of it in other news - it looks like I'm being steered towards using a RecordSet instead of a DCount. Or am I supposed to use them together?:confused: The timer was setup to fire every...

I've never dealt with RecordSets or looping either:confused: I'll do some research and see what I come up with and run it by you guys if it doesn't work as intended.

I'm in the editor now and I'm realizing I've never used DCount() before. How would I set this up? If DCount("Reminder", "tblReminders", "[Time] = #" & TimeValue(Now()) & "#") Then My table currently has two fields. Time (Date/Time) and Reminder (Text). Time is currently the Primary key I'm...

question about the table design: Would a table with two fields (Time and Reminder), using Time as my primary key be a bad idea? Also, do you have recommendations for setting up the LastReminderTime?

Moving it all into a table is an awesome suggestion! Such a simple solution that I'm a little bummed I didn't think of it myself. I've even done it once already to move something else out of code to make it manageable via a form. The timer is set to a 1000 interval to fire every second. I...

I have a database for log keeping. I've created popups to remind users when it is time for an entry. 'Popup reminders for watch entries '------------------------------------------------------------------------------ 'Update information between [ and ] for new reminders. Remove the brackets in...

I did briefly look at moving the filter into the record source (a query), but wasn't immediately sure how to do it and didn't' spend much time on it. I did however, solve the problem. Your button idea led me down the path of having the (filtered) report open when I attempt to export it. That...

Is that the only 0 (zero) present?

Simply put? Automation. I know there are ribbon options and right click options*, but I want to automate the process. I may also end up hiding the ribbon bar to minimize the chances of my users doing things outside the sandbox I'm creating for them. *I'm developing in 2010 - My users have...

I'd prefer to have the report open in Print Preview. The button does not display in Print Preview.

After posting about my new attempt I noticed a commonality between my latest efforts and my original export button. The exported report isn't using the filter. How do I get the filter to stick?