Our Success is in our members who value our strength as a valued community.
Forum Statistics
Posts1,014,938
Topics74,900
Members12,909
Forums66
Posts in last 24hrs15
Most Online7,831
Apr 8th, 2013
Who's Online Now
51 registered members (alan128, 9 invisible), 1,229 guests, and348 spiders.
Key: Admin, Global Mod, Mod
Social Media : Follow Us


Popular Topics(Views 7days)
181 Stabbing
New General Forums
Exchange rate
by casper. 14th Mar 2019 10:14am
Pound at a Two Year High
by diggingdeeper. 14th Mar 2019 2:43am
Another Travesty of Justice
by diggingdeeper. 8th Mar 2019 11:24am
Sometimes a Bullet Just Isn't Enough
by diggingdeeper. 6th Mar 2019 7:28pm
New Wirral History
Wirral Street??
by gerrymoore. 16th Mar 2019 2:58pm
WW2 USNavy large sheepskin trousers
by Bultaco. 15th Mar 2019 8:48am
Where is/was this Station Hotel
by derekdwc. 13th Mar 2019 11:44am
Grove Hotel, Wallasey
by diggingdeeper. 9th Mar 2019 9:01pm
Moss hall
by chris58. 8th Mar 2019 7:31pm
Forum Tips
Photo Gallery Forums
WW1 Monument, Birkenhead
No more bridge, never be the same
Topic Replies
Egremont Ferry to Be Destroyed
by Norton. 18th Mar 2019 4:43pm
Looking for a Gym buddy (Total Fitness Prenton)
by Colt743. 18th Mar 2019 4:25pm
New Council Tax bill 2019
by diggingdeeper. 18th Mar 2019 11:58am
Handbag Found in New Brighton
by daveybm. 18th Mar 2019 9:43am
Pair of bedside cabinets
by gerrymoore. 18th Mar 2019 9:14am
Giant rabbit startles motorist.
by Excoriator. 17th Mar 2019 6:43pm
Mosque Attack, New Zealand
by granny. 17th Mar 2019 10:57am
Wirral Street??
by gerrymoore. 17th Mar 2019 9:51am
Forum Updates : 2016-17-18-19
by Mark. 17th Mar 2019 7:41am
March
M T W T F S S
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 ?
Wirral History Fair
by missmahjong. 12th Mar 2019 3:07pm
RAF Tornado Farewell Flypast Tour
by diggingdeeper. 28th Feb 2019 10:14am
Previous Topic
Next Topic
Print Topic
Rate Topic
Access 2003 help #844029
16th Dec 2013 1:45pm
16th Dec 2013 1:45pm
Joined: Jul 2012
Posts: 2,518
Merseyside
Willo_ Offline OP
Forum Master
Willo_  Offline OP
Forum Master
Joined: Jul 2012
Posts: 2,518
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.


..
Google Ads
Re: Access 2003 help [Re: Willo_] #844050
16th Dec 2013 3:42pm
16th Dec 2013 3:42pm
Joined: Nov 2003
Posts: 21,207
Wirral
Mark Online Reading

Wiki Master
Mark  Online Reading

Wiki Master
Joined: Nov 2003
Posts: 21,207
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
Re: Access 2003 help [Re: Willo_] #844123
16th Dec 2013 8:45pm
16th Dec 2013 8:45pm
Joined: Jan 2009
Posts: 7
Wallasey
N
Neilj Offline
Beginner
Neilj  Offline
Beginner
N
Joined: Jan 2009
Posts: 7
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.

Re: Access 2003 help [Re: Willo_] #844381
18th Dec 2013 1:12pm
18th Dec 2013 1:12pm
Joined: Jan 2010
Posts: 21
Upton
P
PlasticScouser Offline
Newbeee
PlasticScouser  Offline
Newbeee
P
Joined: Jan 2010
Posts: 21
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!

Re: Access 2003 help [Re: Willo_] #844384
18th Dec 2013 1:18pm
18th Dec 2013 1:18pm
Joined: Aug 2011
Posts: 709
Wirral
R
rhoobarb2002 Offline
Veteran
rhoobarb2002  Offline
Veteran
R
Joined: Aug 2011
Posts: 709
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

Re: Access 2003 help [Re: rhoobarb2002] #844386
18th Dec 2013 1:31pm
18th Dec 2013 1:31pm
Joined: Jul 2012
Posts: 2,518
Merseyside
Willo_ Offline OP
Forum Master
Willo_  Offline OP
Forum Master
Joined: Jul 2012
Posts: 2,518
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


..
Re: Access 2003 help [Re: Willo_] #852191
21st Jan 2014 12:00pm
21st Jan 2014 12:00pm
Joined: Jul 2012
Posts: 2,518
Merseyside
Willo_ Offline OP
Forum Master
Willo_  Offline OP
Forum Master
Joined: Jul 2012
Posts: 2,518
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.


