Hi,
I need to add secruity to my database.
I would have just a Database Password, except this gives all users admin rights.
There are going to be 2 types of users
Admin and Read-Only
I was going to use User-Level Secruity Wizard to create this except i am under the impression that this means that you cant copy the database and drop it in diferent folders etc.
...
bhcob1
Last Activity: Feb 23 '07, 01:09 AM
Joined: Feb 2 '07
Location:
-
User-Level secruity help
-
The 2 fields that are being updated are locked = True, before the Dlookup updates them, i have now set made a change where before the Dlookup i set locked to false, then back to true after it has been updated.
It seems to be working so far, i havene't seen the error since i made that change, and i usually see it quite frequently.
Thanks Mary
...Code:Private Sub Form_Current()
-
Thanks for your help Mary.
It does not occur on any particular field or on any particular record. But I am now most certain it is occuring because of the code below
...Code:If (fStatus = True) Then Else: ' This code automatically finds the NQO's for the Substantiation File from the requirements table ' variable used to retrieve data fromLeave a comment:
-
The error message pops up with an OK and HELP button, so i dont get to see the code.
I have to delete the entry i just tried and exit the form to get it working again.Leave a comment:
-
Update or CancelUpdate without AddNew or Edit
Hey guys,
'Update or CancelUpdate without AddNew or Edit'
On my database i keep occasionly get this error when i try and edit a field, it is not everytime. It will be working fine and then this error appears. I will be editing records and then a random one will get the error.
A bit of background on my form, this will seem a bit lengthy but here is my code.
The form has a navigation list... -
Lookup Value loop
Hi guys,
This is the situation.
I have 3 tables, with the following relevent fields
tblSubFile (Substantiation Files)
[ID] - autonumber
[Reference Number] - Primary Key
[Issue] - Primary Key
[Relevant NQO]
tblReqAndSubFil e (Shows relationships between Substantiation Files and Requirements)
[Requirement ID] - Primary Key
[Reference Number] - Primary Key... -
Thanks guys, LEFT JOIN worked great. Just what I was looking forLeave a comment:
-
Query for related tables
I have 2 tables, related between the fields 'field1' and 'field2'
tbl1
- field1
- field2
tbl2
- field3
- field4
I want to run a query so that it displays 4 columns (1 for each field), and displays all the records from tbl1 and if that record is related to a record in tbl2 to display the remaining 2 fields. Else, if there is no related record in tbl2, to leave the last 2 columns blank... -
Thanks for that, very helpfulLeave a comment:
-
Find Field Data Type in VBA
I have a list which is populated with Fields from a table, I want to be able to determine if the data type of the value selected in the list is Number. Any ideas, i thought there would be something along the lines of
Me!lstQueryCrit eria.Datatype, but my results turned up no dice.
The reason I wish to do this is, because I am creating a query in VBA and in the Where clause I use IN, and it is giving me a datatype mismatch... -
Pivot Tables
Hi guys,
I need to create a Pivot Table on my database, I don't know much about them. I want the user to be able to direct themselves from my main switchboard (via a cmd button) to the pivot table. Where is it best to create a pivot table VBA, Form, Page... I would like the Pivot Table to not save the users changes but instead open up as a defualt that i set.
So I guess my question is, where is the best place to create... -
I have tried all your suggestions and none work, the caption property is not even recognised.
I believe it has something to the with where the code is (the event), as i have the exact same code for the on load event and it works perfectly.Leave a comment:
-
I have deduced that the error is being cause in the following code as suggested:
...Code:Private Sub Form_AfterDelConfirm(Status As Integer) 'Refresh Form after a record has been deleted (updates lists) DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70 ' Updates the counter after record deletion, counts distinct Deviation numbers Me!lblDeviationCount = "(" & DCount("*",Leave a comment:
-
Microsoft Access can't find the field 'I' referred to in your expression
Hi, Whenever I delete a record my command button, the record deletes, a list displaying all records is updated and then a message box appears:
Microsoft Access can't find the field 'I' referred to in your expression
It only has the option of clicking 'OK', when I do this everything is fine again.
I would like to know what is going on and how to fix this problem. Below is parts of the code that I believe the problem... -
Sorry for the misunderstandin g, my initial post was not very clear.
What I want to do is display the total number of records with a distinct value.
Below is the table tblCSOC, from this table there are 9 records, and 5 distinct [CSOC Number], I would like the label to always display 5, so the user always knows how many CSOCs have been put into the database
...Code:CSOC Number Issue 10303 1
Leave a comment:
-
Count Distinct Access 2000
Hi guys,
I have access 2000, I have a form frmCSOC, with a field [CSOC Number] that can have duplicates, I want a label to display how many records there are with DISTINCT [CSOC Number] values.
I have heard that the DISTINCT keyword does not work on Acc2000.
Thanks Guys -
Thanks for that Nico, your code will do me just fine and save me pulling my hair out.
CheersLeave a comment:
-
Update records
Hey Guys,
I have a db, with a table tblCSOC, there are 4 fields that are releveatn to my question:
tblCSOC
[CSOC Number] - primary key
[Issue] - primary key
[Latest Issue] - checkbox
[ID] - autonumber
The autonumber key was created so i could uniuqly identify each record.
I want a button...
No activity results to display
Leave a comment: