Hi..
I have created a simple db and only have 3 tables. They are not related.
I'm only using it as a basic inventory feature, as well as some history and quick look ups. I've been using several excel spreadsheets, but with a couple of other people in the dept saving them and making new ones all over the place, we've decided to give Access a try.
Here is where I'm at:
Table 1 - all devices in our company...including computers, printers, network switches, cameras, etc.
Table 2 - all software in our company. Titles, registration numbers, etc.
Table 3 - all Account information. Salesperson(s), phone numbers, email addresses, etc.
That's really all I'm after.
I have forms set up, and some basic queries that work fine for us.
I have one form that I call "MainPage" that opens at start up. (equal to the Switchboard function I'm assuming)
It has buttons to open each of the other 3 forms, in Edit, Read Only, or Add mode.
Each form has a few search buttons, that search by DeviceName, UserName, etc.
With that said, my first question is this:
1. How can I have the search buttons on the main page, instead of just on the form?
I'd really like to just click a button instead of opening the form first.
Thanks in advance for all the expert advice!
I have created a simple db and only have 3 tables. They are not related.
I'm only using it as a basic inventory feature, as well as some history and quick look ups. I've been using several excel spreadsheets, but with a couple of other people in the dept saving them and making new ones all over the place, we've decided to give Access a try.
Here is where I'm at:
Table 1 - all devices in our company...including computers, printers, network switches, cameras, etc.
Table 2 - all software in our company. Titles, registration numbers, etc.
Table 3 - all Account information. Salesperson(s), phone numbers, email addresses, etc.
That's really all I'm after.
I have forms set up, and some basic queries that work fine for us.
I have one form that I call "MainPage" that opens at start up. (equal to the Switchboard function I'm assuming)
It has buttons to open each of the other 3 forms, in Edit, Read Only, or Add mode.
Each form has a few search buttons, that search by DeviceName, UserName, etc.
With that said, my first question is this:
1. How can I have the search buttons on the main page, instead of just on the form?
I'd really like to just click a button instead of opening the form first.
Thanks in advance for all the expert advice!