Search results

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

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

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. 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 All. I've run into a problem which I need helt to solve: Run-Time error '-2147217887 (80040e21) ODBC--call failed. Background: Using Access 2016 (FE), SQL Server 2012. (BE) Linked tables, and using 'dsnless' hardcoded connection, with SQL Authentication. The error message occur on table...

Hi all. I've got into a problem I just can't figure out how to fix.. I know it sounds stupid, but here is the case: I have just created a copy of my database backend to Sql Server Express. all tables and fields are created 'by the book' - i think.. and the front end linked to the sql database...

Hi! I have found that my ordinary database with Access FE and a datafile BE placed on a server, doesn't cover our needs any more. Mainly network speed is the biggest problem. I have been givven full access to the company's Sharpoint (Server Enterprise 2010), but I am strugling to decide how to...

Hi. I have a form with multiple controls, mostly check boxes and text fields. The check boxes are named like chkbox1 to chkbox15 What I would like to do, is the posibility to access the checkboxes like this: Counter = 1 Do While Counter < 15 Me.chkbox + str(Counter) = False Counter =...

Hi all. Is there a way to create a report with folowing criteria: On each line in detail section I want to have info from one field, but from multiple records. Example, I have a group code, and I want a list on all items ID on this gropup. Instead of haveing one item ID for each line, I would...

Hi. I have a question I qould like to have some input on. The case is that I am not sure which structure of databases/tables suits me (and the organtisation) best. The scenario is: Our orgainisation are working on projects. Each projects will hold somwhere between 6000 to 8000 records. Each...