Forms :: Impossible To Add Custom Icon To Button
May 23, 2015I 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 Replies
ADVERTISEMENT
Cannot Hide DB Window With Custom Icon
Jun 27, 2005In Access, Tools->Start... I uncheck the "Show Database Window" checkbox to hide the database window when the database opens.
When I enter an icon to be used for the program, the hide DB window utility cease to work on Windows 2000, but not on Windows XP, e.g. the DB window is shown when opening the database on a Window 2000 system.
Any suggestions on how to solve this?
General :: Custom Database Icon
Oct 17, 2014Creating and installing a custom icon for my database but I'm still seeing the access icon. I've done these things:
-I made a 32x32 bitmap in photoshop.
-I saved it in the same folder as my database.
-I opened access 2007 with my database
-I went to access options/current database/application options/application icon and browsed for my bitmap.
-Clicked on use as form and report icon.
-Closed everything and reopened my database.
I couldn't see my icon anywhere in explorer, access or my desktop shortcut for my database.I repeated all this except I put the bitmap into an online icon creator and downloaded an .icon for win vista and win 7 which I selected as above.
Forms :: Unable To Navigate Between Records - Custom Save Button Not Saving
Jul 22, 2013I'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.
Both Text And Icon On A Command Button
Feb 2, 2006How do you make both the text and the icon visible on a command button? If the 'Picture' propery is set, I can't see the text.
View 2 Replies View RelatedCreating A Custom "What's This?" Button In Forms
Aug 19, 2004Is 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 2 Replies View RelatedCustom Button
Jan 16, 2006I'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 RelatedAdd A Button To A Custom Menu
May 7, 2007I 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?
Help With Custom Command Button
Aug 16, 2005I 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
General :: Put A Custom Button On QAT
Mar 19, 2015I 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.
Custom Button Image Transparency Problem
Dec 5, 2006Hello,
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.
Modules & VBA :: Delete A Record With Custom CMD Button
Jul 12, 2015I 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.
Changeing The Forms Titlebar Icon
Apr 13, 2005Hi,
I created an icon for my database application and I would like to display it in each form's title bar. Is this possible? And if it is, how? A few years ago I learned a little Delphi programming, and there this is possible to do.
Thanx!
Attila
Custom Save Button On Form Preventing Subform
Jun 21, 2005I 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
Forms :: Tabbed Documents Icon On Caption Bar
May 25, 2015Customizing the form with the following code
Code:
Public Declare Function LoadImage Lib "user32" _
Alias "LoadImageA" _
(ByVal hInst As Long, _
ByVal lpsz As String, _
ByVal un1 As Long, _
ByVal n1 As Long, _
ByVal n2 As Long, _
ByVal un2 As Long) _
As Long
[code]...
I can load the little icon on the left on CaptionBar.It works very well on overlapping mode but no on Tabbed documents. How to works with tabbed documents mode?
Forms :: Replace The Access Icon In Taskbar?
Nov 21, 2013how I can replace the MS Access icon in the windows 7 taskbar at the bottom of my screen with my customized one. I already added under the access options the form and report icon and was hoping that this may solve the issue. But my own icon just pops up on the title bar of the main access screen, forms and the reports.
View 4 Replies View RelatedForms :: Change Form Icon Next To Caption?
Jun 12, 2014how to change a form icon and make that icon embed to my database, I have tried the Application Icon property in Access Options but when I copy the database to other computer then the icon disappeared.
View 3 Replies View RelatedIs This Impossible???
Jul 7, 2006I have a table with 3 fields: CUSTOMER, START INVOICE NUMBER and END INVOICE NUMBER
I want to populate an identically formatted table with a consolidated list of start and end invoice number ranges for each customer. HOWEVER! Heres the rub....
The ranges for each customer in your starting table may overlap, one range of numbers may fit inside another range of numbers for the same customer.
For example:
Customer: X Start: 10 Finish: 15
Customer: X Start: 11 Finish: 17
Customer: X Start: 9 Finish: 16
Customer: X Start: 3 Finish: 7
I want to represent this in my new table as:
Customer: X Start: 3 Finish 7
Customer: X Start: 9 Finish: 17
I have been banging my head again against a wall for hours trying to work this out.........
PLEASE HELP!
Regards,
Dalien51
Is This The Impossible?
Apr 25, 2006I have created an Access database to be placed on a company network consisting of 25 individual tables and 1 large table (the large table is an amalgamation of the smaller 25). The 25 individual tables will be updated regularly by different staff!
I was wondering if tables can be linked to one another? i.e If I enter data into an 'individual table' can that information be automatically transfered to the 'large table' to save entering the same data twice?
Confused :confused: - Me too :)
Impossible? Perhaps
Nov 23, 2004Hi,
I'm creating a form to input data with. But, since forms are by an individual record basis, I was hoping that I can somehow see a general view of what is happening for all the records as I'm inputting data. Is there any way to stick the table into the form itself, kind of like a subform, so that I can see all the records as I input them in? If not, is there any such thing that I can do, where I'm not just limited to the one record I'm working on, but where I can see what's happening around that record I'm working with? VERY much thanks to anyone who can figure this out. Hope it wasn't too unclear.
G
Mission Impossible
Jun 29, 2005Hey Everone.
In the middle of building a DB system obviously for someone else. Is it possible to generate an email with the subject box & body filled in automatically.
e.g The button will say "Send Email", when clicked will generate an email with the subject box filled in with "Turmic Records....." and the body of the email filled in with "Thanks you for joining us...balblabla". You know what I mean.
Is this possible at all with Access. Has anyone ever generated any kind of emails from Access.
Please Help
Shane
Report Output Impossible? =(
May 10, 2007Hi all,
I was wondering if this was possible to do at all using access or ideas on how to do it in any other way.
A Query (i Think It's Simple, But Impossible For Me)
Jul 27, 2006Hi,
I have 3 tables (i have 5, but i think it's the same)
t1 (id,name,month,hours)
1,peter,july,25
2,peter,july,5
3,mike,june,7
4,peter,april,50
t2 (id,name,month,hours)
1,peter,june,13
2,jane,july,5
3,peter,july,6
t3 (id,name,month,hours)
1,jane,july,70
2,jane,june,3
i want a query that returns me (the order doesn't matter):
peter,june,13
peter,april,50
peter,july,36
mike,june,7
jane,june,3
jane,july,75
thank you very much for your help
Forms :: Continuous Subform - Control To Display Image / Icon Based On Another Field
Jan 9, 2014I have a continuous subform which queries a table of attachments. I'm using Access 2007 but not using the Attachment datatype; this DB will grow considerably and I don't want to waste precious space by filling it with bulky files. So instead, I have code which makes a copy of the attachment and adds the hyperlink (to the copy) to the table instead.
Now - I want to add a control to the subform to display an icon / image reflecting the file type of the attachment (Word doc, Excel s/s, PDF etc.)
But not sure how to go about it.
I was thinking I could use FileSystemObject.GetFileExtension at the point in the code where the attachment is added, and add a new field to my attachments table (i.e. translate "*.xls*" to "Excel", etc.) Then store / embed a handful of images for the core types I would expect and use an image control on the subform to display the image based on the value of that field.
But is that even possible / feasible?
Or, is there a handy API which can retrieve the icon associated with a file type based on what has been installed on the local machine (even if there is, there's still the problem of setting up the image control to display the appropriate icon specific to each record...)
Or, is there another control available which would be better suited to something like this than an Image control?
Custom "Go To Previous Record" Button Problem?
May 24, 2005Hi 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-----------------------
Forms :: Custom Alternate Row Colors On Forms?
Jul 4, 2013I have a sub form in datasheet view and need to custom alternate row colors with criteria from the main form.
E.g. If the Criteria field in the main form is 4, row colors must alternate after every forth record in the sub form. First 4 rows not shaded, next 4 rows shaded. If the Criteria changes to 6 then first 6 rows not shaded, next 6 shaded etc. I can do this in a Report with the Format Event but in a Form there is no Format Event.
On the Home tab, under Text Formatting group, using the Alternate Row Color drop-down list, changes every row, which is not what I need.