Search results for query: *

10/1/22 I want to discourage a couple of employees from stealing our Access database. One of them did so years ago. And use it for himself. I want to make a simple login method. Nothing fancy. Nothing fool proof. Just to make 3 employees think they cannot get inside the file unless they...

8/19/22 I have read many posts about this topic but wonder, which is the best one for me. I have an Access database and need protection but do not want anything too complicated. I am thinking, give me ability to change the password say every 3 months. And prevent someone hiring a knowledgeable...

I think I figured it out. It works. I do not get the 9 questions. Fast. If you see an improvement, please yell. Glen. Private Sub cmd3010M_Click() '9/12/2020 VBA code Glen DoCmd.Hourglass True DoCmd.SetWarnings False 'MAKE TABLES DoCmd.OpenQuery "Qry3010B", acNormal, acEdit...

I have a good working Form button. However, I am asked 9 times to answer YES when 3 queries that are inside the button, ask like, you are about to override, etc etc. A dialog thing. The 3 queries create 3 make tables. I will always answer yes. Is there a way to permanently lock in the YES...

Duane - thanks so much. You are terrific. I used your link to MSoft. Says it just fixed the Zoombox issue today. https://support.microsoft.com/en-us/office/access-crashes-when-opening-zoom-box-with-shift-f2-853718bd-a341-468c-924e-af0b57d3fa0d Then I picked the blue at the bottom of the...

I have the following in a text box on a Form. I can enter the data but when i doubleclick to open the zoom, i am kicked OUT of the file in the Windows 10 Lan. This text zoom box worked for fine for 10 years. thanks you for your advice. Private Sub txtResNotes_DblClick(Cancel As Integer)...

Hold off. I see RestypeID in 2 tables. I think there is a design error. Trying to do too much. Thanks for convincing me. Glen

Thanks Skip. I have combo field cboResTypeID on the main form called frmReservation. I might select code 19 for the reservation type Below this cboResTypeid field, I have a combo field called cboTripID on this same frmReservation. I hit the pull down button on this cboTripID. I move my mouse...

This is the part that gives me trouble. ([tblTravelMain].[ResTypeID])=14 Or ([tblTravelMain].[ResTypeID])=16,

I have a query criteria combo box to use for choosing a Trip. All works well except for one condition. I would like cboResTypeID 19 to use the trips for codes 14 or 16. I get nothing if i use code 19. IIf([Forms]![frmReservation]![cboResTypeID]=19,([tblTravelMain].[ResTypeID])=14 Or...

2/5/2019 For the past 3 days, no crashes since I told our person not to open two copies of the same file. He was doing a search of a record, looking at the record in Jones.accdb, get's another phone call, did not want to cancel the screen that he was on, so he clicked on the desktop icon to...

Just found a worker opening the Access file up twice on his computer. Then he searches for records in each. I assume that this is bad. He crashed us today. Is there anyway to prevent the person from loading up the same file (let's call it Jones.accdb) on his computer?

I have Access 2010 on a main server and 6 stations. Using Windows 2010 ver 1809. We bought 2 new machines. Put Office 365 on each. Copied the Access 2010 accdb file onto one of the office 365 machines and it works fine. If we linked the 2 new machines into our tiny 2010 server, will...

Sorry for being so dopey. It works. I forgot to pick something. Operator Error. Thanks guys for helping me out. Cimoli Glen

12/14/18 I get an error message. It says "undefined function Dlookup in expression. glen Here is what I have on the events button: Private Sub cmd1171_Click() On Error GoTo Err_cmd1171_Click Me.Refresh Dim sReportNameSpl As String sReportNameSpl =...

We have had Access 2010 crashes often the past 18 days. 3 times, all the qry, forms, reports, mods etc disappeared. And the tables were suspect. This started when we got rid of 3 computers and added 3 new ones with windows 10. We have 1 server and 6 workstations. I have read about 2 Access...

Hi Duane - Lol. We have many resort place and they tend to request their report format. A pain in the butt. So we have one qry that fits all but say a need to retrieve 40 different reports depending on the resort. I use a number system for my work. The form buttons use the same button. I...

I would like to replace the Dlookup that appears in the On Click Events procedure. The purpose was to lookup the report name for a given place. Instead, I have figured out how to get the desired report name to appear automatically in the same form in a Text Box using ...

12/2/18 Hi Curly. It is a netgear GS605 box. Small gadget with 5 plugs in the rear. When the 2nd owner gets back, we want to find out how he programmed the phones to shut down at 5 pm and then they go automatic for receiving incoming calls after hours. When we get our problems around 4 pm...

Curly - thanks for the good thoughts. I saw an internet article about needing to make IP fixes for such a Comcast phone which we buy from them. Poly something phone. A good BestBuy fellow said something that matched my thoughts. We plugged the normal Cat5 lan cable only into the PC. In this...