Search results

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...

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...

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, 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...

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 am trying to create a report out of crosstab query where ; a. Person as row headings b. Category as column heading c. Sum of Amount as value d. and to obtain Sum (by row), Sum of amount as Row heading Report generated from this crosstab query, is putting the 'Total' (row sum) in the second...

I have a textbox for 'Project name' in the form. Is there an option to autofill this field, based on previous values from the same field? As there are new projects getting added, this 'Project name' textbox cannot be converted to combobox and obtain values through drop down. At the same time, I...

I am not sure whether this will work. But, can we have a 'single table' with all Lookup values populated in it? I am referring to total of 24 fields for which lookup values would be used in the database. I wonder whether a single table called 'tblLookup' can be used with 24 fields in it. The...

Hi.. I have been designing and developing access programs for quite a few years MS Access was self-taught by myself using books / online material Would be great to interact with brilliant and experience MS Access minds Thanks