WikiWirral 16yrs online 24/7 365 days a year.
Forum Statistics
Posts1,027,429
Topics75,534
Members13,472
Forums65
Posts in last 24hrs7
Most Online14,906
Nov 23rd, 2019
Who's Online Now
38 registered members (Berliner, 6 invisible), 1,209 guests, and363 spiders.
Key: Admin, Global Mod, Mod
Social Media : Follow Us


Popular Topics(Views 7days)
New General Forums
TV licence
by casper. 11th Aug 2020 5:27pm
Hi everyone.
by Harp1st. 6th Aug 2020 12:16pm
The cat got the cream
by snowhite. 23rd Jul 2020 2:25pm
Eddie Flanagan comedian
by mikeeb. 22nd Jul 2020 2:23pm
New Wirral History
Woodside Ferry on Upton Rd
by mikeeb. 11th Aug 2020 12:50pm
A Stanworth Shop, Birkenhead North
by diggingdeeper. 6th Aug 2020 11:11am
Toll booths Birkenhead Tunnel
by mikeeb. 4th Aug 2020 2:34pm
Ron Gittins Stories ?
by DaDoRon. 2nd Jul 2020 9:59pm
Outdoor swimming pools
by mikeeb. 30th Jun 2020 4:26pm
Forum Tips
Photo Gallery Forums
Boaty McBoatface takes shape
The gathering storm: Mersey waterfront today
Topic Replies
Woodside Ferry on Upton Rd
by bert1. 11th Aug 2020 1:41pm
Ron Gittins Stories ?
by DaDoRon. 10th Aug 2020 8:13pm
Xbox One Console With RDR 2 And 22" LG TV
by rhoobarb2002. 10th Aug 2020 4:15pm
Hi everyone.
by Harp1st. 10th Aug 2020 2:43pm
676 Queens Royal Hotel Marine Promenade Wallasey
by mikeeb. 10th Aug 2020 12:22pm
Bultaco pursang
by BultacoAstro. 10th Aug 2020 10:11am
River Mersey , then and now
by locomotive. 9th Aug 2020 7:49pm
Restaurant/pub with outdoor seating - Bromborough
by diggingdeeper. 8th Aug 2020 11:17am
Restaurant/pub with outdoor seating - Bromborough
by CarterUSM. 7th Aug 2020 8:59pm
August
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 ?
Restaurant/pub with outdoor seating - Bromborough
by diggingdeeper. 8th Aug 2020 11:17am
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,231
Wirral
Mark Offline

Wiki Master
Mark  Offline

Wiki Master
Joined: Nov 2003
Posts: 21,231
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: 736
Wirral
R
rhoobarb2002 Online shifty
Veteran
rhoobarb2002  Online Shifty
Veteran
R
Joined: Aug 2011
Posts: 736
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,922
Wallasey/New Brighton
J
j_demo Offline
Forum Addict
j_demo  Offline
Forum Addict
J
Joined: Nov 2011
Posts: 1,922
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,231
Wirral
Mark Offline

Wiki Master
Mark  Offline

Wiki Master
Joined: Nov 2003
Posts: 21,231
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,922
Wallasey/New Brighton
J
j_demo Offline
Forum Addict
j_demo  Offline
Forum Addict
J
Joined: Nov 2011
Posts: 1,922
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
Woodside Ferry on Upton Rd
by mikeeb. 11th Aug 2020 12:50pm
Restaurant/pub with outdoor seating - Bromborough
by CarterUSM. 7th Aug 2020 9:00pm
Restaurant/pub with outdoor seating - Bromborough
by CarterUSM. 7th Aug 2020 8:59pm
Hi everyone.
by Harp1st. 6th Aug 2020 12:16pm
A Stanworth Shop, Birkenhead North
by diggingdeeper. 6th Aug 2020 11:11am
For Sale & Free
Xbox One Console With RDR 2 And 22" LG TV
by rhoobarb2002. 6th Aug 2020 4:13pm
Roland U-20 Vintage 80s/90s RS-PCM Keyboard/Synth
by rhoobarb2002. 6th Aug 2020 3:41pm
Three light unit
by gerry1. 3rd Aug 2020 10:36am
Carlton Players Birkenhead Theatre Programmes
by NickWirral. 19th Jul 2020 8:54pm
Ipad Mini 5th Gen
by Catsick. 11th Jul 2020 1:58pm
Member Spotlight
Dilly
Dilly
wallasey
Posts: 8,964
Joined: July 2011
Show All Member Profiles 
Newest Members
LACEWWING11, Bobblenose, Johan_Enrik, Oscar27, Barry02020
13472 Registered Users
Today's Birthdays
Mickfish (60), Pete_M (62)
New Wirral Info
Restaurant/pub with outdoor seating - Bromborough
by CarterUSM. 7th Aug 2020 9:00pm
Restaurant/pub with outdoor seating - Bromborough
by CarterUSM. 7th Aug 2020 8:59pm
What Wood?
by rocks. 1st Aug 2020 7:12pm
Covid testing with certification on Wirral
by CarterUSM. 23rd Jul 2020 10:46am
Neowise comet
by mikeeb. 20th Jul 2020 9:04pm
News : New Topics
New Merseyrail trains covered in graffiti
by mikeeb. 28th Jul 2020 6:38pm
Found bicycle seat cover
by BultacoAstro. 25th Jul 2020 10:43am
Regeneration of New Ferry
by Excoriator. 24th Jul 2020 3:53pm
Painted frontages of new Ferry Shops.
by Excoriator. 23rd Jul 2020 11:29pm
Liver building
by cools. 26th Jun 2020 11:14pm
New Enthusiast Forums
Advice Needed Hellcat Carrera rear Wheel
by BultacoAstro. 28th Jul 2020 11:04am
River Mersey , then and now
by cools. 23rd Jul 2020 7:19pm
What is sitting on roof
by BultacoAstro. 9th Jul 2020 11:03am
Cruel ear cropping breeders moved to Bromborough
by venice. 21st Mar 2019 4:10pm
Bultaco pursang
by Bultaco. 13th Mar 2019 12:43pm
Popular Topics(Views 24hrs)
Wirral Sunrise Sunset
Sunrise Tue 5:46am
Sunset Tue 8:47pm
Local Time Tue 8:13pm
Powered by UBB.threads™ PHP Forum Software 7.6.1.1