Search results

Thank you. I have made that one. But everything is locked. What I mean is, first the routine should count the number of records, and only those records will be locked for editing and not the entire Recordset. I am Using Access 2010 by the way.

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...

Ah ok its like this one... That current Example is on the Main Employee Form. and there is a subform for Attendance that has 13 columns in data sheet format that has records of up to 31 days depending on the data entered in it. All I understand is a recordcount command and the rest is I cant...

thanks its now working fine. Can you help me with the data in a subform to paste in excel? its these thing: xlApp.Range("C5").Value = Me.EmpNo xlApp.Range("D5").Value = Me.EmpName xlApp.Range("D6").Value = Me.PayrollPeriod xlApp.Range("E7").Value = Me.PayrollCutOff...

It does run on MS Access97 now I include Microsoft Excel 2007 in the VBA reference's and also replaced Microsoft Jet 4.0 with microsoft Jet 3.51 but The Excel won't close after posting the data. It now fits in the specific cell. I'll post again. Thanks for enlightening me with VBA codes. I can...

thank you pwbrown for the quick reply. Still the screen freezes and I have to press the reset button everytime i click the command button. Private Sub cmdRequery_Click() On Error GoTo Err_AttSum Dim xlApp As Excel.Application Set xlApp = CreateObject("Excel.Application") With xlApp...

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...

I have the same Issue but mine is Access97 and excel 97, we haven't migrated to the new msoffice yet, so we have a 3.51 DAO. But It seems fine. I just couldn't get the explanation from which the field EmpNo be placed in an Excel Worksheet Cell C5 and EmpName to be placed in Cell D5. And the...

I have the same problem as you do Rale. It's been affecting all users since the patch of Windows XP to SP3 and the windows 7 Ultimate. Like you, I teach the End-users to first rum MSAccess, then open the Shortcut through it. However its a hassle. My co-employees didn't like it. So this is the...

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.:)