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 Rhinorhino 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. mikeyb540

    MS-Word Column Shading

    Hello, I have 4 columns in MS-Word. Each column is shaded gray. But each column length can extend longer then the other. When this is the case the long column continues on page two. When Print Preview it looks great but when i print the 2nd page column loses the shading. Any ideas how i can...
  2. mikeyb540

    Excel Export

    My bad. CR 8 Developer. I am running a unique situation where the report runs using the RPT file with CR.
  3. mikeyb540

    Excel Export

    Is there a way to automate it?
  4. mikeyb540

    Excel Export

    Hello, Is there a way to export the Crystal results in Excel? In other words to create the file auto after EOF. Thanks in advance. Mike
  5. mikeyb540

    Round Time

    Hello, Trying to figure out how to round 45min to the nearest hour 60min. I have tried Round(45*24,0)/24 Thanks in advance.
  6. mikeyb540

    Unix Date Query Criteria

    Thanks Again.... works like a charm :)
  7. mikeyb540

    Unix Date Query Criteria

    hmm... without the format function now I see the Time and wont the grouping right Any ideas on how to group per date?
  8. mikeyb540

    Unix Date Query Criteria

    that did it. it was the format. Thanks :)
  9. mikeyb540

    Unix Date Query Criteria

    Thanks PHV. If I leave it with # it reverts back to the old format 1/1/1970. Tried "1970-1-1" but i still get 2003 and 2004 data. What else can I try? Thanks in advance
  10. mikeyb540

    Unix Date Query Criteria

    Hello, Having a hard time with Unix Time in a Query. This is what I got Field is Date: (Format((DateAdd("s",Trim([DATECREAT]),#1/1/1970#)),"m/d/yyyy")) Then in the criteria I have a between statement as follows: between #9/14/2005# And #9/15/2005# My results return: 9/14/2003 9/14/2004...
  11. mikeyb540

    Backups Question

    Try creating Backup Jobs with BackupDevices for the days Then on the job that you want to overwrite include the INIT. Let me know if it makes sense or not.
  12. mikeyb540

    BCP error

    Hello, I am getting a BCP error that I cant see to resolve CTLIB Message: - L6/O8/S5/N3/5/0: ct_connect(): directory service layer: internal directory control layer error: Requested server name not found. Establishing connection failed. The server name is correct. Tested it with an ODBC DSN...
  13. mikeyb540

    Backups Question

    use INIT which will overwrite the previous INIT Specifies that all backup sets should be overwritten, but preserves the media header. If INIT is specified, any existing backup set data on that device is overwritten TSQL would like this: BACKUP DATABASE [DBNAME] TO [BACKUPDEVICE] WITH INIT ...
  14. mikeyb540

    Export to Excel

    just a typo...was trying to make it Italic DoCmd.OutputTo acOutputQuery, "qryMonthly", acFormatXLS
  15. mikeyb540

    Export to Excel

    aha...found the nasty bug...well FYI DoCmd.OutputTo acOutputQuery, "qryMonthly", [i]acFormatXLS
  16. mikeyb540

    Export to Excel

    Can anyone help?
  17. mikeyb540

    Export to Excel

    Txs PHV for the feedback. The problem is that it works on other Win 2000 PCs with Access 2000. Just one of the PCs has this issue. All the Access and Excel components with the sample databases are installed. Any other ideas?
  18. mikeyb540

    Export to Excel

    Hello, got a strange problem I have a command button on a form that exports a Query to Excel. <b>Private Sub Command11_Click() DoCmd.OutputTo acOutputQuery, "qryMonthly", acSpreadsheetTypeExcel9, , True End Sub</B> On click I get the following Run-Time Error <b>Run-Time Error 2282 The...
  19. mikeyb540

    Access front-end - linking to sql stored procedure?

    There is a way... try Pass-Through query. In the SQL view type EXEC YOURSPNAME. Then you have to enter the ODBC connection string in the properties.
  20. mikeyb540

    Datatype issue

    I am having trouble with a SQL Server 2000 datatype in MS-Access 2000. In SQL server it is a Numeric (6, 4) or 0.0123 or formatted as 1.23% MS-Access link object to table the datatype becomes Currency so my value becomes $0.01 and I cant convert it to a percent. Any ideas? Please, help ! ! !

Part and Inventory Search

Back
Top