Search results for query: *

I have a bulk email process in access 2003 which goes through a list of selected contacts and sends an email with attachment. This has worked well for 2 of 3 users on access 2003/outlook 2003 for the last 2 years. However the 3rd user (on access 2007/outlook 2007) is recently seeing a 50%...

Hi willsth I've found dlookups to be slow in general when large datasets are involved. They are great for small tables. If it's important to use dlookup it sometimes helps to index the table for the field you are using in the where part of your lookup. However the better solution is to create...

I will go with asking client "Is the msgbox really necessary or can we just use color changes instead" Thanks to JBinQLD / PHV for the help. Close Thread F2F4

JBinQLD Ok Done - in the OnOpen event main form - I have removed the requery line - Forms!frmjobsiteb!frmJobDetailsB.Requery However the problem persists - Main form appears with white background when the form/subform opens with the msgbox awaiting an ok click I could remove the onLoad...

Hi JB Yes I have my code in the on load event in the main form. I have substituted the isdate function rather than isnull function as per your suggestion - this still results in a white main form when msgbox first displays. Rationale for checking for existence of date on entry is that...

Thanks TheAceMan1 I didn't realize that the combo dropdown was a toggle - that solved the problem with the residual dropdown on the 2nd screen - That makes twice you've helped me. Now I understand why you and PHV are so active - probably received this timely help when you first joined and feel...

Thanks for both suggestions TheAceMan1 (double click event) PHV (current event) I tried both suggestions and found current event has the advantage of selecting the record no matter where you click plus it even defaults to a record when the form opens. My client will get current event as record...

just tried same code in either load event for the form or subform - just received different forms of white screen For load event on subform - entire screen white For load event on main form - main form top and bottom white - subform normal color

When opening a form containing a subform I check to see whether a date field is filled in. If not filled in then my message box says field is blank. This causes the main form to appear white while the subform is normal. The effect dissapears after clicking the message box ok. It's annoying.

I normally use the on focus event to initiate the docmd.dropdown for a combo box lookup. In this case the combo box has focus when the form is opened so would rather use the on change event to initiate the docmd.dropdown. The problem is that the after update event opens a 2nd form and the...

I am looking for the name of the event using continuous forms when you select a line in the detail section. I can see the on click event for the detail section however client wants to select the line using the gray select to the left of the record.