Search results for query: *

I have a table which consists of the following fields: Project Name Sales Person Date We have ten sales people who's initials are put against a project that they have been allocated to. Theres around 3,000 records and what I want to do is count how many projects a salesperson is allocated...

I get this error when trying to run a mailmerge to Word 2003 using code from Alison Balters Book : Mastering Microsoft Access 2000 Development. I am using the code in Access to 2003 to merge with a document in Word 2003. Could this be causing the problem?

I have a simple database with a query that grabs all the customers from a customer table for a mail merge into Word 2003. When I do a mailmerg from Word using the query I get norecords returned. If I do the merge direct from the table I get the records ino Word. The query works fine in...

I am trying to create a simple button on a form which when pressed merges the current record into a Word 2003 document. I am using the shown below - from the MS Knowledgebase. Option Compare Database Private Sub cmdPrintLetter_Click() MergeIt End Sub Function MergeIt() Dim objWord As...

I have created a simple sub-form using the wizrd to show sick ness times and dates for each employee. I have tblemployee with a filed EmoID and the other table used for subdorm is tblSickness with a filed EmpID. When I try and enter data into the subform I get the following messge: "The...

I am writing an Employee Information database where I need to store, payments, sickness, holidays etc on a per employee basis. Is it posible to have a series of tabs on the main form showing, sickness, holidays etc so that when I move to the next record (next enmployee) on the main form the...

I have a sub form on my main form and I want to double click on a field (Site ID) and open up another form. I have written a piece of code which opens up a dumy form but I cannot work out how to open the form at the particular record I have double-clicked on. I'd like to be able to show the...

I have been asked to put together a database where we have Customers who have multiple sites and then engineers that could make multiple visits to those sites. Could anyone help me with the corcect structure and relationships for a database like this?

I have a basic report fed from a query. It consists of a company name, project value and a status. The status text might be "Tender Submitted Won", "Tender Submitted Sent", Tender Submitted Oustanding" etc. The grouping works fine in that I can group all the companies and their associated...

I've created a PivotTable on a form and when I open the form from within Access by double-clicking on it opens fine and displays as expected. However, when I use a command button (generated by the command butrton wizard to open the form, I just get a single row display of the fields used for...

I am trying to add a single record to the subform of fifty records in amin form. i.e. I have employee names and departments on the main form and associated with each employee is one or more courses in the sub-form. I need to add a single course name and status field for every main record. i.e...

Can anyone tell me how I go about exporting data from an Access form by clicking on a button and then having Excel open automatically with that newly exported data? Many Thanks

I have a database that records all employees and the courses that they have taken. I need to re-create a training matrix which displays the employees name down one side and the course along the top. A coloured rectangle (whose colour depends on the status of undergoing training, requires...

I need to create a training database which contains all employees, their department, their supervisor and which course they have attended or are due to attend, there can be multiple courses by different suppliers and I need to be able to print out a report which in effect provides a training...

I've got a really simple database consisting of three tables: tblCourse --------- CourseID (PK) CourseName CourseSupplier CourseDuration tblAttend --------- CourseID EmployeeID CourseStart CourseEnd tblEmployee ----------- EmployeeID (PK) EmployeeDept EmployeeFirst EmployeeLast EmployeeNumber...

I am trying to create a database that will allow the user to Create new projects and assign them with a contact and organisation. In other words, there should be Organisations that can have multiple contacts linked to it and each contact can have multiple conversations attached to it. An...

Hi There, I have a form which I cannot update. It consists of contacts details held in tblContacts, the organisation the contact belongs to held in tblOrganisation and a projects table which displays the projects associated with each organisation. Notes attched to each contact in a subfornm...

I have two combo boxes. One displays UK towns and the other UK counties. The look-ups are from a single text field tables. The towns drop-down displays the towns in alphabetical order, but the counties drop-down appears o be random in order. I have set the columns to A-Z sorting in the tables...

I have a subform on my main form and when I click on the text box in the sub-form I get the following message: "You tried to assign the NULL value to a variable that is not a Variant data type". I can clear the error and enter the text into the sub-form, the data is writen to the table but...

I've got a simple training database that has three tables: tblCourse tblAttend tblEmployees I have a main form which displays employee information and the subform displays the courses they have attended. Whenever I try an add a new record to the subform for any employee I get an error message...