WikiWirral is where great friendships are made.
Forum Statistics
Posts1,031,781
Topics76,069
Members14,050
Forums65
Posts in last 24hrs7
Most Online14,906
Nov 23rd, 2019
Who's Online Now
33 registered members (8 invisible), 921 guests, and263 spiders.
Key: Admin, Global Mod, Mod
Popular Topics(Views 7days)
New General Forums
DarrenGee and Shaun Atwood
by GaryFromWirral. 25th Jan 2022 3:41pm
Assembly Picture Gautby Road, Bidston 1968
by Longnails. 22nd Jan 2022 5:13pm
The Winter of 1963
by Griff20. 2nd Jan 2022 10:12am
Losing our Freedom re COVID booster jab
by Longnails. 4th Dec 2021 11:40pm
New Wirral History
Pub 100 quid raffle Birkenhead
by GaryFromWirral. 26th Jan 2022 3:18pm
Cleggs stonemasons
by steviebyday. 16th Jan 2022 6:49pm
The old flour mills of Wirral 1903
by _Ste_. 29th Dec 2021 7:46pm
Wheatsheaf Hotel 39 Corporation Road
by Lovelfc88. 23rd Dec 2021 5:57pm
Birkenhead rail tunnels construction pictures?
by yoller. 23rd Dec 2021 10:08am
Forum Tips
Photo Gallery Forums
Cruise liner Anthem of the Seas
Tram by the Penny Bridge
Topic Replies
Indoor bowling in Wirral
by mikeeb. 27th Jan 2022 1:14pm
Pub 100 quid raffle Birkenhead
by mikeeb. 27th Jan 2022 12:52pm
Age of House
by moretonkiwi. 27th Jan 2022 12:42am
Time flies
by GaryFromWirral. 26th Jan 2022 2:54pm
B M T H
by GaryFromWirral. 26th Jan 2022 2:50pm
Glass replacment
by diggingdeeper. 26th Jan 2022 2:35am
Shop Window Personal Ads.
by rickhefner. 24th Jan 2022 1:20pm
Sheldrakes to become private home
by mikeeb. 24th Jan 2022 1:09pm
TV / Audio display unit
by NestonCYC. 23rd Jan 2022 2:16pm
January
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 ?
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,240
Wirral
Mark Online Reading

Wiki Master
Mark  Online Reading

Wiki Master
Joined: Nov 2003
Posts: 21,240
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: 750
Wirral
R
rhoobarb2002 Offline
Veteran
rhoobarb2002  Offline
Veteran
R
Joined: Aug 2011
Posts: 750
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,925
Wallasey/New Brighton
J
j_demo Offline
Forum Addict
j_demo  Offline
Forum Addict
J
Joined: Nov 2011
Posts: 1,925
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,240
Wirral
Mark Online Reading

Wiki Master
Mark  Online Reading

Wiki Master
Joined: Nov 2003
Posts: 21,240
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,925
Wallasey/New Brighton
J
j_demo Offline
Forum Addict
j_demo  Offline
Forum Addict
J
Joined: Nov 2011
Posts: 1,925
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
Indoor bowling in Wirral
by Reno46. 26th Jan 2022 7:13pm
Pub 100 quid raffle Birkenhead
by GaryFromWirral. 26th Jan 2022 3:18pm
Time flies
by GaryFromWirral. 26th Jan 2022 2:54pm
B M T H
by GaryFromWirral. 26th Jan 2022 2:50pm
Age of House
by moretonkiwi. 24th Jan 2022 1:46am
For Sale & Free
TV / Audio display unit
by NestonCYC. 23rd Jan 2022 2:16pm
A4 Ring Binders
by NestonCYC. 23rd Jan 2022 1:31pm
SONY BRAVIA KDL-22PX300 PS2
by _Ste_. 22nd Jan 2022 10:35pm
Echo and the bunnymen, Liverpool Feb. 14
by Jakeypoos. 12th Jan 2022 10:12pm
Magic mystie
by lincle. 7th Jan 2022 11:12am
Member Spotlight
KevinFinity
KevinFinity
Wirral
Posts: 2,344
Joined: April 2009
Show All Member Profiles 
Newest Members
Donuts77, Annie1079, az156, 778Liam, Maro111
14050 Registered Users
Today's Birthdays
No Birthdays
New Wirral Info
Indoor bowling in Wirral
by Reno46. 26th Jan 2022 7:13pm
Age of House
by moretonkiwi. 24th Jan 2022 1:46am
Glass replacment
by Wickerman. 6th Jan 2022 7:55pm
Nuisance Motor Bikes In Wildbrook Drive, Bidston.
by Jobneeded67. 21st Dec 2021 12:43pm
Nuisance Motor Bikes In Wildbrook Drive, Bidston.
by Jobneeded67. 21st Dec 2021 12:17pm
News : New Topics
Sheldrakes to become private home
by Gibbo. 18th Jan 2022 1:51pm
Woodchurch Leisure centre and libraries?
by Greenwood. 11th Jan 2022 9:10am
Tony Blair Knighthood
by diggingdeeper. 7th Jan 2022 12:49pm
Wildbrook Drive Idiotic Motorbike Riders Nuisance!
by Jobneeded67. 21st Dec 2021 12:38pm
Child murders
by cools. 14th Dec 2021 1:44pm
New Enthusiast Forums
Time flies
by GaryFromWirral. 26th Jan 2022 2:54pm
B M T H
by GaryFromWirral. 26th Jan 2022 2:50pm
Most Haunted
by Longnails. 17th Jan 2022 10:14pm
Worth a watch ...
by GaryFromWirral. 9th Jan 2022 10:22pm
Panther & Rottweiler
by GaryFromWirral. 4th Jan 2022 5:29am
Popular Topics(Views 24hrs)
Wirral Sunrise Sunset
Sunrise Thu 8:04am
Sunset Thu 4:45pm
Local Time Thu 2:04pm
Powered by UBB.threads™ PHP Forum Software 7.6.1.1