Recent content by gkl

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