When I made a report in Access using VBA I coded my calculation as:
Code:
Me.ExactReprintTextbox = DSum("Pages", "HBELP_FINAL_Q",
Diana Miller
Last Activity: Mar 14 '11, 04:51 PM
Joined: Nov 3 '10
Location:
-
Calculate a SUM after Combo box SelectedIndexChanged
I am using VB 2008 Express to connect to an Access 2007 database. I have a combo box called SelectYearMonth that is populated by the database. In the Access report VBA, I used the AfterUpdate() event to calculate a sum. I need to know how to do the same operation in VB 2008 Express.
When I made a report in Access using VBA I coded my calculation as:
... -
Diana Miller replied to How to use the value selected in a combobox to update multiple records in a report?in AccessOMG, I wrote Count in my code and not DCount! It works great now as:
DCount("JOBTYPE ", "HBELP_FINAL_Q" , "YEARMONTH = " & [SelectYearMonth] & " AND JOBTYPE = 'E'") -
Diana Miller replied to How to use the value selected in a combobox to update multiple records in a report?in AccessHi gnawoncents,
I am over trying to get this thing working by groups it is just too frustrating! I have coded the individual JOBTYPE boxes, since there are only 4 JOBTYPES as:
Me.ExactReprint Textbox = DSum("Pages", "HBELP_FINAL_Q" , "YEARMONTH = " & [SelectYearMonth] & " AND JOBTYPE = 'E'")
Me.KeylineUpdat eTextbox = DSum("Pages", "HBELP_FINAL_Q" ,...Leave a comment:
-
Diana Miller replied to How to use the value selected in a combobox to update multiple records in a report?in AccessHi,
Well, you are getting closer to the answer. By removing the other single quote, I now get a number in my text box. However, it is the same number for all four different JOBTYPE's. The number I am getting for all four types is the correct number for the first one listed.
I am sorry I can't post a sample of the database here for security reasons but we are getting really close here...wish we were playing horseshoes! :...Leave a comment:
-
Diana Miller replied to How to use the value selected in a combobox to update multiple records in a report?in AccessI have to remove that single quote from YEARMONTH or I get a type mismatch, it is numeric. There must be something else wrong with the syntax regarding JOBTYPE...Leave a comment:
-
Diana Miller replied to How to use the value selected in a combobox to update multiple records in a report?in AccessHere is the error code I get with the code above:
Run-Time error '3075':
Syntax error (missing operator) in query expression 'YEARMONTH = 201010' AND JOBTYPE = 'E".
What is the operator I am missing?Leave a comment:
-
Diana Miller replied to How to use the value selected in a combobox to update multiple records in a report?in AccessHi gnawoncents,
I get an error of a null value when I try to use this calculation. Am I missing something in the syntax here?
Code:Me.TotalPagesTextbox = DSum("Pages", "HBELP_FINAL_Q", "YEARMONTH = " & [SelectYearMonth] & "' AND JOBTYPE = '" & Me.[JOBTYPE] & "'")Leave a comment:
-
Diana Miller replied to How to use the value selected in a combobox to update multiple records in a report?in AccessJobtype
"JOBTYPE" is text
"PAGE" is numericLeave a comment:
-
Diana Miller replied to How to use the value selected in a combobox to update multiple records in a report?in AccessThis is a different problem than previous post
Hi gnawoncents,
Yes, this is a different report than my previous post. It goes into a little bit more detail than the other report.
I am still having trouble figuring out the proper syntax for the afterupdate code for this one. My previous post didn't have to deal with multiple groups. There was no "JOBTYPE" group. It was a straight forward calculation...Leave a comment:
-
Diana Miller started a topic How to use the value selected in a combobox to update multiple records in a report?in AccessHow to use the value selected in a combobox to update multiple records in a report?
Hi All,
I have an Access 2007 report where the user selects a date from a combo box. After selecting the date, I need the AfterUpdate() event of the combo box to fill in text fields with a calculated total for that month.
My combo box is named "SelectYearMont h" and is populated by the field "YEARMONTH" in my database. I have this part working great.
The report is grouped by "YEARMONTH"... -
How to distribute an interactive Access 2007 report?
Hi All,
I have created an interactive Access 2007 report where the user selects a date from a combo box and results are shown. I would like to know how I can share this report interface so that other users can only use the report interface and not modify it (no access to any other views, i.e design view).
Is there a way to do this?
Any help is greatly appreciated.
-Diana -
Excellent Answer!
That's it! You have solved my dilemma. I had to take out the single quote marks and it works great. Thanks you so much for making this easy!Leave a comment:
-
How to use value selected in combobox with a button to show a total
Hi All,
I am creating a report from Access 2007. I have a form where the user selects a Month from a combo box and then presses a button to show the sum of all pages worked for the Month selected in the combo box. I am populating the combo box from the database and everything there works great.
My problem is this: How do I code the button/combo box to take the value selected by the user in the combo box and then...
No activity results to display
Leave a comment: