Search results for query: *

I have a form which I has two combo boxes. I want the first combo box to select the table which the data in the second combo box will come from. I have four strategy level tables strategy1_tbl strategy2_tbl strategy3_tbl strategy4_tbl each table has several fields including the following...

I have a couple of questions regarding your response. I have created a table with the categories names as records in one field. I then imported the table into my query and linked it to the field which holds the results for that question in the queries control source. I then set the link up as...

I have set up a chart based on a query which does a count. The categories are numerical and can either be 1,2,3,4. Is there anyway for the chart to display an empty space when, for example, there are no results for category 3. The reason for this is that I have a standard legend which I am...

I occasionally use word to check spellings if I am using another program that does not have a spell checker. A while ago I checked the spelling of the word 'Commandeering'. I simply opened word typed it in and then closed word. However now every time I open MS Word the word Commandeering is...

I am using Microsoft Office 2000 and Windows XP. I have set up a report in Access which has lines between the records. It all looks fine in print preview but when I export to Word all the lines dissapear. Is there anyway of stopping this from happening. Thanks

I have solved this problem myself if anyone is interested this is how I did it. i set up a filter in the reports query to search for records which met the criteria <date(). I then used the applyfilter macro command to activate this filter when the correct checkbox is checked.

I am trying to set an option on a form (either a lookup table or check box) which will then activate the following criteria in a query <date(). I have tried setting this formula up in the lookup table and I have also tried setting an IIF statement to pass this expression to the query when a...

I am trying to set up a mail merge from an access table to a word table. I have set it up as a catalogue so that I can display multiple records on one page. After setting up a table with five columns and putting the merge field in each column I then put the next record command after the last...

I wasn't sure if you meant put the expression in criteria lines 3 and 4 of the same field or the other field so I tried both e.g Field: Owner Table: actionsnolinktbl Sort: Show: Criteria:[Forms]![reportselectoractionsnl]![Combo29] or: Like [Forms]![reportselectoractionsnl]![Combo29] Is Null...

The first part of the expression is on the 1st criteria line of the query grid and the second is on the second (or) line of the query grid so it looks like this. Field: Owner Table: actionsnolinktbl Sort: Show: Criteria:[Forms]![reportselectoractionsnl]![Combo29] or: Like...

I have set up a form in access 2000 which allows you to select criteria in order to run a query. This is done via a series of combo boxes. I want the query to pick up the criteria from the combo boxes which the user select but ignore the ones the user leaves empty. In the query i am using the...