Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. topgeek

    Counting number of records for a particular name in a field

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

    Counting number of records for a particular name in a field

    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?
  3. topgeek

    Counting number of records for a particular name in a field

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

    Error #5852: Requested Object is not available

    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?
  5. topgeek

    Mail merge to Word 2003 using Access 2003 query

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

    Mail merge to Word 2003 using Access 2003 query

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

    Trying to mail merge Access 2003 data into Word 2003

    ..._ Name:=CurrentDb.Name, _ LinkToSource:=True, _ Connection:="TABLE tblEmployee", _ SQLStatement:="Select * from [tblEmployee]" 'Execute the Mail Merge objWord.MailMerge.Execute End Function It works after fashion but I have two problems. 1.I get a pop-box warning me...
  8. topgeek

    Error message when using subform

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

    Using subforms on tab controls

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

    Opening another form by double-clicking on sub-form field

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

    Opening another form by double-clicking on sub-form field

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

    Basic question on table design & relationships

    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?
  13. topgeek

    Ordering groups in a report

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

    Opening PivotTable form

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

    Opening PivotTable form

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

    Add records to a subform via a query

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

    How do I export Access data to a an excel Spreadsheet

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

    Creating a training matrix

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

    Help with database structure for training database

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

    Problem updating simple form

    Hi Stuart, I have been using the new database you suggested and added a coupe of forms. Everything seems to work OK, but I have changed the Course Name field to a combo in the subFrmCourses subform with a record source of tblCourses so users can select a previously entered cours. Unfortunately...

Part and Inventory Search

Back
Top