Search results

Thank you. It was as simple as moving the RecordCount after the Requery. Thank you very much

Thanks

I indented with spaces ... if didn't save as such. So sorry Varcount shows properly. I ran a Msgbox Varcount to see the counts

The following code is an event on a timer. The code works fine, with one exception. When the form is refreshed, if there's a new customer, the Wav file is played (that's good). But after the customer is served and there are no customers in the queue, the Wav file is played once more. The...

First two If Then's work fine (no action) but I having trouble with the third If Then. I want the wave file to play if there are 1 to 5 records. I believe the problem the AND but I don't know how to write a between statement using the variable. Any help would be appreciated. Dim VarCount As...

I send customer surveys via the database (CreateObject). At present it's a text email. I want to create an HTML survey with radio buttons. Is that possible? If so, any help would be appreciated. I don't want to create an attachment because this will decrease the number of surveys returned...

I'm lost. I have a text field named "Status." The first set of code works fine. The second set doesn't. Is it because I'm using "<>" with a text field? If so, what should I use instead? Any help would be appreciated. Me.SectionClearText = "Contractors" If IsNull([TimeOut]) Then Me.TimeOut...

Works like a charm. Many thanks

On my main table I have organization information of different locations (location, unit name, etc.). The primary key is UnitID (autonumber). On my secondary table, I have all the trainers assigned to the entire organization. I have a UnitID field (number) to associate the trainers to the...

I have a database that generates an email via SendObject. The email generator works fine for all users but one. No error message. I'll click on the icon, on the user's computer, and nothing happens. Because the process works on all computers but one, I believe the issue is an Outlook...

I'm creating a report, saving it as a pdf, then later using the pdf as an attachment to an e-mail. Everything works fine. However, I've decided to save the pdf on the user's computer rather than save on a shared drive. The error I get is the Output To was cancelled. I believe it's because of...

The problem isn't one report, it's all reports I've built. The report is in preview mode not print mode. I've had no problems until I started using the basaccesshider module. https://www.access-programmers.co.uk/forums/showthread.php?t=136266&highlight=basaccesshider I run Access as...

I have various reports which I activate in the preview mode. For whatever reason, the Print Preview toolbar options (e.g., print, close, etc.) are deactivated when I open the report. If I leave Access (e.g., activate another program such as Word) and then go back to the Access report, the...

I have a form with (continuous forms). In each record there is an icon which sends an e-mail to the e-mail address in the record. The process works fine if I'm in the record then click the icon. If I open the form and see 10 records, I want to be able to click the icon, on any record, to...

I have a date field [RNLTD]; I have a number field [TourLength], which represents the number of months. What I need to do is calculate a new date by adding the number of months in [TourLength] to the date field [RNLTD] What I did was take [TourLength] and multiply it by 30, then I added the...

I have a small attachment for each record, which I want to store in an attachment field. I want to extract that attachment and send via e-mail as SendObject. Is that possible, if so can you provide a link or directions. If not, what method should I use. Thank you

I'm looking for the selected values in the second column; comma delimited I'm still hunting the web for a solution. Very frustrating. Thanks for your help

Steve ... thanks. I don't have a problem when using the combobox, it's when I use a listbox with multiple values. The listbox saves the multi values in ClassReasonID, which show when I run the query (see atch) but not when I run the code for the e-mail in the form I get an error (Type...

The error occurs when the e-mail is constructed. Works fine without the Me.ClassReasonID reference (which is the multivalue field. Too difficult to send database (FE BE split; personal data contained therein).

I have a table: Field Name = ClassReasonID, Data Type = Number, List Box, Data source is another table. The list box field works fine in the form. The data in the query looks fine. I'm trying to write an e-mail but when I reference the ClassReasonID I get a "Type Mismatch" error. I tried...