Search results

How do I only bring back the top 3 from the join in this query? There will be multiple records in the InvoiceNotes table and many different invoices. select invoice_no, inv_date, totamnt, projman, invoicenotes.note, invoicenotes.notedate from invoices left join invoicenotes on...

None of these systems have SQL enterprise or query analyzer installed but when testing the ODBC link, it connects successfully. They login through separate NT access at the moment. So, until I set up a group, they each have their own DOMAIN\username login on the sql server. I can't see why 1...

nope, the first link requires you to set up a table in the access db with the dsn strings and table names. I need to do it programatically and relink tables each time the application is started. If I have linked tables, does it matter whether it's DSN or DSN-less connection?

If I use the linked table manager and save the password with the connection, what type of connection is that? This seems to be different from using a system DSN and separate fro DSN-less string connection?

We have an ODBC connection (System DSN) set up for an application with linked tables to the SQL server. On some PCs, this works straight away. On others, a login was set up on the SQL server (DOMAIN\username) and the test function in the ODBC connection works but the actual application cannot...

But should we be using ODBC at all?

We have an app that connects to a SQL back end using ODBC. Is there a way to do this in code or should we be using DSN-less connection? All the tables are linked in the Access front end currently.

Are there any advantages/disadvantages to distributing an Access packgae application versus storing it on a server and having users access only 1 file through shortcuts?

Surely you can, no ? The code at the top of this post uses a connection string to connect to SQL in VB. I'd just need a way of importing the data from the Access table to SQL. It works with linked tables fine but that uses a DSN stored on my computer. So, either: - connect with a connection...

No, the queries work when I add a linked table. What I mean is that the linked table uses a DSN file on my computer to know which server to connect to. On the 20 other client PCs that will be using this, there is no DSN file, so the application will fall over. I need another way of specifying...

But if the Access DB is being used on a different machine all the time, it won't be able to read the DSN file on my machine will it? So it has to be a DSN less connectin somewhere and then link the tables. ...or not?

So far, I have this: Private Sub Command23_Click() Dim conn As New ADODB.Connection Dim cmd As New ADODB.Command 'Dim rs As ADODB.Recordset Dim sConnString As String Dim iCtr As Integer sConnString = "Provider=SQLOLEDB.1;User ID=sa;password=putpasswordhere.;Initial Catalog=CCApp;Data Source =...

I need to export a table from Access to SQL server by using code. Ideally, I'd just like to leave the table on SQL server but the network is very slow here so this is about the only way to do it. Export the table and then have it accessed by other applications on the SQL server?

Hi I need to allow users to select a file from their desktop and save it to a fixed network location (they should not be allowed to change this). Ideally, through a select file dialog, then save. Any recommended solutions to go about this? Maybe an Open dialog that allows them to select the...

I have the following code, which changes the items in the listbox depending on another box in the form. Form.RecordSource = "CreditControllerSpecific" combo_CostCentreLevel.RowSource = "SELECT 'All Profit Centres' FROM Structure UNION SELECT DISTINCT CostCentre FROM tblCostCentres WHERE...

I think the AS is fine because it's an alias but this is what I mean... when I save the query the ]. is not there because I type it properly and use a single bracket. When I next view it, Access has changed it back so althought this query works fine when called from code, it will not open it...

Thanks. Gives me: SELECT TOP 10 [Name 1], [Profit ctr], ROUND((Sum([1To90]) + Sum([Not Due]) + Sum([91To120])) / 1000,0) AS Months0To3, ROUND((Sum([121To150])+Sum([151To180])) /1000,0) AS Months4To5, ROUND((Sum([181To365])) /1000,0) AS Months6To12, ROUND((Sum([MoreThan366])) /1000,0) AS...

in a VBA form/button or something?

nope, won't open at all. It is only 4 queries that have some paramaters in them such as Forms!blahbla.Form.combo_box1 They saved fine, they work fine when run in code, but they can't be opened anymore to change the code.

I am trying to view a query in design view but everytime I right click on it (or any method) it brings up the: syntax error in from clause. I then have to say OK and that's it. Cannot view it. Interestingly enough, the query works fine when called from my VBA code. Know anyway round this?