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!

  • Congratulations gkittelson 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. rknmsp

    ActiveX DataGrid in Access 2003

    I have been given an Access 2003 app that is erring. It has a segment on a form where it attempts to create an ADO recordset object and databind it to and ActiveX Grid control. The code has Set <grid name>.DataSource = <ADO recordset> I get a message box that says Object doesn't support this...
  2. rknmsp

    Access 97 and SQL Server 2005

    I have an Access 97 Front End (solid workhorse that will eventually be converted). The data currently resides in an Access 97 mdb on the network. Another department is implementing a SQL Server 2005 backend. I was hoping to DTS the Access data into the SS DB, then have the front end link...
  3. rknmsp

    Date Formatting

    I have a result set that includes a date field, currently in mm/dd/yyyy format. I need to group according to mm/yyyy format. The issue is under mm/yyyy format is is reading the date field like a string value. So 1/2006 comes before 3/2005 and 12/2007 will come before 6/2006. Does anyone know...
  4. rknmsp

    DoCmd.OutPutTo a landscape snapshot

    I'm not sure if this is an Access issue or Windows XP. I use the DoCmd.OutPutTo method to save an Access report to a .snp file, which I then fax. The report is saved in landscape mode (which is correct). However, when I view the snapshot via the Microsoft FaxConsole, it is landscape, but...
  5. rknmsp

    Snapshot Viewer - Landscape Orientation

    I have an Access application which uses the DoCmd.OutPutTo to save an Access report to a .snp file for later faxing. When I look at the .snp file (via the fax console, but it brings up snapshot viewer), the image is in portrait format, but it is a landscape report, so it's sideways. Anyone...
  6. rknmsp

    Installing VB .Net 2003 on machine w/ Access 97

    Does anyone know of any problems that arise by installing Vb.Net 2003 on a machine that is running Access 97? Unfortunately upgrading Access is not an option at this time, so I need to know that nothing will get messed up. Thanks
  7. rknmsp

    &quot;Un&quot;-securing a database

    I have and Access 97 database (don't ask) that is set up under Access user level security. I want to do a conversion to a more current version of Access, but on a separate machine not attached to the production system. The test machine does not have Access security on it, nor do I want to...
  8. rknmsp

    Synchronized Scrolling

    Does anyone know if it is possible to have a form with 2 subforms, and to have the subforms both be able to be navigated by a single scroll bar on the main form? Thanks
  9. rknmsp

    Exporting to RTF for faxing

    I am using an Access 97 app to fax reports via Windows XP Fax Services. I use the OutputTo method to save the report as a RTF file. My problem is, in some cases a single page in my report may overlap on to a second page in the RTF file. So if I have a page that is filled (landscape) with data...

Part and Inventory Search

Back
Top