Form to export data and .....

[wannabepro]

Hi,

I am new, as you can see this is my first post. I have been reading different posts, but couldn't find a solution to my problem. Actually, I have created a table and around five forms, now each form is connected with that table. I can input the information through those forms into the table, now the only problem is this I want to transfer the information into differnt forms using the combo drop down menu, when the selection will be made it will transfer the information into the other or it will freez it into that form.

for e.g. I have made new, active, deal etc forms, I have made a drop down menu using combo which has these options in it as these are not only the forms name they are processes too. As the new deal comes in, it will be kept into new process for 30 days, after 30 days it should be moved to deal forms automatically, how would that be possible. And I want that to be frozen in that form. Other question is, how is it possible to hide the table from users, that they wont be able to make changes into table. Third question, once the info is inputed into the form no user should be able to delete that or overwrite it. And my last question is in regards to security, how is it possible to keep one user login into the database at one time, so no other user can login into that database or make changes.

I would really appreciate your help.

I hope I haven't conufused you guys.

Thanks

 

[WayneRyan]

wannabe,

That's a lot of questions!

For your first part; You control which records your different
forms require by using queries. You can use the Date fields
in your table (maybe a status field too) to include/exclude
records using the Criteria section of the query.


You can hide the database window. Use the Search Facility
here and look for "hide and window" or "hide and database".

To control the user's access to data, you can launch forms
in read-only or append-only mode.

To get exclusive access for a single-user, launch Access with
the /EXCL switch.

wAYNE

 

[wannabepro]

Okay, I understood most of it. I am still stuck on one question how can I make my forms only one time useable, meaning once they enter the info and move to second page the first page should become frozen so they can not rewrite the information. Because, right now I can enter the information on the pages over and over again and its erasing the previous info and adding new to the table.

I tried making the query, you have to be patient with me, actually I have worked in table forms and reports, and never touched the query section during my school years and this is my first job doing this assignment. I did make the query however its not something I want it to be. I want this page to show one month a head. Now for that I want the data from new form to move into deal form after 31 days be there until someone change its status. It should only happen to only that data which has been input 31 days ago in new forms. I don't know if I am making any sense here. hopefully I am.

And thank you so much for previous help, much appreciated.

 

[wannabepro]

i have taken care of security somehow but still confused about above questions.

 

[WayneRyan]

wannabe,

As for the form's mode, when you open the form use the DataMode
setting:

DoCmd.OpenForm "YourForm", , , , acFormAdd

The above only lets you add records, other values are readonly, etc.

As for the queries. Assume that you table has a date called DateEntered
and a status (Open, Closed).

Your query should obviously include the appropriate table and columns.
At the bottom of the query grid is the Criteria section.

Under DateEntered:

Date() Between [DateEntered] And DateAdd("d", 30, "[DateEntered]")

Under Status:

= "Open"

That way your query will include all "Open" records entered where today's
date is between the date entered and the date entered plus 30 days.

Wayne

 

[wannabepro]

data type mismatch in criteria expression, this is the error I am getting whenever I try to use the query. What should I do now.

Sorry, I know I am bugging you way too much


I tried the expression in datamod its not solving the problem either.

 

[WayneRyan]

Wannabe,

What is giving the error? Can you post the criteria?

Wayne

 

[wannabepro]

I have attached the pic of it, it moves from recieved date to another column 'ur given expression'. And then whenever I click on the query it gives me the upper given error message.

I have locked the page that no one can make the entry again, but the only problem which remains is that now all the objects on the record are locked and I can not make changes to pull down menu. Its interesting while keeping me confused. Thanx for all the help