help changing a database

[Alleycat]

Hi everyone,


I have a database that was created for me at my job. I am having trouble
contacting the person that helped create this database and was hoping I can
get someone here to help me out.

The database is a phone log that our sales people use to keep track of their
incoming and outgoing calls. The fields in the main form consist of the
following:

Discard button
Caller field
Company field
Sales Person field
Status field
Notes field

As the sales person inputs the information, the form automatically shows the
next record to input new information into. This allows the sales person to
scroll up and down to view or edit those records inputted on that day.
However, the way that it was set up is such that you can only view todays
records. If the sales person wanted to view a record from yesterday, he
can't. I want to change it so that the sales people can go back to previous
records (last weeks, months, etc.) Also, because the database is secured,
when the sales person opens it, he/she cannot minimize the database. The
alt+tab option would need to be used in order to toggle between programs. I
would like to make it so that the databes can be minimized just like any
other program.

I greatly appreciate any assistance from this group. I've had great success
before... and have also experience not so great success... hopefully this
time will be one of those "great" times.

Thanks all for your help! And if you need any further information, please
let me know.... especially since I'm not really well versed with the rules
of this group... not to mention access databases (in depth that is).

Regards,
Carolyn

 

[Alleycat]

Hi everyone,

 

[Dave]

too many questions.. to start... you say it's 'secured', can you get to the
screen that shows you the tables, forms, queries, etc?? can you access the
design view of the form they use to enter data?

 

[Alleycat]

Hi Dave,

Yes, I can get to the screen the shows me the tables, etc. I know how to
bypass the security. I've tried looking in the code (the modules) to see if
there was anything in there that might have something to do with the
minimize/maximize option. But I haven't had much success.

Any ideas? Thanks for your response!

Carolyn

 

[Dave]

i don't know of a way to maximize the access window itself directly. you
can do it easily with the forms and reports within access, but they just
maximize to fill the access window. i can think of at least two ways to
force the access window to maximize from code, one with sendkeys that could
be pointed at the main window to bring up the system menu and maximize it,
the sequence to look for would be alt-space, alt-x. another might be to
call a windows api function directly to maximize the main window.