maj3091's Profile User Rating: *****

Reputation: 308 Architect
Group:
Expert
Active Posts:
1,845 (0.83 per day)
Joined:
26-March 09
Profile Views:
24,015
Last Active:
User is offline Today, 10:02 AM
Currently:
Offline

Previous Fields

Country:
GB
OS Preference:
Who Cares
Favorite Browser:
Chrome
Favorite Processor:
Intel
Favorite Gaming Platform:
PC
Your Car:
Who Cares
Dream Kudos:
0
Expert In:
VB6

Latest Visitors

Icon   maj3091 has not set their status

Posts I've Made

  1. In Topic: TO USE ACCESS DATABASE WITH LOG IN FORM .

    Posted 30 Apr 2015

    As a starting point, have a look in our tutorials section (I believe there is a post in there about using the ADO Data Controls), to see if that can shed some light on your issue and give you some usage scenarios.

    Personally, I've never used the controls, but looping around to check records doesn't seem like a good way to do things. It would make more sense to have a select query that checks the database for that particular user.
  2. In Topic: Crystal Reports Query

    Posted 27 Apr 2015

    View Postdeniserich, on 27 April 2015 - 06:48 AM, said:

    Hello guys, Im having a hard time in loading my crystal report using vb6. Can you help me with my query?

    Here is my query.

    ssql = "SELECT Temp_Portal.SectionCode, Temp_Portal.nr_workcode, Temp_Portal.Order_Number, Temp_Portal.Item_Number, " & _
    "tbl_WC_FWBS.FWBS_Code, tbl_WC_FWBS.FWBS_Application, Temp_Portal.Project_Total, tbl_Department.dept_name, " & _
    "Temp_Portal.Project, Temp_Portal.Billing_Month, Temp_Portal.Billing_Year " & _
    "FROM MTS_Portal.dbo.tbl_WC_FWBS tbl_WC_FWBS INNER JOIN (MTS_Portal.dbo.tbl_Department tbl_Department INNER JOIN MTS_Portal.dbo.Temp_Portal Temp_Portal ON tbl_Department.department_id=Temp_Portal.Dept_ID) ON tbl_WC_FWBS.Work_Code=Temp_Portal.Work_Code " & _
    "WHERE Temp_Portal.Project_Code='" & gProjectCode & "' AND Temp_Portal.IsBillable='1' " & _
    "ORDER BY tbl_Department.dept_name, Temp_Portal.Project, Temp_Portal.nr_workcode "



    You're replying to a post that was started in 2007, so the likelihood of the OP responding to this is fairly minimal.

    Please open a separate topic with an applicable title and a description of what your problems are including what error (or errors) you're getting.
  3. In Topic: Install fonts automatically while installing a program

    Posted 21 Apr 2015

    What did you create the installer with?

    What have tried so far yourself?
  4. In Topic: Copying and pasting sections of data

    Posted 19 Apr 2015

    Does it do anything?

    Do you get any errors?
  5. In Topic: populating a listbox from a .dat file?

    Posted 12 Apr 2015

    OK, so it specifically say a ListBox, so you'll need to concatenate your data to use with AddItem, for example:
    Joe Bloggs (01234 567890)
    John Smith (+1 555 123 5678)

My Information

Member Title:
D.I.C Lover
Age:
43 years old
Birthday:
June 12, 1971
Gender:
Programming Languages:
C#, VB

Contact Information

E-mail:
Private
Website URL:
Website URL  http://

Comments

Page 1 of 1
  1. Photo

    Coulee Icon

    02 Feb 2012 - 19:29
    Hi,I found your post Compiling on Win7x64 SP1 gives ADO Issue on XP....http://www.dreamincode.net/forums/topic/221024-compiling-on-win7x64-sp1-gives-ado-issue-on-xp/
    I met the same problem,can you help.
    I will really really appreciate it
  2. Photo

    maj3091 Icon

    20 Dec 2011 - 01:32
    Thanks raziel_, I didn't realise what you meant at first! I was hoping you knew my boss at work! :)
  3. Photo

    raziel_ Icon

    19 Dec 2011 - 09:24
    gratz on the promotion man :)
Page 1 of 1