I have a form with a few filters. Once the user clicks "search button", the code first evaluates my filters, then shows the query results in a List Box" titled backschedule.
I have a few text boxes below the list box that add sum values in the query columns using Nz() Function.
Example
"openpoqtyt otal = openpoqtytotal + Nz(Forms![A2_bs_summary]!backschedule.C olumn(4, i), 0)"
...
VbaNewbee
Last Activity: Nov 14 '07, 05:01 PM
Joined: Jul 18 '07
Location:
-
Sum up Column Values from a Query using a List Box
-
If you are simply trying to remove the highlighted select radio button, enter this vba after your command statement or once you are ready to select another country .
Create a button on form titled "Clear"
"on click" type ...
Me!groupby1.Val ue = 0
Me!groupby2.Val ue = 0
Me!groupby3.Val ue = 0... -
_______________ _______________ _____________
THIS IS THE CODE I USE TO EXPORT THE SPREADSHEET IN AN EMAIL ATTACHMENT
_______________ _______________ ____________
...Code:Private Sub Command69_Click() On Error GoTo Command69_Click_Err DoCmd.SendObject acQuery, "Apt_Requests", "MicrosoftExcelBiff8(*.xls)", "johndoe@gmail.com", "", "johndoe@gmail.com, johndoe@gmail.com,johndoe@gmail.com",Leave a comment:
-
Query keeps deleting after using the Docmd.sendobject
I have a form, once a button is clicked it sends out an excel email attachment to lotus notes.
The first time it works fine, however ifyou try to attach and send out the attachment again it states the Error "Query must have one destination field"
I then go look at the query it is pulling from and it keeps getting Deleted. I have no idea why it keeps deleting.
Is there a way to send out an email...
No activity results to display
Leave a comment: