|
Forums65
Topics76,460
Posts1,033,932
Members14,835
| |
Most Online44,182
Mar 18th, 2025
|
|
|
11 members (Alanbentley, 3 invisible),
8,350
guests, and
610
robots. |
|
Key:
Admin,
Global Mod,
Mod
|
|
|
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
|
|
|
|
|
|
|
|
Joined: Jul 2012
Posts: 2,518
Forum Master
|
OP
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.
|
|
|
|
|
Joined: Nov 2003
Posts: 21,269 Likes: 4
Wiki Master
|
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.  
|
|
|
|
|
Joined: Jan 2009
Posts: 10
Newbeee
|
|
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.
|
|
|
|
|
Joined: Jan 2010
Posts: 21
Newbeee
|
|
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!
|
|
|
|
|
Joined: Aug 2011
Posts: 750
Veteran
|
|
Veteran
Joined: Aug 2011
Posts: 750 |
Been a while since I did it, tried this seemed to work fine  '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
Forum Master
|
|
OP
Forum Master
Joined: Jul 2012
Posts: 2,518 |
Been a while since I did it, tried this seemed to work fine 'Tools' -> 'Startup' -> 'Display Form/Page' (Choose your form you want to display on startup) -> Untick 'Display Database Window' Hope that helps Perfect, thank you. 
|
|
|
|
|
Joined: Jul 2012
Posts: 2,518
Forum Master
|
|
OP
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.
|
|
|
|
|
Joined: Nov 2011
Posts: 1,925
Forum Addict
|
|
Forum Addict
Joined: Nov 2011
Posts: 1,925 |
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!)
|
|
|
|
|
Joined: Nov 2003
Posts: 21,269 Likes: 4
Wiki Master
|
|
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.
|
|
|
|
|
Joined: Jul 2012
Posts: 2,518
Forum Master
|
|
OP
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.
|
|
|
|
|
Joined: Nov 2011
Posts: 1,925
Forum Addict
|
|
Forum Addict
Joined: Nov 2011
Posts: 1,925 |
 sorry i couldn't be more help all i have to say is GOOD LUCK!
|
|
|
|
|
Joined: Jul 2012
Posts: 2,518
Forum Master
|
|
OP
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.
|
|
|
Click to View Topic.
|
|
|
Posts: 131
Joined: March 2012
|
|
|
There are no members with birthdays on this day. |
|
|
|
