Search results

Having your combo boxes bound our unbound is not relative to making the second combo box display values based on the selection made in the first combo box. You specify the field to which you combo box is bound using the "Control Source" property of the combo box. Where you are wanting to do...

It it typical for a subform to appear blank if there are no records linked to the main form. Most likely what has been done is that several of the properties of the subform, like the Border, etc, have been set to be transparent and therefore it appears that the entire subform is disappearing. .

You do not have to set the field as a primary key field. Try setting the "Indexed" property for the field to "Yes (No Duplicates)".

You can still use your AutoKeys macro when using VBA. You would not need to change anything about your macro.

I also have been totally using VBA for many years. However, I am now developing in Access 2010 and find myself now using Macros. The reason for the big switch is that my client has a need for the database to be accessible by users in many parts of the world. They also want to take advantage...

One thing to keep in mind is that you will need to not only select the church but supply a start date so it may not be as simple as putting a combo box on your main form. It is a little difficult to advise you as to exactly what you will need to do to manage the information because I don't know...

You are faced with a many-to-many relationship because not only can a church have many pastors, because these pastors move from church to church, a pastor can have pastored many chruches. I would create a PastorChurchLink table. You would have a primary key field (autonumber type), a number...

Sorry, if I misunderstood your question. The reason that I posted the code that I posted is because the "leaves the Excel instance of the file still in memory" issue is caused by using code that does not specifically refer to a defined object. I was just attempting to provide code that I have...

You did not indicate which version of Access you are using so I have attache a file for Access 2010 and one for Access 2002-2003. Give the appropriate demo file a try. When it opens, it will display the current or next work day and the next four work days. It always excludes Saturday and...

Could you post all of your code? Just seeing the line where the error is stopping may not tell the complete story.

Give this a try: Dim objXLApp As Excel.Application Dim objXLBook As Excel.Workbook Dim objXLSheet As Excel.Worksheet 'open Excel Set objXLApp = New Excel.Application 'The next line can be uncommented if you want to see the spreadsheet 'objXLApp.visible = True 'open the spreadsheet Set...

You should never be attempting to interact directly with the tables. You need to build forms for the user interface and you can design the combo boxes into the form.

In theory the code below should do what you want: If cboQ14 = "Yes" Then Me.cboQ15.SetFocus Me.txtQ14b.Enabled = False Else With Me.txtQ14b .Enabled = True .SetFocus End With End If If this code does not work then you need to check to see what value is...

Shutzy, My offering to you was simply that, just one option for doing something like you were proposing. With that said, I would me more than gald to take a look at what you have in mind and see if there is something that we can do to make things work as you would like for them to work. I...

Without seeing exactly how your database is designed, it is not possible to provide specific information about how to retrieve the correct data but if your data is normalized properly, I would think that you should be able to link a sub-form to the main form using the appropriate master and...

If your main form has the field that would provide the link to the sub forms data then you can just insert the sub form into the main form and use the Link Master Field and the Link Child field properties of the sub form to link the data in the sub form to the record in the main form.

You have chosen a strange place to ask your question, but ... What you want to do is create a "lookup" for a field. With your table in design view, select the field that is to display the list. In the Field Properties area at the bottom of the table definition click on the Lookup tab and...

If many students can have many placements then you have a many-to-many relationship. This will require an additional table where the placement and the student can be linked together.

Managing a many-to-many relationship will require the use of VBA code because you are going to need to have the user make multiple selections from your list boxes and then process each of the selected items, writing to or removing from the table that links the records together. This is one of...

@moishy, Did you try implementing my function and calling it. It does not rely on any specific order of the checkboxes. It will work no matter which of the checkboxes are checked or unchecked at any one time or in which order they are modified.