Recent content by Cowlers

I was hoping I could create the report and then when I call the reort from my filter form I would be able to enable/disable the groups/summaries to suit the filters that have been chosen if this is possible? I will be showing the total for the month regardless so my guess would be that I could...

I haven't created the report yet hence I don't have any launch code because I've been trying to figure out how I would make it work and how I'd structure it. The query it is based upon is named COAnalysis and the four fields are named: ProfileID IntColour ExtColour LengthID There is...

That's correct BlueIshDan, Regards, Dan

Hi folks, I'm trying to allow my users to do some analysis of existing data. they would like to be able to generate a report which will summarise sales orders against the month they were placed. They would also like to summarise this by between 1 and 4 other fields. I have created a...

I had this problem too, I managed to resolve it as part of the export function using VBA, you will need to make sure the Microsoft Excel reference is enabled in VBA to allow you to control excel from your access code: Dim XLApp As Excel.Application Dim XLWB As Excel.Workbook Dim NewFileName...

Hi again, I've overcome this issue now, I have set up some 1 to 1 tables from my original table and now the most relationships I have between any two tables in my database is 9 which is much more healthy than the 38 I was going to require!! Thank you for your help folks, just got to go...

Ok, have done a bit more examination and think I may have found my problem - not that I know how to solve it!! Although the explicitly defined indexes are only the 5 listed above I also have checked the relationships that this table has with other tables. In total there are relationship...

I have 52 tables in my db, the "tblWarehouses" table is the one that I am getting the warning about. This has 15 fields but only the ID field and 4 other fields are indexed according to the properties. Should I also consider the tables which use the ID field of this table as a foreign...

Thank you for your reply Access Blaster, The strange thing is that I have only added indexes to a couple of fields myself, all the others seem to have been added automatically for me I guess as a result of adding relationships with referential integrity. My bigger problem as I outlined in my...

Hi All, I have a table within which I store my "Warehouses". The services offered by each warehouse (there are 8 of them) are stored in here as yes/no fields as well as the full addresses of each warehouse. For one warehouse I can therefore say if it contains "Stock" or offers a "Painting"...

Found the answer in the end, bit of coding from Microsoft after searching on google, Cheers, Dan

Thanks for your reply spikepl, Because I am looking at the sum of the particular field I am entering I believe I need to capture the old value and the new input as I need to deduct the old value and then add the new value to prevent the query from taking both into account. Does this sound...

Hi All, I have a textbox on a subform to allow a delivery qty to be entered (to allow me to cater for part deliveries). I have a query which totals up the values of this field (so that I have a total of all the deliveries for this record) and compares that value against another field (to...

Ok, I think I've resolved this. Instead of calling up all records automatically I am instead putting the records into a drop-down on the subform so that the user selects the relevant order line and then enters the figure for the particular delivery. I need to refine this a little to stop the...

You are absolutely correct abla, I believe you can resolve this problem by modifying the code on the current event of the form so that instead of the requery of the combobox being within the if statement (so that it only applies if the main combobox is empty) it also requeries when you change...