Search results

Thanks Pat & MajP. Here is why the customer needs two forms open at once. Picture in the form on the right, the customer enters and order to schedule work for a certain day. In the form on the left, it currently shows, (in a continuous form sorted by date and city), the number of jobs that...

Pat, thank you for your feedback. I've been able to get Forms!FormName.Requery to work. The update is almost instantaneous so it is working well. Thank you!

I did. It didn't update the popup form. I tried the Recalc for the popup from the order form and also after the focus was set from the order form for the popup and in the On Activity event, I tried Me.Recalc. Still doesn't work.

I'm sure this has been asked before, but I haven't been able to find the solution. I’m trying to get a popup form to requery after I enter an order on another form, (the order form). The requery will then show an updated number of pending orders. I seem to recall there are some challenges doing...

After I sent my question, I tried declaring CheckIsBlank with it's corresponding If-Then statement. That worked perfectly by eliminating the If-Then within the .Body. Thank you Eugene and Doc Man for your help!

Hi, I'm feeling kind of dumb this morning. I have vba code that ultimately sends and email. The .Body of the vba has line continuation characters because of the length of the message that will be in the body of the email. I need an if-then statement to include some text or not. I'm getting...

DBG & bastanu, Good work from both of you. It works. Here is the code that works. I appreciate all your help! You made a difference. Chuck Private Sub FindCustX_Click() On Error GoTo Err_FindOrder DoCmd.GoToControl ("CustomerIDX") Dim CustNbr As String Dim CustNbr2 As...

Hi DBG! Here is the code I use that opens the Customer Form from the "Customers with Similar Last Names Form". I've tried it with and without the filtering. In both cases, when the Customer Form opens, it opens to the correct customer, however it's record 1 of 1. DoCmd.GoToControl...

Hi, I have a continuous form that produces typically a small number of records that includes for each record a [CustomerID]. When I see the results I click on the "Find" button that successfully opens the Customer Form and finds the customer that matches the [CustomerID] from the previous form...

Hi, my customer has about 2,000 customers with their postal addresses in his Access db. He enters "order" to do work when they make a request. What he would like to do after he enters an order is to be notified that "by the way, there are X number of other customers who have pending orders...

Thanks Pat. I always appreciate your feedback. Chuck

Hi Pat. I just want to make sure we’re on the same page. I want to be able from a customer form, (contains data for one customer name that may include one or more telephone numbers and probably just one email address), click on a command button and have the contact information sent to Outlook...

Got it. Thank you!

OK, I have mostly figured this out. After reading Pat Herman's reply about DLookup and no criteria, (and Minty's feedback which addressed the same issue), I added an Autonumber field to the temp table, and I used the DFirst function to find the first Autonumber value and then set the DLookup...

Hi Pat. Can you please give me an example of using an append query to add a contact to Outlook? I believe I understand your point about Domain functions, but I’m not sure how to extract each record from the temp table and use that to send it to Outlook as a Contact.

I'm back at this. With this code I've removed all if/then logic to make sure that wasn't causing a problem. I added a counter called TestMsg and I've confirmed the code is looping; it increments the counter each time it goes through the loop. However, for whatever reason, the code continues...

First, I didn't copy the On Error line to what I posted. In my code I have it remarked out so if there is an error I could see where the error occurred. No errors. I'm always open to learning which is why I posed this asking for help. Again, the record count was just for me to use when...

If I run the queries before the rest of the code starts, aren't the records "old", not "new"?

Well, I'm still stumped. I moved the queries to right after the DIM statements, (they should have been there), to make sure they are executed before the rest of the code. The contents of the temp table are correct. I changed the .movenext to rs.movenext. As far as stepping, maybe I'm not...

The queries establish which records/contacts to add to Outlook. The queries work perfectly. I can see the table after it's repopulated and the data in it is correct. I'll check the other suggestions as well.