Search results

Here is a code that I wrote and I was wondering if anyone can shed some advice if there is a better way of doing this. I am open for suggestions. Please provide helpful advice. Thanks. The code works but I am wondering if I can make it better. Private Sub cmdSaveRecord_Click()...

Any ideas?

I posted more details on my situation at this thread: http://www.access-programmers.co.uk/forums/showthread.php?t=217589

MODS: If this isnt the appropriate area, please move to the appropriate forum. I have researched this topic in this forum and still have not found a viable answer. Maybe this will help someone answer my question by actually give the steps on how to duplicate this problem. I am running...

Okay, I found a link that pretty much describes what I am running into. The link is http://stackoverflow.com/questions/2371876/does-setting-an-ado-commands-activeconnection-nothing-close-the-underlying-sq Pretty much it says even clearing it, it doesnt clean up on SQL server end. :mad: BTW...

Okay, I did have that already and thought thats what it did. But I am not sure what you mean to recreate it. What happens is that when i execute the pass through query one time, Ill go to my test SQL remote database and look to see if there is an active connection and it lists that 1 is still...

Here is my code for my pass through query. As you can see I am using Late Binding. I am not sure how I destroy the ADODB.Connection. Function CreateSPT(SPTQueryName As String, strSQL As String, passStatus As Integer) Dim cat As Object Dim cmd As Object On Error GoTo ErrorHandler...

After further testing, I a running into a problem and dont quite understand what is going on...please forgive my ignorance. I wanted to create a test connection to my remote SQL server hence a function to test my connection. This was done so before a user can use a form which calls to create a...

Thanks for your example, I appreciate it, I tried modifying it using Late Binding for the ADODB connection because I have different versions of Access Users but was having problems when it attempted to check the cn.state = adStateOPen line for some reason, it would not go into this block of...

I was wondering if its possible to test my ODBC connection using my DSNLess connection to my remote database without creating a query or table link? Is there a sample VBA code I can look at? Thanks.

Thanks for your reply but please forgive me since I am not totally familiar with the Pass Through Query setup....the link you provide is for a view? I just want to send a pass through update query, but need more sample code. Thanks.

I have 3 queries in Access 2007 tableA - same structure in local and remote database 1. Query1 (Query based on a table "A" in the LOCAL database) 2. Query2 (Query based on a table "A" on a REMOTE database using a pass through query set up) 3. Query3 (Query based on what records are different...

That worked! Appreciate the quick response.

I have a textbox which I allow the User to enter text. Kinda of like an area where it keeps a log activity. By pressing CTL + ENTER, it will give a LINE BREAK in the text box, which is great. But if I want to pass the multiline text to an e-mail and/or insert it into a database, how do I...

Guus2005, Thanks you for your reply. I did attempt the method but unfortunately, when trying to translate it into two separate queries as MS SQL syntax instead of TSQL, I keep doing something wrong.

I am trying to convert this query I have in TSQL. I am running into problems on the proper syntax. This is the original syntax. SELECT u.UserID, u.FirstName, u.LastName, u.Username, u.Email, u.DisplayName, up1.PropertyValue AS TypeOfAccess FROM...

Uncle Gizmo, gemma-the-husky, ghudson, datAdreneline, Thank you all for your valuable insight, as a newb at writing vba in access, I knew I had a few things to fix. datAdreneline, I am going to try your solution. Yes, I purposely wrote it twice in my original post. I just wanted to find a...

I commented the line "On Error Resume Next' but it still continues.

Example: In my Sub CreateRelationships It looks at this line for the second time: ' tblCompanyInformation => tblContactAgentInformation CreateRelationDAO "DaotblCompanyInformation_DaotblContactAgentInformation", "tblCompanyInformation", "tblContactAgentInformation", "company_cid"...

Uncle Gizmo, Thanks for your reply. I do understand what you are saying. It does test to find that it already exist. I just thought maybe somewhere in my code, I can code something differently to stop my creation the relationship process instead of proceeding.