Recent content by rowan1

I have a table with the names of suppliers listed in alphabetical order. I have several forms which use a combo box from the suppliers table which for some reason I have not set up at the start in alphabetical order.I made the mistake of selecting the ascending order on one of the forms and then...

Thanks John worked perfectly.

I have a calculated control on my report.The next control multiplies the previous control by 20%. If the value of the first control is negative I want it to return Zero. Can someone show me how to do this? Thanks

Thanks for the replies but I still have been unable to find why Microsoft example does not appear to work in their sample db. Obviously I am doing something wrong. But what?

I changed one error I found and in debug I am now getting highlighted If (DragCtrl.Employees <> DropCtrl.Orders) Or _ (DragFrm.nWind <> DropFrm.nWind) Then I can´t see what is wrong.

rjurgens Could you possible explain which libraries I should be selecting? Thanks

PHV Code is exactly as Knowledge Base Question 233274. There were a couple of syntax errors on the code when I first ran it but now there is nothing highlighted. Any indication of where to even look would be appreciated.

I want to add drag and drop between two forms on my db. I thought I would run through Microsoft Knowledge-233274 using the sample db Northwind as practice. I have followed every step but when I come to try drag & drop on the example, I keep getting the message 'Object does not support this...

Thanks for the help.The last gave me exactly what I wanted

JonFer & Blorf I am finding this a great help so far but I would like to go further and in my final query I do not need the invoiceNº and date but I need a total sum of all invoices for each client. Thanks again for your help

My SQL. SELECT[InSELECT [Invoice sales ].InvoiceNº, Invoices.Date, Invoices.Clientname, Sum([Invoice sales].Total) AS SumOfTotal, IIf([InvoicesDate]>=[From_Date] And [InvoicesDate]>=[To_Date],&quot;Yes&quot;,&quot;No&quot;) AS Expr1 FROM [Invoice sales] INNER JOIN Facturas ON [Invoice...

Blorf. Yes you understood my problem and I tried what you said with the result that when I open the query I get three prompts; 1.InvoiceDate, 2.From, 3.To. When I run the query I get a list of all the invoices I have issued from the start of the db irrespective of what I enter in the prompts.Any...

I have 3 tables Invoices,details & Clients. I have a query that gives me a list of dates, invoices & amounts spent during a given period. I want to have the query give me a list of the total amount spent by each client during this period. Each client has several invoices I could specify each...

Thanks to every one for their help and especially Rick Sprague for providing the solution with Window/Cascade.The answer always seems easy when you know it but the know-how is knowing where to look. Thanks Rowan

Thank you for your suggestions but nothing has worked so far. Have copied the original database to a Cd but have the same problem, I cannot copy individual items as I can not see them to select.Any further options to try would be appreciated. Thanks Rowan.