Welcome to WikiWirral, sharing is what we do best.
Forum Stats
12331 Members
65 Forums
73265 Topics
989402 Posts
109 posts in the last 24hrs
Max Online: 7831 @ 8th Apr 2013 4:18pm
Who's Online - Click Me
89 registered (alan128, 17 invisible), 1332 Guests and 292 Spiders online.
Key: Admin, Global Mod, Mod
Social Media : Follow Us


(Views 7days)This Weeks Most Read
Bexit Offer for EU Citizens 623
Washing machine 291
Range Rover P38A Air Suspension Help Needed 229
Deja Vu, Lightning Strikes Thrice, Groundhog Day 180
Benefit Cap is Unlawful 162
VW t4 fixed side window replacement 138
audi specialised pls 125
Ipad 1 charger 103
Every little helps... 74
Kingsway Academy 41
New General Forums
Mainstream Media- Over and Out
by RUDEBOX
Yesterday at 09:35 PM
Kingsway Academy
by lincle
Yesterday at 10:48 AM
Theresa May and the Holy Grail
by snowhite
25th Jun 2017 6:17pm
Deja Vu, Lightning Strikes Thrice, Groundhog Day
by fish5133
22nd Jun 2017 7:38pm
New Wirral History
Round the Wirral with a movie camera[1934]
by snowhite
16th Jun 2017 2:03pm
Bascule Bridge
by Sufee
6th Jun 2017 9:09pm
Pathe news short - merseytunnel 1934
by oldpm01
5th Jun 2017 1:57pm
1878 Post Office Directory of Cheshire query
by derekdwc
1st Jun 2017 10:41pm
Bakery at 275 Poulton Road 1925 onwards
by JAFitz
30th May 2017 8:59pm
Forum Tips
Photo Gallery Forums
wirral from Liverpool big wheel
New Brighton Big Wheel
Topic Replies
Every little helps...
by diggingdeeper
44 minutes 42 seconds ago
Sailing volunteers
by dogsbrain
Today at 10:19 AM
Bean to cup coffee machine
by monsterz4
Today at 08:56 AM
Ipad 1 charger
by _Ste_
Yesterday at 07:22 PM
Portraying A Nation-Germany 1919-1933 Tate Liverpool
by paxvobiscum
Yesterday at 07:06 PM
Shotwick - Old And New (Hall and Solar Farm)
by w10694
Yesterday at 06:42 PM
Bexit Offer for EU Citizens
by cools
Yesterday at 11:27 AM
live webcam from africa, a must see
by cools
25th Jun 2017 9:01pm
audi specialised pls
by diggingdeeper
25th Jun 2017 5:41pm
June
M Tu W Th F Sa Su
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30
Recent Posts : What's On ?
Portraying A Nation-Germany 1919-1933 Tate Liverpool
by paxvobiscum
Yesterday at 07:06 PM
Shotwick - Old And New (Hall and Solar Farm)
by w10694
Yesterday at 06:42 PM
Topic Options
Rate This Topic
#844029 - 16th Dec 2013 1:45pm Access 2003 help
Willo_ Offline
Forum Master

Registered: 5th Jul 2012
Posts: 2518
Loc: Merseyside
I have built a database using access 2003, I have designed a data entry form, which when I click on shortcut to database I would like it to open the data entry form, rather than opening database showing list of tables etc etc.

Any one any ideas on how I do this. please.
_________________________
..

Top
Google Ads
#844050 - 16th Dec 2013 3:42pm Re: Access 2003 help [Re: Willo_]
Mark Online   Reading


Wiki Master

Registered: 9th Nov 2003
Posts: 21062
Loc: Wirral
Dont you have to complie it as an exe ?

Or

Preferences. Its been a while since ive done access. doh learn
_________________________
My Avatar images are all from the Wirral Gallery.Click Me
Wow Wirral History is coming along Great! Wirral History

we get +200 new members a month now smile

