pendaz's Profile User Rating: -----

Reputation: 3 Apprentice
Group:
Active Members
Active Posts:
75 (0.06 per day)
Joined:
14-August 12
Profile Views:
2,035
Last Active:
User is offline May 03 2014 04:11 AM
Currently:
Offline

Previous Fields

Dream Kudos:
0
Icon   pendaz has not set their status

Posts I've Made

  1. In Topic: Update Access database programatically (append to field)

    Posted 3 May 2014

    anyone?
  2. In Topic: filter multiple database fields

    Posted 22 Apr 2014

    Thanks for the reply

    yes i was thinking about splitting the string but like you said, how will it know?

    another possibility i was thinking was to maybe join the two columns with an sql query then apply the filter? i've no idea how to begin with that though :/
  3. In Topic: bindingsource.filter by date problems

    Posted 31 Mar 2014

    awesome thanks, i got it working as you said, with apostrophes and no hash signes:

    .EnquiryBindingSource.Filter = "NextAppointmentDate = '" & String.Format("{0:dd/MM/yyyy}", Date.Today.Date & "'")
    
    


    Thanks again
  4. In Topic: bindingsource.filter by date problems

    Posted 31 Mar 2014

    Thanks for the reply, correct it is an access database

    I tried the following:

    "NextAppointmentDate = " & String.Format("#{0:dd/MM/yyyy}#", Date.Today.Date)
    


    which gave me the following error: String was not recognized as a valid DateTime.

My Information

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

Contact Information

E-mail:
Private

Friends

pendaz hasn't added any friends yet.

Comments

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