Search results

This may not b required Constant check on the fields, monitoring user activity is not required. I believe adding the code indicated by KitaYama will do the job An 'Exit sub' can be added after each if criteria If Password & "" = "" Then Password.SetFocus Exit sub Elseif...

Ok this could work I will add 'Exit sub' after each if / elseif criteria;

In that case, based on the 'tab stop', the focus will be on the login button, but does not get executed, until the user hits enter key again when the focus is on the login button.

I am creating a Login form and need to call login button after the user has entered the password and hit 'enter' key. I am aware of the option, where in the button 'default' parameter is set as 'yes'. However, in case the button default value is set to 'yes', then, after the user enters the...

Thanks. Will certainly try terminal server.

I have MS Access database split into BE and FE. FE has been saved as ACCDE file. I want to deploy this program on to web, where users can edit / add data into the database My Access programs has quite a few VBA codes on the front end. Requirements; MS Access Online Maximum 3 to 4 users...

Thanks Part Hartman Works well !!

Not sure which version of the Linked table Manager has this option. In my case I was talking about Office 365

Excellent arnelgp !! This is what I was looking for. Thanks very much for the code. Additionally , I would create a form in the FE to link to required tables (Server / local) Would also add field indicating path in the form to confirm connected BE is either Server / local Thanks again

Hi Whenever there is modification required to Access database, I change the Linked Table to local BE to carry out the work. I complete the modifications / testing using Local BE and then link all tables to the Server BE. I save the FE file as ACCDE/ACCDR and then distribute the same to users...

Hi Just got update from few 'work from home' users Before using the persistent connection method, time taken to open a form : 20 to 25 seconds After implementing 'persistent connection', time taken to open a form : 4 to 6 seconds Thanks !!

Hi Arnelgp / CJ_London I have now tried 'persistent connection' (form open hidden with connection to linked table) and it has improved the speed considerably. I in process of getting feedback from other users and will revert soon.

Yes, BE is situated in company's server and FE is linked to BE through mapped networked drive. Thanks for the suggestion. I will try using 'persistent connection' and revert back @CJ_London Will try your suggestion if 'persistent connection' does not work well.

Hi, I need help to design a database, where in users from different locations input (populate) details into the table (duplicate) in the front end (FE) database. Eventually to append these details into the BE (backend) database. Main reason is to improve the speed at which users can input...

I have data as indicated below ; and require cross-tab query as per below; Please help

Thanks arnelgp, This is exactly what I was looking for !!

Hi, Some fields in a form needs to be checked for null entries. Is there function to determine whether the field is null and 'set focus' to that particular field and also exit code? I use the below code and repeating the same for each field to check the null value; ' Check for null entries If...

I did just that and using controls, i've managed to place the total column towards the end Thanks

I tried dragging both in design view and result view (separately) and I saved it also. But no change in report

Thanks for your response I tried shifting 'total' field to right most in cross tab query But report still shows the total field somewhere in the middle