..
Re: Access 2003 help [Re: Willo_] #852203
21st Jan 2014 2:31pm
21st Jan 2014 2:31pm
Joined: Nov 2011
Posts: 1,913
Wallasey/New Brighton
J
j_demo Offline
Forum Addict
j_demo  Offline
Forum Addict
J
Joined: Nov 2011
Posts: 1,913
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!)

Re: Access 2003 help [Re: Willo_] #852206
21st Jan 2014 2:42pm
21st Jan 2014 2:42pm
Joined: Nov 2003
Posts: 21,207
Wirral
Mark Online Reading

Wiki Master
Mark  Online Reading

Wiki Master
Joined: Nov 2003
Posts: 21,207
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
Re: Access 2003 help [Re: Mark] #852213
21st Jan 2014 2:48pm
21st Jan 2014 2:48pm
Joined: Jul 2012
Posts: 2,518
Merseyside
Willo_ Offline OP
Forum Master
Willo_  Offline OP
Forum Master
Joined: Jul 2012
Posts: 2,518
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.


..
Re: Access 2003 help [Re: Willo_] #852290
21st Jan 2014 6:37pm
21st Jan 2014 6:37pm
Joined: Nov 2011
Posts: 1,913
Wallasey/New Brighton
J
j_demo Offline
Forum Addict
j_demo  Offline
Forum Addict
J
Joined: Nov 2011
Posts: 1,913
Wallasey/New Brighton
smirk sorry i couldn't be more help

all i have to say is GOOD LUCK!

Re: Access 2003 help [Re: j_demo] #852475
22nd Jan 2014 11:37am
22nd Jan 2014 11:37am
Joined: Jul 2012
Posts: 2,518
Merseyside
Willo_ Offline OP
Forum Master
Willo_  Offline OP
Forum Master
Joined: Jul 2012
Posts: 2,518
Merseyside
Same type of thing this person added something in after he designed his form, [youtube]QFUDt0cpIi0[/youtube] I copied him, but not using picture, and it just does not work.


..

Moderated by  Mark 

Random Wirral Images

Click to View Topic.
Newest Topics
New Council Tax bill 2019
by keef666. 18th Mar 2019 11:13am
Handbag Found in New Brighton
by daveybm. 18th Mar 2019 9:43am
Giant rabbit startles motorist.
by Excoriator. 17th Mar 2019 9:58am
Stabbing
by cools. 16th Mar 2019 9:38pm
Wirral Street??
by gerrymoore. 16th Mar 2019 2:58pm
For Sale & Free
125cc scooter
by vw_kyle. 12th Mar 2019 8:13am
KTM Mancina Action 272 27.5 Inch Electric Mountain
by ianyam. 10th Mar 2019 12:04pm
Cambridge hifi Amplifiers for sale - from £40
by montyz. 8th Mar 2019 11:36am
Pair of bedside cabinets
by gerrymoore. 5th Mar 2019 8:37am
Food blender
by madrob. 3rd Mar 2019 6:28pm
Member Spotlight
neddy
neddy
rhyl
Posts: 15,584
Joined: October 2012
Show All Member Profiles 
Newest Members
Bandurra, Me1978, crsinbeb, Bultaco, Windows
12909 Registered Users
Today's Birthdays
No Birthdays
New Wirral Info
New Council Tax bill 2019
by keef666. 18th Mar 2019 11:13am
Roofer recommendation please?
by Gold_Moon. 15th Mar 2019 4:09pm
Phone calls
by casper. 11th Mar 2019 6:43pm
Can anybody help?
by Heswall1958. 10th Mar 2019 1:41pm
Someone with a van to move a snooker table
by iyoung. 10th Mar 2019 1:15pm
News : New Topics
Handbag Found in New Brighton
by daveybm. 18th Mar 2019 9:43am
Giant rabbit startles motorist.
by Excoriator. 17th Mar 2019 9:58am
Stabbing
by cools. 16th Mar 2019 9:38pm
Mosque Attack, New Zealand
by granny. 15th Mar 2019 8:09am
Human Trafficking
by granny. 13th Mar 2019 11:22pm
New Enthusiast Forums
DNS Not found Error.
by Windows. 14th Mar 2019 12:54pm
Bultaco pursang
by Bultaco. 13th Mar 2019 12:43pm
Hunting for a left hand drive smart car
by mike1965. 13th Mar 2019 11:23am
Small Journal Publishing.
by saltytom. 7th Mar 2019 6:07pm
Leaving Neverland
by granny. 7th Mar 2019 9:15am
Popular Topics(Views 24hrs)
Wirral Sunrise Sunset
Sunrise Mon 6:18am
Sunset Mon 6:21pm
Local Time Mon 4:43pm
Powered by UBB.threads™ PHP Forum Software 7.6.1.1