Can't Click On Option In Tool Bar

Jun 6, 2014

I was trying to convert macros but can't click on the option in the tool bar. It's inactive and greyed out. How do you activate this to click on it?

View Replies


ADVERTISEMENT

Modules & VBA :: How To Have A Shortcut Option When Right Click On Each Item On List Box

Aug 1, 2013

how I can have a shortcut option when right click on each item on the list box. So I got my answer with below code that opens another form "frmshortcut" with a listbox inside that shows list of options like "new task" , "edit item" . Now my problem is (like attached picture) the shortcut list (frmshortcut) will be open in another place when I right click the mouse, it is far from location of click. Also it shows some default in access when I right click in the listbox ("subform", "cut", "copy"), actually I do not like it shows these, just I like it shows shortcut list I have defined by the list box.

Private Sub ItemList_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single) Const RIGHTBUTTON = 2 If Button = RIGHTBUTTON Then DoCmd.OpenForm "frmshortcut"
' DoCmd.OpenForm "frmshortcut", acNormal, , , , acDialog
Forms!frmshortcut!txtparameter = Me.ItemList.Value
End If
End Sub

View 1 Replies View Related

Create Check Boxes/Option Buttons/Option Group Using VBA

Mar 14, 2008

I’m really stuck on how to create: Check Boxes/Option button/Option Group in VBA.

Could someone help on either all of them or some of them please?

Thanks

Richard

View 2 Replies View Related

Blank Option (radio) Buttons In Option Group

Aug 18, 2006

I am using an Access database for a foreign language dictionary project.

One of the forms I use is populated by a query (qryLemmaTable) to retrieve information from tblLEMMA.

This form works precisely as I intend it to work, but there is a glitch on it that is driving me mad.

The form in question has an option group with 11 radio buttons that correspond to the parts of speech associated with each word in tblLEMMA.

When I click on the button optAdjective I apply a filter and the only records that are displayed are adjectives. (The same applies for Nouns, Verbs, Prepositions etc.)

Here is the glitch: even though the radio buttons apply the filter correctly, no “black spot” appears in the button. Other signals on the screen let me know what word type is selected, so I can accomplish what I want, but I want the “black spots” too!

Perhaps this will be a clue: For each radio button I use the following code in the GotFocus event.
Me.FilterOn = False
Me.Filter = "wordtype = 'A'" ‘(or N, etc)
Me.FilterOn = True

And this for the Lost Focus event
Me.FilterOn = False

Thanks for the help.

View 3 Replies View Related

Select Option Group Option Based On Checkbox Value

Aug 22, 2005

Hi

I've got an Option Group with 3 options; Yes, No and Future.

I also have a range of Check Boxes; 1 for every day of the week.

When one of the check boxes is selected I want the Option Group to change to Yes.

Currently, the Option Group defaults to Future and No will only be available by manually selecting it. This doesn't need to be changed.

Any help will be greatly appreciated!

Cheers

View 2 Replies View Related

Code Triggered From Label On Click Behaves Differently From Command Button On Click

Nov 7, 2006

Often I use Labels as buttons due to the fact I can colour them the way I want, and use the on click event to trigger code.
The code below however works for a command button, but not a label button.

DoCmd.OpenForm "frmdatetime"
Do While Forms!frmdatetime!OKFlag.Caption = "False"
DoEvents
Loop

When this code is run by clicking on a command button, it works fine.
If run by clicking on a label, frmdatetime opens, but the mouse will not work on either of the 2 open forms unless you go down to the windows task bar, jump onto another window, and back onto frmdatetime.
If I remove the loop with the DoEvents in it, then the problem does not occur.

Can anyone enlighten me as to why this behaviour occurs.

Thanks

Richard

View 4 Replies View Related

SQL Conversion Tool

Jan 3, 2006

Does anyone have a Jet to ANSI SQL conversion tool they could either send me or recommend:confused:

View 2 Replies View Related

Count Tool

Apr 18, 2008

I want to know how to count the number of records come up for a query
but it keeps coming up like this:
http://img156.imageshack.us/img156/5150/88274572ke4.jpg
This is how i have it now:
http://img245.imageshack.us/img245/5117/98426599lq9.jpg

View 8 Replies View Related

Tool Tip Or Message Box?

