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...
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...
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...
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...
If isnull(rsMidbase1![Add2]) Then
or
If Len(rsMidbase1![Add2] & "") = 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!
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...
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...
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!
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...
dbs.QueryDefs.Delete "StatQ1" ? (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!
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...
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...
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...
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...
The basis of what you need is: -
txtSQL = "SELECT Server, Avg("
txtSQL = txtSQL & Me.cboStat
txtSQL = txtSQL & ") AS Stat FROM tblServer GROUP BY Server HAVING Server = '"
txtSQL = txtSQL & Me.cboServer & "';"
Where tblServer is your table, cboStat is the combo...
"SELECT * FROM people WHERE NAME=" & Chr$(34) & "o'donnell" & Chr$(34) & ";"
<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!
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...
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!
Use a third query to round the average in your second query - e.g. Format([AvgOfFieldToAve]/100,"0.0")*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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.