Search results for query: *

For once it seems Microsoft has provided a working solution. (But I'm not holding my breath!). Knowledge Base Article 303829 has solved the problem. It appears the problem was referencing DAO 3.6 and not DAO 3.51 http://support.microsoft.com/default.aspx?scid=kb;en-us;303829&Product=acc97 My...

There is no front-end. It's just a database placed on a network so multiple users can access it. I tried to decompile switch. When I did the recommended compile of save of all modules, it stopped on the same line and gave the same error. dmh4ab

I have one user of a database that gets an error "Compile Error. Function or interface marked as restricted, or the function uses an Automation type not supported in Visual Basic." The Access version is the same (97) and the references are the same. I even tried a re-install of Access but to no...

I have the function written that works great. However, I wish to capture the address that it was sent from so that I can store it and easily send an email back to the original sender later on. dmh4ab

Is there a way to capture the sender's email address when using Outlook to send email through Access97? Regards, dmh4ab

May not be what you're looking for, but if the user presses ctrl + enter they can insert the hard return. dmh4ab

Thanks again Rolliee. This gave me Run-time error 2101: "The setting you entered isn't valid for this property." It occurs when assigning the sourcdoc to the ole object. Seems Access automatically appends the " to the string as two showed up in the debug window.

Thanks Rolliee. I tried that and the path looks completely normal. (C:\Documents and Settings\e164735\My Documents\courses.xls). I also tried a path that has no spaces in the folder names. Same result. dmh4ab

I have a form with a button to attach a file into an OLE object. However, when the button is clicked it gives me the error "Run-time Error '2753': A problem occurred while Microsoft Access was communicating with the OLE server. Close the OLE server and restart it outside of Microsoft...

Problem solved!!!! Turns out that a patch has been installed on the SQL Server over the weekend. This allowed access to the server only if the user had the SQL Client installed on the local machine, no longer just sufficient to connect through the code. Thanks all, dmh4ab

Thanks. I will research these first thing in the morning when I get to work!

Suddenly something that has worked for months, is giving me an error and driving me crazy. Upon opening the application, it checks to see if there is a later version of the executable on the network, and replaces the version on the users hard drive with the version of the network. This worked...

This is puzzling me. In my application I wish to backup an access database the first time a user opens a form each day. At random times this will work more than once a day. (My quess is that something is going astray when I check the file dates). Also, it takes a long time on some user's PC...

chmohan, thanks for all your help. Using the strSQL and conn.Execute gives me another error... "Microsoft OLE DB Provider for SQL Server (0x80040E37) Invalid object name '#tmp'" Thanks again, dmh4ab

I recieve an error when trying this... Conn.Execute strSQL DROP TABLE #tmp Expected end of statement /myWeb/RoutingTrials.asp, line 24, column 11 DROP TABLE #tmp Thanks again, dmh4ab

This is really strange and is confusing me. My asp page connects to a SQL database and pulls recordsets. For this I need a temporary table which I create like this.... strSQL = "SELECT tbl_RepairSummary.BasicPartNumber, tbl_RepairSummary.RoutingCode, tbl_RepairSummary.RevLevel...

Ok....I had to leave this project for a few days, but now I'm back. It seems that non of the custom error pages is the page I'm getting. The bottom of this page has "Cannot find server or DNS Error. Internet Explorer". What I really would like to do is be able to look for the file...

BasicPartNumber, RoutingCode, and RevLevel are the fields that should match. It's a one (tbl_RepairSummary) to many (tbl_RtgDash) relationship between the tables. Can I save the results of the query into a table? If I could do this somehow, it think it would achieve what I need. But, I'm not...

I need to query the results of the recordset. The first recordset gives me the matches I need from the two tables in the database. Then I need to narrow those results down even further. It's kind of a complex query, but I'll be glad to try to explain it further if I need too. (Didn't want to...

This sounds simple. I pull a recordset from a SQL database. The query for the recordset follows: SELECT tbl_RepairSummary.BasicPartNumber, tbl_RepairSummary.RoutingCode, tbl_RepairSummary.RevLevel, tbl_RepairSummary.RevDate, tbl_RepairSummary.PartName, tbl_RepairSummary.Summary...