Search results

OK - this is how I got it to work. There may be better ways... Put a new textbox on your report. Set the Data Source to: =Day([YourFieldName]) & UCase(MonthName(Month([YourFieldName]),-1)) & Year([YourFieldName]) HTH Chris

Hi. In your date field in the query grid, type the following in the Criteria cell: Between [Enter Start Date] and [Enter End Date] This will prompt the user to specify the date range. If it's just one date you want to specify, just type [Enter Date] in the criteria cell. Hope this helps

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

Thanks for your reply. Unfortunately, I didn't make myself clear on the original post. If one (or two) of the subform fields are zero, I want the calculation to ignore them and perform the calculation only on the fields with valid data. Any ideas on how to do this?

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

Instead of having the command button you could show resord selectors on your subform, then enter the code in the OnClick event of the subform. Then the user could click on the record selector to navigate to the main form.

Instead of having the command button you could show resord selectors on your subform, then enter the code in the OnClick event of the subform.

Hi Neil - thanks for replying. Yes, the form is open (it is not allowed to close while the db is open) and the control is populated. I don't think that is the problem as the query (QryCustomer) that returns all information relating to the customer named in the textbox returns the correct...

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

No, because it's part of a larger report I produce. Anyway, using SendObject doesn't solve the problems re formatting (Word) or data loss (Excel) Thanks anyway for replying.

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

Can't tell. If I do that it returns no results, which is correct. But it is also returning no results in scenarios where I would expect to see records returned. Weird!

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

Thanks for the comprehensive response. Everything imported to the blank DB fine, and it now seems to be working like a charm. Fingers crossed.

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

Sorry, I only have 97.

Yep - I'm definitely selecting the correct tables - one thought though - I notice that the 'bound column' property defaults to 1. If the Primary Key column comes first in the SQL statement, then should the 'bound column' be 2, thus selecting the column containing the info? Does this make...

I've got it sorted thanks. Yes, I was using the ComboBox Wizard, for some reason, when I selected the field I wanted shown in my ComboBox, it was also selecting the primary key field from that table, this was column 1 in my ComboBox but the properties had defaulted to zero width so I couldn't...