Recent content by azalealee

Description is a text field. I've created something that might work for me for the time being - the format is a bit dodgy, but at least the info is in the right places. I created a form based on table All_Dates and put a subreport into the detail that has a header for Allocated_To and the...

I get the error message "The expression is too complex to be evaluated..." Perhaps it isn't able to find the First/Min/Max/Last of a text field? Maybe I should have mentioned that there are many Descriptions for each date and I need each of them listed. Thanks for your patience.

Thanks. Did what you said, and it got rid of those messages. I'm now getting the message "You tried to execute a query tht doesn't include the specified expression 'Description' as part of an aggregate function." Am I able to set Description as a value in a crosstab if it isn't an...

I tried creating a crosstab query by specifying the new table All_Dates as the rows, Allocated_To as columns and Description as values. Unfortunately I can't get the query to run because I use many Immediate If (IIf) statements in my original query. These IIf statements evaluate user selected...

Hi I'm trying to design a calendar report for a Work Scheduling Access 97 database, but I'm having some difficulties. I would like the report to have a separtate row for each day, the name of the people doing the work as columns and the work descriptions as entries. The user inputs the date...

No, and I wouldn't even know where to start. Could you help me try?

Hi! I am using Access 97 with Lotus Notes R5 as my mail server. I have been trying to automate the attaching of reports in RTF for users through the SendObject method. I have the following code on the onClick event for a button: Private Sub cmdEmail_Click() Dim WorkID As String Dim...

Hi! I am using Access 97 with Lotus Notes R5 as my mail server. I have been trying to automate the attaching of reports in RTF for my clients through the SendObject method. I have the following code on the onClick event for a button: Private Sub cmdEmail_Click() Dim WorkID As String...

Hi. I've just split my database, with the back end residing on a shared network drive. Since I split the database, I'm not able to access the Switchboard Manager with an error message of: "The Microsoft Jet Database Engine cannot find the input table of query 'Switchboard Items'. Make...

I created the module, threw in the bit of code on the On Click event of the cancel button, but I added Me. Requery into the code for the Form_Activate event. Ie:If CancelIncomplete = False Then Me.opStatus = "incomplete" CancelIncomplete = True 'reset to true...

Thanks for your suggestions HomeAlone. 1)I tried to use Me.opStatus = "incomplete" on the cancel button for PUF_Incomplete, but the option group is in F_List_WOs - not the pop up. 2)I should have mentioned that PUF_Incomplete is an unbound form, but I'll try your suggestion by...

Hi there! I have a continuous form that lists work orders (F_List_WOs). This form has an option group (opStatus) for each work order record with three choices, Complete, Incomplete or Not Required. When the user selects Not Required, a pop-up form (PUF_Incomplete) opens with three command...

Thanks for the suggestion. Unfortunately the form needs to be continuous, which doesn't support sub-forms. I've come across a work around for now, but I don't know how this will affect my data integrity and relationships. I changed the Recordset Type property of my form from "Dynaset&quot...

Hi I have a very frustrating select query based on 3 tables. The basic content of the tables are: M_Work M_WO JT_Section_Work *Work_ID *WO_ID *Section_Work_ID Work_ID Section_ID Work_ID...

Hmmm... I did put the CStr into the code and I don't remember taking it out... But I did have a long fiddle with it... I just tried the query both ways - with and without using CStr and both ways seem to work fine. Azalea