Search results

This site was closed for update, hence I had to go elsewhere.

Thanks a lot!!!!!! MAY GOD SHOWER HIS CHOICEST BLESSINGS ON YOU!!!!!!!!!!!

Replication of DB has been totally eliminated in Access 2013. Is there any substitute for it?

Isn't there any way to check in the present structure?

The problem is that by entering Dept & Allocation separately many mismatches occur. Hence I want Allocation to be entered and the corresponding Dept. will automatically be taken from the table (ALLOCATION). For this purpose I made the query for the form. But Dept field in table (DEPARTMENT &...

In the attached DB I have to enter dates in the field REMARKS. I want to ensure that the dates are entered in the format dd-mm-yy and that the date is not less than today's date. How to achieve this?

I put Me!Dept = Me.Dept in after update but it is not working in the attached DB.

Thanks a Lot! GOD BLESS YOU!!!!!!!!!!!!!!!

In the attached DB when I type allocation the Dept. automatically appears. But I also want DEPT in Tbl_ALLOCATION-I to be updated simultaneously because all my queries are based on this field. How to achieve this?

Really I want to make a backup of a database which is on another PC on my N/w. Instead of copying all the objects of the database I want to import only the changed tables. But before importing I need to delete the old tables. I want to do all this through code.

I wrote the following code for deleting tables: Function rib() On Error GoTo Err_Command4_Click DoCmd.DeleteObject acTable, "REGISTER I M F" DoCmd.DeleteObject acTable, "DEPARTMENT & ALLOCATION" DoCmd.DeleteObject acTable, "CASH OFFICE" Exit_Command4_Click: Exit Function...

Thanks a lot. GOD BLESS YOU!!!!!!!!!!

Thanks, it worked. GOD BLESS YOU!!!!!!!!!!!! Will it work on any PC having different date format? Also if I want to change the format of #12/31/2019# to dd/mm/yy how do I do it?

Please tell me what changes need to be made to the above code in order to achieve the goal?

Thanks. One problem with date is that on my system the date is in dd/mm/yy, when I write the code the date in hash automatically changes to mm/dd/yyyy. If Format(DATE, "dd/mm/yyyy") = #12/23/2019# Then MsgBox " HAPPY NEW YEAR ", vbExclamation, "Greetings:" End If Hence even on 24/12/2019 it is...

Thanks, GOD BLESS YOU!!!!!!!!!!!!! WHERE ARE THE SETTINGS TO ENABLE MACROS OF A DATABASE???

Please give me your final decision.

Thanks, GOD BLESS YOU!!!!!!!!!!

I have the following code on the Onload event of an opening form: If (DATE > "31-12-19") Then MsgBox " HAPPY NEW YEAR ", vbExclamation, "Greetings:" But it has already started giving greetings on some PCs of the local n/w. This may be due to the different date formats on those PCs. How to solve...

I have changed my OS from Windows 7 (32 bit) to Windows 10 (64 bit). When I run my Access 2013 (32 bit ) databases on this 64 bit OS I get errors like "32 bit encryption", Macros cannot run, etc. How to solve these problems?