Search results for query: *

Thanks to both of you. This will work perfectly. I hadn't thought of the logic this way. Alexis

...The logic works fine. However, I just realized that the field being used as the selection criteria should not appear in the output so "select *" can't be used. strSQL = "select * from qryExport where listname in (" & Me.txtFilter & ")" Set qdf = dbs.CreateQueryDef("TempExportQry", strSQL)...

I already changed the authentication setting a couple days ago to mixed. I just put some screen shots in a doc file on my website. Maybe I am looking at something wrong and the screen shots will explain what I mean. http://www.drdatabase.biz/docs/sql_server_screenshots.doc Thanks, Alexis

My setting under SQL Server security is already SQL Server and Windows Authentication. I changed the Windows Only setting a few days ago. I tried the connection string at www.connectionstrings.com and got the same trusted connection error. It's like the connection isn't even looking at the...

I tried this: set myConnection = server.CreateObject("ADODB.Connection") myConnection.Open("Provider=SQLOLEDB;Data source=Aragorn;Database=Intranet;User Id=XXX;Password=XXX") 'myConnection.Open("DSN=intranet;User id=XXX;password=XXX") set ref = server.CreateObject("ADODB.Recordset")...

Thanks everyone for your responses. From hejamana's comments, I changed my code but still got the same error: Microsoft OLE DB Provider for ODBC Drivers error '80040e4d' [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'ARAGORN\IUSR_ARAGORN'. /mytestpage4.asp, line 14...

I have tried many different ways to connect to a SQL Server db but can't get any to work. I am logging in through VPN and then remote desktop onto a machine and am working directly on the machine (there's no external IP address). It's SQL Server 2005 and Windows Server 2003. Each way I tried...

Thanks for sticking with me (and have a star). I think I see where you are going with this. I will work with what you've given me today and will let you know how it worked out. Thanks again. I really appreciate it. Alexis

Thanks. I don't mean to be obtuse but does this code go in Access? I pasted the code into an Access module. When I run GetRecips(), I get the error "User-Defined Type Not Defined" on "Public Adm_Cnn As ADODB.Connection 'Declare the "bridge". Do I need to use an additional library in...

My db structure is somewhat like what you described, as follows: tblContacts ContactID FirstName LastName EmailName tblContactCommittees ContactID CommitteeID tblCommittees CommitteeID CommitteeName I will have queries that tie the 3 tables together and then select based on CommitteeName. I...

Yes, I want to look at a table/query in Access and use that data to create a distribution list in Outlook. The data will come from a query because we will be grouping the contacts based on different criteria, such as committee name, or other values. I have used Access as a data source for Word...

I created an Access db (2003) that contains contact info with a lot of custom logic. My client wants to be able to use Outlook to "see" these contacts and create distribution lists from the data in the Access tables and queries. I have done automation the other way; that is, having Access...

Thanks, everyone. I asked a friend to look at this for me as I was getting very frustrated. It turns out that the statement "$numcars=$_POST['NumOfCars2Quote'];" should have been at the top of the page, and not inside the form statement, which was being submitted each time. I looked at this...

Thanks, sleipnir214, but the problem isn't with the drop-downs. I used SELECTED along with the MySQL data to build that logic. The problem is that when a user selects from the drop-down, the form is regenerated and I lose a value sent from a previous page. For example, if the value "two" is...

My php page has 3 dynamic drop-downs reading data from a MySQL db with select statements like this <select name="VehicleYear1" onchange="this.form.submit()">;. The drop-downs are all working fine, however, the first time the drop-down submits to the same page, I lose the $numcars value that I...

Thanks for letting me know. I'll have to try it. I thought I had created a new ODBC source and it still didn't work but it was many months ago so my memory may be foggy. In any case, thanks for sharing your solution. Alexis

No, I never found a solution. It was very strange. I couldn't get it to work at all on my computer but my client was able to get a result, although she did get warnings along the way. I had a copy of her database and we had the same Access versions (2003) and .mdw file. Sorry - I wish I...

Thanks again, Mike. Actually I changed my code to xlSheetVisible instead of True earlier today in hopes that this was the problem. But it didn't work until I removed the extra space from the sheet name. Yes, it would have been nice to have a more meaningful error. I searched in this forum and...

Thanks, Mike. I was just logging on to say that I found problem, after looking at this so many times. There was an extra space at the end of the sheet name on those two sheets. Once I removed the extra space, it worked like a charm. Alexis

Does anyone have any suggestions on this issue? Thanks.