Search results

Thank you for your help tehNellie, I never even knew or looked at the SQL side of queries before and especially not Union queries so it’s opened up a wealth of options. I’ve used the following code and it produces the list which is just as I want it and described: SELECT...

Hi, Im using Access 2000. Essentially I want to find out which of the entries in my master table have matching entries in my other tables, and list the ones that do. So if I have an entry in the master table for “productA”, and there are also matching entries for “productA” in tables...

thank you ajetrumpet, it worked perfectly! thanks again!

Thank you once again RuralGuy, the proble seems to be "It has a GROUP BY clause. A Totals query is always read-only." Is there any way to skirt the issue? for example by somehow coding an update query to return the same results? or should I just face the facts and move onto something else...

Hi, I am very sorry, I’m sure this is a very basic issue but I’ve had a complete brain freeze and I can’t solve this problem. If anyone could help I would be very grateful. I have one chainsaw that I can buy from a maximum of 3 different suppliers. I have 4 tables in all – “OurTable”...

Hi, I am trying to check a “Check Box” on my query, but Access won’t allow me to do so as “This recordset is not updateable” - Could anyone please offer an idea of how I can get around this problem….. I buy lots of products from a supplier, for each product ordered I assign an order ID, and...

Hi, I have two subreports on the details section of my main report. I have the second subreport positioned directly underneath the first. As the first subreport grows and expands, it covers the results of the second subreport (which stays fixed in place). Is there anyway to allow the first...

I've managed to solve it in the end by creating the report in design view rather than using the wizard. Just dragged and dropped the two reports into a blank report and it now works fine.

Hi, I have a report (called “ReportA”) which is connected to a query, the query only shows products from “Supplier A”. The report is designed to show the details (such as “name” and “price”) of the products listed. So if the query returned 20 products from “Supplier A” then they are listed...

Did anyone ever solve ths problem as I have exactly the same problem? The query that runs off my subform requeries for everything except delete.

Thank you again Rural Guy, I googled the On NoData Event and built a macro with a CancelEvent action. i had come across it before but i had read somewhere that the CancelEvent action would stop the print process entirely, so if the first report was cancelled it wouldn't print any of the...

Hi, I have 7 different queries – each query has its own report. I have a macro set to print all 7 reports, however sometimes some of the queries do not return any data and I end up printing out lots of blank reports. It’s a complete waste of paper as I do this 10/15 times a day and I’d like...

Thank you guys for helping. I get your point KeithG, and I'm fine setting up the table and a "Value" Field - but how would the code work when you consider that some (like Visa and Mastercard) are multiplications, and others (like Switch) are minus calculations? Thank you for the code Craig...

I forgot to mention that the text box is a combo box that has the 5 values (visa,mastercard etc) already entered.

Hi Craig Dolphin, Thanks for your response, in all there are 5 options, however the default value is "visa" and it is a required field so it will never be null. I am looking to set the following: Visa = *0.98 Mastercard = *.983 Switch = - 0.5 Visa Debit = - 0.3 Misc = * 1 (so it takes nothing...

Hi, My query produces a “Total” figure. I need to use this figure to generate a “final total” – however it depends upon a field on my form/table as to how this final figure is calculated. If “text box1” on my form = “Visa” then I need to use the following code: [Final Total] = [Total] * .98...

I'm trying not to get too excited, but so far so good, I'll give it some thorough testing tomorrow and come back and let you know. Thank you for your help Rural Guy, I really do appreciate the time you've spent helping me tonight, I've built my database myself and have been living with this...

I've just read a thread that explains my problem a little better... ...you can calculate the VAT by multiplying the Price/quantity by the VAT rate [i.e. Price * 1.175].... but the VAT is likely to involve rounding off pence fractions, and you may therefore decide to store the rounded VAT Note...

I run a query on a subform to calculate nearly all the calculations, especially to calculate quantity prices and the tax amounts on quantity orders. I use the code quite a few times using different methods, but if it can be used on a query I'll be quite happy to change the other methods so it's...

Thank you for your help rural guy. This may sound like a silly question, but where should I enter the code to do this? Can it be set to the table field properties somehow? Do I add it to the properties of the text box on the form? Or is it to be used on a query somehow? Thank you again, I'm...