elbatz
Last Activity: Jan 3 '08, 05:47 AM
Joined: Dec 26 '07
Location:
-
Thanks a lot.It works!! -
How to put Input mask in text box
Hello.Did anyone here know how to put an input mask to a textbox. for example only a phone number must be inputted like '(063) 123-4567' do I need to code this one? -
this is my code using data environment in search function.How do I convert it in ADO Codes?Code:Private Sub Text1_Change() DE.searchBookCode Text1 & "%", Text1 & "%", Text1 & "%" DataGrid1.DataMember = "searchbookcode" DE.rssearchBookCode.Close End Sub
Leave a comment:
-
I am trying to create a search function in which if i input string in text box such as
Macapagal as surname then it will show all the lists from table1 in access showing those records having a surname Macapagal.Those record will show in datagrid.Leave a comment:
-
Creating search function
Hello there..need help how to create search function in text box to search records from access database using vb6..thanks a lot -
table2.field1 linked to table1.field1
thanks...Leave a comment:
-
DELETE Statment Problem in VB6
Does Anyone know how to code this example in DELETE STATEMENT?
Table1 , Table2
field1 , field2 , field1 field2
22 , aaaa , 22 , aaaa
22 , bbbb , 22 , cccc
22 , cccc , 22 , bbbb
33 , ssss , 33 , ssss
33 , xxxx... -
Check whether records exist in Access table
Can somebody help me? How do I know if records in Table1 are also in Table2, using VB6 code?
For example:
If Table1 has 1111 in column1 and also Table2 has 1111 in column2
msgox "Existing record in Table2"
else
msgbox "No record in Table2"Last edited by Killer42; Dec 28 '07, 06:08 AM. -
How to Delete records (Access/Excel)
Hi! Does anyone know the code of how to delete records in access using excel as reference.
example:
Delete * FROM table1 WHERE table1.ID=excel file.ID ?
Thanks -
Here's an example: I have a database BillMatch w/ table Bill. excel files to be exported to Bill.mdb are TB111.xls, TB222.xls, TB333.xls and so on. column1=Bill# ,column2=Name.
I am going to insert the records from TB111.xls sheet1 and other xls file to Bill.mdb..Now, what if I am going to insert again the records from TB111.xls because TB111.xls has been updated having only 1 Bill# = 111. The records from Bill.mdb having Bill# =111...Leave a comment:
-
sorry for unclear question.i am creating a vb6 project which transfer records from excel to access. I have read some threads that shows how to transfer the records and it works in my project.My only problem is..what if the data from excel already exist in access table and therefore it shoudn't append to the table or else the old records in access table will be replaced by the records coming from excel worksheet.by the way i/m not using primary key...Leave a comment:
-
I mean using VB6 codeLeave a comment:
-
IF..Else statement in sql.
How can i make an if else statement where the condition is in sql.for example:\
if data exist then
delete the old and insert the new data
else
insert new data.
Thank you. -
Need Help excel to access conversion using vb6
Hello.Does anyone here know how to convert or export data from excel to access database having an existing table using visual basic 6 codes?
And if that data in excel already exist in access database it should not be inserted or maybe the old records be replaced.plss help me.i do not know how to code it.it's urgent..thanks a lot..
No activity results to display
Leave a comment: