Search results for query: *

Hi I'm amending an existing application in PHP. One of the fields in the database called 'mileage' has a list of values stored in a text column as follows: 75,000 51,000 80,000 32,000 100,000 How would you order these values numerically as follows? 32,000 51,000 75,000 80,000 100,000 Thanks

What would happen if the data was stored in a text field like this: 32,000 51,000 75,000 80,000 100,000 How would you order these numerically?

Can anybody tell me why I get an 'invalid procedure, call or argument' error for this: DatePart("dd", yearEndTo) when DatePart("d", yearEndTo)is fine? I need to return a two digit day number for the date yearEndTo. Thanks

Hi I'm still struggling with this. The Year End is stored as text i.e 01/02 for 1st Feb in the contacts database. A form is used to get the Year End From date i.e. 01/01 and the Year End To Date i.e 01/03. I want to return the records for those that fall in between. The code is a small part of...

Hi I'm developing a database for an Accountants form. They need a Year End field whichis essentially dd/mm i.e 01/02 for Feb 1st. Basically how can I search for date ranges using just day and month without the year? I know that the following works with the year added but need to use it without...

the .Display brings up Microsoft Outlook but the Email Client we use is Outlook Express. What's the best method for sending out using Outlook Express

If I display the email i.e. use .Display instead of .Send then Outlook comes up fine with the correct Fields filled in. However, I would like to send out a single email for Each recipient without calling .Display but just by sending them out automatically without the user seeing the Mail Client...

Hi. Can anybody who is an email expert see what is wrong with the following? I've put debugging code in this and know that it is going through the loop correctly and getting the email address from the query. However, when it has completed I check my mail boxes and nothing is being sent to them...

Cheers Lads. That sorted it

The query below works. It takes 4 values from a form (two of them short dates). The search looks for a transaction date between the Date From and Date To. If a transaction date is '30/05/2003' and a user enters Date From - '01/05/2003' and Date To - '11/06/2003' then results are returned...

Hi. I've looked through the forums and tried a variety of solutions. Basically I have a form which asks the user for an account type, transaction type, a date from and a date to. I am trying to run the query and if there are results then a report is opened else a message is displayed. The...

Hi If I have a button on a form called 'MailMerge' how can I create a macro to open up the mailmerge wizard to save a user from having to go into the menus to open it? Cheers

Hello I've created a form called 'General Mailshots'. This form consists of a combo box called 'Transaction Types' and a datasheet query called 'generalMailshotQuery'. What i'd like to do is for the datasheet view to refresh/re-run using the user defined criteria in the combo box. A)How do I...

Hi I'm getting errors on the INSERT part of this query in the WHILE loop (data type error) Would appreciate any help... Private Sub Update_Click() Dim rs As New ADODB.Recordset Set rs = CurrentProject.Connection.Execute("SELECT contacts.[Contact ID], transactions.[Transaction ID]...

Can somebody please tell me why i'm getting a missing semi colon error 3137? CurrentDb.Execute "insert into transactions ([transactions].[Last Transaction],[transactions].[Transaction Date],[transactions].[Transaction Notes],[transactions].[Next Action Date],[transactions].[Next...