Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. supermaestro

    ORDER text numerically

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

    Ordering numbers in a text field

    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?
  3. supermaestro

    datepart

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

    Date Range Calculation problem

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

    Date Range Calculation problem

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

    email problem

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

    email problem

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

    email problem

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

    Date Range Calculation

    Cheers Lads. That sorted it
  10. supermaestro

    Strange Results Returned Dates

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

    Date Range Calculation

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

    macro to mailmerge

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

    Need help with running a query from form using combo

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

    Hi I'm getting errors on the INS

    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]...
  15. supermaestro

    SQL query error

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

Part and Inventory Search

Back
Top