Run A Activex Control From A Command Button

Mar 4, 2008

Hi all,

I am wandering if someone can help me out on this i have a thermal printer with it you get some ative x components to control the printer like for example what i am tryin to do is kick the cashdrawer which is connected to the printer,
Now the activex button does work correctly when click but i have another command button which prints out a couple of pages odf information so what i am tryin to do is have abother cmmand button when clicked run the code and then calls or runs the active x button to open the drawer is there a way i can do is i tried using the call statement with the name of the activex but with no luck.

i would really appreciate it if someone can help me out on this. thanks.

Regards
Naym

View Replies


ADVERTISEMENT

Forms :: Control Form Command Button Based On Subform?

Sep 2, 2014

i have some command button and some combo box on my form and also a subform. the subform contains some field. the fields used to enter numeric values.

i need to disable my command button on the form based on the subform fields if they r null.

View 1 Replies View Related

Make Command Button Visible Based On Value Of Control On Another Form

Feb 27, 2015

Form 1: I have a combo box on my main menu(MenuMainF) called cboCompanyType with typical values 1,2,3,4,5,etc......

Form 2: I have a command button on my administration menu(MenuAdminF) called cmdDevelopment

My goal is to have the cmdDevelopment button of Form 2 be visible if cboCompanyType on Form 1 is equal to 1,2,3, or 4, but if it is any other value, then cmdDevelopment should be not visible.

View 1 Replies View Related

Correct Code Command To Keep Form Open After Selecting Close Control Box Button?

Oct 13, 2015

I am at my Login Screen, I want it to return to the Login Screen if you select "NO" and Close the DB if "YES"

Here is my current code:

Private Sub Form_Close()
If MsgBox("Would you like to EXIT the Database?", vbYesNo, "Quiting Database") = vbYes Then
Application.Quit
Else
???
End If
End Sub

View 5 Replies View Related

ActiveX Control

Feb 4, 2008

Hi All!

I'm new to ms access 2007.
How can I register my ocx files? like comdlg32.ocx?
Please help! My .mde file is running but somehow some of the features are not running.

View 1 Replies View Related

How To Register ActiveX Control

Jun 10, 2014

I'm using an activeX control and access gave me an error message showing that "I must register the ActixeX control. how can i do this?

View 6 Replies View Related

Free Datepicker Activex Control

May 14, 2005

Hi,

While searching for a free datepicker activex control I found the following control. It also allows null value. I found it quite useful and it's free

http://spazioinwind.libero.it/vbprogzone/activex/downloads/cal2.zip

regards

edit: copy the shortcut on a new browser otherwise it gives an error

View 1 Replies View Related

ActiveX Control Problem In FORMS

Jan 4, 2006

Whenever i try to add an ActiveX control in my any form i recieve following Error Message ( See Attachment ), any help will be Appreciated

Take Care
ENJOY

View 4 Replies View Related

Media Player ActiveX Control

Jun 18, 2006

Hi,

I have a form with an ActiveX Control for Media Player 10. The player works ok, but if I try to close the form using the PlayStateChange Event, Access crashes out to the 'Send Report To Microsoft' window.

This is the code:-

Private Sub WindowsMediaPlayer0_PlayStateChange(ByVal Newstate As Long)

If Newstate = 8 Then

DoCmd.Close

End If
End Sub

This is looking for the end of the current media file, but I get the same problem if I look for Newstate = 1, the stop button being pressed.

However, if I put the DoCmd.Close command behind a command button, the form closes as normal.

Any ideas?

View 3 Replies View Related

Error: Communicating With OLE Server Or ActiveX Control

Nov 18, 2006

I just installed Office 2007 and I get this error whenever I start MS Access 2007.
"A problem occured while Microsoft Office Access was communicating with the OLE server or ActiveX Control"

What could it be? I don't have any antivirus appz or such that could interfere, and my Windows XP+SP2 is updated daily.

View 12 Replies View Related

Modules & VBA :: Referencing ActiveX Control In A Class

