thanks!...
but ill tried that before...
want the value1 to value4 will vary, can i do this.
INSERT INTO table_name(fiel d1,field2,field 3,field4) values ('value1.text', 'value2.text',' value3.text','v alue4.text')
thank you!
julius...
OldSchool
Last Activity: Jan 12 '07, 06:37 AM
Joined: Nov 11 '06
Location: Dasmariñas, Cavite
-
Can you Translate this to SQL????
everyone can you traslate this to SQL... instead of ADDnew use INSERT
Private Sub Command1_Click( )
With Adodc1.Recordse t
.AddNew
!fldIDNUM = Text1
!fldDATE = tim3
!fldTIME = Time
!Name = Text2
!Position = Text3
!ShiftCode = Text4
!Line = Text5
!UpdatingOffice r = Text6
.Update
... -
Thans mary, but there an erro about Refresh, well anyway i'll try to fix eat, but if i cant , may be i'll go to you ... thanks Godbless you
julius...Leave a comment:
-
SQL in ACCESS and VB6
PLS.... Help!!!
--------------------------------------------------------------------------------
hi commnunity
i have problem with sql,
i have created a table in Access Named TABLE1 in TABLE1 i have EmployeeNumber, Section, Posotion;
i assigned EmployeeNumber as text1.text
Section as text2.text
Posotion as text3.text
i have buttons name ADDrecord,
here... -
PLS.... Help!!!
hi commnunity
i have problem with sql,
i have created a table in Access Named TABLE1 in TABLE1 i have EmployeeNumber, Section, Posotion;
i assigned EmployeeNumber as text1.text
Section as text2.text
Posotion as text3.text
i have buttons name ADDrecord,
here is my code:
Private Sub Command1_Click( )
Dim EmployeeNumber... -
HoneyWell RFID
Good day!
I have problem dealing with Data recieving through use of RFID scanner. the Scenario is this, im going to scan the RFID and I will Recieved a Data from it and i will compare it in database.
how can i compare the TIME i scan using RF ID, in Real TIME base on Data Base Same with the Date;
Can you Site a COde?
Thanks in advance
Julius -
you need to have table of the information of your existing person who listed,
First you need to learn SQL here is the best site www.w3schools.c om...Leave a comment:
-
thanks!
for example;
i have a table created in MS ACCESS;
Can you site a sample code using ACCESS and SQL?
thanks...Leave a comment:
-
Thanks!
it is just a support not a real stand Alone Program?...Leave a comment:
-
hi,
this site will help you in our SQL programming need, hope it will helps
http://www.w3schools.c om/sql
Julius...Leave a comment:
-
NEW to SQL
hi everyone
right now im searching SQL. iwant to study about it. but IM a PLC programmer i dont have background in Database can you help me.
i have a question.
Where can i gprogram SQL what are the software?
Creating database in Access is SQL? -
ok,
I have RFID scanner then i'll go to scan the ID, how can i Get the Data from RFID.
For example the Time, i will COmpare the time that i Scan the ID and The Time in Database. How can i Code that? do you have any idea?
Hopeng for your responds
Thanks
julius...Leave a comment:
-
Problem
Good day!
I have problem dealing with Data recieving through use of RFID scanner. the Scenario is this, im going to scan the RFID and I will Recieved a Data that is Mscomm.input and i will compare it in database.
how can i compare the TIME i scan the RF ID in Real TIME base on Data Base Same with the Date;
Can you Site a COde?
Thanks in advance
Julius -
Thanks!
Big help to me. coz as of now im just a beginner in vb. thanks for the support.
From where country you are if you dont mind?
Julius...Leave a comment:
-
Sir i Highly appreciated your kindness, Sir can you out Comment in the code you given to me if you dont mind sir...
Thanks
JuliusLeave a comment:
-
OldSchool started a topic How to compare the mscomm data recieved using RFID and Compare it with my Textin Visual BasicHow to compare the mscomm data recieved using RFID and Compare it with my Text
Sir its me julius,
Sir how can i compare the mscomm data recieved using RFID and Compare it with my Text data.
Sir example.
Private Sub MSComm1_OnComm( )
Text1.SetFocus
' STX Data ETX + Cr
Text1.Text = MSComm1.Input
MSInput = Text1.Text
End Sub
How can i compare the recieved Data to TextData ?
Msinput is memory right?... -
VB6 VS. Microsoft Access
Guys,
Thanks for the Reply i recieved from one of our Buddy here in Community.
Question REgarding Coding of VB6 and Access
1. Are they same when it comes to Coding?
2. Can i Copy and Paste the Coding From Access to VB6?
e.g The "Add" Command of Access ?
On Error GoTo Err_Add_Click
DoCmd.GoToRecor d , , acNewRec
Exit_Add_Click:
Exit... -
Thank You Sir, for the Code you gave me... Thanks Again God Bless U...
Julius...Leave a comment:
-
Rs-232 VB6
Sir,
I have my project its a Barcode System, since i dont know yet how to use RS-232, My question is:
1. RS-232 is only for Sending Date and Reading Data? its just for open the MScomm port and Settings.? How can i interface it in VB6 Programming?
Sir,
can you give explanation of these code:
MSComm1.PortOpe n=True
Ms.comm1.Settin gs=9600,n,1,8
...Leave a comment:
-
Thank you sir for informing me.
Julius...Leave a comment:
No activity results to display
Leave a comment: