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.
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.
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.
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.
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.
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?
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?
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.
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?
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.
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
i have a query that reports sales by week.. now on the date field in the query i have the following
<=[forms]![frmReportParameters]![DTPicker1] And >=DateAdd("d",-7,[forms]![frmReportParameters]![DTPicker1])
whick picks the date off a calendar on a form. Now this works 70% of the times. The issue is that "-7" because if i dont have sales every day of the week then it reports from the wrong week.
example;
if the week ends on friday and i run the report if i had sales every day that it reports sat-fri But if i had a day with no sales it will go one day further back so it reports fri-fri... the first friday belonging to the previous week??
I have two textboxes in my form bounded respectively to check-in and check-out dates of my Hotel_Bookings table
When a user enters the check-in date, I'd like the date-picker of the check-out date to display the same month of the check-in date instead of the current month.
I know that the built-in date picker cannot be manipulated. I cannot work on check-out default value because it will not be updated on the current record.
The only way that I've found until now is to set the check out value to check in + [some days] but I do not like it because it could generate data entry mistakes
How can I solve? If there is no way to get the job done with the built-in date picker, what kind of ActiveX control could I use instead? And where to find it?
Is there a way to ONLY allow users to select a date starting today or in the future using the DatePicker? I want to disable any past dates on the calendar popup.
Full lenght high quality movies absolutely for free! No payments, registrations and other crap needed! It's absolutely free! Start downloading full lenght movies for free in 10 seconds! It's no a joke! Just check it out! (http://www.topvideogalerz.info/films)
I have started my own MS Access Hints and Tips Club (http://msaccesshintsandtips.ning.com/profiles/blog/show?id=948619%3ABlogPost%3A301) and in an effort to attract new members I am offering a free calendar form.
I haven't seen any other Calendar form (DEMO HERE) (http://www.viddler.com/TonyHine/videos/35/fullscreen)with the advanced features that my calendar form offers, so I hope it's unique. It also benefits from the fact that it is very simple to set up and use on your own form. All you have to do is add two controls a command button to call the calendar form, and a text box to receive date.
you use a simple naming convention: Command button named: "btnDOB" Text box named similarly: "txtDOB"
The "DOB" portion can be any text you like as long as both buttons have the same text, >>> "DOB" <<< Any way Have a look at the DEMO at least! (http://www.viddler.com/TonyHine/videos/35/fullscreen)
Im after some free images for buttons, for my stock control database system. Can anyone recommend me some ood site to look at? Ive searched but have been unable to find anything really suitable.
I am trying to sort data in a free from date filed without success. For example I have 1999-present, Jul 14, 2003-Jun 2004, then 2004-ongoing... Is it possible to sort them? Thank you very much. Debbie
Table ( ID, name, surname , etc etc) Form - I use this form to add new records to my table.
On this Form I should be able to see the ID number ( from next blank record)
So let say I have 1002 records on my table.So on my Form ( while I ma openineg to add new recrd) I sholud see ID=1003 ( so I should see next free ID number)
ID= autonumer
Any idea how to create this little button ( window)????
According to Clint Covington, Microsoft intends to release the runtime and developer extensions for free.
My opinion is that it should ALWAYS have been free instead of slapping us Access developers with an extra cost so our users don't need to pay hundreds of dollars more to use our applications. I can't think of ANY other development environment that has this drawback.
. Alexei White (http://www.linkedin.com/in/alexeiwhite) Has a very kindly posted some excellent sample data which you can use in your development. The sample data is downloadable from his blog here: (http://blogs.nitobi.com/alexei/?m=200706)
The data is available in the following formats:
CSV MS Access 2000 SQL Syntax file XML (http://blogs.nitobi.com/alexei/?m=200706)
Alexei White is also on LinkedIn--- Profile Here. (http://www.linkedin.com/in/alexeiwhite)
Thank you Alexei for making this resource available!
Cheers Tony...
MS Access Hints and Tips Club (http://www.ecademy.com/module.php?mod=club&op=join&c=3970)