Reputation: 308 Architect
- Active Posts:
- 1,845 (0.83 per day)
- 26-March 09
- Profile Views:
- Last Active:
- Today, 10:02 AM
- OS Preference:
- Who Cares
- Favorite Browser:
- Favorite Processor:
- Favorite Gaming Platform:
- Your Car:
- Who Cares
- Dream Kudos:
- Expert In:
Posts I've Made
Posted 30 Apr 2015As 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.
Posted 27 Apr 2015Hello 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.
Posted 21 Apr 2015What did you create the installer with?
What have tried so far yourself?
Posted 19 Apr 2015Does it do anything?
Do you get any errors?
Posted 12 Apr 2015OK, 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)
- Member Title:
- D.I.C Lover
- 43 years old
- June 12, 1971
- Programming Languages:
- C#, VB
- Website URL: