Search results

if they see tables they can simply change data. Is there a way that we make the “option” to be out of reach of the user or make it password protected? I want the user to be restricted to work through forms and buttons.

well, difficult is not enough. i need it totally blocked and accessible only by the owner or admin. I have already made my file and now i see how insecure is MS Access. is there a way that i change my file into another DB program, such as "oracle" or " file maker"? i dont know much DB programs...

is there a way to securely block the access of user to tables/queries, else in Microsoft Access? thank you

the main access file is located in one PC. Three other users are connected to that PC. So they log into their own machine, then get the file by pc-pc connection through a modem/router.

i found it. thank you. i couldn't find out where i should put that code. is it for the log in form? let me explain that there is not a network here. there is a single access file to which different users are logged in. after that, will every document be issued and recorded in the name of the...

There is a DB with many forms and reports on which multiple employees are going to work. Is there an easy way to prompt each employee to enter his/her own password to be able to open the database? Since it is important to record who has put data in forms, a column is designated to record the...

thank you, so for the first( main) table, how I can design the invoicenumber field so that it puts numbers automatically, increase sequentially, and unique for a set of orders like the above example?

that you guys, i think i have lost the subject. i have put a new pots. i appreciate your help.

I am selling some products, namely A to M. I record the orders of costumers in a table, named "orders". Can we assign a unique number, named invoicenumber here, for each set of orders that a costumer puts? Please see this table: ID costumer product quantity unitprice orderdate...

where can i see this demo?

I mean, in the above example, there should be a number, 13896 for example, assigned to orderID from 12 to 17. If another costumer make orders with orderID from 18 to 21, we will have 13897 as the assigned number. how do you think we can do that?

I am selling some products, namely A to M. I record the orders of costumers in a table, named "orders". For example, if costumer "Jack" has ordered as the following: ID costumer product quantity unitprice orderdate 12 jack A 4 10 25/11/2014...

thank you, shall i put this in the criteria of the query?

We make a criteria in a query to get data from from1 like: [forms]![form1]![text1]. This requires us to have the Form1 open and there should be a data in Text1. Can we make the criteria to either take the data from Form1 like the above, or if Form1 is not open it gets data for the criteria from...

There is a query named query1, which has a column named “salary”. We also have a form with a textbox named “payements”. Can we design the form so that when it is loaded the textbox named payments gets the sum of column salary of query1? I mean: “payments” in form textbox = sum of “salary”...

There is a table named “ student_score” like the following: ID studentname score subject 12 jack A Biology 13 jack c politics 14 jack B math 15 jack A...

I have made a report, to list the employee data as the main report. In one field the employee salary is mentioned. At the end of the field the sum of all employee salaries is shown in a box. I put a subreport to list the Managers and in one column their salary is shown, with the related sum at...

thank you. it is now ok :)

normally the forms are listed in left pane where i can choose and then write a code.

I’m using Microsoft office 2013. I create a new access file: MYFILE. A new table, TABLE1. Then I make a form over that: FORM1. Then I go to DATABASE TOOLS and then click “visual basic” to see the list of projects. But there is nothing there. I mean the names of forms are not even listed on the...