Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Showing results 1 to 12 of 12
Search took 0.01 seconds.
Search: Posts Made By: luxcs
Forum: Beginning VB 6 June 8th, 2004, 01:26 PM
Replies: 2
Views: 5,597
Posted By luxcs
VB6 ListBox Sort by Date

Does anyone know if this is possible?

I have a listbox which is populated from database which contains valid dates. The date is in a string format d-mmm-yy (e.g. 6-MAY-04). If the listbox is...
Forum: VB Databases Basics June 8th, 2004, 09:09 AM
Replies: 10
Views: 1,859
Posted By luxcs
Just got myself a copy of VB6 - decided to use...

Just got myself a copy of VB6 - decided to use that instead as its fair better for connecting to SQL.
Now I just need to figure out how to do what I want.....

Thanks for your help everyone though.
Forum: VB Databases Basics June 8th, 2004, 04:32 AM
Replies: 10
Views: 1,859
Posted By luxcs
connection string it produces is the same - at...

connection string it produces is the same - at least I know the string is correct.
still doesn't like the cnPubs.Open strConn
Forum: VB Databases Basics June 7th, 2004, 05:07 AM
Replies: 10
Views: 1,859
Posted By luxcs
Anyone even know of any other sites they can...

Anyone even know of any other sites they can refer me to? I still have had no success with this. What is it I'm missing?
Forum: VB Databases Basics June 5th, 2004, 03:56 AM
Replies: 10
Views: 1,859
Posted By luxcs
All the general stuff, plus Standard OLE Types,...

All the general stuff, plus Standard OLE Types, Microsoft DAO 3.0 Object Library and Microsoft ActiveX Data Objects 2.6 Library
Forum: VB Databases Basics June 4th, 2004, 11:07 AM
Replies: 10
Views: 1,859
Posted By luxcs
It says "Invalid use of property" for the...

It says "Invalid use of property" for the .ConnectionString section
Forum: VB Databases Basics June 4th, 2004, 10:46 AM
Replies: 10
Views: 1,859
Posted By luxcs
VB4 Connection to SQL2000

Hopefully someone can help me here.

I'm trying to write a small VB4 program that connects to an SQL DB on another machine on the network.
I've managed to get another project (Excel VBA to connect...
Forum: Excel VBA June 1st, 2004, 12:54 PM
Replies: 5
Views: 2,043
Posted By luxcs
heletoomik -: couldn't get it to run at the...

heletoomik -:

couldn't get it to run at the moment from another sub either

chrislepingwell -:

Altered code to use rsPubs.Fields(1).Value. No change yet.

The reason for it being a UDF is...
Forum: Excel VBA June 1st, 2004, 12:22 PM
Replies: 5
Views: 2,043
Posted By luxcs
Put in closing semicolon. Missed that one. No...

Put in closing semicolon. Missed that one. No change though.
Used Get External Data in Excel and managed to connect and pull in entire DB.
This was working originally when I had it as public Sub...
Forum: Excel VBA June 1st, 2004, 08:01 AM
Replies: 5
Views: 2,043
Posted By luxcs
SQL2000 and Excel2000 VBA UDF

I currently have a database which I'm trying to connect Excel to to automatically fill in some work reports.
I need the UDF to take in 3 variables - two of which are for the WHERE section of the SQL...
Forum: Excel VBA March 25th, 2004, 03:00 PM
Replies: 0
Views: 1,495
Posted By luxcs
Loading from multiple sheets on another workbook

Hi
I'm trying to extend an existing function I wrote to use different sheets on a different workbook, instead of the active workbook.

The function below did work when using 'local' sheets. But I...
Forum: Excel VBA March 20th, 2004, 08:06 AM
Replies: 1
Views: 1,842
Posted By luxcs
Multi column search and compare

Hi

Hopefully someone can help me with this problem.

I have a 3 page workbook (report,data1,data2).
data1 and data2 are loaded as External Data from 2 csv files and are updated at 10 minute...
Showing results 1 to 12 of 12

 


All times are GMT -4. The time now is 11:12 AM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.