Prevent edit and delete after printing a form
I want my order details form, after printing to prevent deletion and edit.
I got this vba code to use, when I used it, it closed up all the forms including the ones I have not printed.
Normally I print immediately the order is made.
I dont know what to put ,"" <> ""
If Nz([OrderDate],"") <> "" Then 'there's a value there so the orders been printed
Me.AllowEdits = False
Me.AllowDeletions = False
Me.AllowEdits = True
Me.AllowDeletions = True
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I need to find a way to prevent printing of a form unless a certain box (QA approval) is checked. The checkbox is on a subform to the main form.
When the list form launches an add/edit form, it remains open, merely opens the add/edit form which is a modal dialog box.
I am having a difficult time finding an event which will fire when the add/edit dialog form closes and the list form regains focus. I need to preform a Refresh to update the UI and prevent seeing #Deleted when an edit has been made.
I have tried Activate / GotFocus / Dirty event. None have worked thus far. Of course, pressing F5 refreshes that list form.. I would simply like to have the application automatically do that.
If I delete each field to clear the screen, it also deletes it from the table. This also happens when I go to my search form.
How do I prevent this from occurring. If the screen automatically clears, it will also delete from the table ? In the search form, I have a clear search button that clears all the search values in the form header, but not the detail.
Again, if I clear the detail, will it delete the record from the table ? And how do I prevent the search form from being edited once data isdisplayed ?
I am almost there but these are minor quirks that I cannot figure out.
Can this be done? If so, how can this be done? Would you have any sample code to attach to the editing button, to do this interesting problem.
2.i do QRY for 3 table link in from
3.i make from form for add, edit , and delete
1.when I delete in from but table not delete?
** I'm enforce and cascade delete related but can't delete it
in step 1 can't delete it I will do step 2
2.i make new button in code VBA
Private Sub Command123_Click()
DoCmd.RunSQL "Delete * from tbl_com"
it delete all record in table
I want delete 1 record in from and intable
I am using 2007 that I have set so the file can be opened in 2003. The data was imported to create tables from two Excel spread sheets using the wizard. The tables are linked together and the combined data is shown in a report. This all works without a problem.
Now I need to edit the data, so I created several forms all of which I cannot add, delete or edit the data.
I saw under the User and Group Permissions that under table all the permissions have checks but under form read, update insert and delete are all greyed out and I am unable to change this.
I found in security parameters of Access 2003 the options to create new users and/or groups and to set the permissions for these. I have created a "limited" user and group and I seted for these only "Read" options for tables, queries, forms, but this user can edit/remove the records and data from tables
I am sure this can be done, I am very new to Access and am not sure what settings I would have to change to make this happen. Any help in moving towards the right direction would be greatly appreciated.
Record Selectors are also enabled. The individual fields are enabled and not locked. But when a delete is attempted, a message pops up "The command or action 'delete record' isn't available at this time."