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

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.

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

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

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

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

This is a strange one I am trying to shrink my Tranasction Log Im using DBCC SHRINKFILE (TRANSLOG1_LOG, 2) But nothing happens says: 20MB used 800MB free and the file LDF is 820MB I have tried the TRUNCATEONLY option and still nothing. I know all the transactions have been commited so why...

Hello, Is there a way I can rename Tables in the MSysObjects table? Txs in advance.

Hello, Is there a way I can rename Tables in the MSysObjects table? Txs in advance.

I have a link table to MS SQL Server that has images. Is there a way to view the Image(SQL server database Blob) on a MS-Access Form? If yes, is there control in Access 2000? Txs in advance. Mike

Is there a way to document the description on a table field? The native Documenter in Ms-Access does most of the work for name, datatypes, size, and etc. but will not extract the description. txs in advance. Mike

I am so puzzeled about this one. I have a Command_click with the following: DoCmd.TransferDatabase acImport, &quot;ODBC&quot;, &quot;ODBC;DSN=JRNL&quot;, acTable, &quot;UNNAMED&quot;, Text4 When I click to execute it does what it suppose to. When I change the DSN to a different Table it still...

Having a hard time setting up a TransferDB for a DBF DoCmd.TransferDatabase acImport, ODBC, JRNL, acTable, UNNAMED, TEST What am I missing here? Txs in Advance

Hi, I am supporting an App called WinDSS developed in Clarion 5 with TopSpeed DBs and it runs on Win2000 Pro. The app is constantly crashing with GPF errors. Is there a way I can debug? Also, are there any updated ODBC drivers for .TPS? I got a driver thats v3.00 C40TRX.DLL 2/14/2000 Txs in...

Just a Q... Is it possible to transfer my A2000 forms to a VB project?

I have a 2000 Server as a PDC. Installed Exchange 2000 with SP3. I stopped SMTP services from IIS recommended by MS When i enter the server name, it reports that- -------------- A connection could not be made to the Microsoft Server computer &quot;servername&quot;. The microsoft exchange...

Anyone know where I can get an Sybase 12 or higher ODBC driver? The Sybase site is driving me crazy. Cant find it there

Hi, I get a Runtime error '13' Type Mismatch. error My code is: Dim rs As Recordset Dim SQL As String SQL = &quot;SELECT count(table1.test) as TestCount FROM table1&quot; Set rs = CurrentDb().OpenRecordset(SQL) Me.txtTest = rs(&quot;TestCount&quot;) rs.Close Tried the ADODB for Dim rs As...