WikiWirral values you and your opinion.
Forum Stats
12254 Members
65 Forums
72900 Topics
982774 Posts
55 posts in the last 24hrs
Max Online: 7831 @ 8th Apr 2013 4:18pm
Who's Online - Click Me
83 registered (alan128, 15 invisible), 1890 Guests and 336 Spiders online.
Key: Admin, Global Mod, Mod
Social Media : Follow Us


(Views 7days)This Weeks Most Read
Boom : New Ferry Explosion 2434
Incident at Westminster 1682
Offset number plates 551
Death at Leasowe Train Station 419
Huge Gas Explosion in New Ferry Sat 25/03/17 401
What does this all mean? 272
Planet Earth Tonight 266
Has Talktalk been hacked yet again? 237
Snowhite's Bird Rescue 202
Reclaimed floorboards needed. 195
New General Forums
hi
by norma67
26th Mar 2017 7:42pm
Clocks go Forward
by Mark
25th Mar 2017 3:01pm
Mannequin Challenge AKA MRI Scan
by fish5133
24th Mar 2017 11:20am
Surely the most honest add.....
by buddy
20th Mar 2017 5:43pm
New Wirral History
William Bernard's building, Birkenhead
by yoller
20th Mar 2017 4:27pm
1882 Plan of the borough of Birkenhead and Wards
by Dave_Wood
19th Mar 2017 11:57am
New Brighton Coop
by Mike_White
9th Mar 2017 12:48pm
Tranmere High School for Girls 1882 Chesnut Grove
by sarah708
6th Mar 2017 8:23pm
Whetstone Lane, Birkenhead
by MoretonExpat
6th Mar 2017 8:04am
Forum Tips
Photo Gallery Forums
Birkenhead Transport Museum 24th Feb 2017
fireworks on the Mersey last night
Topic Replies
Will It Work For You
by casper
hi
by Dilly
11:36 PM
'March' Photo Competition.
by snowshoes
10:58 PM
Boom : New Ferry Explosion
by fish5133
08:27 PM
It's Broken : Forum Update
by Mark
08:13 PM
Prescriptions
by diggingdeeper
06:55 PM
Death at Leasowe Train Station
by fish5133
27th Mar 2017 11:12pm
What song are you listening to?
by Vanmanone
27th Mar 2017 3:50pm
Huge Gas Explosion in New Ferry Sat 25/03/17
by venice
27th Mar 2017 1:18pm
March
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 ?
Planet Earth Tonight
by Excoriator
26th Mar 2017 10:31am
Lee and Cragg Quarries - Bacup
by Mark
23rd Mar 2017 7:43am
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......

* * * vipstudios.co.uk - Photographic Studios * * *
Now Advertise with WikiWirral.
WikiWirral stats 35,000 Page Views a Day +500 Search Engines.. Click Me
#844050 - 16th Dec 2013 3:42pm Re: Access 2003 help [Re: Willo_]
Mark Online   Reading


Wiki Master

Registered: 9th Nov 2003
Posts: 21031
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: 679
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: 1866
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: 21031
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: 1866
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
Will It Work For You
by granny
08:26 AM
Death at Leasowe Train Station
by Mark
27th Mar 2017 10:02pm
KEYS found
by rocks
26th Mar 2017 11:48pm
hi
by norma67
26th Mar 2017 7:42pm
Huge Gas Explosion in New Ferry Sat 25/03/17
by Dogwalker59
26th Mar 2017 10:36am
For Sale & Free
boxed 10 inch tablet for sale
by stumpyduck
26th Mar 2017 7:12pm
various fly reels and boxes of fly's
by brady
25th Mar 2017 10:48am
Challenge extreme angle grinder used once
by brady
25th Mar 2017 10:43am
White Hyundai I30, 2011 plate For sale, 1.4 petrol
by goodoldphil
24th Mar 2017 6:24pm
I am having a clear out!
by TheComputerLab
24th Mar 2017 4:01pm
Featured Member
Registered: 21st Jan 2010
Posts: 837
Newest Members
BoilerEngineer, flipmodefly, Noize, cartoonhead, shelleyc1990
12254 Registered Users
Today's Birthdays
No Birthdays
New Wirral Info
Planet Earth Tonight
by granny
25th Mar 2017 11:50am
Reclaimed floorboards needed.
by Gold_Moon
25th Mar 2017 10:45am
Has Talktalk been hacked yet again?
by Habdab
24th Mar 2017 10:25am
What does this all mean?
by venice
22nd Mar 2017 12:20pm
black contiboard locally?
by fish5133
21st Mar 2017 9:30pm
News : New Topics
Death at Leasowe Train Station
by Mark
27th Mar 2017 10:02pm
KEYS found
by rocks
26th Mar 2017 11:48pm
Another Terrorist Attack ? -London Islington
by fish5133
26th Mar 2017 3:03pm
Huge Gas Explosion in New Ferry Sat 25/03/17
by Dogwalker59
26th Mar 2017 10:36am
Boom : New Ferry Explosion
by diggingdeeper
25th Mar 2017 9:39pm
New Enthusiast Forums
Will It Work For You
by granny
08:26 AM
Snowhite's Bird Rescue
by diggingdeeper
26th Mar 2017 2:44am
Offset number plates
by venice
23rd Mar 2017 1:24am
File too large
by Dilly
20th Mar 2017 10:41am
ford focus 1.6 t reg rattling
by Little_B
19th Mar 2017 11:02pm
(Views 24hrs)Trending Newest Topics
Will It Work For You 12
Wirral Sunrise Sunset
Sunrise Wed 6:50am
Sunset Wed 7:42pm
Local Time Wed 10:14am
WikiWirral Can . . . .