Apr 20, 2005

I have a form with a check box control on it and a pick list text box.

What I looking for is when the user checks the check box, I want to display a message or tool tip to inform the user to ensure that the correct membeship type has been selected from the pick list, (this has a default setting) so can accept the default in this field.

I am trying to aviod the user having to press a button on a message box to continue. it would be useful if it could be display for a preiod of time.

regards

View 2 Replies View Related

Search Tool Help

May 14, 2006

Hi all,

I found this search tool example on this forum which works for my situation. Can someone tell me what changes I need to make so it works with my date field. When I search for data based on Last Name, First Name, or Account # the records appear fine, but when I click on one of the records I get this error message. " Could not locate [8/1/2005]". I would actually like to be able to search by the date field also. Can someone help me modify the database to accomplish this task. Thanks in advance.

View 2 Replies View Related

Check Box Tool For Forms

Apr 20, 2006

please see attachment.
I created a small database to help explain my issue.

When I click on the check box in box 1(train), the text box turns blue...great...and even better the other records stay clear when I scroll down, which is what I want to happen.
But when I scroll back up, from dog to train, the blue in the train box has gone- not what I want!
I would like the blue to stay in every box that I click on. Any ideas?

Thanks,

J

View 3 Replies View Related

How To Make Your Own Custom Tool Bar

Aug 30, 2005

If I wanted to build a database in Access can I make my own file bar. Let's say that I wanted to build a gun inventory but wanted the tool bar at the top to have the specific files I want people to click on. How is this done? Is it done with another program used as a developer with Access database? Hope this makes sense.

View 6 Replies View Related

Tool Menu Deactivate

Sep 27, 2005

I can't use the menu TOOLS because it is deactivate for all mdb.

Is it deactivated from portion of VBA code?

How Can I restore this menu?

By Francy

View 3 Replies View Related

Access Main Tool Bar Help

Aug 2, 2006

I have a database which I can not get to the normal tool bar to change the permissions on.

The startup was set to not display this. I need to modify the security on a form.

Help please.


Thanks

View 2 Replies View Related

Access Lookup Tool

Oct 31, 2006

Hey there,

I am wondering if there is somekind of tool that can be used in access that can run and locate any queries that are redundant and not used within a system. Also if there is any kind of tool that can be run that identifies fields that are in tables that are also not used in the application!

Not sure if such software exists but thought id ask before i manually begin to go through the application, this is all done to be done before normalisation of the application data and upgrade of the system

Thanks in advance

Jas

View 2 Replies View Related

Linked Tables - Looking For Tool

Feb 21, 2008

We have a nasty number of access databases spread around our network and linked to each other like a giant spiderweb.
I can easily open an database and using linked table manager find out what is attached and from where.
I need some sort of tool that will tell me where a table is linked to.
IE - you have a master database that holds the data. You have several other databases that are linked to the master data and run queries, reports etc. I need to find out where the master data is used.
Any ideas?

View 2 Replies View Related

Cool Search Tool Help

Jan 4, 2007

Hi All,

Would anyone be willing to somewhat guide me through the cool search tool because coding isn't my speciality.

Thank you in advance.

Josh

View 4 Replies View Related

Reporting Tool Selection

Nov 19, 2004

Hi all,

I want to display data from a database I have in MS Access. Any ideas on what sort of tool I can use to display the data locally? Can I get a free VB dev tool anywhere?

Access's reports and data access pages just aren't flexible enough for me. I know ASP and SQL well, but I don't want this database to be stored on our server.

Thanks for any feedback.

View 1 Replies View Related

Exporting Custom Tool Bar

Nov 11, 2007

How do I export a custom tool bar to another DB??

Any ideas are appreciated.

View 1 Replies View Related

Custom Tool/Menu Bar Added

May 25, 2005

Hey..

I'm having a rather strange problem that no one can fix, apparently. My teacher is even baffled :S.

Basically, I created a custom menu bar, took off some of the defaults, but now I am having a problem. I deleted the original custom menu bar and now I am posed with the following error when my database is loaded (I am using an autoexec script that opens the switchboard).

Can anyone shed any light on this? Thanks a lot, again, guys :).

View 2 Replies View Related

Best Tool For Recovering Corrupt Database?

