Re: access 2003

Is there a text version of the options regarding implementing system security
in access 2003. I assumed the best plan is to load the converted or new
databases (data & program) then set up the security. The data will go on the
server and the program database will go on each workstation. IE,
administorator and user with login and password or just not allow changes on
the forms, queries, reports, etc and forget the login password, etc.

Suggestions or pointing me toward text to read will be greatly appreciated.
There is a lot of material available but nothing replaces experience.

Regards,
doglover

"doglover" wrote:

Sorry for the dealy it has been a very hectic two weeks with other
commitments that are not computer related.

You nailed the problem regarding the filter issue and relalized the hidden
parameter in the query "qryWorkOrders_uninvoiced."

I commented the line of code in the "Open Event" on the form
"Me.FilterOn=True" per Microsoft's instructions. For now, there do not seem
to be any related issues with the commenting of this code. However, the
"ChooseJob_AfterUpdate Event" uses this filter "Me.FilterOn = False" before
the Me.Requery portion of this event.

My help with the conversion of the project is volunteer as I made a 360
degree career change a few years ago ... most likely I am not current on all
of the changes that affect Access 2003 from Access 97.

I will continue to post information that relates to this project as received.

Thank you for your time, knowledge, interest, and help with this enormously
time consuming project.
Regards,
doglover






"Geoff" wrote:

All is clear after a sleep!
No doubt you realised that the parameters are in "qryWordOrders_uninvoiced",
so are hidden from the code below. I didn't see it, working from this
distance without the database. Another good learning experience!
Regards
Geoff

I do now believe that your following code is very suspicious:

Set qd = db.CreateQueryDef("", "SELECT wrkky_invno FROM
qryWorkOrders_uninvoiced WHERE wrkky_invno = true;")
qd![Forms!frmInvoiceSelect!ChooseCust] = Me!ChooseCust
qd![Forms!frmInvoiceSelect!ChooseJob] = Me!ChooseJob

The SELECT clause and WHERE clause do not contain the required parameters:

[Forms!frmInvoiceSelect!ChooseCust]
[Forms!frmInvoiceSelect!ChooseJob]





.

Loading