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 Wanet Telecoms Ltd 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: *

  • Users: elvenmaiden
  • Order by date
  1. elvenmaiden

    Auto Email with HTML Link

    Additional info...using outlook to send out emails
  2. elvenmaiden

    Auto Email with HTML Link

    Have set up an access database with automatic email. Would like to send out an e-mail with a link to an existing web page. The following syntax isn't working...any suggestions? .HTMLBody = "<HTML><Body> Hello <a href=chr$(34)http:\\www.google.com chr$(34)>Google</a></BODY></HTML>" I...
  3. elvenmaiden

    Persistant Cache Question

    Would like to implement persistant-named cache on concurrent sessions in Informatica 7. The question I have is if the recache is set on one of 7 sessions in a concurrent batch will the other concurrent sessions wait for the recache to occur? Also, if the look-up using persistant cache and...
  4. elvenmaiden

    Persistant Cache and Concurrent Sessions

    Would like to implement persistant-named cache on concurrent sessions. The question I have is if the recache is on one of these sessions will the other concurrent sessions wait for the recache to occur?
  5. elvenmaiden

    Marts vs. materialized views

    Could anyone discuss the pros and cons of using a mart vs. a materilized view?
  6. elvenmaiden

    Date Comparison

    ...time picker value to a date field in access, but cannot come up with the right syntax. Would appreciate any suggestions i.e. .Open &quot;Select * from tblDate where EffectiveDate = # & dtpEffectiveDate.Value & # This syntax does not retreive any records. Also tried to set the...
  7. elvenmaiden

    How to: Update Access database via internet

    ASP would help - try a weekend book course in ASP
  8. elvenmaiden

    Uploading files to a Web Server using FTP

    If any one of you has this ftp code, please let me know. Thanks!
  9. elvenmaiden

    Best structure?

    If intGuests > 1 then x = 0 do until x = intGuests cur = cur + 10 x = x + 1 loop end if
  10. elvenmaiden

    Recordset Navigation and variable column name

    Thanks mattKnight, This did the trick: intCurrent = rsSales.Fields(mstrCurrent) You are the bomb!!!!!
  11. elvenmaiden

    Recordset Navigation and variable column name

    ...for use With rsSalesHours .ActiveConnection = CurrentProject.Connection .CursorType = adOpenStatic .Open &quot;SELECT * FROM tblCrosstab&quot; End With With rsDifference .ActiveConnection = CurrentProject.Connection .CursorType =...
  12. elvenmaiden

    crosstab report question

    Thanks, I had my recordsourse messed up. So...it's running now. Thanks a million!!!!
  13. elvenmaiden

    crosstab report question

    VBSlammer thanks for the help. When I used this code I get a 9-page report preview - but there isn't any records showing (i.e. the 9-pages are blank). I feel really stupid, but what do you think I am doing wrong?
  14. elvenmaiden

    how to load a picture in a picturebox from a database???

    Did this in a project at school, but really went around the mullberry bush to get there. Probably a better way, but here goes: We put the file path in the database and then called the path to load the picture box. Hope this helps
  15. elvenmaiden

    crosstab report question

    I didn't realize this was in the solutions database... Got the structure from a book. Have several cross-tabs queries that will feed into unbound reporting structure with the above code running in the background. The code I have listed is working for dynamic column headings - no problem...
  16. elvenmaiden

    crosstab report question

    ...for use rsSalesHours.ActiveConnection = CurrentProject.Connection rsSalesHours.CursorType = adOpenStatic rsSalesHours.Open &quot;SELECT * FROM qryMonthSalesHours&quot; 'determine number of columns in the recordsource mintColumnCount = rsSalesHours.Fields.Count...
  17. elvenmaiden

    Only getting 1st or last record in details section of report

    Trying to hard code a report based on a recordset. Problem with obtaining more than one record in the details section of the report. I tried without a loop and with a loop. Without a loop I get the first record of the recordset - with a loop I get the last record of the recordset. Is there...
  18. elvenmaiden

    Internet Connection Sharing and Macintosh

    I have recently upgraded to Windows 2000 from Windows 98SE. With Windows 98SE I was able to set up connection sharing with two NIC cards and checking the sharing box on my local network card. I have kept the same set-up with Windows 2000, but the Macintosh can no longer touch the internet...
  19. elvenmaiden

    Autorun in 8.5.1 problem

    I am using the following autorun.ini with a director 8.5.1 projector: [autorun] open=repke.exe /autorun It is not working. This same autorun.ini was used with an 8.5 projector and it worked just fine. Any suggestions?
  20. elvenmaiden

    SQL-PROBLEM

    &quot;SELECT SUM(Questions)as Question, FROM qryStats WHERE OrigDate >= # &quot; & DTPBegin.Value & &quot; # AND OrigDate <= # &quot; & DTPEnd.Value & &quot; # &quot; You can either SUM() a field or COUNT() a field over a specific date range.

Part and Inventory Search

Back
Top