On one table there are four fields: StudentID, text ExamType, text ExamID, text Attempt, text I have an index on the table to prevent a combination of these...

I have a form called Service Request F; we enter the services requested for each unit into this form. Once the service has been done/fixed at a later date I...

In Access 2007 is there anyway to add a button to a form to open a query?

I have a main form that opens when I open my database file with two command buttons; one of them is called office and it opens another form with more command...

I have used the following code in my form and it keeps telling me that it is not available at this time: If Not Me.NewRecord Then RunCommand...

I am having the same or similar problem as KW in this forum with disappearing forms. I created a form in Design View, but when I switched over to Form View,...

On my new form I trying to have a custom find/sorting report. I am using a group option filter to do this. On the Select report I would like to have for...

On my new form I trying to have a custom find/sorting report. I am using a group option filter to do this. On the Select report I would like to have for...

In a form where a datasheet is a subform, and where the last line is the data entry line, and where the first field of the data entry line is a date picker...

Hello, It has been many years since I created forms in Microsoft Access so I just need some quick help to get started again. I need to add a label or text...

Good Morning all, I have the following code on the After Update event of a combo box: Private Sub biennium_AfterUpdate() Dim varBiStart As Variant Dim...

Hello all, I have three tables (I am using recipies to make my issue clearer): tbl_Authors, primary key = AuthorID tbl_Recipies, primary key =...

I have one form used for editing, that can be opened by two other forms. Since this is not a parent child relationship, is there a way to reference the form...

Hello all, I have the following code on the On Click event of a command button: Dim stDocName As String If Not IsNull(Me.ID) Then stDocName =...

Hello all, I am using a command button on a form to open another form. The first form (frm_Orders) is bound to tbl_Orders. The 2nd (frm_OrderErrors) is bound...

Good Morning all, On a form there is a combo box(Type), limited to list. There is also a set of 10 check boxes (A - J). If a specific selection is made on the...

Perfectly, Thank you =) I hope my pizza analogy didn't make you too hungry! "Sprinks" wrote: Hi, Renee. You can do this with a series of calculated...

Hello All, I have a main form and sub-form. After selecting an employee on the main form, the sub-form will display all matching records. If there are...

Good Morning All, I am using the Undo command as a cancel button on a form. Is there a way to disable the command button, if the undo is currently not...

Is there a way to set the data entry line on a datasheet view (in a subform) to be the first top line or does it always have to be the last bottom line? MS...