Reputation: 104 Stalwart
- Expert w/DIC++
- Active Posts:
- 904 (0.42 per day)
- 09-December 08
- Profile Views:
- Last Active:
- Jan 24 2013 01:07 AM
- OS Preference:
- Favorite Browser:
- Internet Explorer
- Favorite Processor:
- Favorite Gaming Platform:
- Who Cares
- Your Car:
- Dream Kudos:
- Expert In:
Posts I've Made
Posted 19 Dec 2012That does look like should work, although I would put the lower criteria before the higher.
Provide the complete SQL statement.
You don't want the results to be inclusive for the criteria?
Posted 17 Dec 2012Concatenate variables. Reference to the current record ID is a variable:
Ltotal = DSum("Donationpaid", "Donationinfo", "ClientID = " & [clientid])
Posted 29 Nov 2012This is why saving aggregate data is problemmatic. Ideally, save raw data and calculate aggregate data when needed.
Use the BeforeUpdate event of the quantity textbox. Data controls have OldValue and Value properties. So something like:
If Me.control.OldValue & "" <> Me.control.Value & "" Then
'code to modify the inventory record
Need more code in the BeforeUpdate event of Product.
Need more code if record is deleted.
Posted 23 Nov 2012Corruption is a possibility.
Want to provide db for analysis (maybe both versions)? Try attaching file to post using the Attachment Manager under the 'Full Editor' window.
Make copy, remove confidential data, run Compact & Repair, zip.
Posted 19 Nov 2012Why isn't it working - error message, wrong results, nothing happens?
I use Environ function. Access does not recognize the function but VBA does. Create a custom function that runs the Environ function and call that custom function from wherever - query, textbox, VBA.
- Member Title:
- D.I.C Addict
- 60 years old
- December 13, 1953
- Anchorage, Alaska
- snowboarding, baseball umpire
- Years Programming:
- Programming Languages:
- VBA, VB, VB.Net, SQL, Fortran
- Website URL: