WikiWirral values you and your opinion.
Forum Stats
12457 Members
65 Forums
73761 Topics
997219 Posts
160 posts in the last 24hrs
Max Online: 7831 @ 8th Apr 2013 4:18pm
Who's Online - Click Me
80 registered (alan128, 19 invisible), 1369 Guests and 230 Spiders online.
Key: Admin, Global Mod, Mod
Social Media : Follow Us


(Views 7days)This Weeks Most Read
Submarine Disaster 725
Jon venables 670
Fitting bathroom lights need help 502
Murderer walks free 317
Great Mystery Of Our Time 301
Likely Lad Rodney Dies 173
Charity fishing match 170
David Cassidy 165
Brexit bill 119
Borat 😂 70
New General Forums
Should family hugs be banned?
by cools
Today at 08:29 AM
Elixir of life.
by granny
Yesterday at 10:15 PM
Great Mystery Of Our Time
by Spellbinder
21st Nov 2017 2:19pm
Brexit bill
by casper
20th Nov 2017 7:33pm
New Wirral History
Downloadable oldwirral pdfs
by derekdwc
9th Oct 2017 12:26pm
Forum Tips
Photo Gallery Forums
clipper yachts arriving for round the world race
Azamara,silouette and balmoral this mornig
Topic Replies
Jon venables
by lincle
Today at 07:32 PM
Where can I buy conservatory parts?
by venice
Today at 06:54 PM
Bodytrain 2 in 1 Exercise bike and Cross trainer
by jonno40
Today at 05:04 PM
Fitting bathroom lights need help
by yr20405
Today at 03:41 PM
What song are you listening to?
by snowhite
Today at 11:07 AM
Submarine Disaster
by RUDEBOX
Yesterday at 10:44 PM
Water Dispenser Cold Cool Machine Cooler
by markyport
Yesterday at 08:53 PM
3 X Eating / Writing Tables
by markyport
Yesterday at 08:24 PM
Murderer walks free
by fish5133
Yesterday at 07:42 PM
November
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 ?
The Lanterns at Chester Zoo
by granny
16th Nov 2017 1:05pm
bonfire night
by snowhite
3rd Nov 2017 5:40pm
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: 21086
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: 7
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: 686
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 Online   Know_it_all
Forum Addict

Registered: 4th Nov 2011
Posts: 1893
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: 21086
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 Online   Know_it_all
Forum Addict

Registered: 4th Nov 2011
Posts: 1893
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
Where can I buy conservatory parts?
by yr20405
Today at 03:45 PM
Jon venables
by Dilly
Yesterday at 07:23 AM
Borat 😂
by _Ste_
Yesterday at 05:08 AM
Murderer walks free
by _Ste_
22nd Nov 2017 2:29pm
David Cassidy
by cools
22nd Nov 2017 9:17am
For Sale & Free
3 X Eating / Writing Tables
by markyport
Yesterday at 08:24 PM
Bodytrain 2 in 1 Exercise bike and Cross trainer
by jonno40
Yesterday at 12:17 PM
Wheelbarrow wanted
by zigzagwanderer
22nd Nov 2017 2:03pm
Lenovo H30-50 Slim Line Fast PC
by markyport
22nd Nov 2017 12:50pm
Extending dining table with six chairs
by kazaroo
20th Nov 2017 4:46pm
Featured Member
Registered: 27th Nov 2008
Posts: 7948
Newest Members
Peter_exWirral, gray153, Ria63, Stephen1953, negusmat
12457 Registered Users
Today's Birthdays
locomotive (75)
New Wirral Info
Where can I buy conservatory parts?
by yr20405
Today at 03:45 PM
Fitting bathroom lights need help
by yr20405
17th Nov 2017 11:29pm
Games for children
by granny
17th Nov 2017 1:35am
Bath Lifts
by locomotive
16th Nov 2017 6:22pm
The Lanterns at Chester Zoo
by granny
16th Nov 2017 1:05pm
News : New Topics
Jon venables
by Dilly
Yesterday at 07:23 AM
Murderer walks free
by _Ste_
22nd Nov 2017 2:29pm
David Cassidy
by cools
22nd Nov 2017 9:17am
Submarine Disaster
by diggingdeeper
20th Nov 2017 5:46pm
Anyone read this ?
by venice
16th Nov 2017 3:22pm
New Enthusiast Forums
Borat 😂
by _Ste_
Yesterday at 05:08 AM
Likely Lad Rodney Dies
by fish5133
21st Nov 2017 7:43pm
Charity fishing match
by paul110180
17th Nov 2017 9:29pm
Are there any doctors or nurses on here.
by granny
16th Nov 2017 11:52pm
Taltalk Broadband Dying
by diggingdeeper
15th Nov 2017 3:40am
(Views 24hrs)Trending Newest Topics
Elixir of life. 54
Where can I buy conservatory parts? 48
Should family hugs be banned? 44
Wirral Sunrise Sunset
Sunrise Fri 7:55am
Sunset Fri 4:03pm
Local Time Fri 8:36pm
WikiWirral Can . . . .