Search results for query: *

Hi I have a table with a number of dates that are checkboxes. I need to mailmerge this table into a letter and display the label of the checkbox rather than the True/False value of the check box. I have tried an IIF statement so if the value is true to display the date (eg...

Hi We currently have an Access database which consists of alot of queries and reports and a form from which users can modify the criteria (dates, officers etc) for each report. This has been working very well, however, as this database is being used by more and more people the administrator of...

Hi I have an Access query in which I calculate the number of Working days between two dates. How do I workout the average of this figure? I have tried using Avg as well as dAvg both in the query and also in the footer of a report but I just get errors. Any ideas as to what I am doing wrong...

Hi We have 2 (Canon/Oce) printers on each floor and each individual prints direct to the own mailbox. We have an access 2000 database that is basically a report generator from an internal system. Reports are being added and amended all the time but whats recently started happening is that who...

Hi This probably has a very simple answer but I can't find it! I have an audit table which records any changes made to another table which contains applications. The audit table records the date and time of the change, who did it and the application number. An application maybe updated a number...

Hi We have a changed the density of our tape deck and the instructions say to 'format' the tape. How do we do this using Solaris 8? Any help would be appreciated!! Thanks

Hi I have a problem which probably has a really simple answer! I have a blank field on a form which I want to update with todays date when a button is clicked. I have created a macro to do this but at the moment it puts the date in all the records and not the current one displayed. How to I...

Hi I currently have a VB6 program that we use to transfer times and dates of completed helpdesk jobs into a time recording system. We recently had an upgrade to our helpdesk system to Access 2000 and I am having great problems getting the vb6 program to work with it. I have added the MS DAO 3.6...

Hi, I have a quick question that may not even been possible. Do you know when you select the 'Find and Replace' box, is there any way to change the default on the drop down list for match to 'Any part of field' rather that 'Whole field' which it is currently set to? Thanks Fi

Does anyone know how I can pass parameters from a vb6 application into Access? I currently run a report in Access based on a number of criteria, which are selected by the user in VB, one of which is a date range. This all works fine but I would like to put the date range input by the user into...

Hi Does anyone know whether it is possible to number records in a subform? I have managed to do this on a report using the Running Sum property on a textbox but you can't use a Running Sum property on a text box in a subform. I don't want an Autonumber because that will number all the records in...

Hi I have a form which contains a persons details and have added a subform. This subform just contains a combo box with a list of venues and 5 date fields - each venue only has 5 dates so when you change the venue the dates change appropriately. This subform works fine independently and the...

Hi there Does anyone know of a formula or a way of counting either only odd or only even numbers in a range of numbers? I have 3 fields as below: FROMHOUSE TOHOUSE ODD/EVEN 52 58 E 84 92 E...

Hi I have a query that contains planning applications and also the dates that the applications were last edited/updated. Some of the applications may be edited just once or twice and some maybe edited hundreds of times.What I am trying to do is just extract the first occurrence that the...

Hi, does anyone know a way within Access97 that you can format a text field into Sentence case (ie, first letter capital the rest lower cae?). I can only find the Ucase and Lcase functions. Is there a VBA module available that will do this?