Search results for query: *

Thanks TheAceMan1.... I followed everything you said and I appreciate your taking the time to delve into the details. Over the last 3 months, you've been a lot of help to me in this project I have been developing!

TheAceMan1.... Your suggestion worked like a charm. I have another question on a related subject. I have code elsewhere in this form to control movement from record to record and when I wrote that code, I used the RecordSetClone property. I know that this property copies all the records into...

That is exactly what I was hoping to hear. I just wasn't familiar with capturing keystrokes. I'll give it a shot and see how it works. Thank you.

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 need to clarify. I have a subform which is set to cycle current record. On the subform, in addition to several data entry controls, is a tab control with 4 tab pages. One page is add only, one page is delete only, one page is edit only, and one page is locked and used for viewing data only...

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 need to clarify. If there is only one record on the edit quantities datasheet (form set to edit only), after editing that record, instead of remaining on that record (since it is the last and the first record in the recordset), it jumps from the form and the subform record which is being...

The allow additions property is set to No. Only allow edits is set to Yes. This is a datasheet form on one page of a tab control. The other pages on the tab control have forms that are for adding, viewing, and deleting records and their properties are set accordingly. This tab control resides on...

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 determined that what is happening is that upon leaving the last datasheet row in the edit quantities page the cursor moves to the first subform control. I have disabled and locked the subform controls to prevent additional editing once it had been saved. That is causing the process to...

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...

Thanks PHV! I'll check it out and get back.

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...

What would be the syntax for the subform control?

I mean lock and unlock the control, not the form!

Got it! Can I then unlock this form and relock it at the appropriate time through VBA code similar to unlocking and locking a control?

Remou: That makes sense and also brings up a few other possibilites. However, I don't see a locked or enabled property in the form property sheet. Is there a form locked property setting that I can enable and disable? Or should I just be locking and disabling all controls on the subform and...

Hey mightyatom13.... Have a look at the Requery method!