Recent content by topgeek

Thanks PHV You where quite right. I wasn't referring to the correct field name. Work fine now! Many Thanks

Thanks for responding PHV. I've used the query: SELECT [Sales Rep], Count(*) AS CountofProjects FROM tblEnquiry GROUP BY [Sales Rep]; It prompts me for a sales rep and then returns all the records in the table. Have I missed something?

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?

No, no parameters - it has some criteria set within the query and it returns the correct records if run from Access itself. I was trying to set the criteria from Access, otherwise I will have to edit the users mail merge templates from Word which I was trying to avoid.

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...

Thank You AceMan1 I tried your code, but don't understand what the: & Me!TextboxName & "'" Line is doing? Many Thanks

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...

Thanks PHV, That was spot on - hadn't even realised there was particular argument for a Pivot Table!!

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...