You Don't Have The License Required To Use This Active X Control

Jan 11, 2008

Hi,

I have an Access database built by someone else and I need to make a change.

The database works fine on the client machines but does not work on my Development PC.

What happens is when it starts up I get the initial program screen but when I try to launch any data form I get the title error messge.

However, It does however work on an older PC I have here (which has the same configuration).

I am running Windows XP with Office 2003 - this is the same thing that both the client and other PC have.

In general Access works fine on the new PC and there are no specific

Any thoughts on whats going on? I want to use the Development PC as the old one is very slow and has basically been retired.

Thanks

View Replies

MSCOMM Active-X Control

Jul 22, 2007

I have built an automated procedure in VBA Access 2000 that is now great (thanks to a lot of downloaded help from this forum). I use the MSCOMM active-x control to talk to an instrument via the serial port.

Question: Is that control only working because I also have VB6 installed on this same computer? It seems to me that I tried something like this a year ago and could not get MSCOMM to work in Access, but at the same time, I didn't have great MSCOMM examples to go by. I do now as I could rob them from other programs my company has written in VB6.

I have both VB6 and Access 2000, but chose to develope this procedure in Accesss because of the heavy amount of data to store (and I know VBA much better than I do VB6). I thought Access is a natural. But now I am wondering if I will have problems distriubuting this database to other service offices that may not have a machine with VB6 on it?

Do they need just plot MSCOMM32.OCX in to their system32 directory?? :confused:

View 6 Replies View Related

Active X Calendar Control

Mar 2, 2005

Please can someone advise me how I can link the date which I select in the calendar control to a date field in the form. I want to use the calendar instead of a combo box.
It's probably simple....but then so am I!
Help appreciated
Richard

View 11 Replies View Related

Active Control / Button

Mar 5, 2008

hi,

when i select a button from the active control menu and want to use that button for either next record, previuos record. attach macro, print, i am sure that was part of the menu when selecting the button. i am not seeing that menu when i select the button from the active control could you please tell me why

thanks
steve

View 3 Replies View Related

Active X Control Comes Grayed Out?

May 29, 2014

Set default controls comes as grayed out. I am in design view of form.

View 1 Replies View Related

Change Color Of Active Control

Apr 12, 2005

Please can someone tell me how to change the back colour of a control when it has the focus and then revert to the original colour when it loses it. I have 35 controls on my form, so I need a function, rather than changing the colour with a subroutine evey time.

I have searched the site and haven't found whatI want-though I'm sure this question has been asked before.

View 8 Replies View Related

Crystal Reports Viewer Active X Control

Feb 26, 2006

Could anyone point me in the right direction re the Crystal Reports Active X viewer control and access forms. I loaded it onto a form in access 2000, but can't seem to find any meaningfull properties I can manipulate (especially the report source). I am thinking it works like any other active x control and I can manipulate properties through code, however, the main property I would think I need (source report) does not seem to exist. I have Crystal 10.0 loaded on my system.

View 1 Replies View Related

Forms :: Finding Previous Active Control On A Form

Mar 2, 2015

I have a form where the user clicks a button (button 1) to open a modal form, the user then enters data into this form and clicks close.

Then back in the first form I need to find which control had focus before (button 1) was clicked.

Screen.PreviousControl returns a control on the modal form.

I hope its easy like Forms!FirstForm.PreviousControl but I can't seem to find it!

View 2 Replies View Related

Modules & VBA :: Only Refresh Specific List Control Box That Is Active In Form

Jan 28, 2014

Essentially I have a form_A with several tab's and then one list control box in each of those tabs. At present if you double click on any item within the control boxes your taken to another form_B with info about that item and when you close that from down again if refreshes form_A.

Is it possible to only refresh the specific list control box that is active instead of refreshing the whole form ?

View 4 Replies View Related

License Agreements

Jan 13, 2007

Hello

I am in the process of creating my first commercial databse and i was wondering if anyone new where i can get a template of a generic user licence text?

Any assistance would be appreciated.

View 3 Replies View Related

Help On License Count Sum

Apr 22, 2008

Hi. I have a table that contains licence details.

LicenceAgreementID / LicenceKey / NumOfLicencePurchased

Each licence agreement can have one or many licence keys, each licence key can have one or many licences

I would like a query that groups by LicenceAgreementID then sums the NumOfLicences for the the LicenceAgreementId.