Top
#844123 - 16th Dec 2013 8:45pm Re: Access 2003 help [Re: Willo_]
Neilj Offline
Beginner

Registered: 9th Jan 2009
Posts: 6
Loc: Wallasey
I know how to do this in Office 2007 - so try this for 2003.....

Click on the Microsoft Office Circle in the Top Left of the Database
This will show a drop down menu
At the bottom on the menu on the right you should click a button called 'Access Options'
Then on the left choose Current Database
Where is says Display Form - choose the form that you have created from the drop down list - you should then have set the database to load that from each time the database is loaded.

Top
#844381 - 18th Dec 2013 1:12pm Re: Access 2003 help [Re: Willo_]
PlasticScouser Offline
Newbeee

Registered: 22nd Jan 2010
Posts: 21
Loc: Upton
Hi there. I use an Access 2003 database at work.

Do the following:

1)Start Microsoft Access
2)Open the database want to use
3)Click on "Forms"
4)Right click on the form you want to open direct from a short cut and select "Create Shortcut..." In the "Create Shortcut" window that opens, click on browse and select where you want the shortcut i.e. "Desktop".
Click "OK"

Job Done!

Top
#844384 - 18th Dec 2013 1:18pm Re: Access 2003 help [Re: Willo_]
rhoobarb2002 Offline
Veteran

Registered: 13th Aug 2011
Posts: 680
Loc: Wirral
Been a while since I did it, tried this seemed to work fine wink

'Tools' -> 'Startup' -> 'Display Form/Page' (Choose your form you want to display on startup) -> Untick 'Display Database Window'

Hope that helps

Top
#844386 - 18th Dec 2013 1:31pm Re: Access 2003 help [Re: rhoobarb2002]
Willo_ Offline
Forum Master

Registered: 5th Jul 2012
Posts: 2518
Loc: Merseyside
Originally Posted By: rhoobarb2002
Been a while since I did it, tried this seemed to work fine wink

'Tools' -> 'Startup' -> 'Display Form/Page' (Choose your form you want to display on startup) -> Untick 'Display Database Window'

Hope that helps
Perfect, thank you. happy
_________________________
..

Top
#852191 - 21st Jan 2014 12:00pm Re: Access 2003 help [Re: Willo_]
Willo_ Offline
Forum Master

Registered: 5th Jul 2012
Posts: 2518
Loc: Merseyside
Another question, can anyone help.

In this database I have a form for data entry, but have now decided to call a memo box on form a different name, I have gone in to table design and renamed the field name, but on the form it is still showing the old name.
I have also added a new field in table design, and it is not showing on the form.

I am normally very good in Access, but it's been a few years since I was having to databases, so am a bit rusty.

Can anyone advise please.
_________________________
..

Top
#852203 - 21st Jan 2014 2:31pm Re: Access 2003 help [Re: Willo_]
j_demo Offline
Forum Addict

Registered: 4th Nov 2011
Posts: 1880
Loc: Wallasey/New Brighton
Originally Posted By: Willo_
Another question, can anyone help.

In this database I have a form for data entry, but have now decided to call a memo box on form a different name, I have gone in to table design and renamed the field name, but on the form it is still showing the old name.
I have also added a new field in table design, and it is not showing on the form.

I am normally very good in Access, but it's been a few years since I was having to databases, so am a bit rusty.

Can anyone advise please.


been a few years since i used Access however i do believe that editing it in design view would change it automatically... but if it doesn't you may need to do it via the wizard (which i know is a pain but that's access for ya!)

Top
#852206 - 21st Jan 2014 2:42pm Re: Access 2003 help [Re: Willo_]
Mark Online   Reading


Wiki Master

Registered: 9th Nov 2003
Posts: 21062
Loc: Wirral
Close Access !
ReStart Access

A daft one but could force it too look at the form again.
_________________________
My Avatar images are all from the Wirral Gallery.Click Me
Wow Wirral History is coming along Great! Wirral History

we get +200 new members a month now smile

