Search results

My designs include access to temp tables and queries for manipulating data and pulling data from queries to excel. I'll have to work on some redesign. I do use some of the items you noted remove full menu and other abilities. read only is not an option since the user not able to modify the data...

Hello: I forgot about this option for ACCDE I use to use MDE's back in the day. However this option does not protect changes to queries or tables. Is there way to lock down these items as well? Thanks for the help. Tracy

Hello I wanted to lock down my code base in the ACCDB access database but I need the user to be able to hit the linked tables however when I change the ACCDB to ready only the "import" functions are disabled. What is the recommended practice to lock down the front end code base while...

I will keep Mark's suggestion in mind, the date will always be the end of a specific month but the day I generate the reports varies based on when the books closed, so I will consider this in future or for other needs but for now I think using the table to prepopulate the end date on the form...

Perfect The on load worked Thanks for the help Private Sub Form_Load() Me![txtLastDate] = DLookup("[Enddate]", "tblDivRptDates") End Sub Tracy

out for meeting going to try to give it a try tonight, thanks for the help

I thought the quotes were around the table name is the argument right with the Me? I am primarily an Accountant never get enough time to dig deep into this fun stuff. Private Sub Form_Open(Cancel As Integer) Me![txtLastDate] = DLookup("[Enddate]", "tblDivRptDates") End Sub

I did create table and wrote sub routine to match my table and field name inserted on the form open command. I usually put events on load option maybe I should try that. I use the FMS Total visual agent to schedule and run these reports from 10-15 access databases and in the past I changed the...

Thanks Paul

Hello I am Accountant and System Admin/developer who has been using Access for 15+ years in Pennsylvania USA. I use Access to automate accounting tasks as well as for reporting. I have aprox. 25 Access systems I have built to automate routine accounting tasks and several robust Access reporting...

I am trying to determine best way to default a specific date onto a form, where they date will change each month for reports I generate. I tried using the sub routine from Poppa Smurf but it's not working error says there is a null. Any suggestions. I have the date in a table, I want to call...