WikiWirral Share a Little Learn a Lot about your Wirral
Forum Stats
12131 Members
65 Forums
72372 Topics
975945 Posts
69 posts in the last 24hrs
Max Online: 7831 @ 8th Apr 2013 4:18pm
Who's Online - Click Me
96 registered (11kendo, 17 invisible), 1475 Guests and 221 Spiders online.
Key: Admin, Global Mod, Mod
Social Media : Follow Us


(Views 7days)This Weeks Most Read
Disgusting surely not legal creamfields noise !!@ 1078
anything with castors 728
Pensby Hotel 429
loud music in new brighton 397
Wirral Globe 326
Paying for EU Citizenship (Poll) 303
Sports Personality Of The Year 303
Cubitts Holland and Hannen 293
PC Repair needed 248
Raspberry Pi in the classroom! 226
New General Forums
Daft funny joke
by venice
Today at 05:54 PM
We dont learn much.
by venice
Yesterday at 09:22 PM
Freegle
by venice
Yesterday at 06:36 PM
TPS failures
by venice
Yesterday at 02:41 PM
New Wirral History
Cubitts Holland and Hannen
by fish5133
27th Nov 2016 5:38pm
Fire station
by chris7777
22nd Nov 2016 12:24pm
Buy a house in Greasby for 12s a week - in 1935
by yoller
6th Oct 2016 6:56pm
North end bidston
by BennyBoy
27th Jun 2015 6:06pm
461 Collingwood, Black Horse Hill, West Kirby
by diggingdeeper
3rd Mar 2009 8:30pm
Forum Tips
Photo Gallery Forums
fireworks on the Mersey last night
Hadlow train station
Topic Replies
anything with castors
by dustymclean
34 minutes 24 seconds ago
Wirral Globe
by dustymclean
Today at 05:04 PM
Paying for EU Citizenship (Poll)
by Excoriator
Today at 04:46 PM
Raspberry Pi in the classroom!
by diggingdeeper
Today at 03:16 PM
Buy a house in Greasby for 12s a week - in 1935
by marty99fred
Today at 02:30 PM
Sports Personality Of The Year
by fish5133
Today at 02:25 PM
Disgusting surely not legal creamfields noise !!@
by Habdab
Today at 07:56 AM
Hi
by venice
Yesterday at 09:31 PM
54 plate renault clio 3rd brake light
by mikroc
Yesterday at 07:33 PM
December
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 ?
Wirral TUC Meeting re Update on Wallasey CLP Suspe
by RUDEBOX
30th Nov 2016 9:16pm
World Aids Day Event 2016. Liverpool
by RUDEBOX
30th Nov 2016 9:05pm
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_]
Mark Online   Reading


Wiki Master

Registered: 9th Nov 2003
Posts: 20958
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 Offline
Forum Addict

Registered: 4th Nov 2011
Posts: 1827
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_]
Mark Online   Reading


Wiki Master

Registered: 9th Nov 2003
Posts: 20958
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 Offline
Forum Addict

Registered: 4th Nov 2011
Posts: 1827
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
Wirral Globe
by locomotive
Yesterday at 06:25 PM
54 plate renault clio 3rd brake light
by Mike72
Yesterday at 12:52 PM
Raspberry Pi in the classroom!
by FelixCowden
30th Nov 2016 9:27pm
Wirral TUC Meeting re Update on Wallasey CLP Suspe
by RUDEBOX
30th Nov 2016 9:16pm
World Aids Day Event 2016. Liverpool
by RUDEBOX
30th Nov 2016 9:05pm
For Sale & Free
Steam Train Money Box/Ornaments
by Tranquil
Yesterday at 11:32 AM
Childs LFC Bike 5 - 8 Yr old
by Pete_M
Yesterday at 01:10 AM
Cat related Collectables
by Tranquil
29th Nov 2016 4:48pm
original xbox
by vw_kyle
27th Nov 2016 8:17pm
anything with castors
by lincle
27th Nov 2016 4:06pm
Featured Member
Registered: 2nd Nov 2011
Posts: 2346
Newest Members
uptonvillage, NobbyHunt, sam1512, ant72, benjamin17
12131 Registered Users
Today's Birthdays
No Birthdays
New Wirral Info
Wirral Globe
by locomotive
Yesterday at 06:25 PM
Wirral TUC Meeting re Update on Wallasey CLP Suspe
by RUDEBOX
30th Nov 2016 9:16pm
World Aids Day Event 2016. Liverpool
by RUDEBOX
30th Nov 2016 9:05pm
A job. Company not named.
by venice
30th Nov 2016 6:30pm
Santa's Grotto at Tam O'Shanter 11th Dec.
by Greenwood
29th Nov 2016 1:44pm
News : New Topics
Pensby Hotel
by granny
29th Nov 2016 6:39pm
Paul Nuttall Elected UKIP leader
by granny
28th Nov 2016 12:03pm
Disgusting surely not legal creamfields noise !!@
by svenlock68
27th Nov 2016 8:25am
Paying for EU Citizenship (Poll)
by diggingdeeper
26th Nov 2016 12:35pm
Footballers--Abused
by fish5133
25th Nov 2016 3:46pm
New Enthusiast Forums
54 plate renault clio 3rd brake light
by Mike72
Yesterday at 12:52 PM
Raspberry Pi in the classroom!
by FelixCowden
30th Nov 2016 9:27pm
crop loss & water rationing in Dominican Republic
by FelixCowden
30th Nov 2016 8:46pm
PC Repair needed
by TudorBlue
29th Nov 2016 2:54pm
Sports Personality Of The Year
by fish5133
29th Nov 2016 12:32am
(Views 24hrs)Trending Newest Topics
We dont learn much. 42
Daft funny joke 9
Wirral Sunrise Sunset
Sunrise Fri 8:08am
Sunset Fri 3:56pm
Local Time Fri 7:48pm
WikiWirral Can . . . .
Advertising Click me
To Advertise with
Wikiwirral Click Me