Search results

hi again everyone. i didn't post quite a long time. been doing great with ms access 2007. and moving on, i need help on reading text file, line by line and storing them into separate string variables... i have this text file: "E:\Data\Access\connection.dll" and it contains 4 rows: 102.16.21.14...

I have been searching for examples from all searches but i could not find what i was looking for. i found a few regarding continuous form data but its not the sample that fits. attached here is my screen shot and my accdb file (MSAccess 2013) all i need help is how do they populate unbound...

basically, i wanted to post a data from an msaccess to ms excel using msaccess 2007 and ms excel 2007. first question is, i wanted to post the main form data into formatted excel and the sub-form data below just like the data appearing from the main form here is the msaccess data: and here...

MS Access 2013 Adding Data Using VBA On_click function. Any help is highly appreciated. Runtime Error '3265' "Item not found in this collection" Produced by the code below (OnClick Function) Option Compare Database Private Sub cmdPost_Click() Dim dbASP As DAO.Database Dim rsASP As...

Payroll main form to post attendance record. Before I open the attendance form, I wanted to check if there is a record in the sql statement. The code below produces error MS Acces object "Variable or With Block Variable Not Set" Private Sub cmdPostAtt_Click() Dim stSQL As String Dim dbHBK As...

Inserting data from History Table LIKE "P" Type into Preventive Maintenance Table and LIKE "R" Type into Repair Table. I don't quiet get it because it says "PM Data Update" but nothing happened. Below is the code: Private Sub cmdUpdate_Click() Dim strSQL Dim dbMNT As Database Dim rstHist As...

Done with the Equipment Management Systems. Thanks for the help. I am now in the payroll system. I would like to know how to automatically import biometrics data into VB-MSaccess procedure, if there are samples then it would be great help. right now, I designed the data to manually input in an...

I have a terrible skill in this but I am doing my best to find ways. But I am running out of time in the development stage. I have the following form and table: Tables: Eqpt EqptHistory Forms: frmEqpt frmHistory frmEqpt is the Mother form and frmHistory is the subform connected thru eqptID...

I have encountered PC Lockdown when I tried this onClick Code. I am trying to post a data from MSAccess field into a specific cell in Excel. The Excel File is formatted already as document. It is submitted for Attendance records. But I couldn't find the problem and fix to automate it properly...

My name is jing and I'm a user of MS Access 97 from 1998 to present. Several Database had been developed and helped a lot in my co-workers. And now Learning thru Access 2010 as front end and MySQL as backend to adopt the current technology ^_^ Nice to meet you all.:)