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 Chriss Miller 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 janetb99

  1. janetb99

    Siwtching Hardware on FSMO Server 2003

    Davetoo, Sorry. From various sources. Microsoft's site and this site, in particular. Janet
  2. janetb99

    Siwtching Hardware on FSMO Server 2003

    I'm getting new servers, and one of the boxes is the FSMO domain controller running Active Directory, DNS, and Global Catalog. I know this is terribly anal and insecure, but I do this once every four years (lease). Sound like a good game plan or does anyone have suggestions for improvements...
  3. janetb99

    Task Scheduler and Access

    Thanks for the help. Sorry to be so slow, it's my first time at this sort of thing. That did the trick and everything's ducky now. Janet
  4. janetb99

    Task Scheduler and Access

    On XP SP2 machine, I'm trying to get an Access DB to open automatically every day at a set time. Here's the syntax I got from: http://support.microsoft.com/?id=210111 myTest.bat is the following: c: cd\Program Files\Microsoft Office\Office10\MSACCESS.exe f:\APPS95\List\listAuto.mdb Task...
  5. janetb99

    Getrows to string

    Finally hit on a combination that worked. Many thanks to all for replying. Here's the one that worked: strMsg = "Detailed summary report for the following docs: " & vbCrLf Dim rs As ADODB.Recordset Set rs = New ADODB.Recordset rs.Open "qryFHCxlsRpt"...
  6. janetb99

    Getrows to string

    Eupher Ken, Ummm. Well, I commented out everything and then un-commented one step at a time. It started hanging when I got to the Do While statement. I commented out the rs movement and just tried the field stuff, and the email came through blank except for the line before the rs. When I...
  7. janetb99

    Getrows to string

    Eupher, Thanks much for the explanation and response. What you're saying does make sense. I tried your approach, but now Access hangs until I kill it with Task Manager. Would appreciate more insight: strMsg = "Detailed summary report for the following docs:" & vbCrLf Dim rs As...
  8. janetb99

    transferSpreadsheet export problems

    Roy-Vidar, Any ideas about this? I've tried three different ways and can't get the list from the recordset to populate the email body. Email comes through fine, but just with the sentence. Try One: Dim rs As DAO.Recordset Dim vArray As Variant Dim strTo As String Dim strCC As...
  9. janetb99

    transferSpreadsheet export problems

    Eureka! Thanks Roy-Vidar and PH Appreciate the assistance... Just in case someone else runs across this: Does not work: strFileName = "f:\users\janetb\fhc" & StrConv(Date, vbShortDate) & ".xls" Works like a charm: strFileName = "f:\users\janetb\fhc" & Format$(Date, "mm-dd-yy") & ".xls
  10. janetb99

    transferSpreadsheet export problems

    Anybody know why this isn't working from AccessXP? Dim strFileName As String strFileName = "f:\users\janetb\fhc" & StrConv(Date, "mm-dd'yy") & ".xls" 'DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, "qryFHCxlsRpt", strFileName, True DoCmd.TransferSpreadsheet acExport...
  11. janetb99

    Getrows to string

    trying to send file with email body populated by one field. Get the email with attachment fine, but can't get the fields to display in the body. I've tried: the following three and nothing seems to populate? 1. Dim rs As DAO.Recordset Dim vArray As Variant Dim strTo As String...
  12. janetb99

    CSS and IE

    Vragabond, Well, thanks, I guess. But that wasn't my question? I'm investigating, remember? There are some who feel that tables cause delays in page loading because the page has to be completely parsed twice before display. If you have a large dataset, have limited resources for buying...
  13. janetb99

    CSS and IE

    As a newbie to CSS, I'm trying to set up a page, experimenting with replacing tables. I have a test page at: http://www.mtn.ncahec.org/web/test.asp Can anybody give me a fix and brief explanation on why it works fine in FireFox and not IE? Something to do with floats in the parent divs...
  14. janetb99

    doCmd.SendObject Email

    Background: WindowsXP, OfficeXP, GroupWise Simple Access form displaying single record, including email address. On button-click, want to go to visual basic and use doCmd.sendObject to display an email dialog box in GroupWise. I'm pretty sure things are set up okay on our network, cause the...
  15. janetb99

    Temp table cursor and dynamic sql build

    I need the ability to build an sql statement based on variables, use the local temp table option to keep users separated, and then cursor through the recordset to actually determine and calculate inserts into another temp table for selection. I've read that cursors can be slow, but because of...
See more

Part and Inventory Search

Back
Top