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 bkrike 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
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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?
  4. elvenmaiden

    Marts vs. materialized views

    Could anyone discuss the pros and cons of using a mart vs. a materilized view?
  5. 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...
  6. 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...
  7. elvenmaiden

    crosstab report question

    I am hard coding a crosstab query report that has a variable number of columns up to 16. The problem is I can only seem to print the first or last record in the recordset to the report print preview. (There is a looping structure I tried, but it is now commented out - it shows only the last...
  8. 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...
  9. 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...
  10. 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?
  11. elvenmaiden

    Object variable or with block variable not set

    This error occurs in the second with statement. Went out to Microsoft Knowledge base to retrieve information on creating Group Data Reports dynamically, as far as I can tell I have the right format. But I am getting a object variable or with block variable not set. I am certain there is...
  12. elvenmaiden

    SQL to Access - Can I ORDER BY a SUM column

    This is what I have, but it doesn't seem to recognize the AcceptanceRate as a valid sort field. SELECT qryStats.Name, qryStats.Subject, qryStats.Questions, qryStats.Solutions, AVG(qryStats.AcceptRate)as AcceptanceRate FROM qryStats WHERE qryStats.UserEmail = '&quot; + mstrUser + &quot;' AND...
  13. elvenmaiden

    Can I ORDER BY on a SUM column?

    This is what I have, but it doesn't seem to recognize the AcceptanceRate as a valid sort field. SELECT qryStats.Name, qryStats.Subject, qryStats.Questions, qryStats.Solutions, AVG(qryStats.AcceptRate)as AcceptanceRate FROM qryStats WHERE qryStats.UserEmail = '&quot; + mstrUser + &quot;' AND...
  14. elvenmaiden

    Do I have the proper syntax on this SQL statement?

    I am tring to connect to an Access qry through VB using SQL, but I am getting an overflow error. Any suggestions?? Set rsStats = conHelpPlus.Execute(&quot;SELECT qryStats.Name, qryStats.Subject, qryStats.Questions, qryStats.Solutions, SUM(qryStats.Accepted/qryStats.Solutions) as AcceptanceRate...
  15. elvenmaiden

    Overflow error - ADO recordset populated through SQL Query to Access

    I am getting an overflow error message if there is information in access to populate the recordset. Dim datBegin As Date 'holds begin date of report for recordset generation Dim datEnd As Date 'holds end date of report for recordset generation If mintDepartmentID > 0 Then If...

Part and Inventory Search

Back
Top