Search results for query: *

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.

John, When I open the data base there is no dialog box. The toolbar is there and I can open the relationship window.I can also open the code dialogue box, which opens onto the last item I was working on before the problem happened. I tried F10 and compact and repair but to no avail. The data...

I have three databases on my computer. The first is the main, the second uses linked tables to the first and the 3rd is independant of the other two. I was working on the first designing a report when the screen went blank. Now I can not access the 1st database because it opens on to a blank...

Thanks Rick, Will give a star. I have tried downloading the service pack twice before and ended up re-installing office as it became unstable. I am reluctant to try again ¿Any advice?

I have an invoice form that prints a invoice report that is based on a query.It works fine except that the report settings for page set up keep returning to default every so often. It does not do it every time and I do not alter or change anything in the query or the report just add invoices to...

Ken, Thanks for the reply, but perhaps I did not explain myself clearly. The combo box on the form works perfectly. The first column is set to nought and you just see the description. My problem is with the query and I don`t know how to hide the ID and see description here