raycomp's Profile User Rating: -----

raycomp's Photo
Reputation: 0 Apprentice
Group:
Members
Active Posts:
47 (0.03 per day)
Joined:
25-August 09
Profile Views:
1,567
Last Active:
User is offline Aug 28 2012 07:09 AM
Currently:
Offline

Previous Fields

Dream Kudos:
0

Latest Visitors

Icon   raycomp has not set their status

  1. Awards
  2. About Me
  3. Blog

Posts I've Made

  1. In Topic: Need help with deleting records not working

    Posted 5 Feb 2012

    View Postmaj3091, on 05 February 2012 - 03:25 AM, said:

    You have to put the #'s as part of the string, not around the Text1.text, otherwise you would get a syntax error??

    Look at what you've written and said that works.

    Something like below, should work

    Quote

    "DELETE From ControlDetailsA where [Date] <= #" & Text1.Text & "#"



    maj3091 thanks a ton. Works like a charm

  2. In Topic: Need help with deleting records not working

    Posted 5 Feb 2012

    if I use the code below it works properly if I put a specific date in the code


    "DELETE From ControlDetailsA where [Date] <= #4/2/2011#"


    If I however want to change the query to use a date stored in text1.text field I'm having trouble with it. The idea is to delete all records <= to the date stored in text1.text,
    the value in text1 text = 5/11/2011 (Text1.Text = Format$(test, "d/m/yyyy")

    I have tried "DELETE From ControlDetailsA where [Date] <= " & Text1.Text NOTHING DELETED
    "DELETE From ControlDetailsA where [Date] <= " & #Text1.Text# SYNTAX ERROR
    "DELETE From ControlDetailsA where [Date] <= #text1.text#" SYNTAX ERROR

  3. In Topic: Need help with deleting records not working

    Posted 5 Feb 2012

    View Postmaj3091, on 04 February 2012 - 02:09 PM, said:

    You SQL query doesn't look right.

    You don't Delete * from table, you just Delete from table and your date text should be cast as a date. I'm not 100% sure on the access syntax, but I think it might be #date#, so your query would be something like

    Delete from Table where [Date]<= #date#


    Thanks for the reply. I'm still not getting it to actually delete the records in access table

  4. In Topic: Help to strip portion of text from textbox

    Posted 14 Jun 2011

    Thank you BobRodes for the advice and for the useful link. I am rather a novice using VB6 and dis search but did not come right at first. Enjoy your day

  5. In Topic: Help to strip portion of text from textbox

    Posted 14 Jun 2011

    major3091 thanks for taking the time to help out. Really appreciated. Any forum with members like you, who are willing to give constructive help, is very lucky.

My Information

Member Title:
New D.I.C Head
Age:
Age Unknown
Birthday:
Birthday Unknown
Gender:

Contact Information

E-mail:
Private

Friends

raycomp hasn't added any friends yet.

Comments

raycomp has no profile comments yet. Why not say hello?