Creating A Custom "What's This?" Button In Forms

Aug 19, 2004

Is there a way to use a command button to perform the exact same function as the "What's This" (?) button on the title bar? Is there code I can give it "On Click" that will make it do the same as as the What's This button?

View Replies


ADVERTISEMENT

Forms :: Impossible To Add Custom Icon To Button

May 23, 2015

I got an image bitmap that I want to use to customize my button. I got following error pop up."Image Generator" - "search key not found in any record".I'm using access 2013

View 1 Replies View Related

Forms :: Unable To Navigate Between Records - Custom Save Button Not Saving

Jul 22, 2013

I've been working on a database for work for the last few weeks and this forum has been a Godsend many times over, but now I have a problem that I can't find any reference to.

Using Access 2003, I have a form that uses 3 cascading combo boxes in the header to find a unique record, and a command button that brings up the rest of the record into unbound fields in the body of the form.

It works fine for finding records, but whenever I enter/change data on it, the record doesn't save. The navigation buttons at the bottom don't work - the Next/Previous record buttons are disabled, and the First/Last Record buttons do nothing.

Navigation buttons are enabled/activated in the properties.

I tried getting around this by creating a Save Record command button - first using the wizard, then using VBA code DoCmd.RunCommand acSaveRecord as advised by [missinglinq;696351], but this still doesn't save the changes.

View 4 Replies View Related

Forms :: Creating A Clear / Refresh Button

Dec 29, 2014

Using Access 2013.I have a Search Form with a Run Query button. I would like to add a button that clears the criteria entered into the search text boxes. Right now to change the criteria I have to manually delete everything entered, closed the current query it had open then go from there. I have tried using the command button wizard, form operations, then refresh form data. When I click that button a window pops up "The command or action 'refresh' isnt available right now".Is this not the correct way to set up what I need? What other options should I look into for setting this up?

View 1 Replies View Related

Forms :: Creating New Record In Subform - Button To Add New Object To Main Job

Jul 1, 2013

What i'm trying to do is add a new record to a subform. The problem is, I couldn't use a subform based on a table in order to achieve this. I needed extended information for it to be useful, so I made the visible part of the subform based on a query instead.I'd like to add a button that adds a new object to the main job. I'd like the adding of that button to call a new form allows you to fill in the information for that object (this called form actually contains 5 subforms to populate all the data of the object). That form works.

What I need is for the button to call the 2nd detailed form AND create the necessary entries in the project/object junction table.The idea as it is now is a button on the main form, but if it was possible to do so via continuous form in a subform, that's doable.

View 11 Replies View Related

Creating Custom PivotChart

Jun 28, 2005

I am trying to make a special kind of blob chart. It has to mimic the charts I have attached. I have a high number and a low number for everything that someone might want to put on the axes. The eventual goal is to have a form were the user selects what goes on each axis, and have a few other possible choices to limit how much is displayed. What I am making doesn't have to be as fancy, flexablity is more important. Can Access make this kind of graph or am I on my own, making shapes in VBA?

http://www-materials.eng.cam.ac.uk/mpsite/interactive_charts/energy-cost/generics.jpg
http://www-materials.eng.cam.ac.uk/mpsite/interactive_charts/energy-cost/metals.jpg

View 3 Replies View Related

Creating Custom Letters????

Dec 23, 2004

Hello,

I would like to create a custom letter where I can type the body of the letter and it will print the letter for every customer in the database.

Thanks

View 1 Replies View Related

Forms :: Creating Command Button On Form Containing Drop Down List Of Commands?

Nov 30, 2013

I wish to create a forms that has command button which display a drop down list. The drop down list should contain commands for reports and forms.

Lets assume we have forms named FrmStock, FrmSales and we also have Reports named RptUserLog , RptTurnover.

View 3 Replies View Related

Pages - Creating A Custom Theme

Apr 18, 2007

Hi.

Can anybody help?

I would like to create a custom theme for my INPUT page, however within Access 2003 I only have the option of about 20 predefined themes. I want to insert my companies' logo onto the INPUT PAGE.

What I would like is to save a template, like I have done in REPORTS, so that when I build a INPUT PAGE I can select my own theme to use, based upon my companies' logo, type face et al .,

Thanks and kind regards.

Phil Drury.

View 1 Replies View Related

Creating A Custom Formatted Id Number

Jul 19, 2007

I'm trying to create an auto generating ID number field that contains a date followed by a sequential number for that date. In example...

YearMonthDay###

070719001
070719002
070719003
tomorrows numbering would be
070720001
070720002 and so on.

Each new day would start a new sequence of 001, 002, 003, etc.
I have searched these forums and haven't really found any answers. Could someone direct me in the correct direction. Also I need this number to be saved in the table and not just displayed or printed.

View 9 Replies View Related

Creating Custom Date Format After Import

Aug 28, 2004

I am stumped: After importing from an outside source (an excel spreadsheet) I have to change the short-date format
that I have just imported into a very specific custom format: "yyyymmdd" Ex: 20040828. How do I convert into this
new format? Help will be greatly appreciated...

View 1 Replies View Related

