Recent content by trackdaychamp

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