Hello,
I am developing an access 2013 database and I would like to create user permission level. I have all users listed in a table as:
strUserID strPassword strName strUserLevel
How can I assign permission to each user category to either edit rights or no edit rights?
I have searched for codes with no success.
Please help
Stoic
Last Activity: Aug 18 '19, 09:22 PM
Joined: Jun 25 '12
Location: Monrovia, Montserrado, Liberia
-
Give permission to user
-
@twinnyfo I thought to just use one column to represent the in and out but I would like to show them in separate columns as double entry. If there is another way to separate the entries into two columns in a query, that will also be helpful. If also the coding can be done in a report, that will also be helpful.
The query is based on the two tables - tblTransaction and tblStockCard and the only code used there is with the runtot which... -
Running total based on two columns
Hi,
I know there are lots of answers provided on here regarding running total, however, I have not seen the specific answer to what I need for my database.
Now, I have a database built in access 2013. In my database, I have two tables (tblTransaction and tblStockCard).
The tblTransaction table holds all the +- transactions while the tblStockCard holds the list of items in stock with their opening balances. The tblTransaction... -
Thanks Phil, I got is sorted out.Leave a comment:
-
generate report based on date range
Hi everyone,
I have an Access database with a table and a date field, and I also have a report for this table. I am getting error from my code on getting the exact date range I need to be generated from the table into the report.
Here is my code:
...Code:Private Sub cmdDateRange_Click() On Error GoTo Err_Handler 'Remove the single quote from start of this line once you have it working. 'Purpose: Filter a report -
I am sorry if I confused you, my first question stands. I was only trying to clarify what I meant. Yes, I have the combo boxes label as cboCounty,cboPr ogram, cboProgram ... each of these combo has a dropdown for selection. I have placed a control button to query base on what I select from the combos. that is working perfectly if I make selection from all three combo, but if I make selection from only one combo box, the button does nothing. So...Leave a comment:
-
Thanks zmbd,
I don't seem to catch the option. Can you explain further. My mind is, using one control button that functions/queries multiple selections.Leave a comment:
-
Use a single control to query more fields or combo boxes
Hi,
I have a database with tables and fields. I have created a form that with three to four combo boxes and inserted a control button.
I would like a write a code to query my data based on the selection(s) made from the combo boxes when I click the command button.
I have this code and it is working perfectly well, only that I have created multiple command button to perform the queries I need.
Here is what I... -
linking field from main form to sub form
Hi,
I have an entry form with a field(combo box) called cboGetCode. I also have a sub form (continuous form) with number of fields, also an entry form. Now, I have added a code behind the cboGetCode AfterUpdate event to populate the result to relevant fields in the main form.
...Code:Me.lngSCode = DLookup("[lngSchoolCode]", "[qrReadingFirstSchools]", "[lngSchoolCode]='" & Me.cboGetCode & -
Interesting! I will look it up. ThanksLeave a comment:
-
Adding data to Access database from html
Hi,
I have an Assess Database developed in Office 2007. Now, I would like to share forms(data entry form) with entry clerks using other computers to input data while I monitor their entries into my access tables. I have tried to put the access database on the network for entry clerks to enter data, but it is not working. I have developed some HTML forms, and would like a code in ASP to perfom the logic and get the data entered into the html... -
Thanks guys, but your suggestions are not working.Leave a comment:
-
Thanks, I will try the flag.
Thanks...Leave a comment:
-
Thanks, the user table is hidden and has a security feature as well. For storing, I have two fields (userId and userpassword). Only the administrator has access to changing password and most of the functions are disabled.
Can you send me the process of flaging in a global variable; I am sure that would help. I was also wondering if it is possible run a code to lookup a username from the user table.
Thanks...Leave a comment:
-
Database User Name Displayed on Welcome Form
Hi,
I have an Assess 2007 database with a user table. This table holds database user names and user passwords an entry permission to the database. I also have a welcome form that activates when user enters the database using either of the user names and user password in the user table. Now, I would like to display the database user name (NOT THE SYSTEM USER NAME] on the welcome form of the user that enters the database.
I do not currently... -
My mind is that if I can get the Saturdays and Sundays done, I can as well do the holidays. thanks.Leave a comment:
-
Calculating Leave days
Hi,
I am working on a project using Access 2010. I have a Leave table with startdate and enddate fields. I have a query to calculate the total days taken. I would like for the query to subtract the Saturdays and Sundays from the leave days if there are.
Can Thanks for your assistance -
Oh pod, those are useful sites especially the first one. I believe after reading through, I will settle down on making a lot work for me.
Thanks so muchLeave a comment:
-
Thanks for responding to my entry, however, I will need to be an intermediate user and developer of ASP.NET before knowing exactly what you are referring to here.
I will keep you codes and study.Leave a comment:
-
Connecting MS Access to ASP.NET
Hi,
I am new to ASP.NET and I have started developing forms and tables, but I have been working extensively in Access and I would still like to maintain my access database.
Can anyone help me on how to connect my database to my asp form.
Thanks
No activity results to display
Leave a comment: