gina farrow
Last Activity: Feb 18 '11, 04:33 PM
Joined: Jan 23 '11
Location:
-
How to lock table and queries so user cant get into it?
I have a database that has over 30 users. I need to not only hide my tables and queries,but also lock the tables and queries? -
Wow! Your good! -
How to do a query on data type memo?
I keep getting a message," syntax in your sub query is incorrect". For the following code:
SELECT IIf(IsNull([Answer]);"No";"Yes") AS [Answered?]; Count(IIf(IsNul l([Answer]);"No";"Yes") ) AS Qtd
FROM Motivos
GROUP BY IIf(IsNull([Answer]);"No";"Yes") ;
My memo data type is "answer". I need to know how many users answered in the... -
I do apologize if I wasnt clear. I have a form that the user can input data. If the user goes back to the data he previously inputed, he can only change one record and the other fields are disabled. When the user goes back to a new record,it should allow them to type in all the fields and so on.Leave a comment:
-
I have a form that locks all fields except one. after update you go to next record. my code is staying in lock mode and will not let me update the next record only the one I specified
Private Sub Form_AfterUpdat e()
Dim ctl As Control
If Not Me.NewRecord Then
For Each ctl In Me.Controls
If ctl.ControlType = acTextBox Or ctl.ControlType = acComboBox Then
If ctl.Name <> "Hair"...Leave a comment:
-
a user inputs data in a form after update nothing can be changed in the fields except one field.Leave a comment:
-
thank you that works,but what if you want to keep one record open to edit.Leave a comment:
-
gina farrow started a topic Can you have a user not be able to change anything on a form afterup date?in AccessCan you have a user not be able to change anything on a form afterup date?
I have user inputing info in a form
I want to input data ,then update the data after form is updated the user can no longer edit what he has done. when the user goes back to the form the user cant change things.. -
How to count and show percentage for "yes" or "no" records on a form?
I have a form that has yes or no answer. I need to know how to count how many yeses and how many nos on the form. and then show a precentage of how many records said yes and no. -
How do you get a form in Access to start with last record?
Everytime I go to my form I have to keep clicking all the old records before I can go to the next record. Would I put a command button for that or in the form itself? -
Thank you it works!Leave a comment:
-
How to fix "can not enable after disable" message?
When I enter the code below I get a message"can not enable after disable." Access 2010 it works,however in access 2007 it doesnt work.
Private Sub CheckBox2_Click ()
If CheckBox2 = True Then
CheckBox2.Enabl ed = False
End If
End Sub -
When I enter the code below I get a message"can not enable after disable." Access 2010 it works,however in access 2007 it doesnt work.
Private Sub CheckBox2_Click ()
If CheckBox2 = True Then
CheckBox2.Enabl ed = False
End If
End SubLeave a comment:
-
That's exactly what im looking for, Im doing it in access. Im not familiar with excel how do you look at the code in excel?Leave a comment:
-
How to make a database that allows four users to Critque Forms?
Hello,
I need to know what would be the best way to make a database that allows only 4 users to go into the form section, and click on the forms.
once the database form is open, on the side of the form(or some where on the form) there is a check box with the four users names.
They have to be able to check there name on the form and the form then goes to the next user to check and they put there check mark on... -
Again thanks for your help,I used that code and when I click on the box it just stays gray with no check mark.Leave a comment:
-
thanks for the info. I am a beginner. So, Im sorry but i just dont get it. See I am trying to have a user look at a form critque it. then on the form they check their name and the form goes to the next user they look at it and so on so once check cant change it. do i need a table for each users check mark?Leave a comment:
No activity results to display
Leave a comment: