473,242 Members | 1,599 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,242 software developers and data experts.

MS-Access 2007 - change of entry screen possible?

Searching some time now for documents on this but still did not find
anything about it:

Is it possible to replace the entry screen of MS Office Access 2007 -
that one presenting that default 'templates' (with that big graphic
buttons) - with some sort of own HTML-Page? I could imagine, that
somehow it is possible to change this construction (hopefully not
hardcoded in MS-Acc07), like it is possible to edit the 'Fluent Ribbon'?

If so where to find infos about it and under what keywords are those
whitepapers on MSDN avail?

Any ideas?

rob*
Jun 27 '08 #1
7 3335
You can setup you own startup screen, and build that form to look just about
anyway you want.

That screen could launch other applications, or do whatever you want. You
limited only by your imagination here.
>like it is possible to edit the 'Fluent Ribbon'?
Yes, you can change to also...
>
If so where to find infos about it and under what keywords are those
whitepapers on MSDN avail?
For the startup form, you can specify that by going office button->access
options.
Just choose current database, and you can set the startup form to replace
what you see.

For the ribbon, here some info:
Customizing the Office Fluent User Interface in Access 2007
http://msdn.microsoft.com/en-us/library/bb187398.aspx

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
Jun 27 '08 #2
Albert,

thanks for reply.

Albert D. Kallal wrote:
You can setup you own startup screen, and build that form to look just about
anyway you want.

That screen could launch other applications, or do whatever you want. You
limited only by your imagination here.
Ok. Just the usual way binding an entry form dialog. Is it possible to
(at least) having this entry form staying maximized while other dialogs
are normal not maximized windows? In the older Acc this was not
possible. Either maximized or non maximized - a mixture was not possible.

>like it is possible to edit the 'Fluent Ribbon'?
http://...
I know that link, you mentioned in your answer. What I thought is if MS
made it possible to change the entry screen, like it is possible to
change the Ribbon thing. But obviously it is not the case. So not very
much has changed under the hood since Acc2000.

I'm fearing many unknown side effects. For example: What if Acc2007
runtime and MS-Office 2000 are installed on same machine and the like.
Is there a specific whitepaper for this kind of scenario? Having several
customers still working with Off2k and definitively unwilling to upgrade.

rob*
Jun 27 '08 #3
"Robert S." <ro*******@googlemail.comwrote in message
news:48**************@googlemail.com...
Albert,

thanks for reply.

Albert D. Kallal wrote:
>You can setup you own startup screen, and build that form to look just
about anyway you want.

That screen could launch other applications, or do whatever you want. You
limited only by your imagination here.

Ok. Just the usual way binding an entry form dialog. Is it possible to (at
least) having this entry form staying maximized while other dialogs are
normal not maximized windows? In the older Acc this was not possible.
Either maximized or non maximized - a mixture was not possible.
<SNIP>

Access is a 'Multiple Document Interface', and as such maximize and minimize
are all or nothing. You maximize one form (say) and everything is max'd.
However, if you're not averse to copying and pasting a little VBA, you could
try this:

http://www.smccall.demon.co.uk/Windows.htm#WinManip

