Access /Runtime cannot get to a control on a subform

  • Thread starter Thread starter Bill Patterson via AccessMonster.com
  • Start date Start date
B

Bill Patterson via AccessMonster.com

The following code returns valid values with full Access 2000 BUT "" when
run with the Access 2000 /Runtime set.

' Different Response with RUNTIME
'MsgBox "Full Access Versus RUNTIME." & vbCrLf & vbCrLf & _
"Anticipated Payment Method is " & is_Actual_Payment_Method & vbCrLf
& _
"Greater to be used is " & ib_Greater_To_Be_Used & vbCrLf & _
"No of Guarantee Rows is " & Str$(Val(Nz
(Me.txt_Guarantee_Rows.value, "0"))) & vbCrLf & _
"No of Greater Rows is " & Str$(Val(Nz(Me.txt_Greater_Rows.value,
"0"))) & vbCrLf & _
"FSUB Greater Remuneration is " & Format$(Nz(Me!fsub_Greater.Form!
txt_Total_Remuneration.value, 0#), Decimal_Format) & vbCrLf & _
"FSUB Guarantee PayGTEE is " & Format$(Nz(Me!fsub_Hours.Form!
txt_paygtee.value, 0#), Decimal_Format), _
vbInformation + vbOKOnly, _
gs_Application_Name

The main form has a number of tabpages, each with a subform and appropriate
controls.

All performs correctly under Access 2000 but can not get any values with
/runtime

Any ideas?
 
Build it bit by bit to nail down whether it's related to an individual
control/variable.
 
No. There are no "@" signs. All fields are effectively Dollars and Cents
(Fixed with 2 decimals) and held and calculated as Double.

As stated, All works correctly under full access 2000 as developed yet the
MSGBOX returns only the "Text ... is " portion with "nothing" following
when run using msaccess.exe /runtime.

What are you thinking about the "@" signs, I don't understand ?
 
My concern is with the "difference" between Full Access and /runtime.

In this instance there are two separately built sub forms using differnt
tables and separate calculations culminating in a Total of a column being
sought from each sub form.

Full access returns everything correctly both arithmetically and formatted
and because it gets a value > 0.00, it actually shows the sub form and the
correct total of the column.

/runtime does not return a value from the sub form and therefore does not
show the sub form.
 
What are you thinking about the "@" signs, I don't understand ?

Access message boxes treat "@" characters differently
than VBA message boxes: they reformat and may hide some
of the text. Normally, you get a VBA message box, but
sometimes when running an MDE you get an Access message
box instead.

Simplify the code, and include some simple tests:

MsgBox "Full Access Versus RUNTIME." & is_Actual_Payment_Method

if "" = is_Actual_Payment_Method then msgbox "blank here"

if isnull(is_Actual_Payment_Method) then msgbox "null here"


(david)
 
OK David, Thanks for that.

No, the difficulty is not in the msgbox code, it is only reflecting what is
actually happening.

Because of the "No values" being returned from the sub forms, the logic of
the code behaves differently.

I have tried various syntax for the sub form(! / . form!) references but so
far every instance of the Full MSACCESS is correct BUT the /runtime will
not return a value.

However, the sub forms CAN update values on the main form.
 
Back
Top