WikiWirral Wirral's Biggest Online Forum
Forum Stats
12221 Members
65 Forums
72731 Topics
980268 Posts
46 posts in the last 24hrs
Max Online: 7831 @ 8th Apr 2013 4:18pm
Who's Online - Click Me
87 registered (8HBob, 12 invisible), 1470 Guests and 184 Spiders online.
Key: Admin, Global Mod, Mod
Social Media : Follow Us


(Views 7days)This Weeks Most Read
Thousands raised for children of cancer couple. 461
On-street parking charges dropped 396
Ceiling needs smoothing 343
Patio work 225
TS Indefatigable 222
Hezballah 217
Sea Shepherd 203
Info? Bill Dobson, Photographer, Martins Bank 156
Lost ladies Swarovski watch 118
Re sizing 79
New General Forums
Am I missing something ?
by dizdazdoz
16th Feb 2017 12:46pm
Valentines Day---Help From The Ladies
by fish5133
10th Feb 2017 7:35pm
Happy BirthdaY
by Vanmanone
10th Feb 2017 2:51am
Warning!!!
by muzzy2
9th Feb 2017 9:09am
New Wirral History
Seeking old pictures of Egerton Street area, Birkenhead
by yoller
Yesterday at 07:53 PM
TS Indefatigable
by granny
18th Feb 2017 3:32pm
RIP : Chris Kay
by granny
31st Aug 2016 9:25am
Children's home on the Overchurch
by xleahx
26th Apr 2011 7:01pm
Stanlow Abbey
by ghostly1
4th Dec 2008 10:09pm
Forum Tips
Photo Gallery Forums
fireworks on the Mersey last night
Hadlow train station
Topic Replies
Patio work
by saltytom
Today at 07:02 AM
What song are you listening to?
by Vanmanone
Today at 02:59 AM
vet fees
by diggingdeeper
Today at 12:09 AM
Stanlow Abbey
by EportCat
Yesterday at 09:14 PM
Seeking old pictures of Egerton Street area, Birkenhead
by yoller
Yesterday at 07:53 PM
Tony Blair
by granny
Yesterday at 12:56 PM
Lion Salt Works/Weaver Hall Museum
by venice
Yesterday at 12:19 PM
Trump
by diggingdeeper
Yesterday at 09:56 AM
TS Indefatigable
by granny
18th Feb 2017 11:28pm
February
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
Recent Posts : What's On ?
Lion Salt Works/Weaver Hall Museum
by venice
Yesterday at 12:19 PM
Wirral TUC Meeting re Update on Wallasey CLP Suspe
by RUDEBOX
13th Feb 2017 8:50pm
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: 21011
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: 1851
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: 21011
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: 1851
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
vet fees
by eggandchips
Today at 12:01 AM
Seeking old pictures of Egerton Street area, Birkenhead
by yoller
Yesterday at 07:53 PM
Lion Salt Works/Weaver Hall Museum
by paxvobiscum
18th Feb 2017 9:19pm
Patio work
by steamfan
18th Feb 2017 3:45pm
TS Indefatigable
by granny
18th Feb 2017 3:32pm
For Sale & Free
Gaming pc
by Cjoshea
18th Feb 2017 9:47pm
ESCHENBACH Illuminated Magnifiers
by buddy
15th Feb 2017 1:12pm
Canon EOS 550D + lenses & more
by j_demo
14th Feb 2017 4:24pm
Samsung NC10 Notebook PC
by gerrymoore
14th Feb 2017 3:55pm
Suitcase...never used. 2 wheels and sliding handle
by gerrymoore
14th Feb 2017 3:51pm
Featured Member
Registered: 7th Dec 2010
Posts: 372
Newest Members
Vkj530, SunsetP, RachelBinns, Rog0137, Iestyn
12221 Registered Users
Today's Birthdays
No Birthdays
New Wirral Info
Lion Salt Works/Weaver Hall Museum
by paxvobiscum
18th Feb 2017 9:19pm
Patio work
by steamfan
18th Feb 2017 3:45pm
Ceiling needs smoothing
by yr20405
15th Feb 2017 1:52am
Info? Bill Dobson, Photographer, Martins Bank
by diggingdeeper
13th Feb 2017 12:10pm
War Museum
by missmahjong
12th Feb 2017 1:24pm
News : New Topics
Hezballah
by venice
17th Feb 2017 11:15am
On-street parking charges dropped
by oldpm01
15th Feb 2017 9:10am
Thousands raised for children of cancer couple.
by fish5133
13th Feb 2017 3:01pm
Lost ladies Swarovski watch
by spider
13th Feb 2017 10:36am
M53 closed in both directions between J2 and J3
by diggingdeeper
9th Feb 2017 10:00pm
New Enthusiast Forums
vet fees
by eggandchips
Today at 12:01 AM
Sea Shepherd
by venice
16th Feb 2017 1:06pm
Sounds of the Sixties
by paxvobiscum
11th Feb 2017 8:53pm
Hospital
by cools
10th Feb 2017 9:53am
X Box One S
by rossie
9th Feb 2017 8:56am
(Views 24hrs)Trending Newest Topics
vet fees 63
Seeking old pictures of Egerton Street area, Birkenhead 48
Wirral Sunrise Sunset
Sunrise Mon 7:18am
Sunset Mon 5:33pm
Local Time Mon 9:15am
WikiWirral Can . . . .