Search results

Hi, Can I use a macro to run multiple queries in sequence? I searched on this but did not see anything that indicated how to do this. Any pointers would be appreciated! Thanks, Mark

Hi, Can I use a macro to run multiple queries in sequence? I searched on this but did not see anything that indicated how to do this. Any pointers would be appreciated! Thanks, Mark

Hi, Is it possible to print a report using a standard access button and not a user generated one? I usually print by right clicking on the report window but am looking for a more obvious way for useability purposes... Let me know :confused: Thanks, Mark

Hi, I have inherited some code from an MDB but need to migrate it to and ADP format. Does anyone know the correct syntax for a File Dialog object in ADP. I am getting the following error for the code below "User defined type not defined" :confused: 'Declare a variable as a FileDialog...

Pdx Man, Thanks for your input 1 - I have attached the modified query string in full below. 2 - Where in SQL do I check if mixed authentication is allowed / enabled? 3 - The user has db.owner rights to all the tables in the DB, so that should be fine. I guess its just the question I have in...

I apologise for my ignorance but how do I do this? I mean how do I attempt to connect through code in a SQL statement (query)? Sorry, Mark

Bob, I have mapped the login of the SQL Server User to the following Database role members: db_datareader db_datawriter Thanks, Mark

Hell indeed! I checked the connection string again and adjusted the syntax as advised. It prompts me that "Login failed for user 'MyUser'. The user is not associated with trusted SQL Server connection." I presume this points to the actually login entity on the SQL Server side? Even though I...

Hi SQL Hell I have deselected the password expiry option This is my connection string but it says Login Failed for MyUser. The user is not associated with a trusted SQL Server Connection. Here is my code: Dim cn as new ADODB.Connection Set cn = New ADODB.Connection Dim strQuery as String...

Thanks Bob! Mark

Hi, I am using VBA to connect my Access ADP file to SQL Server 2005 Enterprise Edition. Can anyone spot a glaring errors with the following code? Thanks, Mark 'Open the connection to the SQL Server DB Dim cn As ADODB.Connection Dim strServerName As String Dim strDbName As...

Hi, I am putting a SQL Server Backend on an Access frontend. When I create a new Login in SQL Server 2005 Enterprise Edition, I assign it a username and password. However when I go to view the properties of the login I just created there is a problem. Instead of seeing the 4 character...

Hi, I am putting a SQL Server Backend on an Access frontend. When I create a new Login in SQL Server 2005 Enterprise Edition, I assign it a username and password. However when I go to view the properties of the login I just created there is a problem. Instead of seeing the 4 character...

Thanks Hi Bob, Thanks for your help

Hi, I am using SQL SERVER 2005 and its Management Studio to manage my data. The tables in SQL have been linked in from Access but the Autonumbers have not persisted in SQL. The column type is listed as int. Within SQL how do I change the data type to the equivalent of Autonumber for my Primary...

Hi, I am not sure I understand. Do you mean I should open a new recordset [which will take into account the edited data] and re-populate the listbox from this? Thanks, Mark

Hi, I am trying to add to a listbox from a recordset with the following code. However I am getting a runtime error: The setting for this property is too long Do Until rtable.EOF Me![lstRisks].AddItem Item:=rtable.Fields("RiskID").Value & ";" &...

Hi, I have an Access front end linking to a SQL Server backend via an ADP file. When I edit a record, I am having trouble refreshing the listbox that displays that same record. I am trying to use the .Requery method (see code below) Can anyone suggest a better way? Thanks Mark Private Sub...

Hi, I need to convert some old code to ADODB format and I am having trouble finding the correct methods to use with the ADODB Recordset objects :confused: Old Method -> New Method with ADODB connection objects 1 FindFirst() -> Find()? (I think this one will be ok) 2 NoMatch()...

When I tried to put in the listindex, like you said, 0 for the first column and 1 for the second I got the following Compile error: Expected = Me.LstProjects.AddItem(rs.Fields("ProjectID"), 0) Me.LstProjects.AddItem(rs.Fields("ProjectName"), 1) Any ideas?? :confused: Mark