changes in a database

[Alleycat]

Hi everyone,

I posted this in one other newsgroup but didn't receive any feedback or
response. Is there anyone here that can help me out? Please?

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

 

[Joan Wild]

Hi Carolyn,

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: snip

I want to change it so that
the sales people can go back to previous records (last weeks, months,

Open the form in design view and look at the RecordSource property. It is
likely a query. If you click on the build button (...) to the right it will
open the query in design view. You'll find there is some date field that
has a criteria of Date(). Just remove the criteria.

Also, because the database is secured, when the sales person
opens it, he/she cannot minimize the database.

That isn't because of security. Why can't they minimize the database? Is
there no minimize button, do they get an error? What happens?

 

[Alleycat]

Hi Joan,

You can't click on anything accept for the form. The minimize button is
there but the capability to minimize is gone and you cant click on the blue
bar at the top to minimize that way either. There are no errors.


I will try what you suggested.

Thank you so much for your help.

~ Carolyn

 

[Joan Wild]

Hi Joan,

You can't click on anything accept for the form. The minimize button
is there but the capability to minimize is gone and you cant click on
the blue bar at the top to minimize that way either. There are no
errors.

It sounds like there is code run at startup to hide the main Access window.
Perhaps this was used?
http://www.mvps.org/access/api/api0019.htm

You'd have to get into the startup code (could be in a form, or autoexec
macro) and disable this.

 

[Alleycat]

Hi Joan,

Thanks for the info... unfortunately I'm not having any success with this.
I'm not familiar with the code and really don't know what to look for and
where. I looked thru the modules that were created, but couldn't find
anything that looked like the code on the web link you sent me. Hmmm.... I'm
really not sure what I"m doing wrong here. Any other suggestions or ideas?
Where is the startup code located? The only macro is a "lock database"
macro. Could it be in there? Now my wheels are turning... but I"m not sure
how much they'll turn with the limited experience I have. Anyway, thanks
again for your help. I'm sure you've heard this before, but it is very much
appreciated!

Carolyn Schultze

 

[Joan Wild]

. Hmmm.... I'm really not sure what I"m doing wrong here. Any
other suggestions or ideas? Where is the startup code located?

It could be behind a form that is opened on startup - check in Tools,
Startup to see if there is a form set to do this - check the code behind
that form.

It could be an autoexec macro.

The
only macro is a "lock database" macro. Could it be in there?

That could be it - sounds promising. What are the actions in that macro?

It could be that this macro is called in one of the events of your opening
form.

Now my
wheels are turning... but I"m not sure how much they'll turn with the
limited experience I have. Anyway, thanks again for your help. I'm
sure you've heard this before, but it is very much appreciated!

You're welcome.