Recent content by Geirr

Thank you! This works perfectly for my use :) Brg, Geirr.

Thank you very much! I will look into this and try it out Brg. Geirr.

Thank you, but As I wrote on your initial replay, this does not show records where there is no data and it's not filtered. Attached pictures shows the criteria in the 'field01' in true life is Rev (Query_Criteria). The two other images shows output when the query has the criteria set, and...

Hi. Thank you for your answer. I was struggling with this one until I saw that I have to use semicolon instead of comma after the [Ctriteria1] above. But sadly, it gives only records with data in Field01, so empty fields records are still left out when not filtered. Brg. Geirr

Hi. Thank you for the answer, but the case is: Include all records (also empty data in the criteria field) when not filtered, and include only records with the selected criteria without empty data records when filtered. Tried with both Is Null and Not Is null. With And Is Not Nul I will never...

Hi all. I'm sorry if I am bringing up probably an old and answered issue, but I just can't get things to work properly, and I cannot find a solution while trying to search for it. I have a table with 5 column. For the sake of argument, - Field01 - Field05, all text fields. I do have a form with...

Thank You. I realized my mistake as soon as I read the reply from Mr. Gasman above, Best regards, Geirr.

Hmm - thanks Gasman - I think you got me on the Date() versus Now()... I'm afraid I've used Now() too much... and your reply really make sense. Best Regards, Geirr.

Hi. I'm sorry to bother you with a problem which may be an easy case... In a standard table, one of the fields have the Data Type: Date/Time, with format ShortDate. But, when I filter on the field in the table and select a specific date available in the filtering list, I just get one row with...

Hi Gasman and Minty. It works! I didn't realize that I should put the SetQdf in a separate sub. But a new lesson are learned. Thank you both for the help. Best Regards, Geirr.

Thank for your input Minty, but when I tried with a direct copy of your code, I've got error message: Compile Error, Variable not defined, and the yellow mark on the YourStoredQueryName. Just for excluding possibilities I tried with any combintaion (because usage/not usage and type of quotes...

Hi all. I have an (odd) question; The code: DoCmd.OutputTo acOutputQuery, sql_File, "Excel Workbook (*.xlsx)", , True Works like a charm when using a predefined query in Access, named sql_File. But, I would like to hardcode the string inside a form module and set up as sql-string based on...

Hi all. Thank you all for replies and suggestions. I've started over for the whole project to change all instances using the code I mentioned in my first message to use action queries for add, update and delete records. Then we will se an improvement - I hope... Brg. Geirr.

Hartman and Minty, I did understood you very well. My challenge is that known theory doesn't match reality from time to time. The case is that my database is a system for cable management, where several status' on the cable are very often updated (as example; registered, measured, routed, cut...

Hi. Thank you all for replies! I will use update queries, no probs. But avoiding a 'batch update' as mentioned, will be impossible. I will for sure do what ever I can to reduce the usage.