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. kctaylordotcodotuk

    BeforeUpdate vs OnClick

    Try setting the CancelFlag in the MouseMove event. You will need to set it to false in the MouseMove event of the section of the form that holds the cancel button (i.e. Detail, Header or Footer - NOT the Form_MouseMove). In theory this could fail if the user has the mouse over the cancel button...
  2. kctaylordotcodotuk

    Duplicated records

    The easy way, in table design, is to Ctrl-Click the selector at the left of each field name, so that the 3 fields you are interested in are highlighted, then click the Primary Key button on the toolbar. This will create a new index, that will ensure uniqueness across the 3 selected fields. If...
  3. kctaylordotcodotuk

    Report from 2 separate date periods

    Create a query with a date criteria: - Between #07/01/2000# And #10/30/2000# Create a second query with Totals, group by contributor and category and sum contributions, with date criteria between the earlier dates. Create a sub-report from the second query and include it on your main report...
  4. kctaylordotcodotuk

    Duplicated records

    If you get an error message about duplicated records preventing you from saving your table changes then create a new query using the Find Duplicates wizard. This will display records that have been duplicated so that you can delete them or edit the name to be unique. <p>Keith C Taylor<br><a...
  5. kctaylordotcodotuk

    null/empty string ifStatement in recordset

    If isnull(rsMidbase1![Add2]) Then or If Len(rsMidbase1![Add2] & &quot;&quot;) = 0 Then <p>Keith C Taylor<br><a href=mailto:TekTips@kctaylor.co.uk>TekTips@kctaylor.co.uk</a><br><a href=http://www.kctaylor.co.uk>The Information Gardener</a><br>The C stands for Computer!
  6. kctaylordotcodotuk

    Duplicated records

    Make the appropriate index unique. In the table design set the indexed property for the Customer Name field to Yes (No Duplicates). If you have more than one Customer Name field (e.g. First, Middle, Last) then let me know and I'll give further help. <p>Keith C Taylor<br><a...
  7. kctaylordotcodotuk

    Help with concept needed!

    I would create an Order shipping table OrderID DeliveryID (could be autonumber) Date CreditCard ValueCharged and an Order Item Shipping table OrderID DeliveryID ProductID Qty This allows you to create a query showing the balance outstanding, and also query the Credit Card history, irrespective...
  8. kctaylordotcodotuk

    Query has different results according to Access Installation

    When you are in a code window, if you click Tools, References are ther any difference in the ticked libraries? <p>Keith C Taylor<br><a href=mailto:TekTips@kctaylor.co.uk>TekTips@kctaylor.co.uk</a><br><a href=http://www.kctaylor.co.uk>The Information Gardener</a><br>The C stands for Computer!
  9. kctaylordotcodotuk

    Import delimited text file - allow user to change order of fields

    The thread at http://www.tek-tips.com/viewthread.cfm?SQID=26483&SPID=701&page=1&CFID=5632313&CFToken=68325246 (Running A Query that picks different Fields according to a Form in the Queries & SQL forum) deals with building a query from a user specified fields. If you need any help amending...
  10. kctaylordotcodotuk

    Running A Query that picks different Fields according to a Form

    dbs.QueryDefs.Delete &quot;StatQ1&quot; ? (untested) <p>Keith C Taylor<br><a href=mailto:TekTips@kctaylor.co.uk>TekTips@kctaylor.co.uk</a><br><a href=http://www.kctaylor.co.uk>The Information Gardener</a><br>The C stands for Computer!
  11. kctaylordotcodotuk

    Expert help needed with code - Its driving me mad

    jagilman, That certainly is strange. The only thing I can think of off the top of my head is that the OrderByOn property has been set to False. Try adding Me![subFrmQrySelAllTracks2].Form.OrderByOn = True at the beginning of the function <p>Keith C Taylor<br><a...
  12. kctaylordotcodotuk

    Expert help needed with code - Its driving me mad

    There's no need to code the Click_Event. Just type =ReOrder([Screen].[ActiveControl]) in the OnClick property of the Column Heading field. The Column Heading field as I understand your first post, is a Text Field (let's say txtArtistHeading) and the ControlSource should be set to...
  13. kctaylordotcodotuk

    Running A Query that picks different Fields according to a Form

    Alison, Yes the answer is to set the recordsource, as jagilman has kindly pointed out. In the example I put on my site I do this in the function that you've called dynamic_test, though as jagilman has shown, there are other ways to do this. A lot depends on whether you are wanting to display the...
  14. kctaylordotcodotuk

    Expert help needed with code - Its driving me mad

    Your explanation doesn't refer to the need to filter any of the records so I'm going to ignore the WHERE clause. If you need this then let me know and I'll amend the solution to suit. Rather than tidy up the code you've pasted I offer a simpler solution. If it doesn't work as you wish then...
  15. kctaylordotcodotuk

    Running A Query that picks different Fields according to a Form

    The basis of what you need is: - txtSQL = &quot;SELECT Server, Avg(&quot; txtSQL = txtSQL & Me.cboStat txtSQL = txtSQL & &quot;) AS Stat FROM tblServer GROUP BY Server HAVING Server = '&quot; txtSQL = txtSQL & Me.cboServer & &quot;';&quot; Where tblServer is your table, cboStat is the combo...
  16. kctaylordotcodotuk

    single quotes in a query

    &quot;SELECT * FROM people WHERE NAME=&quot; & Chr$(34) & &quot;o'donnell&quot; & Chr$(34) & &quot;;&quot; <p>Keith C Taylor<br><a href=mailto:TekTips@kctaylor.co.uk>TekTips@kctaylor.co.uk</a><br><a href=http://www.kctaylor.co.uk>The Information Gardener</a><br>The C stands for Computer!
  17. kctaylordotcodotuk

    Using Log-in Name as Default

    In the Form_Load event Me.txtUser.DefaultValue = Chr$(34) & CurrentUser & Chr$(34) where txtUser is replaced by the name of your field <p>Keith C Taylor<br><a href=mailto:TekTips@kctaylor.co.uk>TekTips@kctaylor.co.uk</a><br><a href=http://www.kctaylor.co.uk>The Information Gardener</a><br>The...
  18. kctaylordotcodotuk

    Need to print 1 record

    Or if you don't want to preview use DoCmd.PrintOut acSelection <p>Keith C Taylor<br><a href=mailto:TekTips@kctaylor.co.uk>TekTips@kctaylor.co.uk</a><br><a href=http://www.kctaylor.co.uk>The Information Gardener</a><br>The C stands for Computer!
  19. kctaylordotcodotuk

    Rounding question again?

    Use a third query to round the average in your second query - e.g. Format([AvgOfFieldToAve]/100,&quot;0.0&quot;)*100 where AvgOfFieldToRound is the field in your second query that holds the average <p>Keith C Taylor<br><a href=mailto:TekTips@kctaylor.co.uk>TekTips@kctaylor.co.uk</a><br><a...
  20. kctaylordotcodotuk

    Row Numbering in Query

    If the query is going to be used in a report then it's easy - just add a field to the query such as LineNumber:1 then in the report add the LineNumber field and change its Running Sum property to Over All If it's required for a form then it's a little more difficult, but not impossible. If this...

Part and Inventory Search

Back
Top