Recent content by Geirr

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

Hi all. I'm a very big fan of the JStreetAccessRelinker, and up to now have worked perfectly for my projects. But, I've seen that my org. needs to splitt the back end in two different databases, one database for common company recource info, and one database for each project. When using the...

Hi. First, please excuse my lousy english grammar... I'm moving my access app from std access data file (be) over to sql server. In the Access app, I am using 'direct access' to underlaying linked table - in the manner that form field datasource are directly to underlaying querry/table. In the...

Hi all. I've tried to read throug lots of docs on best practice on PK on tables, but.... Background: For electro company in shipbuilding I'created a backend with several tables, one accdb for each project. Many of exisisting keys in those table are same for each project - due to what they call...

Hi theDBguy and isladogs. First, thank you for your time. After a new walkthroug with the IT guys in our company, I've got acceptance to go back to using DSN and Linked Tables. This mostly when they understood my side of the case, dealing with around 20 different forms, and ca 35 queries...