Recent content by hammerva

Hello, how are you. Hey new smilies cool :D Anyway is it possible to convert a field with a type of OLE Object to a text or memo field? I tried just doing a regular update query with a new field to type 'MEMO' but the data was mostly junk.

There is a user in my application who keeps getting a "Automation error" message every time they click a check box in one of my forms. Yet when I try to use it on my system I don't get any messages. What does 'automation error' mean? Why would I get the message when clicking on a check box...

Same result. I set the format of the text box to 'General Number' so that it should be shouldn't be blank. No idea

:mad: Still no luck. Change the control source =Nz([Count_Open_Low],0) for the report text box field 'Count Open Low' and still get a message saying #error. Wish there was a way to know what the actual error message was. Maybe if there is no data on a report, the text box isn't NULL or...

What I want is the first text box with the label 'Number of Risks in Open Status with Low Risk' to show the value of the field Count_Open_Low from the query if records were processed. If the query did not produce any records based on the date criteria, I want the text box to show 0 not blank or...

I am confused by the "" in the true condition of the IIF statement. I don't want to put a space in the field if there is data. Actually I already have a space in that field if there isn't data. Here is a stripped down version of my database in Access 97. You will have to enter parameter...

The source object is Report.Risk Activity Report - Summary The name is Risk Activity Report - Summary Why would that be important if it is a text field in the main report that is causing the issue. The subreport is actually showing data (although would have the same problem if no data exists...

Actually the fields I am having problems with is on the main report not the subreport. So it looks like I am doing the same thing you just mentioned. But could be wrong.

I looked at some examples of the HASDATA and modified the control source for text box 'Count_Open_Low' to say: =IIf([Risk_Activity_Report___Summary].[Report].[HasData],[Risk Exposure Query]![Count_Open_Low],0) But I get a #name? message in the field I know that the query used is Risk...

Hello again. :) I have a report that consists of 2 subreports merged into one. Each report uses its own query to get the data. I just ran this report for a month and one of the subreports showed data but the other showed blanks in the fields. The reason for the blanks is because the query...

I have 3 tables that have the same definition and layouts. Is it possible to merge these tables into 1 complete table in Access 97? Thanks

Actually I am still confused about one thing. I was able to create the text file with the export specification 'Functions Point Count'. But if I go to Excel with this text file, I still get the Text Import Wizard and I still have to set the field widths for the file. Why isn't the...

That did the trick. I was able to create the Export specification without a problem. You rule :D

I tried both ways and I got the same error message. I thought that maybe I needed to run the Metrics Total Estimated Hours query at the same time but that didn't do anything. Actually I can't even get to the Export Wizard box. It fails when I click on Export in the Save/Export Dialog box...

I am trying to create an export specification for a transfer text command in my application. I am trying to take a query and export to an text file. Here is the query: SELECT A.Release_Number, C.Status_Number, C.Status_Description, C.Current_Function_Points AS Function_Count, C.Project_Type...