Jun 26, 2015

I'm using Access 2003. In "References" (Tools > References > Browse...), I've added in "Microsoft Windows Common Controls 6.0 (SP6)" (c:windowssystem32mscomctl.ocx).

I've then created/inserted an instance of the control "Microsoft ListView Control 6.0 (SP6)" on a Form ("MyForm") and given the listvew control the Name "MyListView".I wanted to decorate MyListView with some custom methods so I've created a new class module ("DecoratedListView") which contains a member field called "lvw".

I want 'lvw' to point/reference to MyListView, but I don't know what reference type to use in its declaration. Importantly, I also want to capture lvw's ColumnClick event.

I've tried:

Code:
Public WithEvents lvw As Object
Public WithEvents lvw As Control
Public WithEvents lvw As MSComctlLib.ListView.2
Public WithEvents lvw As MSComctlLib.ListView
Public WithEvents lvw As CustomControl

and none works when I

Code:
set lvw = Forms!MyForm.MyListView

The first try (Object) doesn't even compile. I get the exception "Expected: identifier"
The second try (Control) doesn't compile either. I get the exception "Object does not source automation events"
The third try (MSComctlLib.ListView.2) doesn't compile and throws the exception "Expected: end of statement"
The fourth try (MSComctlLib.ListView) compiles but fails at runtime with the exception "Type mismatch". Using TYPENAME() on the control returns "CustomControl".
The fifth try (CustomControl) compiles but fails at runtime with the exception "Object or class does not support the set of events".

I can't believe I'm the first person to have tried to capture an ActiveX Control's events in a separate class.

View 1 Replies View Related

Change The Built-in Right-click Event Of An ActiveX Control

Mar 13, 2008

I am using an active x control that when you right click on it, it automatically pops up an "About" box showing information about the control. I wouldn't object to this, but I need to use the right mouse down event for another purpose in my program. So far I have discovered that the code I put in the the event works, but only after the "About" box pops up. Is there anyway to cancel or prevent the popup? The reason that I need the right mouse down event is because is that I am already using the left mouse double click event, and I can't use the left mouse down event because then it always fires before the left mouse double click event. This control doesn't have any single click events. Ideas?

View 2 Replies View Related

Distributing A Database That Uses The Month View ActiveX Control

Oct 26, 2004

Hello all,

This problem has been causing to pull my hair out all morning, so any help would be most welcome.

The business I work for hired a contractor to produce a database, he did a great job and it looks very professional, but he used an ActiveX control to display four months at once, it is a fairly common control but it seems it is not included in the Image for the workstations here (it will be soon).

The OLE class is called MSComCtl2.MonthView.2 and I remembered using the date time picker control (MSComCtl2.DTPicker.2) and I figured that it would make sense if it was in the same ActiveX control, so I registered Mscomct2.ocx and yes, it does contain the right class... but it still didn't work. I found a second control package which also included the class, comct232.ocx (older but it should work) and finally, both of them together do work... for all but one user. It isn't the workstation, anyone else logging into that workstation has no problems.

The problem cropping up is the "control has no object" error and it suggests that I unregister then re-register the OLE server (which is another word for the .ocx files for those not in the know) which I did, and it complains about a missing reference to C:WINNTsystem32Mscomct2.ocx if you look at the references in the VBE editor which makes very little sense to me.

The users do not have admin rights to there computers, but I'm thinking of temporarily adding the user to the admin group (on her computer only obviously) and un-registering then re-registering the control there. That seens abit extreme, and it should just work!

This is driving me nuts, anyone know what I'm missing here?

Thanks in advance

-mwalts

View 6 Replies View Related

Reports :: Insert A Barcode ActiveX Control / But It Is Not Listed

May 30, 2014

I am wanting to insert a Barcode ActiveX control, but it is not listed. In an instruction video, after clicking on ActiveX Controls, the one named "ABarcode ActiveX" is at the top of the list.=how I can obtain this.

