Search results

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

Hello again. :) My account is planning to upgrade the Access they use from 97 to 2000. But my boss wants to know what the impact would be to my database system that was created in 97. I was wondering if there is a document or web sites that shows all the changes between 97 and 2000. Or...

Works like a charm now Thanks :D

That is true. Almost every time I use a Date() statement I am putting the result in a field. This time I have no field So is there a way to use the current date in a where check? I tried using CURRENT DATE which I saw in my DB2 book but got a syntax error near the field.

Hello again. I am trying to create a query and here is what I have currently: SELECT Count(*) AS Count_Action_Items, Sum(IIf(Actual_Completion_Date<=Target_Completion_Date And Actual_Completion_Date >#1/1/2000#,1,0)) AS Sum_On_Time, Sum(IIf(Target_Completion_Date < Date(Now,"mm/dd/yy") Or...

Nope no luck. I get an error message saying 'Syntax error (missing operator) in query expression "Count (Distinct Requirement_Number)'