Query so far:

SELECT tblLicenseDetails.LicenseAgreementID, tblLicenseDetails.LicenseKey, tblLicenseDetails.NumOfLicensePurch
FROM tblLicenseDetails
GROUP BY tblLicenseDetails.LicenseAgreementID, tblLicenseDetails.LicenseKey, tblLicenseDetails.NumOfLicensePurch
HAVING (((tblLicenseDetails.LicenseAgreementID) Is Not Null));

It may be that I have to redesign my tables, if so I will will.

Current Output:

LicenceAgreementID...........LicenceKey.........Nu mOfLicencePurchased
12345..............................AAA-BBB-CCC.....10
12345..............................ZZZ-BBB-CCC.....10
12345..............................XXX-BBB-CCC.....10

The output I would would be:

LicenceAgreementID...........LicenceKey.........Nu mOfLicencePurchased
12345..............................AAA-BBB-CCC.....30
......................................ZZZ-BBB-CCC.....
......................................XXX-BBB-CCC.....

or something along those lines!

Can anyone share my vision?
Thanks,
Phil.

View 1 Replies View Related

Forms :: Fields Are Required To Be Filled Out Even Though Not Set As Required

Nov 3, 2014

I have made a form based on related tables. it requires me to fill out every field, which I don't want. I didn't make them required. Why does it do that?

View 3 Replies View Related

Office 97 License Missing On XP Machine?

Jul 16, 2005

Hi,

I�ve installed office97 professional on a computer with office 2003 standard on it.

When I try to start access it tells me there is no license for it on the machine.

Has anyone else had this problem? Of course I have a license, and there has never been any problems with it in the past.

The 2003 version has not yet been registered, if that might have something to do with it.

Fuga.

View 1 Replies View Related

Data Access Pages -Office License

Mar 20, 2006

Hello

At our firm we have a mix of Microsoft Office (2000) Standard licenses and Microsoft Office(2000) Professional liceneses.

After reading through a lot of literature from Microsofts own site it is possible to create Data access pages to enable users to view and have basic inputting into an access back end database.It also states that you need a qualifying License to use microsofts 'web components' to be able to do this.

Now another of our offices has decided to 'check' with microsofts helpdesk about wether or not you need a seperate access license for each user and suprise suprise Microsoft state you do.

Their own site states that Office standard IS a qualifying license see here

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/deploydap.asp

but microsoft are saying otherwise....

Anyone know if i am commitiing an offense or am i just being bullied by microsoft.I have asked them to produce the legislation that states i am doing wrong but they have not yet responded

cheers

View 1 Replies View Related

Microsoft Access Can't Start Because There Is No License For It On This Machine

Feb 1, 2005

I recently bought a new computer and it was kinda cheap, so no office products were installed on the computer. A friend loaned me her copy of Office 2003 which didn't have Access on it. So, after installing Office 2003 I picked my old Office 97 CD and installed just Access 97. Then I go to open the database and get this annoying message.

Microsoft Access can't start because there is no license for it on this machine.

Can anyone help? Thanks for your time.

View 1 Replies View Related

General :: Display License Agreement Or Other Text Instructions

Feb 3, 2013

I want to display the license agreement, which is a one page Word or PDF document, in form or report or whatever.

View 3 Replies View Related

Selling Access Database - How Do I Ensure User Has Valid License?

Feb 24, 2008

I am developing an Access database, and using the Access 2007 Developer Extensions to "compile" it into an installable program which includes the freely distributable Access 2007 RunTime, for users who don't have it already installed.

I am planning on charging a subscription fee to use my Access database. Are there any existing method for handling making sure the user's subscription is still active, and if not, either locking them our or preferably making everything read-only? If there aren't any existing methods anyone can point me to, does anyone have any ideas?

I plan on being the person who installs the application the first time, however I'm sure instances will come up where I instead mail the user a CD for them to install.

Regardless of whether I complete the first install, I'm not interested in going to each users' location periodically regarding the subscription.

I'm more interested in going the route of the user typing in some type of registration code, which is validated for read/write access for a period of time.

I don't want to rely on the user having an internet connection, but if they had one, I could certainly go the Microsoft model (try internet verification, if it goes wrong or there isn't a connection, have user call in.)

View 2 Replies View Related

Queries :: Create Parameter Query To Select Which Column To Calculate Weekly License Info

Mar 2, 2014

