Search results

This is the link. Everything is copied verbatim and pasted to my Swithboard form "Switchboard". This my main Opening Form and Menu. I did not see any function calls, therefore, did not copy any modules. I have no idea how to check missing references on a machine. Thank you.

I copied the code verbatim from the examples triggered On_Load. I tried running code as is and there are more errors with the variables coming up. I did copy and paste the cmdRestore button and the on_click code and pasted into my form "Switchboard", however the on_load event event code errors...

Control the Application Interface This is the information from the link you provided for the download below. Hope, this helps. Thank you. Version 3.44 Updated 14/01/2020 This...

Thanks, DBguy, posted the code to the above Post. The database is already split and would need to combine FE and BE to zip the whole DB. Thank you.

Found the correct thread. Apologies, for posting here.

Getting an Error Message Compile Error: Method or Data member not Found, for this part of the code - Me.cmdRestore.Caption = "Maximize Form". This is for to hide the Access App Window On-Load. Could anyone help me with this? Thanks in advance. Private Sub Form_Load() On Error GoTo Err_Handler...

Pat, thanks! Good article and will implement some of the ideas.

Doc, thanks for confirming that. Learning a lot about multiuser environment efficiencies. Yes, I'm having overhead issues updating the dashboard. The application is used over the internet via VPN from home users and in the office on a network. I'm trying to find the best timer setting that...

Pat & Isaac, Thanks to both your suggestions. I used the following code: Sub Form_Load() Me.TimerInterval = 20000 End Sub Sub Form_Timer() Me.Requery End Sub Works really well. Prior to this, I thought any of the desktop FEs would send a requery to all the other FEs in the network...

Thanks, Issac, I'll experiment. All the FEs are identical. Any updates to the Switchboard/Dashboard form has me.dirty=false statement followed by a [Forms]![Switchboard].Refresh. I hope this refreshes all the FE Switchboard/Dashboards that are open on the Multiuser's Desktop?

Pat, yes, I will remember to post a new thread for different topics. Thank you. Yes, one BE and many FEs. The Dlookups are searching the Mileage Table, Inspection table, Maintenance Table, and Reservation Table. That was the dilemma I was facing trying to Join 4 Tables in one query to be the...

Isla, Thanks. Do you know my question above? Someone, doing an update to the Dashboard underlying tables, will the refresh from their Frontend, update all the Dashboards open on Multiuser Frontends? Thank you.

Thank you for that information. I have a Switchboard that is a Dashboard and Main Menu. The Dashboard uses Dlookup for data calls on, Mileage, Inspections Overdue, Inspections Due Soon, Out of Commission Status, and Dispatched Status. Therefore five items x seven = 35 data calls for tracking...

Does converting the Frontend to ACCDE make multi-users experience faster response times? Thank you.

Pat, thanks for the information. the Me.Dirty=False Property works great. the form I'm updating after the save record, is a Switchboard that has a dual function as a Dashboard, for a vehicle fleet status, and also the Main Menu to the other Forms. The status tracks Vehicle Mileages, Dead-lined...

Hello, I tried to use my save button to trigger the DoCmd.Save method, which in-turn triggers a refresh to a control on another form. However, I can stay on that record and hit save all day and watch the control refresh and never change. It takes a move off the record and then another refresh to...

Hi Cronk, tried to Compact/Repair, but the same result. I created a blank database on our network, then imported all the tables. Compact/Repaired them. I was prompted if I wanted this locations to be a trusted site, I chose, Yes. Deleted the tables from the Frontend. Linked the Frontend to the...

Using Access 2016. I have an issue trying to Split my database. It stops in middle and says one of my tables is corrupted or too complicated. The table seems fine. Any suggestions? Thank you in advance.

Thank you CJ. My apologies. You solved my first issue and I moved to a second Dlookup issue. The first issue was with Inspection Dates. The second issue was with boolean values. I should have kept them separated. Thank you.