My first access database, a couple of questions

[jh_]

Hi all,
I've played a bit with MS Access 2003 the last week. I've made a form wich should contain information about stores (phone numbers, locations e.g.).

I'm trying to imagine myself (what could be a real) scenario, that way it's easier to give myself practice and tasks

As I'm new to MS Access, I'd like you to take a look at my forms. I want to know if there's better ways to do what I have done, and if I have done something wrong.


I also got a couple of questions;

1. Lets say I want to print one post by clicking on a button, is that hard to implement?
2. Is it possible to make a button, which exports the form to an .xls -file by clicking on it?
3. I did make these forms on a computer that had the resolution to 1280/1024, when I tried to open the form on a computer with 1024/768 resolution, the forms won't be displayed in the center of the screen

I think that's all.. Thanks!

Here's the access -file (180kB) (use winrar to extract it)
I've tried to transalate to forms into english, sorry for the bad english

 

[Smart]

I did make these forms on a computer that had the resolution to 1280/1024, when I tried to open the form on a computer with 1024/768 resolution, the forms won't be displayed in the center of the screen

design your form
on the form properties choose the format tab then change the auto center option to yes

 

[jh_]

I did make these forms on a computer that had the resolution to 1280/1024, when I tried to open the form on a computer with 1024/768 resolution, the forms won't be displayed in the center of the screen

design your form
on the form properties choose the format tab then change the auto center option to yes

Hi there,
First of all; by reading through previous posts on the forum, I've found the solution to question 1 and 2. I created a report, which automaticly opens on the active post i'm in on the form when I hit a button, and from there I can print it That way I don't need to export it to excel at all

About question 3; I already had the autocenter -option set to 'Yes', but it doesn't seem to work for me. Maybe it has something to do with my macro, that sets the size on the forms..? Or, is it possible to enter a command in the macro that center's the form?