Modules & VBA :: Creating A Custom Shortcut Menu

Jun 5, 2014

I'm working to put together a shortcut menu for a form that will be viewed as a datasheet. I'm trying to put together the vba to create the menu. I'd like a lot of the standard options i.e. sort a-z, filter toggle etc. I'd also like to add the menu option that is displayed in the default menu called "Text Filters". I've been unable to find the id code for that option, and since it, when chosen opens another menu, I'm not real sure how to code it. Here is what I have so far:

Sub CreateWIPShortcutMenu()
Dim cmbRightClick As Office.CommandBar
Dim cmbControl As Office.CommandBarControl
' Create the shortcut menu.
Set cmbRightClick = CommandBars.Add("cmdWIP", msoBarPopup, False, True)

[code]....

View 2 Replies View Related

General :: Creating Custom Menu Bar For Form?

Jul 2, 2012

i would like to create custom menu bars for my forms report

View 6 Replies View Related

Modules & VBA :: Creating And Initializing Custom Class / Object

Jun 13, 2013

I've been playing around with creating my own class in VBA but I'm having problems calling its methods. My class is pretty basic, its called cDentist and the properties are just Name, Address, DOB etc and one method AddDentist. AddDentist will add the details to a sql server table.

So I create an instance of the class in a module called Dentist. At the very top of the code i put..

Code:
Option Compare Database
Global Dentist As cDentist

I have a method then in module Dentist, where I initialise the instance of class cDentist and i populate it's properities...

Code:
Sub RecordDentistDetails()
Set Dentist = New cDentist
Dentist.Name = Forms!frm_enterdetails!txtName

[Code].....

When I click 'Save' I get error, Method or data member not found. And '.AddDentist' is highlighted. I'm a little confused why it's not seeing AddDentist as a method of class cDentist.

View 14 Replies View Related

Custom Button

Jan 16, 2006

I'm just creating my first db. When I'm on a form looking at a previous record (in this case a transaction), I need to be able to make a minor change to that record (such as the date for a repeat transaction), and then save the record as a whole new record. The button commands I found in the wizards only let me save over the current recond after an edit. Anyone know the easiest way to creaet a command button that does this? Thanks for any insights.

View 3 Replies View Related

Modules & VBA :: Creating Custom CommandBarControl Objects For A Shortcut Menu?

Aug 16, 2013

I finally got tired of having 100 macros managing my different custom shortcut menus, and decided to figure out how to generate the shortcut menus programatically (because lets be honest, Macros are the devil.)

I found a good tutorial here : [URL] .....

and was able to create some basic shortcut menus like the following:

Code:
Sub CreateCopyShortcutMenu()
Dim cmbshortcutmenu As Office.CommandBar
Set cmbshortcutmenu = CommandBars.Add("CopyShortcutMenu", _
msoBarPopup, False, False)
'ID 19 adds copy command
cmbshortcutmenu.Controls.Add Type:=msoControlButton, Id:=19
End Sub

Nice and simple, now I have a copy command. But the problem is that I also need some custom commands. Most (possibly all?) of these would be function calls.

View 3 Replies View Related

Add A Button To A Custom Menu

May 7, 2007

I can't believe I haven't come across this problem before, but I want to add a button to a custom menu I've created. When clicked, this button will run some code I've written.

It may be that I'm losing it (no comments, please :D ) but I can't work out how to add a button that will run code of my choosing, as opposed to just opening a report, opening a form, etc.

Any suggestions?

View 7 Replies View Related

Help With Custom Command Button

Aug 16, 2005

I want to create a custom command button that when clicked hides elements (such as a box, a label, etc) on a specific form (the switchboard) and shows another element (a sub form)
I guessing I would create a module check if the active form is the form called switchboard then using the .Visible properties of each element I want to hide set it to false, and the opposite for the sub form.

Questions I have
1- how do I check if the active form is the form called switchboard - and if not how can I switch focus to the form called switchboard
2- working with modules can i simply call each element like the following Me.CategorySubcategory.Visible = False?
3- now how do i have the code in the module execute when the person clicks the custom command button (i guess it has to do with the on action event in the property for the custom command button but not sure what)


thanks for any help you might be able to offer

View 2 Replies View Related

General :: Put A Custom Button On QAT

Mar 19, 2015

I would like to create a command button that saves a report as a PDF. Currently I am using the built in "PDF or XPS" button but it always opens Adobe reader at the end and also a dialog with the option to save export steps. I want nothing other than a simple save dialog like I can do with a VBA command, but is it even possible to add a custom command to the quick access toolbar?

I know you can add custom commands to the ribbon but the user of this database keeps the ribbon minimized due to it eating up too much of his screen space. The QAT is always visible.

View 3 Replies View Related

Custom Button Image Transparency Problem

Dec 5, 2006

Hello,

I made some custom icons for use with command buttons, and I made them ICO
files with transparency.
However, after I assigned them to my buttons, there's a light grey
background colour - which doesn't look all that great.

Is there a way to import images with their transparency intact? There must
be, since Access' built-in buttons are transparent.
Do I need to use a different image format? Or are there other tweaks to make
this work?

