Recent content by blueboy2001

The admin could try turning on image verification at the registration stage - this will stop most bots from registering.

I am producing a fairly complex (to me) report to show staff performance. Each job is categorised as one of three categories - major, minor or other; and job duration is measured in weeks as the difference between 2 dates. I have all the data in a query based on multiple tables. Each row has...

I am building a contacts database - brief structure as below: tblOrganisation - details pertaining to the company tblContact - Primary key is ContactID (autonumber) and details about the contact tblContactDetails - Primary Key is DetailsID (Autonumber), Foreign Key of ContactID and fields to...

I am currently designing a contacts database for my business and need some advice on how to store addresses. As I see it, I can either use a single field and carriage returns, or multiple fields which for some records may leave some blank fields. The data will be used to perform mailmerges and...

Thanks very much for all that. If any of your work is included, I assure you that it will be suitably referenced in my bibliography, and I will include a copy of this thread in my appendix.

Drivers will be assigned several jobs per day, normally 2 or 3. In my Job Table (tbljob) I have fields for Date, Start Time, and Hours (that the job will take). I've then got tblJobDriver which holds JobID and DriverID to allow multiple drivers to be on each job. The final paragraph of your...

I have made a database for my final year uni project for a contracting firm to manage their job bookings. Each job can have multiple pieces of equipment and multiple drivers assigned to it. I'm using a form frmjob with 2 subforms to allow the input of the drivers and equipment on that job...

Thanks for the advice. Given that the query provides the data for a report, I've worked around the problem using groupings within the report.

I have a query in my database that lists all the jobs for a particular driver on a specified date. Each job may have multiple items of equipment on it, so the query returns multiple rows where there are multiple items of equipment. A Group By JobID should sort this out, but how can I do Group...

Ok, I've unbound the combo box but it has no effect on selecting the correct record. What do I need to add to it so it will select the appropriate record? Edit - Some code might help I guess!

This is so simple, but I'm losing the will to live at the moment with my current Access project. I've got a form for inputting details into a table on. I've put a combobox at the the top that lists the records, all I want to do is be able to select a record from the combobox and view the...

The concept of having many drivers on each job is an essential requirement of the system. In terms of the database, there isn't a direct many-to-many link between the two because of the tbljobdrivers table is an intermediate entity. I can't see that this is a problem? As for their being no...

I'm having terrible trouble getting this damn form to work as I want it to, and I could really use some serious help. This is my final year project for my degree and has to be completed by the end of the week. Bit last minute I know. If anyone would be willing to help me over MSN or email...

Thanks Rich, I've got the whole thing working now. I've had to use a query to populate the subform as it was producing a list of all the records in the jobequipment table. My next problem is how can I stop the user selecting the same piece of equipment twice? If they do it chucks up an error...

I have got separate tables for jobs (tbljob), equipment used on jobs (tbljobequipment) and for equipment (tblequipment). tbljobequipment holds jobid and equipmentid. Having been playing around with this all morning, a subform seems to be the way to go. What do you mean when you refer to a...