bluethunder
Last Activity: Jul 4 '11, 10:18 AM
Joined: Sep 5 '07
Location:
-
Thank you for the reply. Both link that you gave to me is for csv file. Is there for txt file? -
Is there any sample code so that I could follow it.Leave a comment:
-
Export Data to text/excel file
Good day,
I have a program where the report has a range before you can preview it. The user wants the record be export to .txt and excel file. Is there any idea how to construct it via code? -
...Code:Private Sub Form_Load() On Error GoTo LocalError Set rSConn = New ADODB.Connection rSConn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Payroll System\Payroll\DBPayroll.accdb;Persist Security Info=False" rSConn.Open Call AllData dtFrom = Format(Now, Date) dtTo = Format(Now, Date) LogUser = frmLogin.sTrLogUser Call CheckAccess Exit Sub
Leave a comment:
-
Object variable or With block variable not set
Good day,
I have a program that the user wants the record be filtered by cut-off date. After I pressed the command button cmdloaddata. I encountered an error message of "Object variable or With block variable not set". Can anyone help me to fix this stuff. Thank you...
...Code:Private Sub Form_Load() Dim rSConn As ADODB.Connection Set rSConn = New ADODB.Connection rSConn.ConnectionString
-
Possible to set paramaters in Adodc Control
Good day,
I would like to ask regarding the adodc control. Is it possible that I can set a parameters in its command text SQL? -
Adodc filter function
Good day,
I'm having a problem with the filter function of adodc. I tried to filter records according to date range but I'm having an error message of "No value given for one or more required parameters"
This is the command text SQL of my adodc object
Code:select * from pr_dtl where cut_off_date_frm = ? and cut_off_date_to = ?
-
PasswordChar in Datagrid
Good day,
I'm having a problem of displaying records that has a password. I want to display it in data grid as a password char like asterisk(*). I don't know what should code that I must use. Is there anyone who knows about it? -
Error in updating records
Good day,
I'm new with adodc, I made a program and I imitate the behavior of adodc into command button to have a browse view of data using data grid and form view. After I update the 2nd record and so on, the 1st record has been overwritten. I don't know where the problem is, can anyone give me a proper codes that I must use. Im using Data Environment SQL command for my connection to its table. -
problem solve.Leave a comment:
-
Problem solve on my own..Leave a comment:
-
How to refresh the Crystal Report?
Good day!
I'm having a problem with Crystal Report in printing the record that I want. I notice that it works only for one record once the program loaded but when I tried to print for another record it shows the same record that I previewed a while ago. I want to print another record without closing it again so that the time of accessing the program will be lessen.
Is there any string or command that I must use to refresh... -
I'm using Data Environment command for the connection of my program to its database.Leave a comment:
-
Can't display text in report footer
Good day!
I'm having a problem with crystal report. I want an output to be displayed in report footer but it doesn't work. I don't know what's the problem. I'm using VB 6, Access 2007 as my back end.
Is there anyone who can help with regards in report footer function. -
Report footer problem
Good day!
I'm having a problem with my report footer. I want to display text in report footer section but it only show's the sum of a number. Is It possible that I could display a text in report footer section? How will I do? I'm using VB 6, Access 2007 as my back end and Crystal Report 8.5 for my reports.
Thank you for those who will help me. -
file could not be found: "Rpt", at file location: "Rpt"
Good day!
I'm having a problem with my program with regards in reports. I'm using VB 6, .mdb as my back end and Crystal Report 8.5 for my reports.
After I input the required data and press the print button, it gives me an error of:
error opening file
file could not be found: "Rpt", at file location: "Rpt"
I don't know why the error occurs. Is there anyone who can... -
I already figure out what is the problem.Leave a comment:
-
bluethunder started a topic How would I set more than two parameters in SQL statementin Visual BasicHow would I set more than two parameters in SQL statement
Good day!
I'm having a problem with my program with regards of retrieving the data from the tables. I'm using VB 6 and Access 2007 as back end. I'm using the Data Environment SQL statement command when I tried to set more than two parameters it gaves me an error of:
"The specified field 'brandno' could refer to more than one table listed in the from clause of your SQL Statement"
...Code:select
-
Thank you debasisdasLeave a comment:
-
Search as you type in combo box
Good day!
I have a program using a combo box that has 200 records from the table. The user wants to be more convenient in searching the data by searching the word and it will populated the record that has the keyword that you inputted.
Can anyone can give a hint or sample codes for search as you type in combo box?
No activity results to display
Leave a comment: