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

So are we all saying, if my understanding is correct, that if allow zero-length strings is set to No then Access is not going to accept "" as a string literal because it will always translate it to a zls and there is no way to block this behavior?

If you take into account the special meaning of "", this would indicate a zero-length string which is not allowed based on zls=NO. So I want to waive the special meaning by telling Access that the value I want to put is not a zls but it is the string with value "".

Unfortunately it doesn't work. To be more specific, I am in Access 2013 in Table DataSheet View for a field that has Required set to Yes and Allow Zero Length Strings to No and I am trying to insert the string literal "" as the value. If I type """" (four double-quotes) then the value of 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)...

This is true, but I am looking for an answer that doesn't involve VBA; it just works from the datasheet view.

I am fine with this, the question is when Required is set to No can you force an empty string value as Access seems to be defaulting it to NULL no matter what you are doing directly from the datasheet view?

I know this, please read the question again and you will see it asks nothing about this.

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

Thanks Mark, the header is fine - it is actually the footer that I am not getting. Also, could you please provide some advice on how to fill in the most popular recruitment month idea? Regards, George

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

That was a simple

Sure, I edited the original question and it should be fine now. As for my knowledge of JetShowPlan I was looking for a feature equivalent of explain plan for Oracle and one of the forum fellow members suggested it. Regards, George

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

Sure, the first one is: select first_name from user where first_name='John' (first_name is an indexed field with a single-column index) and select last_name from user where last_name='Jones' (last_name does not have an index defined on it). Obviously, neither first_name nor last_name are...

I am familiar with the concept of the index; I am just looking for an example and Access does not give me access to the scheduler (something equivalent to explain plan in Oracle) Regards, George

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