Recent content by cwbviper

Hiya, The subforms are linked to the mainform by the Primary key. And the subforms are not populated by queries. Cheers Colin

Hi All, --Database Setup-- I have created a basic client satisfaction survey database for our organisation. I have split the questionaire up into seperate sections for Personal Details, Services they have used in our organisation, and an Overview of what they thought of the facilities. Each of...

Hi jaydeebetoo, Thanks for the help. I've ended up calculating i using the DCOUNT function. Seem's to work ok. Cheers Colin

Hi jaydeebetoo, The total for TOIL is also going to be replicated for absence and these all impact on pay, holidays etc so i have been asked to build this into the database. The value is not stored in a table on it's own, i have added it in as an additional field on one of the main tables. I...

Hi there, I have created a Personnel database, part of which records TOIL, with a new record created each time a staff member has time off. The amount of time off is recorded in a field for their staff records. I want to show on their Personal Details section a total of all days they have...

Hi Grande, That is exactly the kind of thing i was looking for. Many thanks. Cheers Colin

Hi there, I have created a database which will record number of days absent. However i want to keep a running total of this, so our Company Administrator enters the number of days absent in a field, this will enter the number into an additional field, and keep a running total when more entries...

Hi projector1, I contacted the support company previously and was told it was a hardware issue, whereby i contacted the company we have hardware support and was told it was a software issue. They have just blamed each other. Cheers

Hi there, I'm having trouble printing from our DOS based Finance Package. It's a DOT_Matrix printer connected through LPT1 to a WinXP machine. The printer is shared to give permission to Everyone. There are 2 Win98 PC's which are working fine, although i am trying to connect another WinXP PC...

Hi there, I have added on a word document to our Intranet site for a standard letter. The idea being, staff will open the Intranet, click on the link for the standard letter, fill in the relevant information and print it off. 2 of our PC's will not allow the user to do this, as when they click...

Hi there, We have a database in our office which records contacts with our clients. I am trying to run a query for a report which will show which clients we seen between a particular date. Since we may have seen a client more than once between those dates i am getting several instances of that...

Cheers for the help John, I'll give it a try. Colin

Hi there, I created a Personnel Database at work and set up a button which will email our company administrator when a staff members contract is up for renewal. At the moment this only works if the contract is up for renewal exactly 6 weeks from the current date. This is the code i have...

Thanks for all the help, i'll give it a try. Cheers Colin

So if i create a query based on the initial table i created, and use this new query as the record source with the code, it should allow me to archive clients? Cheers for helping Colin