Nov 11, 2007

Hi,

This is my firts time to join here and hello to everyone.

We have a database in our office, "access" and most of the time we encounter errors in unexpected way.

e.g.
Cannot open access same user are attempting to change
this file is corrupt.

something like that.


and i was wondering if there are best recovery tool that i can use
for this scenario and what is it?:confused:

thanks

nazario.

View 2 Replies View Related

Turn Menu/tool Bars On & Off

Jul 15, 2005

What is the best way to turn all the menu bars and tools bars off and back on when a form opens and closes? Can you just loop through the numerated objects?

View 14 Replies View Related

Access As A Research Tool, Not A Database

Apr 4, 2006

I have a research project. I need to capture numerical values from a scroll bar into a table so they can be used to produce excel charts. I can capture the data no problem, my problem is how to present it in a user friendly format - a form.

I have to capture the following data via a form for each research respondent:
Name
Age
Sex
Occupation

Each respondent is then asked to rank five brands against seven different attributes. In format terms, my researcher wants to display one attribute at the top of a page with five brands listed underneath with the slider beside each brand. For example:

"The Worst IT Information" is the attribute at the page top
"Microsoft" is the brand, with a slider beside it so the resondent can select how much they associate/rank this attribute with Microsoft.
"Adobe" is the second brand with slider
"PaintShop Pro" is the third brand with slider
"Corel" is the fourth brand with slider
"Sage" is the fifth brand with slider

The same respondent then clicks to the next page which has a new attribute at the top, but with the same five brands underneath to rank the attribute against.

eg "full of bugs" is the attribute at the page top
brands and sliders are all as above

There are seven pages in all. At the end of the data collection I need to be able to find the average ranking for each brand against each attribute and apply the demographic information, for example

Microsoft had an average ranking of 7 out of 10 against the attribute "Worst IT INformation" against women 30Plus.

I can't figure out how to do this without collecting the information into tables called PageOne, PageTwo, PageThree, PageFour, PageFive, PageSix, Page Seven and using fields like: brand 1 (text), brand 1 (value), brand 2, (text) brand 2, (value). This seems to fly in the face of how you would normally create a table and will require queries to add together all the values gathered using different fields.

Does anyone have any suggestions on where I might be going wrong?

View 4 Replies View Related

How To Create Tool Bar Menue In Access

Jun 17, 2005

Hi guys. I want create a tool bar menue in access 2000 that is linked to indvidule forms in my access but i do not know how i to do it. Just like internet explorer tool bar menue that has file edit view ... and u can click and a drop down list comes and u can select one and ....

I want make such menue in access that each drop down list item from menue is linked to form and once it is selected that a perticuler form loads. I be happy if some one show me how to make such tool bar menue.(i want it the menue loads once i click on the mdb file).Thanks

View 1 Replies View Related

How To Get Undo And Redo To Appear In Custom QAT Tool Bar

Aug 21, 2013

I am trying to create a custom QAT toolbar. Everything works except for the Undo and Redo buttons. They're giving me an error:

The specified control type 'button' is incompatible with the actual control type 'gallery' ID: Undo
The specified control type 'button' is incompatible with the actual control type 'gallery' ID: Redo

Code:
<customUI xmlns=http://schemas.microsoft.com/office/2009/2007/customui onLoad="OnRibbonLoad">
<ribbon startFromScratch="true">
<qat>
<documentControls>
<button idMso ="Copy"/>
<button idMso ="Paste"/>
<button idMso ="PrintDialogAccess"/>

[code]...

"OnRibbonLoad" is a function in a module that just opens and closes a dummy form.If I take the Undo and Redo lines out of this code, it works fine. No errors.

View 2 Replies View Related

FMS Access Visual Agent Backup Tool

May 12, 2005

Have you guys ever used this scheduling tool from FMS Software that will do a nightly archive and compact/repair.

I tried it out on our live database (not so smart I guess) on a Friday and when I came in Monay it was corrupted. It seems to point to the FMS software corrupting my db.

I wanted to validate and use this software but ain't sure it I will now.

I like the nightly compact/repair. Is there another way to do that with Windows Scheduling or something?

Take a look:

http://www.fmsinc.com/Products/Agent/index.html

View 2 Replies View Related







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