Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. rowan1

    Ascending order problem on combo box

    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...
  2. rowan1

    negative value to show zero

    Thanks John worked perfectly.
  3. rowan1

    negative value to show zero

    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
  4. rowan1

    Drag & Drop.Object does not support this property or method

    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?
  5. rowan1

    Drag & Drop.Object does not support this property or method

    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.
  6. rowan1

    Drag & Drop.Object does not support this property or method

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

    Drag & Drop.Object does not support this property or method

    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.
  8. rowan1

    Drag & Drop.Object does not support this property or method

    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...
  9. rowan1

    Querying invoice totals problem

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

    Querying invoice totals problem

    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
  11. rowan1

    Querying invoice totals problem

    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...
  12. rowan1

    Querying invoice totals problem

    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...
  13. rowan1

    Querying invoice totals problem

    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...
  14. rowan1

    Access not visible

    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
  15. rowan1

    Access not visible

    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.
  16. rowan1

    Access not visible

    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...
  17. rowan1

    Access not visible

    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...
  18. rowan1

    Printer settings reverting to default? Something to try...

    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?
  19. rowan1

    Page set up in reports reverts to default

    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...
  20. rowan1

    Parameter query

    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

Part and Inventory Search

Back
Top