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 Replies


ADVERTISEMENT

Forms :: Display Month View Control On Form?

Mar 6, 2015

I want to display a month view control on one of my forms.

I only want to use it for viewing purposes only. But I don't see the Calendar control or MonthView in Activex list.

Where I might obtain such a month view control?

I'm using Access 2010 and Windows 8.1

View 5 Replies View Related

Distributing A Database

Mar 16, 2006

So I have nearly finished my database and I want to give it to people so they can start entering data into it via the form.

Is there a way to make it so when someone double clicks on the file in Win Explorer it only opens the form for data entry - no access to the tables etc.

Can this be done ussing Access 2000?

Thanks.

View 2 Replies View Related

Distributing A Database Across A Network

Aug 2, 2005

I have a database built in Office 2000.

The client wants it across a network but insists they do not want it split! They want it in a shared drive which everyone has access to via a shortcut.

The database is secured so I presume the Workgroup file will have to be on each PC and a shortcut to the one database on the server which is in a shared mode. Would the security I have implemented still work or would I have to de-secure so everyone has the same level of access.

They do not have Access on all PC's. IFor this to work I presume Access is needed both on the server and PC's

I understand if I purchase Microsoft Access Developers 2000 it has a feature where I can distribute a database to users without Access? However, am I right in assuming this needs the database to be split.

In the UK are there any suggestions on where I can buy Microsoft Access Developers 2000 ?

Many thanks.

View 4 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

General :: Distributing MS Access Database File With Creating Application Shortcut

Nov 4, 2014

I read in the book (Access 2013 inside out), one of the way to distributing access database is creating an application shortcut.

Now i have an Access 2013 file on my computer (with office 2013 and windows 7) other users have office 2007 and windows (XP) on their computers. now i want to give a copy of this file to other users without save as that to 2007.

I would like to know how i can do that with creating an application shortcut , if it is possible because in the book I could not find the way if there is?

View 2 Replies View Related

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 1 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

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

Crystal Reports ActiveX Designer Logon Failed When Select MS Access Database

Jun 13, 2012

I am getting the following error when connecting Crystal reports with MS Access.

---------------------------
Crystal Reports ActiveX Designer.
---------------------------
Logon failed.
Details: ADO Error Code: 0x
Source: Microsoft JET Database Engine
Description: Unspecified error
---------------------------
OK
---------------------------

I have select following options in crystal report -> select OLEDB (ADO) , database name as filename.mdb , db type as Access.

View 1 Replies View Related

Set Month Only On Calendar Control

Jun 17, 2005

I would like the calendar control to default to the current month and year (if there is no date in the control source). I don't want to set it to the current date.

I've tried:
Month([CalendarOut].Value) = Month(Date)

but that doesn't seem to work.

Any suggestions?

Thanks!

View 2 Replies View Related

Sales Query Manufacture By Month - Total Column In Design View

Jan 2, 2014

I'm trying to create a simple sales query by manufacture by month. I want the month as the column headers (with a total YTD Column). Mfg's are the row headers. The query is already completed and I figured out how to do the row total but can't figure out how to create total column. Can I not add a total column in design view? How would I do that?

View 10 Replies View Related

Select Only Month/Year With Calandar Control

Oct 20, 2005

I have a database where all reports are by month. I want a simple way to allow the user to select the month/year and want to know if I can use the header portion of the calandar control for this (although I can't seem to figure that out). The alternative is to use two combo boxes (Month and Year) and in a hidden text box I concatenate them into a date since that is how the report query reads the month (using datediff). I would prefer the calandar control because it is more visually pleasing. If anyone has any ideas or suggestions please !

View 1 Replies View Related

Tab Control View Problemo

Aug 14, 2006

Hi guys,
I know this has been discussed before, but I cannot seem to find any threads regarding this issue.

So, I'm using the tab control on my form, but every time I open my form the view scrolls down and I cannot see the actual tabs. Is there any way to correct this?

Thanks
kruger101

View 4 Replies View Related

Access Db Behind VB - Distributing.

Feb 8, 2007

Hi,

I´m thinking of building a program in VB that uses an access db for data.

what programs does the user need on his computer? Does he need access?

How should I distribute the application?


Fuga.

View 1 Replies View Related

Distributing My Application

Dec 2, 2007

Hello everyone,

I just developed an application and now I want to distibute it.
I want to work with licenties and I also want to make shure the software can only be installed according to the number of licences.

How do I solve this problem?

View 4 Replies View Related







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