Our Success is in our members who value our strength as a valued community.
Forum Stats
12182 Members
65 Forums
72591 Topics
978241 Posts
96 posts in the last 24hrs
Max Online: 7831 @ 8th Apr 2013 4:18pm
Who's Online - Click Me
89 registered (assassin, 17 invisible), 1648 Guests and 193 Spiders online.
Key: Admin, Global Mod, Mod
Social Media : Follow Us


(Views 7days)This Weeks Most Read
Secretive mega shake-up of NHS could cost 15 mil 370
Need help 370
Wirral High Tides? 347
Sometimes You Could Strangle Someone 330
Found a mobile phone 14/01/2017 WALLASEY 329
Asbestos shed removal 313
Paypal help 286
RAC ,AA v Breakdown Recovery 250
Deportation Row 247
Lost Mobile Phone 247
New General Forums
The Scouse Accent
by palemoon
14 minutes 16 seconds ago
birthday wishes
by sunnyside
Today at 12:48 PM
The Green Eyed Girl
by granny
Yesterday at 10:33 PM
Breastfeeding Dads Want to Be A Breastfeeding Hero
by fish5133
16th Jan 2017 1:24pm
New Wirral History
What was County Hall, Abbey Street, Birkenhead?
by yoller
15th Jan 2017 1:28pm
752 The Old Manor Club, Withens Lane, Liscard
by Norton
13th Jan 2017 2:20pm
751 Plough Inn, Mount Pleasant Rd, New Brighton
by Norton
13th Jan 2017 1:38pm
351 Prince Alfred 30 Tunnel Road 30 30 to 32
by yoller
8th Jan 2017 7:18pm
167 Wirral Arms George Street 9 Grange Street
by yoller
8th Jan 2017 7:11pm
Forum Tips
Photo Gallery Forums
fireworks on the Mersey last night
Hadlow train station
Topic Replies
Car Value Sites Parkers Auto Trader
by fish5133
30 minutes 21 seconds ago
Taylors Villas 1874 any info?
by Norton
58 minutes 59 seconds ago
Secretive mega shake-up of NHS could cost 15 mil
by CVCVCV
Today at 06:23 PM
Best Price for Scarpping my car
by fish5133
Today at 05:49 PM
The Green Eyed Girl
by snowshoes
Today at 02:31 PM
Paypal help
by venice
Today at 01:17 PM
Spectacles found.
by Beethoven
Today at 01:02 PM
When we live to be a 100 yrs old
by sunnyside
Today at 12:06 PM
Deportation Row
by goodoldphil
Today at 12:00 PM
January
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 31
Recent Posts : What's On ?
Indian/Jazz fusion music Liverpool
by buddy
Yesterday at 09:46 AM
Chinese New Year Liverpool
by paxvobiscum
15th Jan 2017 11:08am
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
Digital Wirral : Advertising
Click me for more Information......


Looking for a Service / Tradesman? Look in our Local Business Directory. Click Me
#844050 - 16th Dec 2013 3:42pm Re: Access 2003 help [Re: Willo_]
Happy Birthday Mark Online   Reading


Wiki Master

Registered: 9th Nov 2003
Posts: 21001
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: 677
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: 1839
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_]
Happy Birthday Mark Online   Reading


Wiki Master

Registered: 9th Nov 2003
Posts: 21001
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: 1839
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
Car Value Sites Parkers Auto Trader
by fish5133
Today at 06:05 PM
Spectacles found.
by Beethoven
Today at 01:02 PM
The Green Eyed Girl
by granny
Yesterday at 10:33 PM
Paypal help
by venice
Yesterday at 08:59 PM
A Little Girl Gets A Kitten
by Uffda
Yesterday at 03:45 PM
For Sale & Free
Wanted old cars spares or repairs
by vw_kyle
01:08 PM
Astra 1.9 diesel 06
by lansyp
16th Jan 2017 8:47pm
viewsonic 22" monitor
by tommybarry
16th Jan 2017 3:39pm
Childs LFC peddle bike 5 - 8 Yrs
by Pete_M
13th Jan 2017 8:41pm
Projector
by madrob
13th Jan 2017 3:35pm
Featured Member
Registered: 10th Apr 2008
Posts: 13454
Newest Members
Collette63, shellylou, sgjrob, pjmeaneydog, jennynoonan
12182 Registered Users
Today's Birthdays
Mark (48)
New Wirral Info
Paypal help
by venice
Yesterday at 08:59 PM
Brown Bin Collections Restarting Today 17th Jan
by fish5133
Yesterday at 09:04 AM
Indian/Jazz fusion music Liverpool
by paxvobiscum
15th Jan 2017 11:19am
Chinese New Year Liverpool
by paxvobiscum
15th Jan 2017 11:08am
Asbestos shed removal
by TRFCKrisTRFC
13th Jan 2017 10:51pm
News : New Topics
Spectacles found.
by Beethoven
01:02 PM
When we live to be a 100 yrs old
by granny
11:46 AM
Secretive mega shake-up of NHS could cost 15 mil
by RUDEBOX
16th Jan 2017 5:58pm
Lost Mobile Phone
by spinner1
15th Jan 2017 6:56pm
Found a mobile phone 14/01/2017 WALLASEY
by GaryFromWirral
15th Jan 2017 11:28am
New Enthusiast Forums
Car Value Sites Parkers Auto Trader
by fish5133
Today at 06:05 PM
A Little Girl Gets A Kitten
by Uffda
Yesterday at 03:45 PM
Best Price for Scarpping my car
by Mike72
Yesterday at 01:02 PM
Diagnosis Route
by fish5133
Yesterday at 12:10 AM
RAC ,AA v Breakdown Recovery
by fish5133
16th Jan 2017 8:35pm
(Views 24hrs)Trending Newest Topics
Paypal help 286
The Green Eyed Girl 90
When we live to be a 100 yrs old 78
Car Value Sites Parkers Auto Trader 49
Spectacles found. 30
birthday wishes 15
The Scouse Accent 0
Wirral Sunrise Sunset
Sunrise Wed 8:16am
Sunset Wed 4:29pm
Local Time Wed 8:03pm
WikiWirral Can . . . .