Search results for query: *

Ah a break through. For some strange reason after I re-executed the views on the SQL Server end and then refreshed the database connection several times on the Crystal Reports end, only then did Crystal interpret the field as string. This doesn't make a whole lot of sense to me since we didn't...

OK, I think there is one thing that is being misunderstood here. Crystal is automatically converting the nvarchar to number from the database connection. The filter I use in the select expert does not and cannot change the data type taht appears. If I use "0" instead of 0, I get an error saying...

Tables and Views contained in a SQL Server database contains a field (Parcel_UID) defined as nvarchar(50) This field contains a 13 digit number (e.g. 1000017299772) I use Crystal Reports 9 to connect to the SQL Server database so that I can use the views to create a report However, Crystal...

I have 2 worksheets in the same workbook On worksheet "PIR-DT MTH" there is a cell (i.e. "E3") which contains a string value representing a range of cells, eg. "C4:L32" This range value changes due to specific triggers which aren't important In "PIR-DT MTH", there is a named range called...

Thank you rjs2. I had reloaded my laptop and started getting that exact problem in Outlook 2000. I never had that probelm before and I tried and tried and tried and tried and couldn't figure it out. Strange enough I thought I did use the Check Name button before, but it must have been as I was...

I created a feedback form using the template provided in FrontPage 2000. I saved the form on my web as Feedback.htm I configured the Frontpage server extensions on the server to specify how mail should be sent etc. I tried the form out and it worked...cool However, I repeated the same process...

I am working on a project which basically transfers data from Access tables to Excel worksheets. Some of the data is in the form of formulas. Hence, a table would have a formula field with the formula string/text (eg. =utilities*3). Below is a portion of my code where I am getting the annoying...

Yes, what you said is true, but when the formulas are transferred to the cells, they are automatically set to "General" number format. So that's not the problem either. And just for the heck of it, I still entered code to change the number format to "General" and recalculate...

I tried the recalculation thing, but it didn't work. I tried doing it manually (i.e. pressing F9) and not a thing happened! Any more suggestions

I am doing a database application in Access which entails having to transfer a lot of information, including formulas from Access to Excel. I envision I will be running into a lot of problems, but here is one I can't figure out. The portion of code below shows where the problem develops. I am...

I am getting a run-time error 3061 when using openrecordset command with a query. I am testing and learning code to export table information to an MS Excel worksheet. I have pasted the code below. Now I have used this code over and over several times and never had any problems until now. CODE...

I am getting a run-time error 3061 when using openrecordset command with a query. I am testing and learning code to export table information to an MS Excel worksheet. I have pasted the code below. Now I have used this code over and over several times and never had any problems until now. CODE...