Search results for query: *

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

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

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!

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

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

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

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.

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

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!

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

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

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