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 Replies
ADVERTISEMENT
Feb 17, 2008
Welcome,
i am making a database project for manufacturing purpose. I have made tables in MS Access and connected them with MySQL (ODBC). I have created data access pages for employee to access data to database. I have copied these page to my locale appache server and it works as a web page.
I could(employee) insert data from a web page to MySQL tables, but now I want to make some reports and templates(made in Access!) be accesible from web page for managers. Graphs made in access too.
I will look like this: User will log in on a web site, when he log in as a manager there will be available reports and graphs(data from MySQL) that I made in Access.
Data Access pages made in MS access <2007 work perfectly, can I make the same thing with reports, graphs, templates? I mean save them as a dynamic web page with links to databace?
Thanks for help.
Paul Zegadło, Poland.
View 2 Replies
View Related
Jul 8, 2013
Is is possible to create a form that is 4 pages in length? After info is entered in first two pages I would like to print out all 4 pages to pass on to another person.
View 10 Replies
View Related
Apr 26, 2007
Hi! I'm a newbie and have very very basic understanding of Access...I'm running a small group of about 19 members that is expected to grow within the next two months to 11 more members...
I haven't been able to find a freeware club/membership database so having the fun of creating my own.
I used the "membership database" that microsoft offers and I figure out (very easily) how to do the page breaks, but I tried to add an option on the top of the form to goto page 3 and have access take my viewer to "page 3" of the form...
I've looked at the coding for page 1 and 2 that is already in place for the form where member info is enter, but it's just over my head and hoping someone can help me figure out how to build an event that when someone clicks on page 3, it will take the viewer to the "third page" of the form for additional information I hope to add.
View 5 Replies
View Related
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
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
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
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
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
Jul 2, 2012
i would like to create custom menu bars for my forms report
View 6 Replies
View Related
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
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
Jul 16, 2013
I have a button that is using a theme. The words do not center.
View 3 Replies
View Related
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
Feb 3, 2014
I build MS Access databases for small businesses. Generating emails from within Access is no problem - I can even use Access VBA to select specific email accounts and email signatures. However, I have not been able to find a way to use Access VBA to select a Theme that was set up in Outlook. If I create a Theme using the Outlook 2010 menu selections: Options / Mail / Stationery and Fonts / Theme, that theme is present every time I generate a new email from within Outlook. But if I generate a new email via Access VBA, that theme is no longer present - the email that VBA generates has no Theme. What Access VBA code do I need to use to select an Outlook Theme - even just the default Outlook Theme?
One thought is that if someone knows the keyboard shortcuts to select an Outlook Theme, I can do the rest. I can use SendKeys. But if there is a more sophisticated way of making the Theme appear on emails generated by Access VBA, I am eager to learn.
I am using Access 2010, by the way.
View 2 Replies
View Related
Jul 14, 2014
On the Windows 7 Developer desktop, the Windows Theme is set to Windows 7.On the Citrix server (for users) the Windows Theme appears to be Windows 95. It is low graphics.The boxes are square instead of rounded. The selected Form Tabs just barely highlight with a thin line while on Windows 7, the selected Tab completely changes color. A basic Message box in Windows 95 looks square and flat. The title bar is very low graphics as one would expect when graphics were not great. Is there a VBA call that can display the OS Theme that affects MS Access? URL...
View 2 Replies
View Related
May 20, 2015
I have sever forms and selecting a Theme Font work fine with all except one form.
The field is a Memo Field (I have other forms with different memo fields and they are fine) that just doesn't want to use the Theme Font(s). I have several Theme Fonts and it doesn't work with any of them.
So far I've deleted the control saved it and then put it back... no good. I even created a new form and the same thing happens.
View 5 Replies
View Related
Oct 6, 2011
Not a very important question and is just for aesthetics however is there a way to make every form, every command button the same colour, font, size etc?
I have selected a theme however it does not change all forms, labels, text boxes, etc
I don't really want to have to go change them all one by one
For example I would like to get rid of all the navigation on all my forms can you change it over whole database or just individually?
View 3 Replies
View Related
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 2 Replies
View Related
Oct 31, 2013
Is it possible in Access 2010 to change the theme for a single form? I do not want the theme for all my other forms to change, but only for 1 specific one.
View 1 Replies
View Related
Apr 3, 2006
I have a database with 4 tables One for agent info and 3 for property info.
I have linked the agent table to the property tables.
I need to setup a link for the agents. If I have an agent and they click on see my property, Do I have to have a page for each agent or can it be done with one page?
View 2 Replies
View Related
Aug 29, 2006
Hi,
I want to open up a certain page of a tab control using VBA code.
For example: when user presses a button in a form, tab number three of a tab control opens in an other form.
Any help will be very much appreciated.
B
View 14 Replies
View Related
May 6, 2007
This might be a question that isn't possible, but I have three html pages made in my database, and i was wondering if there is a way to link the pages into the switchboard somehow because then everything would be accessible from one central location?? if you have any answers or sugestions they are greatly appreciated! thanks
View 4 Replies
View Related
Nov 13, 2007
Hi im trying to see if there is a way to put a timer in tab pages. so that when the time expires it changes to another tab. I have it working fine with the command button. I have like 20 tabs all hidden until the user clicks the cmd. Now is there a way to put a timer? I know that i can do it with the Form_timer, but that dont seem to work with tabs.
thanx
View 8 Replies
View Related
Sep 23, 2005
I am using the "Tab Pages" on a form. On one of the pages I have a subform. If I'm doing a routine in VBA regarding that subform, do I need to reference the Tab Pages object as well as the form and the subform?
View 2 Replies
View Related
May 26, 2006
Hello,
I have a form with a lot of controls. To make it much more clear for users, I was thinking of adding tab controls or page breakes.
I have placed a tab control with two pages on my form and tried to move the existing controls on the required page but of course the control will show on all the pages.
Is there a way to bypass this without having to create a new form and placing controls one at the time?
Thanks
View 2 Replies
View Related