Search results for query: *

THANKS PHV !!! I tried spreadsheettype 0 which is acSpreadsheetTypeExcel3 and it worked! Appreciate your inputs. Thanks Again! - Amit

Is there any way so that the ticks do not appear? The important point is if I try to export the table into excel directly from the Menu - File->Export there is no such issue. The ticks are not seen for TEXT fields. - Amit

Hi, I am trying to perform export of a table in Access Database to a xls spreasheet. For this I am using the command: DoCmd.TransferSpreadsheet acExport, 8, "Report", Me!txtExportFileName, True However I get a tick (') in the all the data exported. This happens for the fields which are of of...

Thanks Richard. :-) Your info is helpful. Well I am pretty sure that all the value in the text field is numeric psuedo text so converting to NUMBER should not be a problem. However I want the NUMBER to be of format DOUBLE as per Access format. My text numeric is 20-digit long! So will CSng...

Hi, I am trying to perform export of a table in Access Database to a xls spreasheet. For this I am using the command: DoCmd.TransferSpreadsheet acExport, 8, "Report", Me!txtExportFileName, True However I get a tick (') in the all the data exported. This happens for the fields which are of of...

You very well get all the traps on the device even if you miss it. This is only possible if the device implements RFC 3014 - Notification Log MIB. As mentioned by "leaf" some devices do have an alarms table implemented but there you can get the current alarms traps not all the traps...

Thanks PHV. Got answer to first question. But still not clear on the second one :-) >> Where is the specification file stored? If I remember right, on two MSys??? tables. What did you mean by two MSys? - Could you elaborate? TIA - Amit

Hi, I am trying to change the Data Type from Text to Number- Double for a particular column in the Access Database. This Table contains thousands of records. While doing so I get the following Message: Microsoft Access can't change the data type. There isn't enough disk space or memory...

Unfortunately Error Text is not printed. - Amit

Thanks PHV. Can you give more details here. How to access the External Data Import Wizard? Where is the spefication file stored? I am new to MS Access so appreciate if you can give more details. Thnx! - Amit

Following is the ASP Code: Set objDataServicesManager = Server.CreateObject ("XYZ.Services") Dim blnDataFound blnDataFound = objDataServicesManager.Export(ClusterID) The Export method in the COM object does get called but it seems it throws an error from the COM object when it reaches...

Hi, I am new to VBA for Access. I am trying to locate the specification file "ABC" provided in the following statement of VBA code. DoCmd.TransferText acImportFixed, "ABC", "tblTextABC", filename Can someone please tell me in what ways the specification files are created? Thanks - Amit

I am making a call to the VB COM component which throws error. Due to some reason I cannot debug the code directly so I am trying to analyse and see the problem. Following is the Code in COM:- : : Dim strOutPutFileName As String Dim aen As AppErrorNumber : : : strOutPutFileName =...

Hi, I am getting an error in ASP with error code: '80046465'. Any pointers on what this error code corresponds to? Thanks! - Amit

Hi, Can anyone tell me where can I find the Mosy MIB Compiler. I guess it is a freeware SNMP MIB Compiler. Thanks, Amit

Hi, If you do not have the write permissions probably the community dting which u have given as "public" is wrong. Check what community string is set on the device with read-write permissions. Which machine/hardware are you trying to send these snmp requests. You need to use the...