Search results

Hi, I am attempting to modify some code that is used for reading content in an Outlook mail and need to catch and move the email if certain content is duplicated in the email. The code reads the email that is in the attached image format: As seen, this email contains 2 devices, but the Serial...

Apologies if this is posted in the incorrect forum. I am looking for an Article writer for my Microsoft Access related website. Unfortunately, I do not get enough time to maintain the website like I used to, and would like to ensure that there is some new content added to keep the site up to...

We have a subform that allows us to assign multiple Playing Positions to a Player, however the Player can only have one Prefered Position (shown with a checkbox) The composite primary key consists of the Player and the Position. How and where is it best to code to prevent us checking the...

I am creating a mail-merge application. The data stored will be dealing with Students and Qualifications that they have attained. The link table in the relationships shown/attached, allows a Student to have multiple qualifications. When I merge the data, I will need to list all of the...

On my switchboard, for the Quit application command button I have the following code If DCount("[tblJobOutcomes]![lngJobOutcome]", "[tblJobOutcomes]", "[tblJobOutcomes]![ysnSentByMailToStaff]=0") = 0 Then Application.Quit ElseIf DCount("[tblJobOutcomes]![lngJobOutcome]", "[tblJobOutcomes]"...

I am trying to send separate e-mails for each record in a query, one e-mail per row of the query. The following code is what is being used and this is what is causing the problems. The code writes the results of various fields into the body of the e-mail (strEMailMsg) as text and not as an...

If I have a Text Box containing Time Out (txtTimeOut - ShortTime format), can I have this flash if the value in time out is Less Than the Current Time. This should be so the user can visually see that the time has expired and the record will need to be updated. I know how to make a label...

I have the following SQL statement that gives me a count of reviews: SELECT Count(tblReviews.lngReviewID) AS CountOflngReviewID FROM tblReviews GROUP BY tblReviews.strISBN_Number HAVING ((tblReviews.strISBN_Number)=[Forms]![frmLINK_Book_Author]![strISBN_Number])); I would like to display...

Whilst looking for a solution to a problem today, I came across a couple of topics by Pat H and Jon K and managed to cobble together the following: Select OrderNum, OrderDate FROM Order_Lines AS ol WHERE (SELECT COUNT(*) FROM Order_Lines WHERE UserID = ol.UserID AND OrderDate > ol.OrderDate) +...

Is it possible to set up a default field value that will display 01457 for a telephone number field. I have tried using the text and number data types, but it always removes the leading zero. TIA Graham

I would like to append a UserID to a table that contains 3 fields tblUsers: UserID UserFirstName UserLastName From a table that contains only 2 fields tblTempUsers: UserID UserName So, this should append the UserID WHERE [tblUsers].[UserFirstName]&" "&[tblUsers].[UserFirstName] =...

I am attempting to create an on-screen Cookery Book. From the information provided I have deduced that there will be a need to store information in four main tables relating to: tblMeals (this will store Meal Information) and should include: * lngMealID (Primary Key, autonumber) * strMealName...

Just a quick question: When using the In operator, can the list of values contain the wildcard (*). A colleague is using an OR operator that is creating a very long criteria and I thought of using the In operator. However the values she is entering contain * as she is searching on postcodes...

I have created a simple database to import information into a single table, from databases that are sent into us from students. To begin with I had created a macro to do this option, but now see the need to include better error handling, as if mistakes are made, the admin people who will use...

I have created a report that is based on a questionaire filled in on a form. The results of the form can then be printed out and I would like to include an input box to ask for the users name to be included in an unbound text box, based in the report header. Can anyone please help with the...

Is it possible to hide a checkbox and it's associated label in a report if the checkbox is not ticked. The report I have lists students followed by various checkboxes pertaining to different choices. I would only like to show the checkboxes that are checked. TIA

I have a form named "frmSearch". This form contains only a listbox [List0]. The unbound listbox uses the Row Source of: SELECT tblPayroll.strEmpID FROM tblPayroll; I have created a macro named "mcrSearchListBox" using the actions "OpenForm". The action argumants for this are: FormName...

I have a query that uses the DateDiff function to calculate the number of days taken to make payment: DaysToPay: DateDiff("d",[dtmTransactionDate],[dtmPaymentDate]). What I would now like to do is create a report grouping payment times. The groups that are required are as follows: Upto 14...

I am trying to set values within a combo box to N/A dependant on a value choosen from an option group on my form. If a user selects a value then various controls should be set to N/A as they require no further details to be entered. The code I have tried using is as follows...

In a report I am attempting to enter the following expression into the report footer to count the number of results containing YES/NO in the field [Agree with Decision]. At present I have used two text boxes containing: =Count(IIf([Agree with Decision],"YES")) =Count(IIf([Agree with...