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

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

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

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?

I am updating records in a file by adding using recordset VBA code. These are displayed in a subform. I have tried all different combinations of requery without much success.... I know I just don't grasp the concept. Help. I am using Forms!myformname.requery It usually comes with an error...

I am having difficulty updating records since I referentially linked a field. The following code was working fine and allowing me to add records. Since I linked the ProbNum field in 2 tables, I am now getting an error that states "you cannot add a record or change a record because a related...

I have 2 open forms that are connected by a query and not a parent child type relationship. that is the values from fields on first form are used via functions to create a query which is the basis of the second form. I would like it to behave similar to how a subform works, that as it updates...

How do I store a value of a number field from a selected record, to use in a query later?

I have a form the displays several rows of a file. When I select a row, I want it to be able to pass the value of one of the fields of the selected row and use that as the criteria in a query and then open the query. How do I do this?

I am new to VBA. I am developing a program to input problems and goals on patients. The patient may have multiple problems. Also the problems may have hundreds of variations. So I have used a combobox to add the actual values stored in the problem field. This part is working well. Each problem...

I am writing what I thought was a simple Patient form to enter new problems for a patient. A patient may have multiple problems. I want to add problems quickly from a pre-defined list of problems. I have a Patient File which is linked to a Patient Problem file. I also have a Problem List file...

I am writing what I thought was a simple Patient form to enter new problems for a patient. A patient may have multiple problems. I want to add problems quickly from a pre-defined list of problems. I have a Patient File which is linked to a Patient Problem file. I also have a Problem List file...

I am writing what I thought was a simple Patient form to enter new problems for a patient. A patient may have multiple problems. I want to add problems quickly from a pre-defined list of problems. I have a Patient File which is linked to a Patient Problem file. I also have a Problem List file...

I have a table called problems and a table called clients. I have created a relationship between these files. I am using a combo box in clients to access for quick entry problems from the problem table. The standard function in access seems to be to store the unique reference field relating...