I want a blank record to appear first on a subform followed by existing records in descending order. How can I do this? I do not want to use the data entry...

In an unbound table, I have figured out how to delete a record and edit a record with just pressing a command button and it will either allow the user to...

I am fairly new to using Access and here's what I want to do: I want to create a form that allows the user to select a leader, enter a date and receive data...

Hi.....I have a hidden command button and when I choose the value "UNCR-E3" from a combo box, I want the command button to be visible. Here's the code I'm...

I in the process of designing a form that needs to have a subform on it. In the subform there are various items but one field represents one of 5...

I'm stymied. I've created an 'empty' form that I want to use to effect the OnClose behavior of another form. The problem I'm having is that I cannot...

How can I make a command button visible with a new record only?

I have the following code on the 'On Click' event of a command button. Private Sub Command34_Click() If (Me. = "Other" And IsNull(Me.)) Then MsgBox "You...

I have a text field in a table that is a required field. This field must accept a string made up of two double quotes. In other words, the double quotes must...

I have 2 tables, one for emloyers and 1 for job order info The two tables and forms are related by Employer ID. There is a Main form with Employer information...

I want to sync my form with my combo box so when I scroll through the combo box the data in the form also changes and visa versa. I saw this somewhere in the...

I have a Grand Tot Field that totals 14 other fields on a form. Works great unless one of the fields is empty, in which case the calculation returns nothing....

I have a form based on a select (distinct) query to allow for data entry on to a subform. It works for each query that I try, but I would like to continue to...

I have 2 comboboxes cbo1 and cbo2. cbo1 populates the cbo2 in the AfterUpdate of cbo1, where cbo2 is assigned as follows: cbo2.RowSourceType =...

How did you lock the main form fields? If you changed the Allow Edits form property to No, then you locked the whole form. If you want to lock a field, you...

Thanks to "bcap" for his help regarding form and attaching a datasheet. I was able to create a form containing a sub-form containing a datasheet, properly...

Hello, I am using Access 2002 and 2007, some users will use 2002 and others 2007 version. I am making an employee history database and what I want is to...

Hi Guys I run the membership Db for a charity and I am looking for a way to produce a list of email addresses that I can use to send out the newsletter. I have...

Hi Guys I run the membership Db for a charity and I am looking for a way to produce a list of email addresses that I can use to send out the newsletter. I...

The underlying record source of a form has a VehicleDescription field that has the Automobile make model and year all together. Here are examples of the...