Search results

krispi (MIS) 11 Nov 05 9:36 Hi all I have a database of mortgage applications. I have a query 'QryCasesToWork' which identifies applications to work based on a complex set of criteria. Once the query has run, I need a field called 'ToDo' to update to 'yes'. Unfortunately, one of the...

Hi all I have a subform which is used to return search results from criteria entered on the main form. I have used this same setup many times without a problem. On my subform footer, there are calculated controls used to display number of results and average value. No problem there. It all...

Hi all. I have three subforms on my main form. They all display salary details from different sources, and each subform has 2 calculated fields in the form footer to show the average salary and the number of records on which the average has been calculated. I then have a field on the main form...

Hi all - I have a suite of reports which provide customer details. They all require the user to input the name of the customer. The way it works is that I have a query which returns everything for the customer. Then I have other queries based on the first query which bring back the specific...

Morning all, please can anyone help with a little problem? I have a report which I need to export into either Word or Excel to email to a range of recipients. The problems I have are: If I export into Excel, the memo field in the report is curtailed to 255 characters. If I export into Word...

I have a query which requires date parameters, which the user enters into a form. The form enters the parameters into 4 different queries then runs them to produce a report. This all works fine EXCEPT for one query. If I enter my desired date range into the query (in this case it is between...

In one of my tables, there is a field named 'Brand'. This should only ever be one of two text values. Somehow, in a couple of records, the data in this field has chenged to "ÿÿ/ý*" or similar. I have tried to delete this and enter the correct information, but when I try, it produces a Dr Watson...

Hi all - I am getting a runtime error when changing a form from form view to datasheet view. The reason it's happening is that I have code in the OnCurrent of the form which populates a text box with information calculated from subforms on the main form. Obviously, with the form in datasheet...

...not as interesting as it sounds. I am looking to use the Dirty function in Access 97 to create an audit log within my database. What I would like to do is the following: In my Form (Form1), which is based on Table1, I would like to put an after update event on selected fields to do the...

I don't know, these new users bombarding the forum with queries...! I have another problem which I suspect is related to the problem in my previous post... I have a form which I have created from a query in order to enter some autolookup data from a table into a field (Field1), based on what...

I have a drop-down list in a form, which lists values from a field in a different table (Table1) to the one on which the form is based (Table2). The two tables are linked by a one (Table1) to many (Table2)relationship. The problem I'm having is that when the user selects from the drop-down...