which will resize a form or report to fit the Access main window (the
procedure SizeFormToWindow is the one you want. Usage: in the object's open
event:

SizeFormToWindow Me
Jun 27 '08 #4
It seems that in Access 2007 we can conceal the "Accessness" of our
application, something which, I think, was not so easy in previous
versions and which I'm not so sure I like:

The screen shot here is Access 2007 but there is nothing Access
showing.
http://www.ffdba.com/AccessLess.png

The app's icon is set and assigned to forms and reports;
Tabbed form windows are turned off (not sure that this is necessary);
A startup form is chosen (shown on image);
Its min and max buttons are disabled;
The form is coded to maximize on open;
Its default shortcut menu is set to false or no;
It quits the app on close.

So, one can work in the form or close it, which closes Access. I
suppose from it one could open similar forms, but I haven't tried
that.

Can it be broken to show Access underneath? I expect so, but it's
interesting (to me) nonetheless.

On Jun 23, 5:35*am, "Albert D. Kallal" <PleaseNOOOsPAMmkal...@msn.com>
wrote:
You can setup you own startup screen, and build that form to look just about
anyway you want.

That screen could launch other applications, or do whatever you want. You
limited only by your imagination here.
like it is possible to edit the 'Fluent Ribbon'?

Yes, you can change to also...
If so where to find infos about it and under what keywords are those
whitepapers on MSDN avail?

For the startup form, you can specify that by going office button->access
options.
Just choose current database, and you can set the startup form to replace
what you see.

For the ribbon, here some info:
Customizing the Office Fluent User Interface in Access 2007http://msdn.microsoft.com/en-us/library/bb187398.aspx

--
Albert D. Kallal * *(Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKal...@msn.com
Jun 27 '08 #5
Stuart McCall wrote:
"Robert S." <ro*******@googlemail.comwrote in message
news:48**************@googlemail.com...
>Albert,

thanks for reply.

Albert D. Kallal wrote:
>>You can setup you own startup screen, and build that form to look just
about anyway you want.

That screen could launch other applications, or do whatever you want. You
limited only by your imagination here.
Ok. Just the usual way binding an entry form dialog. Is it possible to (at
least) having this entry form staying maximized while other dialogs are
normal not maximized windows? In the older Acc this was not possible.
Either maximized or non maximized - a mixture was not possible.
<SNIP>

Access is a 'Multiple Document Interface', and as such maximize and minimize
are all or nothing. You maximize one form (say) and everything is max'd.
However, if you're not averse to copying and pasting a little VBA, you could
try this:

http://www.smccall.demon.co.uk/Windows.htm#WinManip

which will resize a form or report to fit the Access main window (the
procedure SizeFormToWindow is the one you want. Usage: in the object's open
event:

SizeFormToWindow Me
Some of your methods I do use for quite long time now. Some other frags
are very welcome in my lib. Valueable VBA code. Thanks.

MDI - yes. That is the point of my critism. MS did not change anything
at all internally.

Manual modifications via VB always had been possible. I am doing this
since Access 2.0 (1993? was this if remembering right). The more I am
thinking about 2007 the less reasons are there, not to use 2000 and its
runtime any further.

More than 10 years back we asked MS for a real MS-Acc compiler. If the
Ribbon now is the answer? Sorry dudes at MS. Poor progress.

The final things I will give a try are:
A) Runtime-handling (testing some scenarios to be found at customers)
B) Size of Runtime compared to old one
C) Runtime interoperability with other old SW (especially Off2k)

Having no big hope.

rob*
Jun 27 '08 #6
When one considers the nature of an mdb file, the notion of compiling
it to an executable is ludicrous.

On Jun 24, 5:55*am, "Robert S." <robsmi...@googlemail.comwrote:
More than 10 years back we asked MS for a real MS-Acc compiler.
Jun 27 '08 #7
lyle fairfield wrote:
When one considers the nature of an mdb file, the notion of compiling
it to an executable is ludicrous.

On Jun 24, 5:55 am, "Robert S." <robsmi...@googlemail.comwrote:
>More than 10 years back we asked MS for a real MS-Acc compiler.
I understand what you mean. If you are doing serious development,
usually data are seperated from code. This has been done since Access
1.0 back in 1991. So what?
Jun 27 '08 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Google Mike | last post by:
After a lot of thought and research, and playing with FreeTDS and InlineTDS, as well as various ODBC connections, I have determined that the fastest and cheapest way to get up and going with PHP on...
9
by: CY FOK | last post by:
Hi I am planning to open a software company to develop client-server apps and web applications for my client. Now, i am in a difficult situation to determine what is the best platform i should use...
0
by: Christian McArdle | last post by:
REQUEST FOR DISCUSSION (RFD) unmoderated group comp.os.ms-windows.programmer.win64 This is a formal Request For Discussion (RFD) to create comp.os.ms-windows.programmer.win64 as an unmoderated...
3
by: Christian McArdle | last post by:
REQUEST FOR DISCUSSION (RFD) unmoderated group comp.os.ms-windows.programmer.64bit This is a formal Request For Discussion (RFD) to create comp.os.ms-windows.programmer.64bit as an unmoderated...
18
by: Rob R. Ainscough | last post by:
MS Visual Studio Ad contained in VS Magazine. Two developers in "hip" clothing diagramming out a huge flow chart on a beach. I could NOT stop laughing at the stupidity of the ad -- "Let your...
1
by: Dr T | last post by:
Hi! I downloaded MS Visual Web Developer 2005 Express Edition, MS .NET Framework SDK v2.0, and MS SQL Server 2005. Subsequently, I bought MS Visual Studio 2005 Professional Edition. 1) Are...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.