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

    three dimensional array

    are you making an array in vbscript: Dim myarray = someFunctionToGetValueFromDataBase and then trying to access the array in Javascript? can you do that? vbscript arrays are simply referenced by the notation myarray(x,y,z) Can you get out anything from the array at all? Can you find its ubound?
  2. mackers2

    80004005 unspecified error suddenly stops page working

    ok, fixed now: tracked down what was going wrong (all the Access databases being used on the whole intranet were down) by changing from OLEDB to ODBC driver which then errored with message about Volatile Jet DSN ... MS KB indicated this was permission problem with the Jet driver on the web...
  3. mackers2

    80004005 unspecified error suddenly stops page working

    Reset the permissions now and the funny thing now is that the pages run fine for the webmaster but when an ordinary user tries to use it they have the same error. Alasdair
  4. mackers2

    80004005 unspecified error suddenly stops page working

    thanks, DreXor, any joy and I'll post Alasdair
  5. mackers2

    80004005 unspecified error suddenly stops page working

    Thanks, do you know where I should start looking - there are at least three different databases, some stored on web server, one on other servers, but they've all stopped working. I know the account asp pages are using to access the databases is OK to read/write the database folders as I tested...
  6. mackers2

    80004005 unspecified error suddenly stops page working

    <% Set LocADO = Server.CreateObject ("ADODB.Connection") LocADO.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "\\pharm-svr\Train\dispdata.237\wait2.mdb" Crashes out on line beginning LocADO above (according to browser). This is just an example of one page; all the other pages on the...
  7. mackers2

    80004005 unspecified error suddenly stops page working

    I've got some asp pages connecting to MS Access databases (some are Access 2000, some are Access 2). Suddenly this afternoon I've got 80004005 errors on all pages that try to get data from an Access database. Anybody any ideas why this would happen suddenly - I've not lost RW access to the...
  8. mackers2

    How can I test to see if a web page exists?

    Sub Macro4() ' ' Macro4 Macro ' Macro recorded 05/02/2003 by AMacdonald ' Dim sTemp sTemp = GetStatus(&quot;http://www.tek-tips.com/submitpost.cfm&quot;) If InStr(sTemp, &quot;404&quot;) > 0 Then sTemp = sTemp & vbCr & &quot; - this means the file was not found&quot; End If MsgBox sTemp End...
  9. mackers2

    Sending Outlook Mail from Access

    I got round it with this: http://www.express-soft.com/mailmate/clickyes.html Regards Alasdair
  10. mackers2

    Automating WinFax Pro in VBA

    I added .AddAttachmentFile to your code and it worked fine for me, the only thing is that WinFax takes a while to load the attachment files application and then print it to Winfax so you wait a while to see the pages appear. Regards Alasdair
  11. mackers2

    Front Page Programming Help is broken

    When I access Front Page (2002) Programming help I get an error saying &quot;A runtime error has occurred&quot;. In script editor it reports that ADODB.Recordset: Operation is not allowed when object is closed. I've uninstalled, reinstalled etc etc. Any ideas how to fix?
  12. mackers2

    Securing a pdf file

    I don't know if this is helpful - but what I've done to stop people using a printed version when I don't want them to is to put a form field on the document that has some text on - I use &quot;Invalid Form - Do Not Use&quot; that goes right across the whole page. I set the field to invisible...
  13. mackers2

    Output directly to Excel..?

    this works for my test data with commas in, of course you'll have problems with multiple &quot; in your fields then... if you find out how to get Excel to open it instead of inside the browser I'd love to know. Response.Write &quot;&quot;&quot;&quot; & myRS.Fields(i) &...
  14. mackers2

    Output directly to Excel..?

    This is the code I use - key point is to take out of your page any html tags like <html> <body> as then Excel thinks it's an html file not a csv file. This isn't my code - I got it from www.devx.com - Got Data? Send It to Your Users as an Excel Spreadsheet from Your ASP Page By Rama Ramachandran...
  15. mackers2

    MailMerge DDE connection

    This has bugged me as well, and what I did was separate out the data for the merge into a different database and then used that database as the source for the mailmerge document, but using ODBC. This works fine - Access never opens and the Word document closes clean, and feels much faster. Not...
  16. mackers2

    Lost my DAO 3.6 help - how do I get it back

    That worked for me too! Thanks a bundle Alasdair
  17. mackers2

    Can I set an appointment in Outlook Through Access?

    1. Use the outlook programming interface to make a new appointment item. or 2. could be much simpler, produce from access a vcs file - outlook should recognise this as an appointment, the format is like this: BEGIN:VCALENDAR VERSION:1.0 BEGIN: VEVENT DTStart:20020822T130000Z...
  18. mackers2

    Emails in Access to Outlook address book

    Yes you can, here is some sample code from the outlook help which shows the basic idea - you can start this from access and fill in the outlook fields from your database. Sub CommandButton1_Click() myName = Item.To Set myNameSpace = Application.GetNameSpace(&quot;MAPI&quot;) Set...
  19. mackers2

    FAX group of Word 2000 docs from Access 97

    this is what I would do: buy winfax make sure you have the fax number to send to accessible make button start up word and load the document and then if you have to insert on the fly from your current record, make sure you word document has bookmarks in that you then replace with the current...
  20. mackers2

    Accessing an outlook emial folder

    Hi, here's bit of a solution - this will go thru your default inbox in outlook and save all the attachment files in it that end in xls into G:\testvery rough and ready and outlook will probably shout at you saying do you want to allow this. no trapping. don't know what happens if you have...

Part and Inventory Search

Back
Top