Search results
-
Y
Solved Extract text from String ,Name and telephone number
More guidance is requested . I have a field in Select query solicitors, which produces the name of the solicitor and the telephone number .My requirement is to be able extract only the solicitors name . I have tried various combination using left function and is numeric to remove the numbers... -
Y
Solved Extracting first name if more than one name.
The database I am working on has a field named Firstname and within that field one or two names can be inputted, I wish to extract only the first of these names. I entered the following into the field of a the query. KnownAs: Left([FirstName],InStr([FirstName]," ")-1) The result as shown below... -
Y
Solved Dcount with criteria of <= date()
Assistance is required, I have text box on a from which I wish to display the number or records within a query, where the Due Date is before or equal todays date. =DCount("DueDate","TaskChasePackTwo") records the count of Due date, but when adding a criteria... -
Y
Solved Combo Box List count
Expert advise is sort , I am using the listcount to obtain the number of rows in a combo box .The text box calculated control I am currently using gives the correct count, unless the number of rows is zero , in that case the output is -1 ,which is the same result as when I do not use minus... -
Y
Updating a table via Query
EDITED BY THE_DOC_MAN to correct the code bracketing. NO edits to the actual content. I would appreciate advice on updating a table via a select query which has two IIF fields .Query SQL below SELECT QueryTraining.ID, QueryTraining.FirstName, QueryTraining.Hampshire... -
Y
Solved Totals Yearly Query
Constructive advise would be appreciated for my question . I have created 3 queries . Query 1: counts Source = Product Transfer yearly. Query 2: counts Source "Not Product Transfer" yearly. Query 3 is the combined result of query 1 and 2 . Is there a more efficient way to produce the results... -
Y
Solved Saving a record After update event
Hello fellow access users. I am attempting to save a record within script of the after an update event to allow another procedure to take place based on saved new details of the field Example: On the status changing to Completed, today date is inserted into the Date completed field of the... -
Y
Solved How to Make Replies to Emails sent from Ms access 2019 Go to Another Address in Outlook
By default, the email replies go to the email address that sent the email. I wish the reply to go to the enquires desk, email address. I have tried entering, dot reply “email address” in the code ,but without success . Any guidance on how I can achieve my aim would be appreciated #.To = Email... -
Y
exiting private sub without saving
Seasonal Greetings . i have a small procedure error . The scenario is when a states is change to Booked . After update, actions programmed work as expected. I now wish to place a before update question and if the answer is Yes the sub is exited, without saving the status Booked. Private Sub... -
Y
Adding result of list box to Text box
Please point me in the right direction . i have the results of four separate list boxes in four separate text boxes, No problem. I Now wish to add or sum of the four totals into one text box . i have tried the following in the control source of the text box : #... -
Y
multiple email with individual ref number
In a previous post I received assistance in creating a module to send email message to a rs of members. This work well , but i would like to place an individual reference number for each email to enable me to ask the member to refer to it when responding. I assume this would require an extra... -
Y
Sending Email to a number members
Advice or suggestions would be appreciated. I have a sub to send emails to a number of members, which performs how i desire . There is a but and that is ,I need to send blind copies "bcc" How would I achieve my aim using my current script below: #Private Sub SendeMail() Dim rs As... -
Y
Sum with criteria in Form Field
Further assistance is respectfully requested . In my form i have field named Total Paid, I wish to have the amount amount Due reflected in the field if the check boxes has been checked when paid. I Successfully produced a Dsum #=DSum("AmountDue","FeeDueQuery","Paidinfull =-1")# Which... -
Y
Open form from combo box
Assistance would be appreciated. i have a Flash form which has a combo box , i am trying to open the Contact Details form with the record ID selected in combo box. My efforts open the form as a new record . # DoCmd.OpenForm "Contact Details", acNormal, "", "Combo288.column(0)=[Forms]![Contact... -
Y
MS office 2019
Good Morning from the UK. I am currently testing out MS office 2019 on my home laptop. All seems fine even when I open a database created in MS 2010, all the References are updated from Office 14 to Office 16 , However when I try the reverse and open a database in MS 2010 ,created in Office... -
Y
Date field General
Advise sort. I have created a new date field in my table and set the Date format to general . When using the date picker to enter a date, only the short date is shown . I have tried the format mm/dd/yyyy hh:nn AM/PM, however the result shows short date plus 00 00 and not the hours and minutes... -
Y
Sending Text Message
Advice is sort. I am happy about sending emails to clients, using a word document , for the content of the email, linked to a Query as the Data source . The requirement now is send a short standard text message via SMS.textapp.net . My initial thought is to create a function. Example... -
Y
running count query
Seasonal Greeting to One and All. Advise is sort , i have a simple query which counts the source field that have been grouped . SQL View #SELECT Count(TblDemoData.ID) AS CountOfID, TblDemoData.Source FROM TblDemoData GROUP BY TblDemoData.Source;# This work just fine, however when i tried to... -
Y
Simple Purchase and Sales Db
To anyone who can advise. I am trying to build a simple non commercial data base for my son who is starting a venture by buying old golf buggies and refurbishing them ,which are then sold or if cannibalised he sells the component parts. I have looked at the Northwind database, which is far too...