Search results

Yes frm_Function_T is the main form. I am writing the code on the Edit form. I tried this thing as well but still getting the same error message: If Forms!frm_Function_T.Dirty then Forms!frm_Function_T.Dirty = False End if

No I am not in this form but in a form upon this. That's why I have used this: Forms!frm_Function_T!lstDue.Requery Forms!frm_Function_T!lstOverDue.Requery

Its unbound form that's why the code updates the records. Not sure why this error message is coming up?

Hi Guys The runtime error "You Must Save Current Field before you run Requery" error message . ANy help will be much appreciated. Private Sub cmdSave_Click() 'Me.txtHidden.SetFocus Dim rs As Recordset If ValidateForm = False Then Exit Sub Set rs = CurrentDb.OpenRecordset("SELECT * FROM...

Figured it out. No backets in this. :)

Hi All What's the problem in the below msgbox line. Can't figure it out. It comes up in red line in vba code. Don't know what I have done wrong in this. MsgBox ("Review Date can not be earlier than DateSignedOff",vbCritical+vbOKOnly ,"Date Validation") Thanks

Hi Guys I haven't worked with charts on Forms before and I am given a task to make a minor change in the already existing chart in Access Form. Please see attached the chart. The rowsource property of the chart is set to as below: SELECT tblstaff.[Staff Name], Sum(IIf([DateComp] Is Null And...

My question is how to display the total on the top of each bar. DO I need to change the rowsource ? What else I need to do? Thanks

Hi Guys I haven't worked with charts on Forms before and I am given a task to make a minor change in the already existing chart in Access Form. Please see attached the chart. The rowsource property of the chart is set to as below: SELECT tblstaff.[Staff Name], Sum(IIf([DateComp] Is Null And...

Thanks. It worked.

I am getting Object doesn't support this property or method error at red font line. I just want to check through loop that if all the controls are null or not. Any help will be much appreciated. For Each ctr In Me.Controls If ctr.Value = "" Then i = i + 1 End If Next ctr

Hi Guys Just trying to build timeline management system using Access /vba so need your help how can I build a simple timeline system that manages attendance/overtime/working hours etc. Thanks

Hello Forum Gurus I desperately need ur help in this. In my company earlier we were using Windows XP and the VbA code that I had written in excel used to work perfectly fine with SendKeys{TAB} statements. But now we are moved to Windows 7 and this doesn't work anymore and sometime NUMLOCK...

Hi Guys I have a table that stores ID,PolicyNumber,NewPolNo fields.It has millions of records. The field NewPolNo is empty. I need vba code that will check the following for each record: 1. If the length of the PolicyNumber is over 14 characters long then store that PolicyNumber value in...

yes u are right. sorry I missed out 223344. Please see attached again Table3 results

Ok Mark. The reference number of Table1 should be present in the beginning of Reference number of Table2.. e.g Table1.Reference like Table2.Reference & "*" or we can use Table1.Reference =Left(Table2.reference,len(Table1.reference))

As I can't upload access database so I have made a sample workbook as attached . Please have a look. Thanks

Thanks guys for your help. There is one more condition here. In Table2, Reference field contains data with some extra digits. So we need to use like operator. e.g Table1 Reference data is 12893,234982, 3377660 but Table2 Reference data is 12893000000,12893776600,2349826666000 etc.. so we...

Hi Guys I have got 2 access tables named Table1 and Table2. There is one field common in both the tables and that is "Reference" . So I need to match the data in Reference field in both the tables using VBA. steps to perform: 1. Check each Reference in Table1 against all the values in...

Thanks Uncle Gizmo but I can't find any solution to my problem in that thread. I want help in the code as I am not very good in that.