NearImpossible
Registered User.
- Local time
- Today, 10:13
- Joined
- Jul 12, 2019
- Messages
- 225
For some reason I can't think straight today, its been one of those weeks.
I need to be able to calculate some numbers based off of a couple entries on my current form and its parent form, but I am getting the following error and can't seem to figure out what i'm doing wrong, even though it should be easy to figure out :banghead::banghead::banghead::banghead:
"The Expression After Update you entered as the event property setting produced the following error: A problem occured while <Database Name> was communicating with the OLE server or ActiveX Control"
* The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure]
* There may have been an error evaluating the function, event, or macro
I am basically building a form to tell me how many devices I need to provide based off of 2 fields.
1. Tablet Ratio (Field on TabletCalculator Parent form)
2. Participants (Field on Subform I'm calculating on)
The user will select a facility and enter the desired Tablet Ratio.
On the subform there are several fields with one of them being Number of Participants where the user will enter that number, so in the After Update event of the Participants field, I have the following code to tell me how many tablets I need to provide in the CurrentTablets field, which is unbound
Currently I have both the Tablet Ratio and Participants data types set to Int on the SQL side, I've also tried Numeric and Decimal and get the same error.
I need to be able to calculate some numbers based off of a couple entries on my current form and its parent form, but I am getting the following error and can't seem to figure out what i'm doing wrong, even though it should be easy to figure out :banghead::banghead::banghead::banghead:
"The Expression After Update you entered as the event property setting produced the following error: A problem occured while <Database Name> was communicating with the OLE server or ActiveX Control"
* The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure]
* There may have been an error evaluating the function, event, or macro
I am basically building a form to tell me how many devices I need to provide based off of 2 fields.
1. Tablet Ratio (Field on TabletCalculator Parent form)
2. Participants (Field on Subform I'm calculating on)
The user will select a facility and enter the desired Tablet Ratio.
On the subform there are several fields with one of them being Number of Participants where the user will enter that number, so in the After Update event of the Participants field, I have the following code to tell me how many tablets I need to provide in the CurrentTablets field, which is unbound
Code:
Private Sub Participants_AfterUpdate()
[CurrentTablets] = Participants / [Forms]![TabletCalculator]![Tablet Ratio]
End Sub
Currently I have both the Tablet Ratio and Participants data types set to Int on the SQL side, I've also tried Numeric and Decimal and get the same error.