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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by elvenmaiden

  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

    Am trying to compare a date 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...
  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

    Receiving the following error message: &quot;Item cannot be found in the collection corresponding to the requested name or ordinal&quot; Scenerio: The rsSalesHours is a table in Access generated by a crosstab query which has variable column names (i.e. column names Jan, Feb, Mar... or June...
  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...
See more

Part and Inventory Search

Back
Top