Search results

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.

I need help to evaluate 'best practice' on the following issue: I'm converting a system from accdb to Sql Server. Sql Tables are Linked to the frontend, using odbc driver. Several users may access the system via separate front-ends for each user. From time to time, me or the user(s) need to...

Hi MajP Works absolute perfect for me! Thank you for this info. Brg. Geirr.

Hi all. I've tried to get my head around uisng mask on a text control on a from, but I believe I'm asking for too much... The problem is that I need to solve is. - Any length but max 10 char/digit/special char. - Any combination of char/digit/special char must be allowed. - When 10 pcs are...

Hi. At first, I believed there was an issue using the function on two BE's. But as I wrote in second email, I found it works - and works very well! - but as I wrote, I found a issue which I found to be little odd, and could easily lead to error messages. Those five tables belongs to two BE's...

Hi, and thank you for your reply. I believe I've found something. Let me explain; Common database = CommData.accdb Project database 1 = ProjectData1.accdb Project database 2 = ProjectData2.accdb When jstCheckTableLinks_Prompt runs, the filepicker opens, and the databased CommData.accdb are...