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

Reputation: 3 Apprentice
Group:
Active Members
Active Posts:
75 (0.09 per day)
Joined:
14-August 12
Profile Views:
1,157
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.
  5. In Topic: Background worker Help

    Posted 4 Feb 2014

    View Postybadragon, on 04 February 2014 - 06:52 AM, said:

    I was just doing some testing and it is because you have ShowDialog within your loop and after it's completed you try to hide the form. Try moving your showDialog to your workercompleted Sub after you hide the form so


    Private Sub bw_RunWorkerCompleted(...)
    Me.Hide()
    frmEnquiry.ShowDialog()
    End Sub
    
    


    Thanks for the reply

    While what you suggested does work, it defeats the purpose of my Background worker (which is to load frmEnquiry in the background then display it to the user once it has loaded)

    Could you suggest another way to achieve this that will allow me to close the frmLoading form?

    *edit*
    I was wrong, this does do what i want it to - sorry for doubting you :)

    The problem now is my gif doesn't seem to show? The area where the gif should be is transparent?

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?