Search results

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...

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...

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 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...

Is there a simple way of creating F1 help messages for individual fields? I don't want to use the status bar ... easily overlooked. I searched (F1, field, help) without luck

The following If Then statement doesn't work. Am I using the And's and Or's correctly? If (Me.CurrentSGLIAmt <> "400,000" Or Me.RSN_Increase_Amt <> "9") And Me.UBLCombo = "Married" Then Me.SpouseLetter = -1 Else Me.SpouseLetter = 0 End If

I'm trying to write an IIF but I'm having trouble because of the nested form and the one to many query I'm using (see attached graphic). I have a form (frmTrackerPCS) with a subform (frmMissingItems_Subform) On my main form (frmTrackerPCS) I want to show a label if MissingID (41) from...

I have a pdf file which I want to print (Event Procedure on button). I'm having trouble finding how to print the file. Any suggestions would be helpful

I have a form. I want to disable various fields on different pages (tabs) on the form. I can disable a field on the page I'm working on, such as ... RetirementDate.Enabled = False How do I disable a field on a different page (same form)?

In my database I have several letters (reports). In the reports, I need certain words in a text box to be bolded and other words italicized. For example I need only "Information Program" to be bolded ="According to DOD 52.1-R, Information Program" I've tried <b> and /<b> before and after...

In each record I have two date fields (retirementdate and separationdate). In the record one of the date fields will have a date. The other field will be left blank. I want to combine the two date fields into one field (combineddate) then sort the data (ascending). I created a new field...

I have a table (CSR) that lists all our customer service reps to include the name, position, (Y/N), etc. I can add new reps but don't delete them when they leave because I need to keep CS info in another form; instead, I mark the rep as Inactive (Y) when they depart. I have another form...