Top
#852213 - 21st Jan 2014 2:48pm Re: Access 2003 help [Re: Mark]
Willo_ Offline
Forum Master

Registered: 5th Jul 2012
Posts: 2518
Loc: Merseyside
Tried that one Mark, I have had to start from scratch with the wizard, there must be a way, am determine to find it, I have done a copy of it, and will play around with it.
_________________________
..

Top
#852290 - 21st Jan 2014 6:37pm Re: Access 2003 help [Re: Willo_]
j_demo Offline
Forum Addict

Registered: 4th Nov 2011
Posts: 1880
Loc: Wallasey/New Brighton
smirk sorry i couldn't be more help

all i have to say is GOOD LUCK!

Top
#852475 - 22nd Jan 2014 11:37am Re: Access 2003 help [Re: j_demo]
Willo_ Offline
Forum Master

Registered: 5th Jul 2012
Posts: 2518
Loc: Merseyside
Same type of thing this person added something in after he designed his form, I copied him, but not using picture, and it just does not work.
_________________________
..

Top

Moderator:  Mark 
Random Wirral Images

Click to View Topic.
Newest Topics
Every little helps...
by palemoon
Today at 09:43 AM
Portraying A Nation-Germany 1919-1933 Tate Liverpool
by paxvobiscum
Yesterday at 07:06 PM
audi specialised pls
by Little_B
25th Jun 2017 5:02pm
Bexit Offer for EU Citizens
by granny
23rd Jun 2017 9:38am
Benefit Cap is Unlawful
by RUDEBOX
22nd Jun 2017 7:37pm
For Sale & Free
Bean to cup coffee machine
by monsterz4
Today at 08:56 AM
Ipad 1 charger
by madrob
25th Jun 2017 2:34pm
Washing machine
by GingerTom
20th Jun 2017 9:05pm
22" full 1080p hd and freeview tv
by monsterz4
20th Jun 2017 8:50pm
Apple TV box the 1gen
by monsterz4
20th Jun 2017 8:48pm
Featured Member
Registered: 31st Dec 2008
Posts: 243
Newest Members
Charlotte, OwenChristian, DaveAitch, Fairz87, mikerobbo84
12331 Registered Users
Today's Birthdays
No Birthdays
New Wirral Info
Portraying A Nation-Germany 1919-1933 Tate Liverpool
by paxvobiscum
Yesterday at 07:06 PM
Shotwick - Old And New (Hall and Solar Farm)
by diggingdeeper
15th Jun 2017 10:19pm
Sefton Park
by diggingdeeper
15th Jun 2017 10:02pm
Property Law
by lau2908
14th Jun 2017 8:04pm
van driver needed
by futurepast
14th Jun 2017 7:34pm
News : New Topics
Every little helps...
by palemoon
Today at 09:43 AM
Bexit Offer for EU Citizens
by granny
23rd Jun 2017 9:38am
Benefit Cap is Unlawful
by RUDEBOX
22nd Jun 2017 7:37pm
Finsbury Park mosque.
by Beethoven
19th Jun 2017 11:42am
Grenfell Tower - Notting Hill
by diggingdeeper
14th Jun 2017 5:13am
New Enthusiast Forums
audi specialised pls
by Little_B
25th Jun 2017 5:02pm
VW t4 fixed side window replacement
by Mike72
22nd Jun 2017 8:00am
Range Rover P38A Air Suspension Help Needed
by Martin1943
20th Jun 2017 8:06pm
Loving Home Wanted For 3 Cats.
by DavidC
20th Jun 2017 8:32am
Loving Home Wanted For 3 Cats.
by DavidC
18th Jun 2017 6:02pm
(Views 24hrs)Trending Newest Topics
Every little helps... 74
Mainstream Media- Over and Out 29
Portraying A Nation-Germany 1919-1933 Tate Liverpool 14
Wirral Sunrise Sunset
Sunrise Tue 4:45am
Sunset Tue 9:45pm
Local Time Tue 1:17pm
WikiWirral Can . . . .