Search results for query: *

I have a continuous modal form which is used for editing and deleting existng records. The form is called from a command button on a subform. Everything in the form works properly except that when there is only one item in the list I can't get it to save a change. There is only one editable...

I have a main form and a subform and a form sunchronized with my subform which I am using to edit or delete existing records on the many side of a relationship. There is a mathematical field on the subform which needs to requery as changes are made on the synchronized form. I am using the...

I have a subform that contains a control tab with 4 tab pages. On one of the tab page forms, I am trying to use the Dirty event to set enable to false for the other forms on the other tab pages. Trying to prevent a record being saved by jumping to another form. Forcing the use of a command...

I have the following code in the AfterUpdate event of a subform datasheet. It is working properly, going to the next record in the list, and if on the last record in the datasheet, moving to the first record rather than saving the record and going to a new record. However, if my datasheet only...

After editing the last record in a datasheet form, is there a way to return the cursor to the first record in the list rather than creating a new record? This code would need to be applied to each record so there must be a way for the code condition to return a false result to be able to proceed...

I have a main form with a subform and the subform has a tab control with 4 pages on it. I have a page to add items and quantities to the list, a page to review the list of items, a page to delete items from the list, and a page to edit quantities of existing items in the list. The idea is to be...

I have a date field that has validation rules and mask properties. In my form violation of these properties produces the generic Access error messages. How do I eliminate those messages from displaying so that I can have only my messages appear? Also, what code would be used to insure that a...

I have a subform linked to a main form. I will call this the primary subform. In the primary subform is a tab control with an additional subform on each each tab control page. I am trying to prevent a user from saving changes to an existing primary subform record by clicking down into one of the...

I have turned warnings off in the NotInList event, but I can't seem to stop the default information message concerning the limit to list property from appearing. I have replaced it with a different message but the default message keeps coming up after my message. Perhaps I have turned warnings...

I have a combo box control with limit to list set to yes in a form with msgbox validation code to prevent a blank field where the code works fine unless a space is entered in the control. Then my validation code is preempted by end/debug messages. Is there a way to refer to this type of instance...

I have an unbound combo box being used to pull information from a query onto a form. I have limited the field to the values in the list, but I am interested in generating a message if the field is left blank. All of the other controls in this form are locked and disabled as this form provides...

When moving from a main form to a subform, can someone tell me the event sequence that transpires pertaining to the subform before the subform's control events start to occur?

I am trying to close a form from the lost focus event of a control and I get the message "This action cannot be carried out when processing a form or report". This message occurs whether the form is dirty or not. The control is the last control in the tab order. Thanks for any help!

What is the best way to force any sort of keyboard input into an unbound text or combo box(not allowing the cursor to proceed if the field is blank)?

I have a subform with an editable field which has a default value of zero. I want to force a non zero entry in this field with message box dialog generated by the form's Before Update event. How do I force a form update when no data has changed in the form. I have experimented with the dirty...

I have an Item table where the field Item, a text field, is the Primary Key. I have 2 kinds of items which are identified by a boolean field, raw materials and finished products. What I want to do is to create 2 forms for adding new items, one for finished products where the item is keyed in by...

I have a form which only edits existing records. The last field is the only field available for editing and on the BeforeUpdate event for that field I have a vbYesNo confirmation box which is working properly. No closes the form without saving. Can someone provide me the code needed to save the...

The code below is being used to change focus. It was suggested by a person on the forum and I was wondering if someone could explain the use of the Dirty method and what its significance is in this code? Why would it be needed? Thank you. Dim AddItems As Object Set AddItems =...

Can someone please tell me why the following code is producing a "variable not defined" message on the word Cancel? Thank you for any help! Dim Answer As Integer Answer = MsgBox("Yes to Delete this Batch, No to Exit Without Deleting, or Cancel to Continue Editing?", vbYesNoCancel +...

This code I have below is not doing what I want it to do. When the first message box response is no it does cancel properly. But when the message box response is yes it exits without running the rest of the code. The execution doesn't proceed to ProcessReceipt and the rest of the code is not...