Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. dmh4ab

    Compile Error on CurrentDB - Urgent

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

    Compile Error on CurrentDB - Urgent

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

    Compile Error on CurrentDB - Urgent

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

    Capture email sender address

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

    Capture email sender address

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

    line returns within text field (Access 97)

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

    OLE Error 2753

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

    OLE Error 2753

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

    OLE Error 2753

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

    File Access Denied - Urgent

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

    File Access Denied - Urgent

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

    File Access Denied - Urgent

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

    Daily Database Backup

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

    Strange Connection Behavior

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

    Strange Connection Behavior

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

    Strange Connection Behavior

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

    Custom "Page Cannot be Displayed"

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

    Query a Recordset

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

    Query a Recordset

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

    Query a Recordset

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

Part and Inventory Search

Back
Top