Thank you.

View 8 Replies View Related

Modules & VBA :: Delete A Record With Custom CMD Button

Jul 12, 2015

I am building a db for reservations for my limo company. I want to have a cmd button that verifies the user to make sure she wants to delete a run. This is what I have so far:

Private Sub cmdDeleteRun_Click()
Dim Response
Response = msgbox("Are you sure you want to delete this run?", vbYesNoCancel + vbCritical, "Really delete run?")
If Response = vbYes Then

End Sub

I don't know what I am missing for the cmd to actually delete it.

View 3 Replies View Related

Custom Save Button On Form Preventing Subform

Jun 21, 2005

I have a main form and a sub form. Tbhidden and tbpropersave are the text boxes that govern the update procedure. The main form has two text box that i use to prevent the user from modifying the information on the main form without clicking my custom save button. the problem is that the subform should be completed after the information on the main form has been filled in. The Update code i have refuses to allow me to complete the subform without first clicking the save button on the main form. Here is the code. I wana be able to fill in info in the main form, then the sub form then click save. The sub form is a table which relates to the main form table Many to One.

Private Sub Form_BeforeUpdate(Cancel As Integer)
On Error GoTo Err_Form_BeforeUpdate

Me.tbhidden.SetFocus

If Me.tbPropersave.Value = "No" Then
Beep
MsgBox "Please Save This Record!" & vbCrLf & vbLf & "You can not advance to another record until you either 'Save' the changes made to this record or 'Undo' your changes.", vbExclamation, "Save Required"
DoCmd.CancelEvent
Exit Sub
End If

Exit_Form_BeforeUpdate:
Exit Sub

Err_Form_BeforeUpdate:
If Err = 3020 Then 'Update or CancelUpdate without AddNew or Edit
Exit Sub
Else
MsgBox Err.Number, Err.Description
Resume Exit_Form_BeforeUpdate
End If



Please HELP


End Sub

View 1 Replies View Related

Reports :: Custom Reports Creating Chart Based On Month Not Calendar Year

Jun 15, 2015

I am editing a database that provides the option of creating custom reports, where the user can input a date range of their choice and receive aggregate data for that time frame. Although all of the numbers in the report are correct, I am having trouble with a chart that I inserted into the report.

Specifically, if the date range requested spans 2 calendar years (i.e. April 2014 through January 2015), the data for January 2015 appears at the beginning of the year (so the chart x-axis is for Jan through Dec, and the Jan 2015 data is showing up in Jan (as if it was 2014, not the end of the given range in 2015). When I try with smaller time frames within a calendar year, it adjusts just fine (i.e. shrinking the window so just March-May is displayed on the graph).

How to adjust the axis so that it properly records the data range- so that it would start the axis with April and end in January, for example?

View 2 Replies View Related

Creating A Filter Button

Nov 7, 2005

I have a combo box with different department names in it
I have a button in a form called cmdShowDept the caption "Show only one Department"

When I open the form I have the combo box set to not be visible
When the Show only one Department command button is pressed I want the following to happen;
The Department combo box should appear
The button's text should change to "Show all Departments" in red
If the button is clicked when the text is red then:
the original button text should return in Black
the department combo should disappear

After clicking on the button and you click one of the specific departments ie accounting I want it to show only the accounting records in the form.

I'm still learning about access, so thanks for any help anyone can give me pleeeese!!

View 1 Replies View Related

Custom "Go To Previous Record" Button Problem?

May 24, 2005

Hi gang,

Just spent most of today and all evening trying to get this to work and access keeps giving me a Run-time error '2465':
Microsoft Access can't find the field 'frmPlant_Sub1' referred to in your expression.

I am trying to write the code for Custom Navigation Buttons like - Next, Prev, First, New & so on. To keep it simple for this post I am referring to the "Go to previous" record action.

I have a main form [frmPlant_Main] that is not bound to anything, it just acts as a holder for the sub-form and contains a couple of labels like the database name and so on.

On the main form is a sub-form [frmPlant_Sub1] that is bound to the table that contains the actual data.

On the main form I have a command button called [cmdGoToPrevious]. On its "on click" event I have tried various code but none of it worked. I have searched all over the net but with no luck. I keep getting the same run-time error.

Below is the code that I am currently using and any suggestions would be great.

Thank you in advance,

Kenny

-----------------------Code Begins---------------------
Private Sub cmdGoToPrevious_Click()
If Me!frmPlant_Sub1.Form.CurrentRecord > 1 Then
Me!frmPlant_Sub1.SetFocus
DoCmd.RunCommand acCmdRecordsGoToPrevious
End If
End Sub
-----------------------Code Ends-----------------------

View 3 Replies View Related

Subform Creating An Edit Button

Jul 2, 2006

Main form is frmPeople

As you can see i have a subform called frmPeopleInsurancesSub
Next to that I have a Edit Command button which open a forms called
PeopleInsurances

When user wants to edit one of the insurances all user has to do is click on on one of the insurance and click edit to take user to that record

But cant make it work


Any Ideas

View 4 Replies View Related







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