Hi Withina report, I set the field value of an unbound control by way of a Case statement -eg: Me!GroupLevel.ControlSource = "Service Type" Based on the same...

A2K I have a simple report that shows a list of drawings and the dates we received them as well as the Revision # of that drawing. In the crosstab...

I have a table which shows basic vehicle information linked to another which shows vehicle options. When I create a query to show both basic...

I have used a textbox =1 and running sum over all to label the lines on a report but can you do it in descending order. I have a report of amount received at...

My previously-working PDF-from-Access solution using the PDF995 driver suddenly started hitting problems recently. I have eventually discovered the cause -...

Hi Hope someone can help I have selected data for a report which includes two fields - 'Created By' and 'Service Type'. Sometimes we will want the data...

Please some one tell me ....whether Cryestal Report can be used with Access. If yes..please give me web addr. for the help. Thanks and Regards

Hello there, I have a database that is on my company's network shared drive which can be accessed by all with the appropriate priviledges. However, whenever...

Yes, Jameson, when you export to Word, all the graphical elements are discareded, including lines, check boxes, and images. There's a very simple solution...

I have an address db which from which I need to get a report detailing birthdates on a monthly basis. The fields I use a Birthdate Father Birthdate...

HI There. I have set up a query which pulls through to a label report.. but just wondering how to pull through the formatting. ie. in the forms/tables, the...

When I publish my Access 2002 report to a RTF in Word it goes to Wordpad, it didn't do that before, any idea why it is going there now? What am I missing???

Hi There. I have set up a query with a parameter field to print labels (full page of the one). As the first and last name are in different fields, the last...

Hi There Are you able to advise if it is possible to pull though info from Access into an existing word document and then allow the user to enter their...

If I have 2 unbound controls on a form, ie. num_no and types, how do I limit the types to only those types that are related to the num_no and pass these to a...

I made a report from a query. Query has a field which is longinteger. I didn't add a counter with the wizard. How or where do I add it now? I want to count all...

I created a catalog in Access 2003. Data to the left of the page lists the name of the product and it's main properties (dimensions, content, and price). The...

I'm trying to display an estimated gross profit percentage on a report, but I keep getting syntax error messages and have tried a variety of expressions. I'm...

I can use a filter equation in another field such as: like "A*" and the filter works fine. However I need to do the same thing on a yes/no field but can't...

Please help. I have 2 tables: the 1st one contains a field named "Subject Area" with a combo box listing values in the 2nd table (which has only the subject...