Report based on particular field

[Aleksandra]

Ok. Thanks.
One more: I found an example of database on the Internet, it was a .mde file and when you open it, all you can see is the Switchboard, no Access background.


How do you do that?

[aytee111]

Believe it or not, after all these years I am finally having to write a database that opens like that. Not quite sure yet how to accomplish it, especially with this new ribbon feature. You might just find a thread here from me one of these days!

[Aleksandra]

Ok. I won't even try

[Aleksandra]

I have a form with the button Add new record on it. How do I choose in which table it saves entered data?

[aytee111]

The table it is referring to is the record source of the form.

[Aleksandra]

Ok. Solved that. Is there a way I could disable marked parts in the picture?

[aytee111]

Form Properties:
Record Selectors=No
Navigation Buttons=No
Dividing Lines=No

Do them one at a time so that you see what each one represents.

[Aleksandra]

I made a form with few buttons on it and by clicking it you open new windows. I want those windows to be opened at the exact same place as the first form. The are the same size but they dont open like i would like to. I enabled Auto Center option, but is there something else I could do?

[aytee111]

Three ways:
1 - maximized - that would be in your open database section, usually on OnOpen of your first form, then all subsequent forms will open to the same size
2 - use tabs - set that in Options
3 - in OnOpen of the form, there is a DoCmd.MoveSize which allows you to set exact pixels for top, left, etc

[Aleksandra]

Ok, thank you, I used docmd.movesize and got I wanted.
Cheers!