Welcome to WikiWirral, sharing is what we do best.
Forum Statistics
Posts1,005,789
Topics74,425
Members12,674
Forums66
Posts in last 24hrs38
Most Online7,831
Apr 8th, 2013
Who's Online Now
55 registered members (4436789, 11 invisible), 1,039 guests, and305 spiders.
Key: Admin, Global Mod, Mod
Social Media : Follow Us


Popular Topics(Views 7days)
New General Forums
Hi
by The2Veggies. 12th Jul 2018 8:07pm
Men for all seasons
by casper. 11th Jul 2018 10:32am
Delta 15 Scholarship
by diggingdeeper. 2nd Jul 2018 6:23pm
Trump separating children from parents.
by venice. 20th Jun 2018 12:27pm
New Wirral History
Info on Pilgrim Street, Birkenhead
by Tom_Chisholm. 21st Jul 2018 4:02pm
A Fizz From The Past
by diggingdeeper. 30th Jun 2018 8:49pm
Ashville Road Sports Ground
by derekdwc. 26th May 2018 1:14pm
the heys eastham
by pepster. 23rd Jan 2013 2:04pm
Any pics of Bentinck Street
by derekdwc. 17th Oct 2012 11:25am
Forum Tips
Photo Gallery Forums
Over Exposed Crash Site
Birkenhead Priory / Laird's crane today
Topic Replies
Proud Of My Achievement As A Wirral Author
by Jobneeded67. 22nd Jul 2018 3:28am
My Favourite Halloween Books
by Jobneeded67. 22nd Jul 2018 3:27am
Birkenhead Paranormal & Horror Author
by Jobneeded67. 22nd Jul 2018 3:20am
342 Old Colonial 167 Bridge Street
by RUDEBOX. 22nd Jul 2018 12:57am
10 channels removed from virgin tv
by RUDEBOX. 22nd Jul 2018 12:48am
New Novichok Saga
by diggingdeeper. 21st Jul 2018 10:49pm
the heys eastham
by pepster. 21st Jul 2018 8:58pm
Info on Pilgrim Street, Birkenhead
by locomotive. 21st Jul 2018 8:52pm
Kitchen Supplier & Fitter + other Recommendations
by muzzy2. 21st Jul 2018 8:38am
July
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 ?
Giants to visit New Brighton Lighthouse
by granny. 24th Jun 2018 10:43pm
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,190
Wirral
Mark Online Reading

Wiki Master
Mark  Online Reading

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

Wiki Master
Mark  Online Reading

Wiki Master
Joined: Nov 2003
Posts: 21,190
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,904
Wallasey/New Brighton
J
j_demo Offline
Forum Addict
j_demo  Offline
Forum Addict
J
Joined: Nov 2011
Posts: 1,904
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
Birkenhead Paranormal & Horror Author
by Jobneeded67. 22nd Jul 2018 3:20am
10 channels removed from virgin tv
by assassin. 21st Jul 2018 8:33pm
Info on Pilgrim Street, Birkenhead
by Tom_Chisholm. 21st Jul 2018 4:02pm
Finds from 18/07/18 double silver!
by Detecting_wirral. 19th Jul 2018 5:32pm
Newsflash - Wirral's newest Retail Park
by Greenwood. 18th Jul 2018 1:12pm
For Sale & Free
BBQ Gas Bottle
by delta6. 16th Jul 2018 6:28pm
Gaz 907 bottle
by Snodvan. 12th Jul 2018 8:30pm
China Jardiniere
by The2Veggies. 12th Jul 2018 8:05pm
Freestanding Cooker Urgently Needed
by The2Veggies. 12th Jul 2018 7:58pm
Frame Tent
by Snodvan. 12th Jul 2018 1:30pm
Member Spotlight
Snodvan
Snodvan
Wallasey Village
Posts: 1,342
Joined: March 2008
Show All Member Profiles 
Newest Members
Mike_Garfield, Tom_Chisholm, MarSal, Mcavoy, FatGuyOnABike
12674 Registered Users
Today's Birthdays
No Birthdays
New Wirral Info
Kitchen Supplier & Fitter + other Recommendations
by Itsme. 16th Jul 2018 10:40pm
apprenticeship for electricians mate
by kazaroo. 12th Jul 2018 2:47pm
Qualified Electrician Needed
by spgb1a. 12th Jul 2018 11:08am
Unknown road name
by max232. 10th Jul 2018 10:41am
Taxi to Manchester airport - recommendations?
by CarterUSM. 9th Jul 2018 10:17am
News : New Topics
Newsflash - Wirral's newest Retail Park
by Greenwood. 18th Jul 2018 1:12pm
Dog restrictions on beaches dropped
by Greenwood. 17th Jul 2018 1:41pm
Hose Pipe Ban
by diggingdeeper. 17th Jul 2018 1:34am
Serious Accident Arrowe Park
by fish5133. 14th Jul 2018 5:10pm
More threats to Wirral's Green Belt
by Greenwood. 12th Jul 2018 1:55pm
New Enthusiast Forums
Birkenhead Paranormal & Horror Author
by Jobneeded67. 22nd Jul 2018 3:20am
10 channels removed from virgin tv
by assassin. 21st Jul 2018 8:33pm
Finds from 18/07/18 double silver!
by Detecting_wirral. 19th Jul 2018 5:32pm
Renault Modus 2010
by chrislfc87. 16th Jul 2018 1:48pm
Finds from today 14/11/18 silver again!o
by Detecting_wirral. 14th Jul 2018 10:11pm
Popular Topics(Views 24hrs)
Wirral Sunrise Sunset
Sunrise Sun 5:12am
Sunset Sun 9:24pm
Local Time Sun 5:43am
Powered by UBB.threads™ PHP Forum Software 7.6.1.1