Search results

First, I realize that you are quite new to Access but text boxes do not have "choices" they only allow users to type in a value. I suspect that you are really talking about a combo box with two choices. If this is the case, you can have the background color to be changed based on the value...

Sorry, I left something out. Please try this: < DateAdd("d",-60,Date())

You can create a form and on that form, create a combo or list box, which ever you like to use. Populate the list or combo box with the list of your state abbreviations. You can do this by having these State abbreviations in a table or by selecting "Value" list a the type of list and then just...

Give this a try in the criteria of your flight date field in your delete type query: <DateAdd("d",-60,Date) This function says return or delete only records where your flight date is less than the current date minus 60 days. Those are the records that will be deleted.

Glad you got to the bottom of it. Good luck with your project.

The only way that I was able to recreate what you are seeing in the ribbon menu was to open an Access file with a .mdb extension and then attempt to edit a form. The native web control icon was not visible on the menu. You did not say that the file was created with 2010. I would try...

I don't know if any of the info in the document at this link will help at all but it is worth sending you the link: http://msdn.microsoft.com/en-us/office/cc907897.aspx

macattack, I have attached a text file that has some VBA code that hopefully will show you how to create the sql statement for filtering using values provided by the user from selections made from multiple controls.

jdraw, Sorry, I did not mean to be trivial in my initial response. I was afraid that it was just not showing up. It shows in my 2010 Access installation. I have no idea why you would not see that control. If I hear anything about it, I will get back to you.

It is located to the right of the Hyperlink control in the Controls section of the Design tab.

Here is a link to a demo database file that is on my website. It acutally provides filtering options for a form, but hopefully you can look at how the filtering is accomplished and then apply the same concept to your report...

When you split a database the only thing that you are doing is moving the tables to another file and then creating a link to them. There is no other difference so you should have no problems created by spliting the database. If required, yes you could disconnect (delete link) all of the...

If you are wanting to have multiple items from the listbox written to the table, then you will need VBA code to iterate through the remaining items in the listbox and write the records to the table.

I would think that you would not need the Max at all. Try using the following criteria for your Invoice Date field. >=DateAdd("m",-18,Date() That should return all record where the invoice date is greater than or equal to the current date - 18 months.

It is not a matter of modifying the existing menus, it is a matter of creating your own menus. There is a lot of information out there about how to do this, but it is something that you will need to learn.

Sorry, but I did not pickup on the "Max" part of your query. That is the part that is causing you to have a non-updatable query. You have to remove that from the query.

You will need to create your own menu system. That way you can include any and all options your app needs, but eliminating any options that your app does not need.

To try to solve this issue, keep both tables in the query and linked as you require them to be. Use the fields in the query you need for criteria but do not try to display them. Remove any fields that you do not want to update. In other words, get the query down to just updating the one field...

The answer depends on how the combo box is being populated. Both solutions would require the use of VBA. If the combo box is being populated with a query then you can update the QueryDef and provide criteria that will prevent that value from being displayed. If the combo box is a Value List...

Take a look here: http://autofeupdater.com/ This is the best way to keep it simple.