Recent content by raymondchen21

I left them in a folder in the common server. Yes people can see it and access it, but hardly people will go into the folder except me.

The size of three of my BE files is average 30K to 40K. The main BE file's size is the largest and it changes because I run delete and append queries on it every day. I always make sure it won't reach to the limit. If Jet/Ace backend is not the right solution? Do you know what is the most...

I also checked. They all set to default open mode to shared. I just attached a pic of the setting. I don't know if you can see it.

2010 I checked the fe and all be files after the error msg disappeared. Under the option setting, default record locking is set to no lock. Is this the setting you are referring to?

I checked the fe and all be files after the error msg disappeared. Under the option setting, default record locking is set to no lock. Is this the setting you are referring to?

Hi, If anyone had similar issue, I hope you can share your solution with me. I have been running a database at work for a couple months now that is used by over 150 people. Yesterday I split the back-end file into four back-end files because the original BE file is getting too big. After I...

I found this way. Is there any upside on doing it like this? Private Sub SelectAll_Click() Dim rst As DAO.Recordset, i As Integer Set rst = Me.NavigationSubform.Form.RecordsetClone i = 0 rst.MoveFirst Do While Not rst.EOF i = i + 1 rst.Edit If rst![Identified] Then rst![Identified] = False...

Hi, I have the following code to check all the boxes in the subform. I also want the date and the loginID to be recorded when the select-all button is clicked. The date column and the loginID column are in the subform. Can someone please tell me how can I integrate these: Me.EntryDate = Now()...

Thank you very much for the tip Cronk. It works perfect. How it allows me to check all boxes with one click. I like your idea as well. I will play around with the code and see which one works best.

After I done typing Me., it gave me lots of option. The name of the subform is on the list as well. After I changed it, now it showed run time error '13' Type Mismatch

Hi, I created a navigation form which has several tabs. Each tab has a subform attached to it. When I click on different tabs, different subforms will show. I will want to create a button to check off all boxes in the subform only when it's showing. I found the following code but when I ran it...

Hi, My name is Raymond. I have been using MS Access for couple months now. I started learning MS SQL at the same time as Access. I think my biggest weakness on using Access is that I don't have knowledge of the VBA. I want to start using more and more VBA code in my databases to make them more...