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 Replies
ADVERTISEMENT
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
Nov 11, 2007
How do I export a custom tool bar to another DB??
Any ideas are appreciated.
View 1 Replies
View Related
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
Jun 23, 2014
I know that ever since 2007 custom menus are not well supported as in 2003. From what I've read, outside to using 2003 to make changes, a person can create/update the menus using Commandbars in VBA.
Some coding to use Commandbars to create/update menus/toolbars for Access 2007/2010? It seems possible to do that, although I would expect it would be a lot of work. I've seen a few one-off examples to do specific updates, but so far nothing that would approach what was available in 2003.
View 3 Replies
View Related
Jan 11, 2012
I am new to access. I have an application which has a custom tool bar. I tried to find the corresponding code for the custom tool bar by using the name of the tool bar. But was unsuccessful.
I want ot find the corresponding code for it. Where can I find the custom tool bar code in the VBA code of the applcaition?Actually, I want to add macros, queries and forms as a dirsct short cut in the existing custom tool bar.How to add macros and queries to the existing tool bar??
View 2 Replies
View Related
May 4, 2006
I have a Memo box where the user puts comments and then I have a check box that if check automatically puts a specific phrase on the first line of the Memo box (before any other text currently in the box). What I am trying to do is have it so that if the "check box" is UN-checked it will remove the line that it just added to the Memo box. I have been able to get it to undo everything in the Memo box, but what I really need is for it to just undo the last line of text that was enterd when the user checked the box.
Example:
Memo Box:
This is the line that the checkbox just added when the checkbox is set to "True"
This is the test data the user has already put in the box...
==================
User now UN-checks the checkbox (I want the Memo box to read.. see below) Thereby deleting the line "This is the line that the checkbox just added when the checkbox is set to "True""
Memo Box:
This is the test data the user has already put in the box...
How can I accomplish this?
View 1 Replies
View Related
Nov 14, 2006
Hi, I have found the answer to most of my problem, thanks to previous posts.
I am using the Undo command on a Date field. However it seems that my code is maybe not staying on the event to action the undo.
After it runs the Focus goes to the next field Me.LeaveDays and the value is automatically entered, unless I comment back in the Goto's in which case the value will be zero.
I want to be able to Undo the EndDate (and preferable the StartDate, and Setfocus to StartDate) EndDate will do if not possible.
Don't want to Undo the whole form, although that could be a last resort.
My code is in the before_update event, image posted (ignore faded fields, not visible/needed in final solution)
Private Sub EndDate_BeforeUpdate(Cancel As Integer)
On Error GoTo Err_EndDate_BeforeUpdate
Dim intLeaveLeftAL As Integer
Dim intLeaveLeftSL As Integer
Dim intLeaveDays As Integer
Dim dtNullDate As Date
Dim varNullField As Variant
intLeaveLeftAL = Nz(Forms!frmAddLeaveRecords.fsubLeaveAgTots.Form![DailyALInc] - (Forms!frmAddLeaveRecords.fsubLeaveAgTots.Form![ALDays] - Forms!frmAddLeaveRecords.fsubLeaveAgTots.Form![ACDays]), 0)
intLeaveLeftSL = Nz(10 - Forms!frmAddLeaveRecords.fsubLeaveAgTots.Form![SLDays], 0)
' Use the WorkingDays function to calc the number of Leave Days
' set LeaveDays and requery the form
intLeaveDays = WorkingDays(Me.StartDate, Me.EndDate)
If Me.LCode = "LC41" Then ' Sick Leave
Select Case intLeaveDays
Case Is > intLeaveLeftSL
MsgBox "Employee does not have enough Leave" & vbCrLf & "to take as Sick Leave.", vbCritical + vbOKOnly + vbDefaultButton1, "Entry in Error"
varErrorCondition = True
Me.EndDate.Undo
GoTo Exit_EndDate_BeforeUpdate
Case Else:
End Select
ElseIf Me.LCode = "LC11" Or Me.LCode = "LC13c" Then ' Annual or C/Fwd Leave
Select Case intLeaveDays
Case Is > intLeaveLeftAL
MsgBox "Employee does not have enough Leave" & vbCrLf & "to take as Annual Leave.", vbCritical + vbOKOnly + vbDefaultButton1, "Entry in Error"
varErrorCondition = True
Me.EndDate.Undo
GoTo Exit_EndDate_BeforeUpdate
Case Else:
End Select
End If
Me.LeaveDays = intLeaveDays
Me.LeaveDays.Requery
varErrorCondition = False
Exit_EndDate_BeforeUpdate:
Exit Sub
Err_EndDate_BeforeUpdate:
MsgBox Err.Number & " - " & Err.Description
Resume Exit_EndDate_BeforeUpdate
End Sub
The ifs and cases work fine, just like to send the User back a few steps
appreciated :) :)
View 9 Replies
View Related
Feb 10, 2005
Is there a way to code something that will say do Undo All changes.
I have a button called Exit without changes…and I would like to be able to undo everything that a user has just done on the form.
Thanks.
View 1 Replies
View Related
Aug 15, 2005
Hi All,
Is there a way that I can make a button which will undo all the changes being made on a form (on multiple records). I have a continious form with a checkbox after each record and want to restore the 'old values' if necessary.
Thanks.
I know it's possible by record, but the tricky part is to do this on multiple records.
View 2 Replies
View Related
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
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
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
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
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
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
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
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
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
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
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
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 8 Replies
View Related
Feb 17, 2006
We have an mdb back end on our server with read / write permissions for several approved users. One of them (don't know who yet) has converted the mdb file from 1997 to 2000. Is there a way to undo this? :o (a few have both versions on their machines which is why this was possible to begin to with)
We have had this set up for almost four years now, with no issues might I add but always knew in the back of my mind something like this would happen.
Thanks
View 1 Replies
View Related
Jun 22, 2005
I have a form with a subform, on the mainform there is an undo button but when someone makes changes on the subform the undo button wont run and the error message "The command or action Undo isn't available now". How can i get the mainform to detect that changes have been made on the subform and then if the button is clicked undo the changes.
View 4 Replies
View Related
Mar 21, 2006
I would like to be able to check to see if undo is available.
ie. i have a button thats called 'Cancel' When clicked it undo's changed and then closes the form, but if there are aren't any changes to undo it flags up an error saying not available.
I would still like it to close the form even if there are no changes to undo.
So check to see if the undo is available then undo and close if not then just close the form.
View 4 Replies
View Related
Jun 1, 2006
Hello All,
I am finding this one difficult so felt I should post my issue.
I have status field on my form. It is a bound field.
A combobox - inactive, active.
I wanted the field to do the following when changed
If change then msgbox = Please enter reason in activity notes
a vbYesCancel
If they select it calls the activity notes form - this portion works.
If they select cancel I tried making the field do
form.field.undo (Me.statusid.undo) - something similar
Cancel = True
to reset the field to the original state.
This fails and says my object is not valid
I would be happy to take any suggestions . As always thanks in advance.
View 1 Replies
View Related