Simple Outlook Type Of Switchboard Without ActiveX

Sep 6, 2005

Hi all:

Attached is a simple Outlook Type of Switchboard that I was playing around with. This switchboard does not use ActiveX like others that I have seen out there.

If you improve on this simple switchboard could please post it back for others in in the forum. I would like to know what people think about this simple swtichboard.

The attached zip file is MSAccess 2002 version.

Thanks

matomo

View Replies


ADVERTISEMENT

Simple: How To Use This Code With Switchboard Button

Feb 3, 2005

I found this simple password code that I use to open some forms:
Code:Dim x As Stringx = "password"Dim y As Stringy = InputBox("Enter password for form")If x <> y ThenMsgBox ("Invalid password")DoCmd.CancelEventEnd If
I would like to use it in a switchboard button, but the following statement is
OnClick already "=HandleButtonClick(4)". How can I incorporate this statement
with the code?

(I guess I don't really understanding how the auto-switchboard works.)

As always...Thank You

View 4 Replies View Related

Linking From Switchboard To Switchboard On Two Or More Databases

Nov 21, 2006

I am working on a database that will be an addition to an existing one on the company server. However, to make the overall layout not so complex and allow room for other additions in the future, I'd like to keep the databases separate. This will also ensure more efficiency, integrity and troubleshooting overall.

I have the original database with the name of "Cell MFG Screen" that contains a switchboard. I am now creating a db to keep track of manufacturing waste (which will also be on the same server when completed). That switchboard is called "Cell Waste Weight". Again, I want to keep these db's separated from one another as well being able to add future dbs. Now, what my plan is to make up a one db that consists of only a switchboard that will be used as the main switchboard to be able to navigate to other dbs that are located on the server.

Does anyone know how this is done?

Thank you in advance for your help,

~Kilch

View 10 Replies View Related

Connecting Super Type & Sub Type Entities With A Condition

Sep 21, 2004

hi friends,
i have tried had to connect sub type tabels (Saving, Checking, Loan... they have their own ids...) with super type (Account...it has account id...) on the condition of account_type (either "S","C" or "L") attribute in ACCOUNT entity.
how to joint them??? with query or with expression??
i expect help from you.........please.
........thanks.

View 5 Replies View Related

ActiveX

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

Refreshing ActiveX

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

ActiveX Calendar

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

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

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 3 Replies View Related

Using ActiveX Calenders Across Different Versions

Mar 20, 2006

Hello, I wrote an access program using version 2000 and the activex calendar 11.0 which came with the software. When i tried to run the same program on access 2003 none of my dates worked and I got error messages all over the place. Help!

View 4 Replies View Related

Location Of ActiveX Controls?

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

ActiveX Color Selector ?

Nov 30, 2004

For selecting a Date /time value, I use activex control DTPicker5... What Activex object, or infact any object, can I use to select a color value ?

your answers will be appreciated

Jabez

View 2 Replies View Related

ActiveX Microsoft Calendar

Aug 9, 2007

I have a database in access xp pro with a form that i have a calendar in, the problem is when i open the form i get a error mess (can't set value to NULL when checkbox proberty = false.

HELP Rocky

PS it may help to know that i am not a programer.

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

ActiveX Component Problem In Form

Apr 19, 2006

I had a search client form. This form used to work fine, so i haven't tocuhed it for a while. Basically what happens is you double click on the client and it clones it to the form.

However just a second ago i tested the form again and an error appears "ActiveX component cant create object". I've made no modifications to anything involving this form so im bit stuck for ideas.

I also received an error message telling me to check - Visual Basic --> Tool --> Reference. That says "Missing: Microsoft DAO 3.6 Object Library". I have browsed for the file but had no luck in finding a file to replace it.

View 3 Replies View Related

Activex Component Can't Create Object

Mar 13, 2006

I get this error everytime i try to use any wizard in access, i have uninstalled and reinstalled acces, i looked at the MSDN and i cannot find anything that will fix my problem. I have windows XP and office 2002 if that could help with the solution.

Regards, Neil

View 2 Replies View Related

Activex Component Can't Create Object

Mar 5, 2007

Activex component can't create object


i got this error message when i tried to create a command button...
i have to do it without the wizard... then when i tried to get one of those convenient access pics applied to the button i get an error pop up
Object variable or With block variable not set

...the errors only just started today... well i played hooky on friday cause of a snow storm so i guess it might be a recent microsoft insecurity update...

running XP pro 2002 SP2 with Access 2003 SP2

:( ...maybe this is the latest microsoft challenge...
:mad: ...uninstalling and reinstalling access or all of ms office does not remedy the situation... i searched the forums and cant find a solution :eek: ...

...so
...any ideas :confused:

View 4 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 Trouble While Opeing Form

Aug 28, 2005

Hi Gents,

I copied my mdb from one pc to another. Both pc has Access 2003 ver.

But when I try to open one of the form it gives error. The error has been attached in a Jpeg file. But when the same form runs from previous pc, it runs smoothly.

Kindly let me know why this occures and what is the solution to get rid of this.

Any help would be appreciated.

With kind regards,

Ashfaque




.

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

ActiveX Controls Can't Create Object Help!!!!!!

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

Select Multiple Dates - ActiveX Calendar

Mar 30, 2006

I am trying to build a form that accepts either a single date for start and stop dates whilst allowing a range of dates to be selected for operations that cover several days.
I am using the Access 2003 calendar which is fine for selecting a single date but how do I select several dates (4-7 Mar for example) ?

Thanks in advance
Oscar

View 2 Replies View Related

Error:429;ActiveX Component Can't Create Object

Sep 28, 2006

I'm not sure if this is a Query problem or a Report problem, so I'm putting it in the General catagory. If I need to post it in one of the others, please point me the right direction.


I have set up the following:

Query A - Combines data from several tables
Query B - Prompts for a text string and places it in a table
Query C - Uses the text entered in Query B to select records from Query A. The field that is searched is a text field.
Report A – Has an Open procedure that executes a macro that runs Query A. I also have a Close procedure that executes a macro that runs a second report based on Query A against a different table.

When I run the report on my desktop it works properly. I had a user try to run the report and she gets the following error immediately, prior to being prompted for the text.

Error:429;ActiveX component can't create object


I am running Office XP and she is running 2003 with SP2. She has not had problems with other Access reports in the same DB. Any ideas what is missing?

Thanks,
Christy

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







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