Welcome to WikiWirral, sharing is what we do best.
Forum Statistics
Forums65
Topics76,352
Posts1,033,280
Members14,560
Most Online16,551
Feb 2nd, 2024
Who's Online Now
12 members (ArranGirl13, 3 invisible), 7,899 guests, and 667 robots.
Key: Admin, Global Mod, Mod
Top Posters
sunnyside 45,164
MattLFC 22,315
Mark 21,269
granny 17,788
_Ste_ 16,345
Newest Members
Kalena1962, rattus, Lisrush, Emotecreative, ArranGirl13
14,560 Registered Users
New General Forums
New Wirral History
Tall Brick Chimneys
by diggingdeeper - 16th Mar 2024 11:56am
D.I.Y. / Building Shop
by mharford91 - 3rd Mar 2024 8:53pm
1970's Murder in Central Park, Wallasey
by cutespam - 4th Aug 2018 10:28am
Old Hall in Higher Bebington
by Rhoobarb - 25th May 2010 5:55pm
Oleo Works
by Ducko - 14th May 2008 3:09pm
Top Posters(30 Days)
granny 14
casper 13
bri445 4
Topic Replies
Facial recognition coming in supermarkets?
by diggingdeeper - 27th Mar 2024 3:50pm
Bolts at Bebington Road
by diggingdeeper - 27th Mar 2024 2:33am
Hot Spot Chippie Broadway
by Excoriator - 26th Mar 2024 7:57pm
Tall Brick Chimneys
by diggingdeeper - 26th Mar 2024 5:43pm
Lost river (Well, brook really)
by diggingdeeper - 26th Mar 2024 3:09am
Old Hall in Higher Bebington
by diggingdeeper - 24th Mar 2024 5:58pm
Netflix 3 Body Problem.
by BultacoAstro - 22nd Mar 2024 8:04am
Wisper electric bike. 36v .
by Dilly - 21st Mar 2024 7:36pm
This is Elvis
by GingerTom - 21st Mar 2024 9:27am
March
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
Top Likes Received (30 Days)
Kylix 1
cools 1
Top Likes Received
bert1 14
Mark 4
granny 3
casper 3
Previous Thread
Next Thread
Print Thread
#844029 16th Dec 2013 1:45pm
Joined: Jul 2012
Posts: 2,518
Willo_ Offline OP
Forum Master
OP Offline
Forum Master
Joined: Jul 2012
Posts: 2,518
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
Willo_ #844050 16th Dec 2013 3:42pm
Joined: Nov 2003
Posts: 21,269
Likes: 4
Wiki Master
Online Happy
Wiki Master
Joined: Nov 2003
Posts: 21,269
Likes: 4
Dont you have to complie it as an exe ?

Or

Preferences. Its been a while since ive done access. doh learn

Willo_ #844123 16th Dec 2013 8:45pm
Joined: Jan 2009
Posts: 10
Newbeee
Offline
Newbeee
Joined: Jan 2009
Posts: 10
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.

Willo_ #844381 18th Dec 2013 1:12pm
Joined: Jan 2010
Posts: 21
Newbeee
Offline
Newbeee
Joined: Jan 2010
Posts: 21
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!

Willo_ #844384 18th Dec 2013 1:18pm
Joined: Aug 2011
Posts: 750
Veteran
Offline
Veteran
Joined: Aug 2011
Posts: 750
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

Joined: Jul 2012
Posts: 2,518
Willo_ Offline OP
Forum Master
OP Offline
Forum Master
Joined: Jul 2012
Posts: 2,518
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

Willo_ #852191 21st Jan 2014 12:00pm
Joined: Jul 2012
Posts: 2,518
Willo_ Offline OP
Forum Master
OP Offline
Forum Master
Joined: Jul 2012
Posts: 2,518
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.

Willo_ #852203 21st Jan 2014 2:31pm
Joined: Nov 2011
Posts: 1,925
Forum Addict
Offline
Forum Addict
Joined: Nov 2011
Posts: 1,925
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!)

Willo_ #852206 21st Jan 2014 2:42pm
Joined: Nov 2003
Posts: 21,269
Likes: 4
Wiki Master
Online Happy
Wiki Master
Joined: Nov 2003
Posts: 21,269
Likes: 4
Close Access !
ReStart Access

A daft one but could force it too look at the form again.

Mark #852213 21st Jan 2014 2:48pm
Joined: Jul 2012
Posts: 2,518
Willo_ Offline OP
Forum Master
OP Offline
Forum Master
Joined: Jul 2012
Posts: 2,518
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.

Willo_ #852290 21st Jan 2014 6:37pm
Joined: Nov 2011
Posts: 1,925
Forum Addict
Offline
Forum Addict
Joined: Nov 2011
Posts: 1,925
smirk sorry i couldn't be more help

all i have to say is GOOD LUCK!

j_demo #852475 22nd Jan 2014 11:37am
Joined: Jul 2012
Posts: 2,518
Willo_ Offline OP
Forum Master
OP Offline
Forum Master
Joined: Jul 2012
Posts: 2,518
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 

Link Copied to Clipboard
Random Wirral Images

Click to View Topic.
Newest Topics
Facial recognition coming in supermarkets?
by Excoriator - 27th Mar 2024 10:52am
Hot Spot Chippie Broadway
by Excoriator - 26th Mar 2024 7:57pm
Bolts at Bebington Road
by Excoriator - 23rd Mar 2024 9:48am
Netflix 3 Body Problem.
by BultacoAstro - 22nd Mar 2024 8:04am
Tall Brick Chimneys
by diggingdeeper - 16th Mar 2024 11:56am
For Sale & Free
Wisper electric bike. 36v .
by Dilly - 21st Mar 2024 7:36pm
This is Elvis
by GingerTom - 17th Mar 2024 2:37pm
Member Spotlight
Dilly
Dilly
wallasey
Posts: 8,973
Joined: July 2011
Today's Birthdays
There are no members with birthdays on this day.
New Wirral Info
Facial recognition coming in supermarkets?
by Excoriator - 27th Mar 2024 10:52am
Hot Spot Chippie Broadway
by Excoriator - 26th Mar 2024 7:57pm
Bolts at Bebington Road
by Excoriator - 23rd Mar 2024 9:48am
Get your Money Tree ready
by keef666 - 22nd Mar 2023 12:27pm
Restaurant/pub with outdoor seating - Bromborough
by CarterUSM - 7th Aug 2020 7:59pm
News : New Topics
Gaza
by diggingdeeper - 29th Oct 2023 9:28am
Lost river (Well, brook really)
by Excoriator - 10th Sep 2019 8:50am
New Enthusiast Forums
Netflix 3 Body Problem.
by BultacoAstro - 22nd Mar 2024 8:04am
Xbox
by TudorBlue - 3rd Mar 2024 8:48pm
Wiper mechanism needed
by Peter0787 - 20th Feb 2024 4:07pm
Popular Topics(Views)
5,067,821 WIKI WALK CHAT
4,013,750 Spotted!
Powered by UBB.threads™ PHP Forum Software 7.7.5