Type: Posts; User: thedeathnotes210x
Search took 0.01 seconds.
April 12th, 2013, 08:15 AM
I have database in Access with Table Student (StudentID, StudentName, Address,Telephone).
And Excel file is missing StudentID.
Excel is including :StudentName,Address,Telephone.
November 27th, 2012, 10:42 AM
I am creating 1 textbox and 1 button. A button is open a file contain database (.mdb) and textbox is shown the directory.
Example : C:\ TEST.mdb
I want to copy the directory in the first time and...
November 15th, 2012, 09:08 AM
Dim diem as Double
If (ws.Range("F" & i).Value = NULL) Then
diem = 0
diem = ws.Range("F" & i).Value
con.Execute "INSERT INTO...
November 14th, 2012, 10:50 PM
I have to insert 2 way : if it exist or not.
November 14th, 2012, 08:54 PM
I am trying to use Insert Statement which is one of the field(format = Number) in Access = 0. My program does not understand data which is one of the field = 0. Can you help me to solve the problem....
November 12th, 2012, 08:05 PM
I am using INSERT statement to execute the program. And the error has occured : "Data mismatch in criteria expression". I am checking my database but I could not find the error. Can you help me to...
October 8th, 2012, 11:29 PM
2 Tables Access:
My Excel file include:
MSSV MaLop TenLop Ho Ten HanhKiem
I want to import data from access to excel.But I do not know...
September 26th, 2012, 11:08 AM
I have 2 problem in my homework. Firstly, I have convert ID field from AutoNumber to Number. I want to start ID = 1.Because I try to fix it but ID is starting 0. When I insert repeatly the second...
September 26th, 2012, 04:10 AM
Now I Stuck in FIND Statement because my homework is required if MSSV is update in the first time, the ID Number = 1. Then if MSSV is update the second time, the ID Number = 2 and the Status from...
September 25th, 2012, 09:24 PM
I can not use UPDATE Statement and I do not know Find Statement is working or not. Because I get the error "Syntax error in UPDATE Statement" .The code is as below:
Dim ex As New Excel.Application...
September 24th, 2012, 08:23 AM
I am stuck in Find Statement. You can help me using IF Statement.
Example : If MSSV is found, you use INSERT Statement
rs.Open " SELECT * FROM SV where MSSV ='", con, adOpenDynamic,...
September 20th, 2012, 09:18 PM
con.Execute "INSERT INTO SV(MSSV,MaLop,Ho,Ten,HanhKiem,User,Status,Date) VALUES ( _
'" & ws.Range("A" & i).Value & "', _
'" & ws.Range("B" & i).Value & "', _
'" & ws.Range("D" & i).Value & "', _...
September 19th, 2012, 05:03 AM
tenUser = tbUser.Text 'the user is logged in
Ngaygiodangnhap = Format(Now(), "dd/mm/yyyy hh:mm:ss AM/PM") 'Ngaygiodangnhap is date/time where the user is logged in
con.Execute "INSERT INTO...
September 17th, 2012, 09:26 PM
My Excel have just 5 value : MSSV,MaLop,TenLop,Ho,Ten,HanhKiem
My table Access have just 10 value : ID Number, MSSV,MaLop,Ho,Ten,HanhKiem,User,Status,Date.
I am trying to fix INSERT Statement but...
September 16th, 2012, 09:27 PM
On Error Resume Next
Dim ex As New Excel.Application
Dim wb As Excel.Workbook
Dim ws As Excel.Worksheet
Dim i As Long: i = 1
Dim con As New ADODB.Connection
Dim con1 As New ADODB.Connection
September 15th, 2012, 05:20 AM
I have a problem about INSERT INTO with 2 tables access.
My Excel file have a few paramater : StudentID, ClassID,ClassName,FirstName,LastName
My Access have 4 tables : Student, Class,...
Click Here to Expand Forum to Full Width