Search results for query: *

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

...to the Services or Overview section to start filling in information i get the following message box; You can't assign a value to this object. *The object may be a control on a read-only form. *The object may be on a form that is open in Design view *The value may be too large for this field...

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

...contract is up for renewal exactly 6 weeks from the current date. This is the code i have used, Set rst = CurrentDb.OpenRecordset("SELECT * from [Initial Registration] WHERE [End Date Of Funding] = #" & Format((DateAdd("w", 6, Date)), "mm/dd/yyyy") &...

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

Hi there, I have created a Personnel Database at work, as is the norm, people come and go. I was hoping to add in a tick box where if it is selected, the current record will not be shown in the form, but, it will still be stored in the table relating to the form. Any help much appreciated...

Hi there SuicidED, Cheers for the help. Colin

Hi there, I have created a database at work and up until now any databases i have created have not required any reports. I was wondering if it is possible to create a report which will prompt a user for a staff member's name and then display all their information on items such as...

Hi there, I have just created an Intranet site at work and wanted to set it up so that when users log into it, it will automatically change their default homepage to my Intranet site. My site is set to run on startup, is it possible so that when it loads on startup, a piece of HTML code will...

Hi there, I have created an Intranet site at work. Part of the site includes a section where users can obtain forms such as holidays or sickness etc. One of the problems we had was that staff were saving copies of the form in word format to the network and instead of replacing the copy they...