Topics Search

#Type! error in form control

#Type! error in form control
Views: 1028
Does anyone know what the #Type! error is referencing? I haven't found much on the forum about this error.

I'm trying to use an expression in a text box, but it's putting the error "#Type!" in the text box. Both parts of the expression are in the form's data source (which is a query).

The expression in the text box is:
=[PROJECT_NAME] & " (" & [DATE_START] & ")"

The same error is produced even with this expression:
=[PROJECT_NAME][DATE_START
Sponsored Links:

Similar posts...

 

Active X form control

Active X form control Icon
I have used microsoft active x form control text box in my Form. While opening the same it gives me error

"The expression MouseMove you entered as the event property setting produced the following error: There was an error loading an ActiveX control on one of your forms or reports".

However when I create a test form and insert a new text box com, it does't give me any error.

can anybody plz help me, I need to finalize my project
 

How do I insert an attachment using a form?

How do I insert an attachment using a form? Icon
I have an DB (2003) and I have a table with a column of type OLE Object.

I have a user form, and on this form I want to have a field where the user can attach documents (mainly word docs, but possibly excel, images).

What type of control do I use to add this field on the form?

I have the form, and am working on the code to store the input to various tables. but I'm not sure which control type I should use.

Basically it would be nice to have a button they click, and get a browse window to locate their file, then attach it
 

Requery of sub-report returns #Type error on calculated control (Access 2010)

Requery of sub-report returns #Type error on calculated control (Access 2010) Icon
I have a main form with a sub-report (rptAccount) that contains two further sub-reports (rptPayments, rptBalance). On the rptAccount I have a calculated field txtTotal: =[rptPayments].[Report]![txtSumTotal]-[rptBalance].[Report]![txtSumTotal].

This field calculates just fine at first. But in my main form I need to trigger a requery of the sub-report afterrecords are changed.

The requery runs, and the altered records show up correctly in the two sub-sub-reports. However, the calculated field txtTotal in the first sub-report (rptAccount) now returns a #Type error. No matter what I requery, this is always the result.

I requery all of the sub-reports individually, even the txtTotal control itself in any imaginable order. I always get the #Type error.
 

Help with error 13 type mismatch

Help with error 13 type mismatch Icon
I am getting a Type Mismatch error with the following code. This is called when there is a discrepancy in calculations.

1) MsgBox "Total trip miles = " & lngTripMiles & vbCrLf & _"and the leg miles total " & _ DSum("LegMiles", "qryCalculateTripLegs"), , "Trip calculation error[/indent]"
I'm also getting a Type Mismatch error with the following SQL. I've searched and everything I can find seems that I have my quotes correct. I even tried replacing the form control reference with a variable, which evaluated correctly, but still did not work.
 

How to trap and change the default data type validation error?

How to trap and change the default data type validation error? Icon
I've been teaching myself Access programming and am new to this forum. I have looked here and elsewhere for a problem but have not found a solution, hoping someone here can help.

In a form control, I am doing a number of data checks and generating appropriate error messages, using VB in the "on exit" event. The field I am checking is declared as data type number in the underlying table. If the user mistakenly enters text, Access generates an error "The value you entered isn't valid for this field." I want to change that default error message. I have learned how to change other default error messages, but I can't figure out how to trap and change this one. Note -- I don't want to check for the error in the form, because there are a dozen or so controls in the form where I need to do this check
 

Errors: 2950 AND 2109

Errors: 2950 AND 2109 Icon
I have created a macro to go to a control on a form on click of a button. The control is definitely on the form, visible and enabled and referring to a field within the table but I sometimes get an error.

The error number comes up 2950 which generates a run time error 2109 stating no field named in current record.

As the field is in the table that the form is bound to I have no idea what the problem is and it only comes up with the error occasionally. How can I prevent the error from ever coming up?
 

Pass Values from one Subform ontrol to Another Bound Control on the Same Form

Pass Values from one Subform ontrol to Another Bound Control on the Same Form Icon
I am trying to pass the value for the second column of a combobox in a subform to another control (on the same subform) which has a control source from the underlying query. I have: me!testcontrol = me![subform].Form![control].Column(1) in the afterupdate event of a control.

It work as I would expect it to when I open the subform all by itself. The second control gets the value and it is passed to the query.

However, when I run the the form/subform I get an error saying that it can't find the subform.
 

Error when add MS Office Document Imaging Viewer Control to a form

Error when add MS Office Document Imaging Viewer Control to a form Icon
When I drag a com components control such as Microsoft office Document Imaging Viewer Control that I choose from COM components to a windows form . I got the following message

"Failed to import the ActiveX control. Please ensure it is properly registered"

The above action does not produce error in VS 2003.
 

SetFocus to a Form control when cursor is in Split Form datasheet

SetFocus to a Form control when cursor is in Split Form datasheet Icon
I have a Main form with a Split Form view.

I have an OnCurrent event that runs when the user selects a different record in the Split Form.

The first part of the OnCurrent event is as follows:

1) [Forms]![f_MainTripForm_Admin].SetFocus
2) [Forms]![f_MainTripForm_Admin]![TripStartDate].SetFocus

However, the focus is staying on the TripStartDate field in the SplitForm, and not moving to the TripStartDate field in the Main form as desired.

I need to move the focus to the TripStartDate control on the form so that I can run the remainder of the OnCurrent event which shows or hides various controls on the Main form depending on the type of record the user is viewing.

Otherwise, the focus could be on a control that I am trying to hide and I will get the "Can't hide a control that had the focus" error.
 

Problem with ActiveX Control on Form (Access 2007)

Problem with ActiveX Control on Form (Access 2007) Icon
I have a 10-year old application, which has been upgraded over the years, and is currently running in Access 2007. It is installed on 5 PCs in the same company.

All of a sudden, when the users open a particular form, they get one error message or another, but both error messages end with the text "There was an error loading an ActiveX control on one of your forms or reports".

On one of the PCs, a Compact and Repair seemed to help, but not on any of the others. I'm thinking an OS patch may have messed something up, or a software install that I'm unaware of.

The form in question uses 2 ActiveX controls, a ListView and a DatePicker control. Each of these require their own OCX to be loaded and registered.