Search results

  1. G

    DoCmd.OutputTo - Excel coded sql string

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

    DoCmd.OutputTo - Excel coded sql string

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

    DoCmd.OutputTo - Excel coded sql string

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

    Record Locking (adLockOptimistic) and T-SQL setup

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

    Record Locking (adLockOptimistic) and T-SQL setup

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

    Record Locking (adLockOptimistic) and T-SQL setup

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

    Record Locking (adLockOptimistic) and T-SQL setup

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

    Max length on Unbound text control

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

    Max length on Unbound text control

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

    JStreet Access Relinker with two different BE table.

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

    JStreet Access Relinker with two different BE table.

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

    JStreet Access Relinker with two different BE table.

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

    Inderect or direct data access in forms

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

    Best parctice - Auto increment or Natural Key

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

    Correct SQL Query, DNS Less conn.

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

    Correct SQL Query, DNS Less conn.

    As I wrote earlier, it's based on a existing solution using linked tables to an sql server. It's a prject I have built up over a time. I'm familar with setting up queries based on query designer, based on linked tables, releated or not. Based on some issues related to the company I'm working...
  17. G

    Correct SQL Query, DNS Less conn.

    Hi isadogs. Thanks for your efford, but this issues are little new for me, and I'm really strugling on how I can 'transform' the value I need in the Sql for record source. Brgh. Geirr,
  18. G

    Correct SQL Query, DNS Less conn.

    Thanks for the replies! I understand what you are saying, but I just don't know how to figure out how to solve this issue. If you look at the querry, this is a record source to a combo box. So what I did, was just go into the RSource, and changed the underlaying query (based on inked tables)...
  19. G

    Correct SQL Query, DNS Less conn.

    Hi I've run into a case I hope I can get some directions / help on. Background: Moved a Back End to SQL Server. The server management gave me a user name and pw for access to the sql datafile, used when setting up a DNS to the server, using SQL Server driver. Now, for some reason I've been...
  20. G

    Select Sum

    Thanks for your reply. I believe you understod the question because your solution with Me.txtResult =rsCable!SumAvMeter worked perfectly. I just got a totally block on this solution, so simpla as it is...:banghead: Thanks again. -Geirr
Top Bottom