Recent content by Ben6550

Does anyone know of a good site where i can download fonts free of charge. I am looking for the serpatine font. Any recommendations much appriciated!

I have a font which i do not have installed in my fonts file but has is used in a Word doc i have. Any idea's how i can install this font direct from Word XP into my font's folder??

I want a sub which will change the background color of a text box when a check box has been clicked. However when i click the check box the text box for all the records change color when i only want a single record to change. How can i get around this. Code is: Private Sub employed_Click()...

This is the query using the wizard produced, but i recieve is an error message saying query is too complex to be evaluated: SELECT interview.Position FROM interview GROUP BY interview.Position HAVING (((Count(interview.[Interview Date])) Between [Start Date] And [finish Date]) AND...

I want to run a query which extracts data from a table and returns a total, the data is text form and i seem to be unable to get a total for the extracted records. Any ideas?

Hi, I want to produce an auto key macro that filters for data between two dates by prompting the uset to enter the dates. I cannot use the "between" function in the expression builder. Is there a way i get around this?

I want to send reports from access by e-mail to non access users. I currently send the reports as rich text format, however the reports contain check boxes which do not show up in RTF. Anyone know how i can overcome this problem??

I am tring to create a macro that filters for two different boxes are checked. What code is needed in the 'where condition' box when i have selected ApplyFilter drop down?

I want a text box background to change a different colour when each one of four check boxes are selected within the same form. Does anyone know how to achieve this??

I am trying to merge my query results into a existing word2000 document using the wizard, however once i have entered the source of the access query i get the message "unable to open data source" how can i over come this problem?

Where abouts do i programme a query such as: SELECT SUM(Days) AS (Total Days) FROM Weeks WHERE =Tuesdays The only queries i know how to use are using the wizard.

I wish my query to look at one column of data in a table and ask user for parameter to search for & return a total on ie. ourrances of SMITH in surname, instead of writing seperate queries for each parameter.

Does anyone know of a good website for list of the diferent access query creteria?

Pretty simple solution to this prob... when i run a query using the total function to display sum of table i am recieving a negative total when i am after a posertive total number. Any solutions..

I need to produce a query that returns just a total for a list of data within a access table column and display it in a report.