Search results

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

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

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,

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

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

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

Hi. I'm little stuck here, and I hope I could get some input.. On a pushbutton click event, I have the following code: Private Sub cmdTest1_Click() Dim rsCable As ADODB.Recordset Set rsCable = New ADODB.Recordset rsCable.ActiveConnection = CurrentProject.Connection...

Hi. Thanks for your reply! I did'nt mean to be to general, but the problems is that I will deal with several projects. In each project I will have the same products (product ID) and location (location ID), but the combination of product and location will not be the same for each project. So, no...

Hi. I have a question which might seems little odd, but I hope I could get some guidance here...:) I have a main table, lets call it Project. I have some seondary tables, which have the realtion back to the Project table, with the Project ID as relation link. Then - under one of the...

Hi. Thank you Jleach for your time. The case is that I am using a 'dsnless' solution with the connection with sql server authetication hardcoded in the program. And I believed this would be ok when using standard recodset def and open, like: Dim rsTable As ADODB. Recordset Set rsTable = New...

Sorry for wasting your time. I forgot to inform the most important (maybe) that I am am usng ado all over the project. I'm little familiare with errorhandling, but I haven't use it on ado connection before. If you have version for ado, I would be glad, because i couldn't find a verison I could...

Hi there! Can: Item not found in this collection. .. be the answer you want? if not, please excuse my stupid question on where should I put the code - ?DAO.Errors(0) Geirr.