View 2 Replies View Related

Control Treeview Is Missing Form ActiveX List?

Jun 21, 2014

I use Access 2010 on Windows 7 64b to create a form with a Treeview control. However, this control is missing from the list of controls activix. How can I add?

View 4 Replies View Related

Calender ActiveX Control Display Also Hours, Minutes And Seconds

Jul 22, 2007

I am using the calender control 11.0. By this calender I can only set the date year, month and day. I can not set the clock time:Hours, minutes and seconds. Is there a calender that enables me to set the date in the format:dd-mm-yyyy HH:MM:SS, means day,month,year Hour:Minutes:Seconds.


Grateful

View 1 Replies View Related

General :: Access 2010 - Printing ActiveX Control / Cropped To Top Left Corner

Oct 22, 2014

I have a form and report created in Access 2010 that contain an ActiveX Control.

When the form or report is printed the ActiveX Control appears but is cropped up to the top left corner.

View 5 Replies View Related

Modules & VBA :: ActiveX Control Events Aren't Raised While Calling Its Methods From The Open Event

Oct 9, 2013

We have an ActiveX grid control, 10Tec iGrid, written in VB6. One of its method, Group, used to group rows, raises the AfterAutoGroupRowCreated event so the developer can adjust the look and contents of every group row created during the automatic process of grouping.

When our ActiveX grid is hosted on an MS Access form and we call the Group method while populating the grid in the form's Open event, the AfterAutoGroupRowCreated event isn't triggered. But this event definitely works as expected in other development environments, and even in MS Access if we call Group from the form's Load event.

Is it a well know issue of MS Access, when any events of ActiveX controls aren't triggered while "executing" the Open event

View 1 Replies View Related

Forms :: Copying Command Button Appearance Properties To Other Command Buttons

Dec 17, 2013

I am rewriting an old Access 2003 database in Access 2010. When creating new command buttons, the current theme gives them a default appearance. I need to apply this appearance to old command buttons. I know there is a way to select the default button and apply its properties to others quickly. I have done it before but didn't write the process down .

View 2 Replies View Related

Forms :: Command Button To Unlock And Lock Fields / Edit Button?

Feb 19, 2014

I have created a web-database (? - There are globes over all the forms and tables icons) based on the Issues & Tasks template. This means that most of the data is entered and seen on the "Main" form, which has two tabs - Open Issues and Closed Issues. I have created a form that allows people at my work to input the necessary data and save it, so that it will show up on one of the two tabs. However, once a record has been created, I want to be initially locked if the ID/PK is clicked, so that data can't be changed or entered inadvertently.

SO, I changed the code so that when the ID/PK for a record is clicked, it brings up a different form, but one that looks exactly like the one that is brought up when entering a new form, but I locked all of the fields so that the information cannot be changed. It seems from what I have read that I can create a button on this form so that when clicked, it unlocks the fields on the form so that they can be changed, and then when clicked again it will lock the fields again. Is this true? If so, how can I do it? Or is there something similar I can do? I have seen codes that I could copy and paste, but I cannot figure out the place to copy and paste codes in Access 2010.

I have changed the Form properties so that Data Entry and all the "Allows" are set to No...

View 9 Replies View Related

Difference Between A Command Button And A 'label' Button

Aug 12, 2005

Hi, I have got a small problem and maybe someone could advise me.
I am creating a customised command button from a label button. The new button works fine but I can't apply the 'requery' function to it, if i do an error occures and i am being prompt to save the data first???? :confused: :


Private Sub Labelsearch_Click()
Me!itemquery.Requery
End Sub

Private Sub Labelsearch_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
Me.Labelsearch.SpecialEffect = 2
Me.Labelsearch.BackColor = 255
Me.Labelsearch.ForeColor = 10092543
Me.Labelsearch.FontItalic = True
Me.Labelsearch.FontBold = True
End Sub

Private Sub Labelsearch_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
Me.Labelsearch.ForeColor = 255
Me.Labelsearch.FontItalic = False
Me.Labelsearch.FontBold = True
End Sub

