Search:

Hi, Good day to you.
I had ms access database table name called ‘Incentive’, I had 4 textbox, textbox1,2,3 for user key in the sales values and textbox 4 is sales target values (fixed 100.00).
...

Hi all,

how to insert correct value from ms access database to data report label ?


my report as below, only last one is correct.
the left side red box(label16,label17) value must match with...

Hi,
Good day to you..
is there anyway to get the value from the rpttextbox to label ?
i'm using data report.

error : object doesn't support this property or method

my code here, but it...

sorry, noted

Hi, Good day to all.

can any one help on this ?

i'm using microsoft access 2000, i have 2 database and 2 tables.

table 1 (name : users)
field : usedID,user,salesman,date1

table 2 (name :...

Hi,
i follow your suggestion, finally managed to solved.

thank you.

Hi,
i follow your suggestion, finally managed to solved.

thank you.

Hi,
thank you for your info, i only need to CHR$(27) symbol in prn file when i use printer.print method for send text to prn file.

refer below screenshot.

160223

160225

Hi,
good day to you.
may i know how to use printer.print to print <ESC> in prn file.

below output only have 1 dot (.)



Private Sub Command2_Click()

Private Sub Command1_Click()


RSCheck
rs.Open "select sum(qty) from out", cn, adOpenDynamic, adLockPessimistic
Text1 = rs.Fields("qty")

End Sub

Public Sub RSCheck()

cn3.Execute "INSERT INTO HMF (Code, [Number], [Date], [Time]) IN 'C:\hmf.mdb'" _
& "Select code, [number], [date], [time] From test.txt

thank you dee-u, it work!:thumb::thumb:

now my code is work fine.


cn3.Execute "INSERT INTO HMF ([Code], [Number], [Date], [Time]) IN 'C:\hmf.mdb'" _
& "Select [code], [number], [date],...

Hi,
why got syntax error in insert into statement??


mycode:


Private Sub Command2_Click()

Dim cn3 As New ADODB.Connection

Thank again for your help dilettante, I will learn by myself.

thank you for your code, just now i try, but unfortunately not a correct figure (quantity is 001)? correct figure quantity is 106584.

Hi,
if i want to sum all data in one columns is no problem, how about if i only want to sum selected row??
refer to below image file

my code:


Private Sub Command1_Click()

Set...

ok, i will try it, my i know how you create your Resource File in vb6 or how to open your project1.res content?

thank you so much for your demo dilettante, it really help me a lot, but i not familiar using the schema.ini file. if i want to use dataenvironment as a data source like you mention, how to do this?...

thank you for your suggestion, but to create the report from database (MS access) is no problem, if from text file i don't know how? can you show me the simple example how to create report (data...

Hi,
I already know how to import text file to datagrid,may i how to create the data report from the text file??

my text file content:
2310047019902,50,18/12/2013,08:24...

Hi,
im new vb6, this is my code, why got this error??

highlight Red got error: run time error 91 object variable or with block variable not set

database:MS Access
Field: User Name
data...

you right! tqvm doogle ,problem solved...

Hi,
im new in vb6, how to fix this error..

Database: MS Access
Field :UserID
Data type: Text
Field : Admin
Data type: Yes/No

Highlight error :Either BOF or EOF is true, or the current...

Hi,
anyone know how to update on runtime the combobox from textbox?
i write this code work fine only after exit the program and re-open again then will update the data from textbox.
...

re-solved already,the problem is the date formatted incorrect. thank you all of you guy ,especially si_the_geek your info help me solved this problem..

thank you for your quick reply, no more error msg already, but still got blank report??

Hi,
When i view my report got this error, runtime error '94' invalid use of null, but my database all have data?? if i use 'on error resume next' will blank report. Anyone can help me to re-solve...

my record data is from excel file..



Set cn2 = New ADODB.Connection

With cn2
.Provider = "Microsoft.Jet.OLEDB.4.0"
.ConnectionString = "Data Source=C:\wh_shelf.xls;" &...

hi,
why got this error message when i run the program.
error on red section

anyone help is much appreciated.

mycode:


Private Sub Prn2_Click()

Thank Rhino,now can print out already..but how to print all data?? and i don't know where to put my LabelFormat printing code on this:-

This code work fine.


DataGrid1.row = 0
DataGrid1.Col =...

hi,
Actually I want is when I mark checkbox [Print all] and click Print button then all data from datagrid will print out the barcode label and changing the data as I attach the file, i want is how...

Hi, how to use printer.print entire data in datagrid? this code is only can print
selected row in datagrid.

mycode:


Private Sub Print1_Click()

Dim i As Integer

Hi,
Now I only can print selected row from datagrid, how to print all row from datagrid when I click the checkbox (print all)??

see attachment

Below is my code for print selected row:


...

thank you for your reply and info, can you provide some simple example code for me to reference?
(eg: my excel file is book1.xls and mydata.mdb is my database)

hi,
Anyone can help how to write the vb6 code for import excel data to my database file (mdb), because my excel have more than 10,000.00 code to manually key in to my database file. Another...

hi,
now my code is delete all the rows Itemcode. If i only want to delete one of my duplicated Itemcode row?

textbox8 is connected to Itemcode column 0.



Dim del2 As String

If...

Thank for your info, solved..

Hi,
how to do when i click the cell datagridview1 in the same time will display
datagridview2 in the label5.text (in the same row)

my code doesn't work..any wrong?


Private Sub...

Hi,
Does anyone know how to delete the record then the deleted record will add to another table.

let said i want to delete record from table1 ID '3', description 'monitor', Qty '2'
after...

thank again shaggy, problem solved.