Topics Search

Active X form control

Active X form control
Views: 96
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
Sponsored Links:

More topics

 

Microsoft InkPicture Control

Preview
Need help with a Active X control.
I working on a project to write my work orders on a computer and let the customer sign on my tablet PC screen, this is the idea.

I found a active x control, that maybe worked "Microsoft InkPicture Control"
But I found no way to print the signatur on a report. I dont want to safe the signature as a picture, only if I have to.

Karl

Working with Access 2007 and Windows
 

disable controls on a subform,

Preview
I have a form, it has two combo boxes and a subform with four controls one txt and three combos, When the form opens the first combo is active and the second combo is enabled to false, so is the subform and the controls on it "see first image", as I add data into the control the other update event activates and the next control becomes active.

the subform becomes active and so on for each control on it.

when the last control is used its focus is directed to one of three buttons. close, exit and save and add record.
the form controls which are set to enabled to false work just how I would like, but when I press the add record button, I get "you can't disable a control while it has focus". .
or if I do not put the focus on the close button it works but not all the controls on the subform get set to enabled to false "see second image".
 

Requery Macro Action

Preview
You can use the Requery action to update the data in a specified control on the active object by requerying the source of the control. If no control is specified, this action requeries the source of the object itself. Use this action to ensure that the active object or one of its controls displays the most current data.
 

Outlook Calendar Control Needed

Preview
I am currently recording patient's appointment dates and times in table via a form by having 2 separate controls; a date text box and a time text box.

I still have to use Outlook to display the appointments in a Calendar form (double entry of data is annoying) as I cant find a Calendar control where I can see a week in view. Id like to enter.

Date
Time
Duration

via the Calendar control.

Does anyone know how I can do this ? Ive tried inserting an Active X Control but its saying the object isnt installed or something like that
 

Show All Records

Preview
I have a table with a filed named Status which the default is set to Active, it is a combo with a value list using Active and Archived. On my form I have an option group with the default being set to 1 or active.

Sometimes I wish to set the status to archive so the record does no appear on the form bu not delete it. I also set the criteria for the query that the form uses for the field status to 1 meaning active.

I am using a Do.Cmd.ShowAllRecords (on click event for a checkboxl on the form to view all record but of course it does not work.I need a solutionfor this problem.

P.S. I want to be able to view ALL records on command but then go back to the default when either the form is loaded again or another event is triggered.
 

Filter Subform from another form

Preview
I am trying to filter a subform when I open the parent form from a different form with an option group. So, the first form pops up with the options: 1) Show "Active" Contracts 2) Show All Contracts. If the user selects 1, I want it to open the specific customer form (frmContractsForm) and filter the subform (frmContractSub) where the subform's "Status" field is "Active." Here is my code:

'Display Active or All Contracts
'Open Form
DoCmd.OpenForm "frmContractForm", , , "CustomerID=" & Me.txtCustomerID
'Filter to Active or All
Select Case frameOptions
With Forms!frmcontractform.frmContractSub
.Filter = "Status= 'Active'"
.FilterOn = True
 

How to change a page control parameter

Preview
I've got a little problem in changing a tab control enabled parameteri have a tab control named tabctl0within that tab I have 3 pages: page1,page2,page3I want to depend the enabled parameter of each page on a field in the main form.the field in the main form = dovisitif me!dovisit = 1 then me.page1.enabled = false me.page2.setfocusend ifI wrote that code but everytime I get the message that you cant change a page control if it is active.can somone help pleasethanx alot in advanceNoam
 

reference a text box from a function

Preview
I have a couple of forms which have a text box named txtTempHold. The value of txtTempHold changes on the 'gotfocus' event of the active control. Rather than put the code I am using behind the form on every gotfocus event I want to put it into a function.

I'm having trouble with the folowing line (which compares the active control value to the temp value). I can't use 'me. in the function and am not sure what I should use.

If Screen.ActiveControl.Value Me.txtTempHold Then

I can write it with a reference to the actual form name etc. but as it's on different forms I only want to have the one function and reference the text box from both forms.
 

how to make the form active for editing?

Preview
I have a form and when I click a button it opens up another form. The problem is the newly opened form goes below the form and is not active. I have to close the previous form first to get to the newly opened form
 

Tab Control - Pages

Preview
I have a common text box control which appears on all 4 pages of my tab control. (Common text box control achieved through pasting a text box control onto the tab)

I only want the user to be able to change the data in this text box control if they are on Page 1. If they are on any other Page, then I would like to Lock the text box control.

If there was a Got Focus event for a Page then I could do what I need; but there isn't!

Is there a way to determine which Page of my Tab Control is active