Basically, I have a database table that is maintained every week. It is about e-mail account licenses for Office 365.

Each column represents a week of license data for every mailbox account which is about 10 000 plus users with the date as the field headers( something like "License information as of 06122013").

Basically, I have created 52 queries based on the license type I require to be calculated & I have a form created to control it. However, right now it is all output only as I have yet to create any user parameter to specify on any of the queries about the date I want

As I am currently unsure how to specify all the queries to use one field date header which I want the user to specify via drop down list in order to calculate all the licenses on this specific date.

For example, if I want to see the license information for 06/11/2013, I would choose "License as of 06112013" & it would then run all the queries based on the header specified earlier & output that information on the form.

Right now the queries are all configured as the "Select" type.

View 1 Replies View Related

"Microsoft Access Can't Start Because There Is No License For It On This Machine"

Mar 10, 2005

Trying to use Access97 on Windows XP and I get an error message.

"Microsoft Access can't start because there is no license for it on this machine"

I've tried everything and it still doesn't want to work.
I've uninstalled and reinstalled
I've tried to find the font, hatten, and it's not there
I've downloaded MDAC 2.8
I've check the permissions in HKEY CLASSES ROOT
I've tried c:setup/y
I've downloaded AcLicn97.exe and it tells me that it can't find Access

If anyone can help, please let me know

View 3 Replies View Related

Go To Active Subreport

Apr 6, 2006

Is there any way to add a dropdown box or something that determines that a subrecord is active/completed, and then have a way to jump straight to the one that is active by clicking a button on the record? In the example I attached, I want to be able to click on the button above the tab and have it switch to that tab and open the first record it finds that has "Active" selected.

View 1 Replies View Related

Too Many Active Users

Mar 9, 2008

Hi Again guys,

I have a database application, front end on the local machines, back end on a server (it happens to be a mac server, but still works). Recently we upgraded to Access2007 on all systems, but left the backend in 2000 format. Ever since then we have been having issues with our users getting told "Too Many Active Users" when they try and access the backend. If all users disconnect and the reconnect it seems to be fine for a while, then after sometime it does it again. I assume it has something to do with the ldb file on the backend. It worked fine in 2003, now I am stumped. It possibly has something to do with permissions but I have no idea what.

Thanks for any help.

View 10 Replies View Related

Active X Controls

May 3, 2005

I have application made in MS Access 2000

I got crazy with one Active X Control on one PC. On every other PC works fine but on this one I have error "Object is missing or does not exist".

I tried delete - copy - paste couple times, unregister and register control couple time, but error is still there.

Reference looks fine, I put control on the form and everything looks great.
I tried delete control from the form and put again.

When I try to assign some data to the control I have error "Object is missing or does not exists".

It's look like my Access programm see just as read only or something like that.

Does anybody have idea why my Active X Control does not work on this PC?

View 2 Replies View Related

How Can I Get The Name Of The Active Subform

May 23, 2005

I am trying to get the name of the active subform in an Access database from VBA code.

If i use screen.activeform i get the name of the parent form and not the subform.

Any ideas how to get this ?

Many thanks in advance.

Andrew

View 5 Replies View Related

Link With Active Directory

Apr 26, 2005

Hi All

I have a small Help Desk db with tables that contain computer spec and user information. But I already have all this information in Active Directory and it seems pointless entering the information twice.

Is there any way i can get the database to lookup the information from Active directory i have no idea where to start.

Thanks

View 1 Replies View Related

Inventor View Active X

Nov 20, 2007

I have added an Active X control to my form. The active X control is Inventor View which is for viewing 3D drawings. At the moment I can get it to work and show one particular drawing using a filepath put in the filename property.

However, I want to save the filepath for each record in the table and then change the filename property of the Inventor View to this according to the record that is open.

I have tried searching for similar threads but still can't quite get round it.

What data type should I use to store the filepath and how can I get it to change the filename property of the Inventor View control.

Thankyou in advance!

View 5 Replies View Related

Selecting Active Members

Jan 18, 2007

Hello,

I have a single membership table that contains two separate date fields,a "StartDate" when a member joins and an "EndDate" when an individual cancels their membership.

I would like to query this table to provide a list of active members between a given range of dates.

For example if the date is set to 1/1/06 through 1/1/06, I will get a list of all active members on that particular day.

Any help is greatly appreciated. Cheers.

View 2 Replies View Related