Recent content by mikeyb540

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