good day everyone! how can i distribute the exe application w/o using package and deployment wizard? i just made it executable. the problem is the the database path changes because i did not use the...

hi, the one you provided is about scripting, but anyway, thank you for giving some suggestions. it can help. i am focusing on excel visual basic automation. thanks....

Here is the idea, i have an excel file which contains data(say excel1). In my visual basic form, i have 'locate file' button, (for locating excel1). After i locate excel1 for whatever path it is...

hi there, i am new to excel VBA. can anyone help me how to copy all the data in excel to another excel sheet by means of visual basic. for example excel1 and excel2.. after i locate excel1, then when...

ok, thank you.. i'll update you soon...

ah ok... here is the manufacturer. MySolutions Inc, model: T4 Classic.
MySolutions Fingerprint Time Recorder System, Touchlink.
thank you very much for time and responses..

you mean i won't be able to do what they are referring to? is it possible to program it by using visual basic? i got the user manual. but where do i start? hayy.. how i wish im a professional.. but i...

ok, thanks.. after that? could you give me sample outline for me as guide, then i'll do research for the rest.. thanks

thank you for the responses. we already have the thumbprint scanner here in the office, and it is used already. i am new employee and they thought i can program the data, but actually i am new when...

the one i am referring to is thumb print scanner.. what would i need to manipulate the data.. have no any idea about this.. thanks

Hi everyone! is there anyone has an idea on how to incorporate the biometrics scanner (time in/time out) with visual basic. For example, what would I need (devices, component, software, etc.etc..)...

thank you.. it worked!
God bless (",)..

good day everyone! is there any idea on how to set the picture property of the Data Report's Image Control based on the Form's Image Control?

this code doesn't work:
...

good morning, i have successfully saved the picture together with the data by this code:

Private Sub cmdSave_Click()
Dim picsm As ADODB.Stream
Set picsm = New ADODB.Stream
...

hi everyone, i have successfully saved the image file to DB by this code:

Private Sub cmdSave_Click()
Dim picsm As ADODB.Stream
Set picsm = New ADODB.Stream
picsm.Type =...

ok, thank you. already found it, its a reference, not a component.

ah, it's a reference, not a component, i've found it.
anyway, thanks, thanks....

ah ok, the one i am using is Microsoft ADO Data Control 6.0 (OLEDB), i thought it is similar to the one you said. but how could I add these component? is it in VB 6.0? or not? thanks for the reply

Where should I get the declaration ADODB.Stream Object?
as far as i know, ADODB library has only 4 objects: Command, Connection, Recordset & Parameter.

I need this object for the Image DB.
thanks

JUST TRY THIS.

sqlUpdateUserQuery = "SELECT * FROM tblUSERS WHERE UserName = '" & UserName & "' "
Set rsUpdateUserQuery = New ADODB.Recordset
rsUpdateUserQuery.Open sqlUpdateUserQuery,...

ok, thanks.. what about ADODB.Stream.

how could I add ADODB.Stream in declaration? as far a I know, the ADODB library has only 4 objects:Command, Recordset, Connection & Parameter.

try to add " & Text1.Text & " instead of " & Text1.Text

good evening:

how could this code be fitted to the above code (to what i have posted)..

for example, in my form i have imgPhoto in the form, having UPLOAD Picture button, then after locating...

what's wrong with the code, it doesn's display the data based on the SQL query:

Private Sub cmdSearch_Click()
On Error GoTo Notfound
squery = "": squery = "Select * from...

try to insert report textbox on the data report then set its Data Field Property to the database field name

as what you have said, on the SEARCH comman button. dgGrade is just name of the datagrid control. make some edit regarding the statement I have posted, try to edit, add/delete some statement,...

just try :

Dim squery as String
Dim conn as ADODB.Connection
Dim Cm as ADODB.Command
Dim rs as ADODB. Recordset

squery = "": squery = "Select * from tblGrade where StudentNumber=" &...

Hi everyone, is it possible to add/edit/save picture in MS Access DB using ADO, I have this code

If (MsgBox("Are you sure you entered correct data?" & vbNewLine & "Save now?", vbYesNo +...

thread closed. already found the solution. thanks...

but wait, .Edit is neither method nor data member of ADODB Recordset.

good morning.. thank you for the reply!

i just forgot the ".Edit" command.

i am using SQL UPDATE statement with this syntax:

UPDATE tblEmp SET LName=" & txtLast.Text & ",FName=" &...

hi everyone. i have problem with SQL UPDATE command, with Add and Save Record, Delete Record and Search record, it works well, I have this code:

for SAVE Command button

squery = "": squery =...

hi everyone, i just want to ask if it is possible for the SQL INSERT INTO to LOOP? for example, insert new records in TABLE ten times with the same values (colum1,column2,column3,etc..) is there an...

Private Sub Form_Activate()
Form2.Label1.Caption = Form1.Text1.Text
End Sub

hello to everyone.. i just wanna know if somebody knows how to connect coin slot machine to the pc's parallel port.. or any idea, concepts, you can give me. thanks for all the responses. i will...

hello there everyone! i just want to ask if what would be the process of copying data coming from the excel worksheet to a vb database? so that no need to encode data in the vb program, just insert...

have a nice day! what about a sample idea or tutorial about corporating touch screen monitor with the software application. for example, a vb application.. thanks!

can anybody having touch screen coding. i have to invoke touch screen through vb and fetch and display the corresponding details from database based on user touch. so please help me regarding....

hello to everyone! can you give some websites containing tutorial or the basics regarding a system with touch screen monitor or with bar code scanner.. how could that be provided, things to be...

i am doing a project, and i am not that good in database. pls help me to solve my problem regarding my thesis. i know how to mainpulate controls in visual basic and other aspects, but with regards...