Search results for query: *

ADO: Reference used: Microsoft ActiveX Data Objects 2.5 Library Dim sConnStr As String Dim cnConn As ADODB.Connection Sub OpenDB() sConnStr = "DRIVER={SQL Server};SERVER=ServerName;UID=user;PWD=password;DATABASE=DatabaseName" Set cnConn = New ADODB.Connection With cnConn...

I've found the answer to this one. I totally messed up my printer drivers while i was playing with the settings programmatically. i just re-installed it and it's working fine. there's absolutely nothing wrong with the code.

Hi, I am working in VB6. What i need to do is the following: execute a query and write the results to the printer. The code that i used is "theoretically" correct, but yet i get only an error message on the page when it prints. The code i use: Call modLibrary.OpenConn str =...

Oh crap - i forgot to mention that i am not using a chart. i have this built-in menu, i select an option, a input form pops up, the user inputs parameters (selected from combo boxes), clicks RUN. The report gets generated completely and just as the program ends, this error pops up...

I have the same problem. I run my app, then at the end it gives me this error. There's no error-number with, so i can't trap it. i've tried debugging through the code, but can't catch it. it also doesn't happen consistently - a bit of a trial and error problem. Please help?? This is urgent...

Hi, I want to set permission for a DTS package? How do i do this? I have to do it the same way you set permissions for tables and views. Please help.. I'm using SQL Server 2002. Mel. :)

Hi, I want only certain users to execute a specific DTS package. I want to do it in a similar way as you do it for tables and views. I'm using SQL Server 2000. Please help. Thx alot. mel.

Thank you for all your help! What I've done is to have 2 combo's on the form. thx. mel.

in the 1st one i forgot to mention that there's normal codes and then group codes to which the normal codes belong to.. that's where the second example comes in.

okay, I've tried it and i end up with: john adrian mel male female adrian - male john - male mel - female how am i going to get it in the list as: adrian female john male mel?

It's a SQL database. I link it in Access to create queries, etc. U c, it's 2 different fields. I have normal codes and then a group which these codes belong too. Eg. table 1: john, adrian, mel. table 2: male, female. (Groups) I have to have them all in one combo box.

well, the tables are sorted. Let me try an example for you to understand: table 1: koos, john, piet. table 2: candy, mel. now i load table 1 in the combo and then table 2 in the SAME combo. I end up with: koos john piet candy mel What i want is: candy john koos mel piet.

I'm busy with a VBA application in Excel. I have a combobox on a form that where I have a to display a list of codes that comes from 2 tables in a database. I load the lists seperately into the combo box, but how do i sort it afterwards? I can't seem to find something that says: ComboBox1.Sort...