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 derfloh 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: *

  • Users: kevvo
  • Order by date
  1. kevvo

    Word and Access 2003 mailmerge propagate problem

    Hi there, I'm trying to merge some postage labels in Word using a MS Access table. However, when I propagate the labels, only the first two and the last two on each page appear. Does anyone have a fix for this? Thanks Kevvo
  2. kevvo

    Convert a Number field to Autonumber in Access 2003

    Hi there, Is there a way of converting an ID field in a table which is currently in "number" data type, to "autonumber". There are no duplicate numbers in this field at present. I would like access to add new autonumbers from the next new records onwards. Thanks Kevin
  3. kevvo

    MS Excel 2003 Selecting an array for a quartile formula

    That's the one! A little bit of fiddling and it works a treat, and saved me about 2 hours of manually selecting ranges! Thanks Skip!
  4. kevvo

    MS Excel 2003 Selecting an array for a quartile formula

    Hi Skip! Yes, it is a strange one! In essence I would like to return the quartile in column C, and I know that this would be a duplicated value for the data items of any particular category. I would just like to be able to extend the formula throughout the rest of the rows in column C...
  5. kevvo

    MS Excel 2003 Selecting an array for a quartile formula

    Hi there! I'm currently working on a spreadsheet where I need to calculate a quartile based on data in one of the columns. However the data is categorised by a variable in a preceeding column. Here's an example: Column A Column B Type 1 1.4 Type 1 2.8 Type 1...
  6. kevvo

    Charts disappear from Report

    Yes thanks, I had a look, but they didn't seem to answer the query I have. The base query on which the report is built looks like this: SELECT PLANACT.*, contractsref.description, specref.specGroup, specref.careGroup FROM (PLANACT LEFT JOIN contractsref ON PLANACT.contract =...
  7. kevvo

    Charts disappear from Report

    I've narrowed it down now to the point that I can see the graphs only dissapear when I remove a particular subreport. The graphs all run on a sql query unconnected to this subreport, so I'm a little confused as to why this only happens when I remove the subreport.
  8. kevvo

    Charts disappear from Report

    Hello, I am building an access report based on an existing one. It features a 'dashboard' of charts grouped under a header, we'll call it "category", which is also the child and master link field for all of the reports. The problem has occurred when I have added a new chart, created a...
  9. kevvo

    Looping to select items in a listbox one-by-one

    That's done the trick, and saved me at least 4 hours a month! Thanks loads Rubbernilly! And btw the "choopurch" genius comes from a derivation of the fact that the combobox "chooses" the "purchaser" for each of the items in the list!
  10. kevvo

    Looping to select items in a listbox one-by-one

    Hi, and thanks again for getting back so quickly. I've put the code in and it is detailed below: Private Sub Command58_Click() For a = 0 To choopurch.ListCount - 1 DoCmd.OpenQuery "Planactdel", acNormal, acEdit If Me!incp = True Then DoCmd.OpenQuery "PLANACTaddplanSUB"...
  11. kevvo

    Looping to select items in a listbox one-by-one

    Hi, Thanks for this, maybe I should clarify a bit more the way things are working in the DB; The list box is a combo box in a form (form = "reports", combo box = "choopurch"). When I run the above code it is asking for an object, even when I insert the objects as named just above. Could...
  12. kevvo

    Looping to select items in a listbox one-by-one

    I am trying to write code for a reporting database. In the main form, users have to select a contract number from a listbox, and then they hit a button which is coded to run a number of queries, and then export reports based on these queries. Problem being that I have to run all of these...

Part and Inventory Search

Back
Top