Using ActiveX Controls In MsAccess
Feb 1, 2006
I need to use various activeX controls in MsAccess2003. I downloaded a few activeX controls but I am having a problem with licensing. I registered the controls and the registration succeeded but when I try to add this ActiveX control on a form in MSAccess, I get the message that I don't have the license required to use this ActiveX control and that I should obtain the appropriate licence from the company that provides the licenced OLE object or ActiveX control. Any ideas on how to overcome this problem?
View Replies
ADVERTISEMENT
Jan 25, 2005
I use the Active X calendar control 10.0 in a number of forms*. The mscal.ocx file is in c:Program FilesMicrosoft OfficeOffice 10.
(*In the calendar's Properties it says it is "MSCAL.Calendar.7", which I think is just MS's way of confusing people.)
After splitting the deploying my app, it appears lots of my users either don't have version 10.0 or it is stored someplace else; for example, in C:WindowsSystem32. Because they don't have the correct version/path, everything crashes.
So, how can I easily determine whether users have the right ActiveX in the correct location?
The Microsoft web site says "To distribute your component as part of a Visual Basic application, you can use Package and Deployment Wizard". I don't have that wizard in my version of Access (2002 SP3 on Windows XP), so that's not an option.
Microsoft also says to "To enter the base address for your component, open the Project Properties dialog box and select the Compile tab. The address is entered in the DLL Base Address box, as an unsigned decimal or hexadecimal integer. The default value is &H11000000 (285,212,672). If you neglect to change this value, your component will conflict with every other in-process component compiled using the default. Staying well away from this address is recommended." It seems to make sense that I put the mscal.ocx in the database's directory on the server to serve as the "base address", but other than that this option scares the heck out of me.
Does someone have any suggestions how to easily ensure users have the right ActiveX version on their computer - and in the correct location? (I'm not a super-coder.)
As always, thanks
Christine
View 3 Replies
View Related
Feb 8, 2005
Okay, so I have tried to fix this for three days. When I try to create a button, combo or list box I get the message:
ActiveX Controls Can't Create Object. I have been through Internet Options/Security. I have tried reinstalling, I have tried to look into the registry. I even check Microsoft HELP and Mircosoft website and am getting nowhere. Can anyone please, please help solve this problem because it completely baffles me on how to fix this!!!
Oh yeah, (and now I am angry!!!)
View 14 Replies
View Related
Jan 3, 2007
After searching the forums, I've found some information, but not what I need or what works.
I've got everything playing fine, from where people can play a file they choose from a list, but I need to add some advanced controls for Fast Fowarding and such.
Searching google, I've managed to find plenty of VB controls, but none seem to work in VBA. I've set the Media Player references, but when trying:
me.MediaPlayer0.Controls the only option it gives me are Items and Count, not Play, Stop or Pause (or anything similar).
Anyone know how to do the advanced controls?
View 5 Replies
View Related
Jan 10, 2014
Using Activex controls for capturing video from a webcam or similar. Just looking for a snapshot that I could then forward via email from access.
Ive seen commercial licenses for an activex control. The form Im imagining would have a window showing the live video with a snapshot button where we could store the image as a jpg for example and then generate an email forwarding on the image. It seems possible!
View 1 Replies
View Related
Sep 30, 2013
I wrote a custom ActiveX Control in C#.NET using a guide (Google ".net activex control step by step", first link on CodeProject). The control is compiled as a .dll and registered in Access 2007.
When I place the ActiveX control on a Form or Report, I can call its methods from VBA and see its output just fine.
When I open a Print Preview, only the top left corner of the control is shown, the rest is a blank white box. This does not happen with built-in ActiveX Controls (e.g. Calendar control), which print as they should.
I also tried a basic ActiveX Control build using VC++ (the sample control created by the MFC wizard), and that displays and prints correctly.
View 1 Replies
View Related
May 12, 2005
Why it is not work???
I have got one list control and i want to populate it with values of one query
:
ListItem1.RowSource = "Select " & fld & _
" from " & tbl & ", Stock where ( " & tbl & "." & fld & " NOT IN (Select SerialItem from Stock ) ) AND (BIN=0) AND StockItem = '" & tbl & "' group by " & tbl & "." & fld & ";"
i try it with simple query and it is not working:
ListItem1.RowSource = " Select id from stock ; "
I try this in ms access 2k2 it work.
Or it is problem of VusialBasic ???
I need solution from MSAccess 2k.
help me plz
View 6 Replies
View Related
Sep 15, 2005
With ColdFusion and MSAccess 2003, the following query :
SELECT A.*, B.entry_id
FROM A.blog_entries, B.blog_subscriptions
WHERE B.blog_id = #variables.blog_id#
AND B.user_id = '#variables.userInfo.user_id#'
AND A.user_id = B.user_id
returns this error :
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Could not find file 'C:WINDOWSsystem32B.mdb'.
Please advise. ThankYou
View 4 Replies
View Related
Mar 3, 2007
Hey guys!
I got a Ibase/firebird database and I need to convert it to MS-ACCESS format.
I searched on google, on this forum but I couldn't find a solution.
I appeciate any help!
Thank you!
View 3 Replies
View Related
Apr 12, 2007
Is there any way to compare two tables and write out the records that don't match to a third table?
thank you.
View 1 Replies
View Related
Apr 28, 2005
Is there a way to change the caption "Record" to "My Record" on navigation
bar in a MSAccess Form?
:rolleyes:
Thanks in advance.
View 4 Replies
View Related
Jan 12, 2005
Hello,
1/ I occasionally run into this error: "The instruction at "0x77fc823" referenced memory at "0xfffffff8". The memory could not be "read".
Click on OK to terminate program."
Do you know if this error message occurr ONLY on certain computers using Access 2000? Since this error popped up on one of my co-worker but NOT on mine. I even tried to re-install Access 2000 again, but the error message still pop up when tried to open a report. Also, the last three digits of instruction number "0x77fcZZZ" change everytime. Please help!!
2/ For some reason, I was coding VBA on one of the procedure on Form_Load, then certainly Access 2k does NOT let me go in the code of any control. WHY!! I am frustrated!! I tried to go in different way, but does not work
Thank you so much.
View 1 Replies
View Related
Mar 25, 2005
hi,
I am a newbie in ms access. I am ask to do some coding to help me with massive duplicate datas in my database in access.
But i do not know where to start from?
Im very confuse.
As i do not know if ms access itsself can be program using codes?
or am i suppose to use SQL? or VB? or VBA?
I really need help urgently...
thanks alot
View 3 Replies
View Related
Nov 6, 2006
I'd like to know when a user has modified their records on my site. Is it possible to include code to stamp the datelastmodified per record? And if so, how?
I'm using MS Access and ASP vbscript
Thanks
Sandra
View 3 Replies
View Related
Jan 26, 2007
the compact and repair on Access enable us to compact or database bec when we delete records the space consumed is not removed. in ASP my Access is increasing rapidly almost 10MB and sometimes downloading this file takes a lot of time for a slow internet. is there a script i can use to automatically compact the database?
View 4 Replies
View Related
Oct 16, 2007
Hi,
my table have a a text field F1 (data ex:25%) and number field F2 . I have a query which contains a new number field based on the above fields i.e F3=F1*F2.My query is not able to retrieve the data.My data is been filled with error#.How i can convert the data types in order to get the multiplication of those two fields.
Thanks in adavance
sam
View 2 Replies
View Related
Mar 11, 2006
I'm trying to import a tab delimited text file into MSAccess and its driving me nuts!! How hard can this simple thing be? I have a text file thats rather large (300Meg in fact) and it has a field that is a date/time but msaccess refuses to import it as such. If I import as text and then change the field to date/time it will work but I can't do this on my file because access reports that its run out of memory in converting the field type (2.5M rows).
I've tried setting up the table prior to importing the data and setting the field type but it make no difference. Any help here appreciated because this should be simple!!!
The format of the data that I'm trying to import is.
28/08/2005 10:31:11 PM
You can even make this a single row and try importing it and access drops it so obviously I'm very dumb!!
Thanks:confused:
View 1 Replies
View Related
May 12, 2005
I am using msAccess to develop a small application.
I have 2 tables, student and course, and
I need to create a form with 3 fields -
by_id, by_date, by_course_id
This form can generate a view only table according to the field the user entered.
Can anyone help me on this?
What's the step to do so?
Thnx
View 3 Replies
View Related
Apr 9, 2008
Dear Expertise..
How I can store scanned object in Access. Becuase I have a employee database. I have to store all employees signature in the database Also I have to verify thier signature with the previously stored in database when they are trying to log .
With Thanks
Polachan
View 2 Replies
View Related
Jul 20, 2006
Hello All,
I am new here and new to Access.
I have created a query which allows me to schedule daily events. But I want to automate this. Let me explain what i am trying to do.
Every morning at 7 am I want this query to run and the output of which to be mailed to myself. All this without me having to hit any button of sorts.
I have a long shot but very inefficient answer to this - which would be - having to leave my MS ACCESS running all night with an infinite loop checking to see what the system time is. When the infinite loop equates to 7 am it runs the query. But I think this would be a massive memory guzzler and I don't like this solution. Is there something else I can do?
Thanks for you time.
Regards
View 1 Replies
View Related
May 28, 2006
Is there a way perform CTRL+' with vba code in MsAccess 2000
Carbo
CTRL+' copies data from a field in the previous record to that field in the current record.
Resolution:
http://support.microsoft.com/?id=210236
If you receive a compile error related to DAO Recordset go to:
http://www.mvps.org/access/bugs/bugs0031.htm
View 8 Replies
View Related
Feb 25, 2007
To
Repected Viewers'
I'm developing small window application using msaccess database and forms.
I want to create a form where a user can upload or attached or save as images to another folder or direct to msaccess database...
"Just like a uploading profile photo"
so please let me know
regards
mdateeq2003
View 2 Replies
View Related
Dec 16, 2007
Hi there,
This may mean stupid question to you but I find that some of the events or types in the properties which give me 'no meaning' at all.
For example, has module on form, on retreat on report. THIS IS ONLY A sample, my list would be endless.
Thanks in advance
View 3 Replies
View Related
May 11, 2005
I have a subform with loads of command buttoms on it but if I try and select any of them I get the message "The OnClick you entered as the property setting produced the following error: A problem occured while BCF data collection tool was communicating with the OLE server or ActiveX control". I don't understand what this means and just wondered if anyone could point me in the right direction for resolving the issue.
View 2 Replies
View Related
Nov 24, 2005
I just added a ActiveX control to my program and I have a scroll mouse, and there when the user used the mouse to scroll through the records, the record changes but the ActiveX Control doesn't. My activeX Control is used for a digital signature. Anyone Have any ideas?
View 2 Replies
View Related
Sep 1, 2006
I use the Calendar ActiveX to select a date.
The calendar have a dropdownlistto post the selectede date?
I the calendar to dissapear after the date is selected. The selected date should remain in the drop down list.
I think that the control have a dropdownlist to show the selection, but i didn't found it.
Thanks,
Richard
View 1 Replies
View Related