Private Sub Labelsearch_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As Single)
'Come back to initial state when button release'
Me.Labelsearch.SpecialEffect = 1
Me.Labelsearch.BackColor = 16373685
Me.Labelsearch.ForeColor = 8388608
Me.Labelsearch.FontItalic = False
Me.Labelsearch.FontBold = True
End

If I create a command button with the wizard and assign the code :
me!itemquery.Requeryto the on_click event my form is working fine.
Why is his code is not working if I assign it to a label? :o

View 6 Replies View Related

Go To Next Page Command For Tab Control?

Oct 17, 2006

Hello,

Is there a way to program a Next Page button for a tab control that can be put in the form's header and that'll go to the next page, regardless of what page I am on?

Thanks.

View 4 Replies View Related

Control Date Value From Command Click

Jan 24, 2006

Dont be overwhelmed by the following, but it may require some extensive thought and I dont expect everyone to understand....

I want to have a unbound form control a subform. On the form I have an unbound text area entitled txtDate. In this area it displays the current date being viewed. I have put left and right buttons on the main form that will add (+1) one day to the date being shown and subtract (-1) one day from the date being shown. I want to conrol it though the "On Click" but I dont know what to enter in the "On Click" field that will allow me this. The reason is, co-insiding with the previous, when the date is changed, the subform is also changed to a new day. Therefore instead of displaying 24 hours of today, you can view 24 hours of yesterday, tomorrow and so on. See, if one is to set the onclick to be: Me.txtDate=Me.txtDate-1, or Me.txtDate=Me.txtDate+1, it calls for a custom macro and I dont know why. I know it somehow resides in some similar command set up.

I also need to know how to make the subform bound but continous, and what exactly does that mean?

Anyone care to offer some assistance? :confused:

View 4 Replies View Related

Can I Control Which Tab Is Selected With Command Buttons

Jul 26, 2006

I would like to turn the tab style to none and select the tab pages with a
command button instead is this possible.

Thanks

View 3 Replies View Related

Command Button To Set Value

Apr 20, 2006

I have been working on this for awhile, and can't figure it out for the life of me!

I have a form set up with a drop down box that lets me pick from values from a table based off of the Primary Key of that table (Row Source = SELECT Order.OrderID, Order.OrderName from Order). I have a button on the form that I want to set a value (Closed) from the table entry based off of the order selected.

Pseudo code would go something like this.

Closed.Value = True Where Table.Order.OrderID = SelectedOrderID



Table.Order is a Table Named Order (obviously)
Closed is a yes/no field in my Order table
OrderID is the primarykey of the table Order
SelectedOrderID is the drop down box.

Any help would be greatly appreciated!

View 3 Replies View Related

Command Button?

Apr 26, 2005

I, unfortunately, have been singled out as the Access guru in my work area. We have 223 people and the Information Manager has tasked me to modify a database he "found" to be able to track a number of things, but most important to him: performance reports.

I have posted the sample of what I currently have. What is being asked of me is a way in which to have a button or by double-clicking a block where a date would go for all other dates on the form to become non-visible while the current date stored in the computer the database is being worked from be entered in the block where the button or double-click happened. All this links to a report for the IM to be able to track what performace reports are out, and when they are due back to his section. He also wants me to be able to show which are overdue and where they are at. I am not sure if it is at all possible, but with me having spend most of last week purusing the articles on Access here, I know now that nothing is implausible if you happen to go about it the right way.

Since I have read the rules on posting, here is what I have done. I searched the forum for command button and got a lot of really cool ideas to use elsewhere in the database. I looked up the help in the program itself for command button, and got some good information on how a command button works, but I cannot make it put a date into a block. I can enter the date in any block that is a date format, but then I have dates in every block. He only wants to see the most current date in any of the blocks.

Any assistance at this point would be appreciated. If I have missed something in another thread, I apologise in advance.

View 11 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved