Search results

On a subform, when I navigate back through records of the subform, it sometimes leaves the information in the fields from the previous record. It only changes them, if I go back one or more records and then navigate forward. Any ideas? thanks

the form is still present. Does not go "invisible"....

fixed It was an error in my coding. I simply had the field to update OnChange as opposed to OnAfterUpdate. Is there a way, such that the initial form does not show the warning when the program starts ie "shut down in few moments" and only show when the time has elapsed?

thanks sometimes it's just so simple. thanks. Ken

close order I used the petersoftware - excellent... thanks. The one problem I encountered was if someone was working on a record adding information and then left it alone, when the auto close went into effect the sequence of closing caused a problem. There was no related record to attach it...

How do I write a VBA script that runs before the first form opens when Access opens the database? thanks

thanks thanks for your help

My staff frequently does not close out the access database which prevents me from opening it exclusively to modify it. is there a way to automatically close the database after a period of inactivity? thanks

I have created several forms being used by different persons on different computers. How do I maintain the size of the form? Since the resolution on the monitors is set different, changes to the form need to be made. Is there a way to set this so that each computer has its own settings? thanks...

thanks...seems to work with the me.name..... why?

had tried that already without success?

I seem to have difficulty closing a form. In VBA when opening a new form, i want the previous form to close. I am using the docmd.close "formname" without success. any ideas?

What exists in a "field" in a table when no records have yet been added? When I debug.print the field, it results in "null". However, any VBA line that references this as "null" does not seem to work. I am trying to default a field only when the first record is added. After the first record...

I am struggling with a subform. I am unable to edit the fields. It allows the cursor to enter the field (a memo, date field and text field) but does not allow any changes. I believe all permissions have been set, ie. allow edits, enable, etc of both the fields and form. It is a 'dynaset'. It...

Any quick ways either to convert a form to a report or to print a form as on the screen?

Thanks.... the answer was using the name of the form that the main form referenced. I had changed the name of the frmPatGoalProb to "Goal"... it now works. Why I changed the name I'll never know. Thanks to all of you for your perserverance....

tried it but it still states it cannot find the subform?

yes.... subform name is frmPatGoalProb code: forms!frmPatGoalProb.requery produces --> Access can't find the form..... the main form with subform are open. I have tried placing code in main form, subform and tried various combinations of the Me!frmPatGoalProb.requery.... without...

still unsuccessful. Error state it cannot find the form. The form/subform is open. What am I doing wrong?

I am still not getting this.... I have tried VBA code as suggested (I think) but still get errors that form cannot be found or object issues.... At what event should I be using the requery? At the on current? As for the background issue, I am using an outside table and check boxes to select...