Search results for query: *

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

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

Is there a way to automate it?

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

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.

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

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

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

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

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

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.

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

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

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

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

Can anyone help?

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?

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

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.

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 ! ! !