I have 2 related tables. The form to enter new data into the tables is set up with a subform for the second table. I want to allow the user to query for a specific record, have it display in a form that looks exactly like the data entry form, and be able to update the tables from that. I first tried an exact copy of the data entry form, using a subform for the second table. It allows me to update the 2nd table from the query results displayed, but won't allow updates to the main form. So then I tried just doing one form with all the results displayed, no subform, but then it won't allow me to update ANYTHING.
SELECT tblClientDetails.FirstName, tblClientDetails.Surname, tblClientDetails.MobileTelephoneNumber, tblClientDetails.SentTextMarketing FROM (tblCategories INNER JOIN tblItems ON tblCategories.CategoriesID = tblItems.CategoriesID) INNER JOIN ((tblClientDetails INNER JOIN tblOrders
[Code] .....
this does not allow edits on a continuous form. the edit i am trying to do is the check box. it will allow edits if the grouping is not on but if it is not on then i will get many duplicates of client details.
so how do i set it up to allow edits but still only get one instance of each client detail.
I'm looking for someone to help me understand why a form of mine that has only 3 fields - [Name], [Date], [Notes] isn't working right. I have the form's "Allowedits = No" which works great except when I add a macro that uses the "Setvalue" to put the current user in the name field and to put the current date in the date field the form allows editing. When I take the macro out it works the way it should. All I'm doing is creating a Journal entry area that allows one to write notes into the [Notes] field and automatically plugs in the current user and the date/time but doesn't allow editing once entered.
Have the data settings for the form all allow=true And tried the VBA allowedits=true on form open but the form is still locked. Any suggestions about why? Is updating two tables from a two-table query not allowed or??? Thanks,
I have a database that allows multiple entrys of the same information. I also have a report based on a query that pulls out said data.
I just need my query to pull out every record regardless if it is indentical to a previous one. I found under queries > design > properties there are two options unique values and unique records. According to a source online, these are what control allowing duplicates through, but I have swapped them around with no luck. Currently they are both set to "no".
Is there some other setting I have to switch up in order to allow the duplicates to come through?
I am fairly new to Access and I would like to create a form to allow users to create their own query. I would like to allow users to select multiple fields (perhaps with checkboxes?) from all possible fields in a table to return either all data from that field or narrow their search by inputting certain criteria or choosing from a drop down into a text box. Is this possible in Access and any detailed specifics on how to achieve this?
I want to allow users of a database to view data through a form but not to edit or delete it. I have set Allows Edits, Deletes and Additions to "No", but this causes the record-finding combo box I have to search for records to stop working. It works again if I enable Allow Edits, but then users can edit the data through the rest of the form. Is there a way I can allow edits to the combo box but not the rest of the form?
I used to queries ,1 to get items that are taken ( its all about sign in sign out for equipment) and other query is list of all items. How can i make 3rd query which will give me all but taken items from query1? (of course items from query 1 are in query2) thx in advance
I made a little Access app for a friend, to do his invoices. Access wouldn't allow me to copy the db to a CD, but advised me to convert it to a Master. I followed all the instructions (honest!). Afterwards, I could burn his db to a CD and, on his computer, it opened but wouldn't allow edits or new records - not terribly helpful for an invoicing program :eek:
Since then I've tried creating a new admin in his name, re-setting all permissions, blah blah ... Basically, it looks like there is loads of help on securing a database but very little on un-securing it enough to be transferred to another PC!
The dang thing persists in allowing everything except edits & additions :confused:
I can't find out how to convert it back from a Master to ... what, a slave? :p Even so, that wouldn't be the answer coz I'd be back at square1.
I use a PC running XP and Office 2003. My invoice-less friend has a PC with Win[NT]2000 and Office 2000. I converted the database to Access 2000. I am way out my depth here, but hoping you Access swimmers will be able to advise :cool:
i am relatively new to databases so this is a fairly basic question.....
I have a form. Within this form all records are locked as i do not wish users to change details. However i am told there is an option allowing the editing of existing records upon request. is this true?, as it would improve my form greatly
I have a db where a planner inputs a commit date. The problem lately, is that the commit changes day to day before the part if filled. Management is looking for a way to count the number of times a commit field has been updated? Is there a better way to do this? I have minimal VB knowledge. Please help!
I have a check box field in table, i want this field to be work as if once checked cannot be unchecked again... no worries if done through queries, vba etc
We have 3 different sizes 1x3 2x3 4x6..I want to make 3 separate forms that have multiple sections that can be chosen.Upon Request I can Supply each separate Label with arrows to show what fields need to be changed for each Sales order.For the 1x3 Labels we Make:
1. ETL - We change model # - We Change if the Labels Says Dry Damp or Wet Listed.
2. MISC. -One Plain Txt Box that can be edited in the center
For the 2x3 Labels:
1.Box Labels -Customer -Item -Sales Order# -Shipping Location (For the Box Labels I was thinking I have a Table that holds all this data and all I would have to make is a Query then a form)
2.ETL -Change Model -Wet Damp or Dry 3.CSA -Change Model -Change the Wattage (3 Different Places) -Wet Damp or Dry 4.MISC -6 Text Boxes (From top to Bottom not side by side)
4x6 Labels: 1.HID Box Labels -Item -Watts -Color -Medium or Mogul Based
I designed and distributed a database client to a bunch of users. They have asked me to password-protect it so that anyone can open the database and view the forms, but a password is needed to actually make any updates. I am trying to do this, but everything in Tools--Security is making my head spin. I have actually already managed to somehow lock myself out of my own database, although I have another copy.
How do I set the Workgroup Administrator Files so that they apply to anyone? It wants to put a separate file on my C: drive, but I don't use this database, I distribute it to people who do. (The server is on a share drive, can I put the Workgroup file(s) there?)
What settings do I modify to require *anyone* to need a password to update? Or is that even possible? I don't really want to break up the users into different categories.
If anyone could walk me through this process I would really, really appreciate it.
Hi all, I have a form that is used to Enter and Edit records. At the end of a record is a "shipped Date". This is blank until the item ships. I want to make the entire record editable up until a date gets placed in this field. Is this possible? and can editing of the record still be done maybe at the table level?
can anyone tell me how to stop additions and edits on a particular record in a form, plus the subform that the main form contains, im trying to put the event behind the change of a text box, shipped date, so when its changed you cant add or edit the record which is the order.
Greeting, I am still struggling with my sub-form. Have managed to prevent edit by using the form properties. However I have some fields which have to be updated after the form has been closed. I tried putting the following code in the (Before Update Event) of date issued field for instance.
If Me![DateIssued]=Null then Me![DateIssued].Locked=False end if
Needless to say this didn't help.
I have some fields which cannot be filled in until a later date. These are job records so I have date open, Technician name date completed plus a whole herd of other stuff which has to be filled in as the job progresses.
Any help will be most appreciated, Brian. Zimbabwe
I have a form which was locked down (ie Allow additions, allow edit and allow deletions were all set to no) on the Form property. I want to change this to allow edits so in design mode I changed the Allow Edits property to Yes.
I then went to Form view and was able to update fields on the form. When I exited the form it asked me if I wanted to save the changes so I clicked yes.
On going back into the form I can no longer update the fields I could before. Going into design mode I can see that Allow edits on the form property is set to no again.
What is happening here. There is nothing in the on load or other events to set this to no, besides this shouldn't change the form property should it?
I know I can get around it my setting the property in the form itself but why is the property getting reset in the first place.
How to restric forms entry to be restricted from second edits .. means if some one posted single entry one time and wanted to post second edited entry i need form to ask passoword. or not to be updated if not available the password option.
I have a form called Contacts that has two tabs. One is called General adn the other Calls.
In the General tab I have a bound field called CustomerIDdet which can be numeric or alphanumeric. I need to disable edits in the General tab but not in the Calls tab if CustomerIDdet is numeric (and it follows certain additional rules)
I have placed this code in the Onload even for the form:
Code:
If Len(CustomerIDdet) = 9 Then If IsNumeric(CustomerIDdet) Then If Right(CustomerIDdet, 4) = 9090 Then If Left(CustomerIDdet, 1) = 0 Then 'disable editing in the General tab End If End If End If End If
I know how to disable edits control by control, but can I disable edits in all controls in that tab at once?
So I have a form that allows me to view the information associated with a specific record. Within this form is also a subform that shows additional information about the record from a junction table. I want to create a button that allows me to edit the information on both forms.
I have created an ACL table (access control list) where I have the fields UserID,FormName,CanSee and CanEdit.
When the user opens the db, the on open event gets the LoggedOnUserName and then check my ACL table to either prevent viewing or editing.
I have got the prevent viewing part working, but am having a small problem with the prevent edits. I can set the property to prevent edits, but i need the user to be able to search records. the combo box is disabled if I use the following code.
MyCount = DCount("User_ID", "dbo_NPY_ACL_User", "(dbo_NPY_ACL_User.User_ID)=" & MyUserId & " AND ((dbo_NPY_ACL_User.CanEdit)=False) AND ((dbo_NPY_ACL_User.NavBtn_ID)=" & MyTab & ")") If MyCount > 0 Then Me.AllowEdits = False end if
I'm creating a database about Vets and I need to make a button on my menu form that will open something like message box that will allow me to type in something (in my case Customer ID) which will then apply the filter on the customer form and allow me to do edits. I have only done the macro that will open the customer form but can't figure out how to do the filter part.
I thought "Undo" was only available while in the current record.Here were my steps:
1 - Loaded form that shows 1 record per form page. 2 - Edited a record 3 - Moved to another record with status bar nav arrow 4 - Verified my edit was in the underlying table 5 - Moved back to the original record, again using status bar nav arrow 6 - Clicked my "undo" control and the original data appeared in the form 7 - Moved to another record 8 - Verified my original data was now back in the underlying table
I have a simple form that has a subform with its datasource being a query that is a multi-table select (complex joins)... the subform is set to allow dataentry, edits, etc. I have a checkbox that displays a value from the query (0, -1). Is there a way I can enable this checkbox to write back to one of the tables? Temp table to hold the contents of the query?