Recent content by SjCc

I was finding something onm goole and downloaded few stuff, meanwhile the system started behaving abnormal now the access db 2010 with format accdb is now showing like this abcfile.accdb.mass and even i changed the format and correct it to abcfile.accdb then it not opeing and shwoing the error...

Thanks dear should i use it same or change form name with my form name and field name as well ? or should use like GetData = Forms(strForm).Recordset.Fields(strFld) or GetData = Forms(searchins).Recordset.Fields(dr2)

Gasman could you please do it in sample i attached, as i am not getting it :banghead:

Copy paste menas have no expertise over vba coding !!! :D I attached error image which is again now after your suggesstion Please do me a favor that my form name is SearchIns and form field name is Dr2 please set all these in vba code you provided I have also attached a sample DB i want if...

I am getting this error as attached file.. or may be i am doing something wrong as i can only do copy paste in vba codes ... :D your help appriciated

Thanks for the reply indeed!! I will try it as per your instructions

Hi, I have a Function below, I am calling this in query and having error when form is not loaded or closed and i want that if form is not loaded then the query to show all records or in simple words should ignore this criteria without any pop up error message Function IsFormLoaded(strForm As...

Here is link waiting for your assistance too https://access-programmers.co.uk/forums/showthread.php?t=308538

Hi ArnelGp here is link waiting for your assistance too

Hi Dear, hope you are doing well I need your assistance in developing this at; https://www.access-programmers.co.uk/forums/showthread.php?t=308538

Yes no msgbox worked for me as per my requirement.. Thanks for the support indeed..

I have a command button named "Go_Set" in a form named "Payments" i want if the user forget to hit that command button which include an append query and refresh command the at the time of form close there need a pop up message box where if hits "YES" then this yes should hit command button...

Resolved after whole night wffort

Hellow there!! I have a table with field name Sdate (Short date dd-mm-yyyy) In the same table i have another field I_Months (Numeric field) now what i want that if i select todays date i.e. 12 Dec 2019 and select 6 in I_Months field means i want 6 rows to added in new table with month name...

Cant get your answer