Search results

Dear All, I have seen a few books mentioning that the default width for a new form in Access is 5 inches, but no one is making any reference as to where this is set (there does not seem to be any Access template that I can find on my computer like Normal.dot for example, should I be looking at...

Dear All, I have a database in Access 2013 which, amongst others, has a table for holding employee pay rates. I want to do a query that calculates a new field that will be saying how much their new pay rate would be should they be given a 10% pay rise. It's all good and simple, I have a query...

Dear All, Let's say we have the classical Customer-Order one-to-many scenario and I want to build a form that shows customers and their orders. I start with the Form Wizard and at some point in the process I have to choose between a subform and a linked form. Let's assume that I go for the...

Dear All, This might sound as an odd question, but I am interested into whether it is possible or not. Let's say I have a table with a text field and Required is set to Yes and Allow Zero Length Strings to No. I want to input a value for this field which is "" (two double quotes literally)...

Dear All, I have a table in Access 2013 with a field that has the Required property set to No and the Allow Zero Length Strings property to Yes. I am trying to insert an empty ('') value into this field - I tried putting in a white-space, typing some text and then deleting it to no...

Dear All, I have a query that is looking at an Orders table and it is extracting information about the order id, total cost, department placing the order and date on which the order was placed. I want to do a report that presents the information and groups them first by department and then by...

Dear All, I am using JetShowPlan on Access2013 running on Windows 7 (64-bit) and I enabled JetShowPlan. I have a table called User with id, first_name, last_name, email and country fields. The field country has an index defined and the others do not. I run a query with first_name and checked...

Dear All, I am looking for an example that will show the difference in time that the use of indexes will make. I created a user table with random data from Mockaroo (10,000 rows), indexed one non-key field and developed two queries one on the indexed non-key field and another one on a...

Dear All, I have an Order-Product scenario in which I want to display order details and in a sub-form the product details of the items in the order. That works fine and it is quite easy to set-up in Access 2013! Now I want to change the display of the product name's attribute so that it will...

Dear All, I have a query in Access 2013 that generates four fields, first name, last name, department and equipment and I want to produce a report that groups by department, then first and last name and then equipment. I know I can have the query generate the full name by concatenating first...

Dear All, I am using the user-level security in Access 2003 and manage to have different users and logins for each of the database users. My question is whether that functionality creates a login log so that if I am an admin for the database I can see who logged on when and what changes he/she...