Search results

Many thanks ally that worked a treat. I needed it as a query list rather than a report as it feeds a combo box. Thnaks fro the prompt replies folks

I have a table of orders placed by customers, each customer having their own code. A customer may have placed just one order with me or many orders. From this table I would like to produce a list that shows my customers code just once. This must be simple but so am I it would appear as I can't...

Don't you just love this forum! Thanks Rich, once again you've saved the day

I have a continuous subform which has 2 fields on it bound to a table . These fields are [volume] and [rate] where rate is a percentage. I have a third calculated field (unbound) on the subform that mutliplies the volume by rate to give me an amount due. I have called this unbound field [due]...

Thanks rich. I also noted that I was not refering to the full name of the sub form (I needed to include the mother form and child form name, eg I ws looking at [forms]![subform]![field] when I should have used [forms]![motherform]![subform]![field])

I am trying to write a system to control debts my company have. There are lots of case records that may form the debt and I have these listed in a subform which has a calculating unbound box in the subform footer that shows the total debt for the customer. When we have decided to write off these...

I have a report that is doing quite a lot of calculations, so much so that sometimes it crashes Access. Is it best to do calculations on the report or on the query feeding the report please?

I have made a simple help system for a simple database following "simple" instructions in a book! On my help I have a Contents list and a custom index based purely on my help files. When I test this it works OK and I have combined it with my database so that the relevant help appears for...

I have a one to many set up. On the one table I record freight charges, on the many individual line item slaes and their price. Net result is that on screen I have the total sales value on a subform and the freight charge on the main form, all very straight forward so far. I want a report that...

Many thanks for the prompt reply Kevin, will give it a whirl

I have a simple customer table that has a unique identifier for the customer. There is another "many" table where each time this customer is contacted they can either respond yes or no. This process only goes on for so long, then the customer unique record is notated as being closed through a...

Nice solution, gave me just what I wanted. Many thanks for the help

I have a report that I want users to preview. They can then choose to print it. If they do print it I then want a piece of code to run asking if they want to run an update query. (records that the letter has been generated). I have tried tying this in to OnPrint in the report footer but no joy...

I would like to run a report in Print Preview mode. If the user then decides to print this report I would like this print action to trigger an update query. Any pointers in the right direction would be much appreciated

What stars! Now why couldn't MSoft have made this easy. Function worked a treat. In my form I can now do the calculation in the data source as =FLOOR(([field1]*[field2]),0.01) and get the right answers. Thank you very much!

I am still trying desperately to get FLOOR to work in access without success. On a form I have an unbound box doing a calculation with can go to several decimal places. The value I require must be to 2 decimal places AND round down in all cases e.g. 12.579 should give a true value (not just...

I am trying to use the FLOOR function. From searches here and in the Access help, I need to use msowcf.dll which is installed and activated, but to allow its use in forms I need to create a "public function" which is where I am stuck. Could someone explain in simple terms what I need to do to...

Not had problems before with sub forms but this one has me going. Got a very simple dbase. One table holds customer details and the other holds payment details, linked by customer ID. Both tables have been populated by importing data from other sources but I am happy that no errors with the...

Excellent, just what I wanted. Another hidden gem

Dave, many thanks that did just what I wanted it to do. Just like Access though, gives with one hand then takes with another.. why such a small number of icon options.