Search results

If you are running office 2010, then this may be what you are looking for: C:\Program Files\Microsoft Office\Office12

Use the Between function in your criteria for both fields, but put the criteria on two separate lines. In this manner you have created an or criteria. Look at this link for further information on the Between function. http://www.w3schools.com/sql/sql_between.asp

try this: Expr1: Left([tany],InStr(1,[tany],"-")-1) & Right([tany],Len([tany])-InStr(1,[tany],"-")) where tany is your field name. Change it to reflect your field name.

Mint Julep celebrating

Access 2010 Programmer's Reference by Teresa Hennig, Rob Cooper, Geoffrey Griffith and Jerry Dennison have a dedicated chapter with step by step instructions for web and sharepoint publishing. This published by Wiley. I found my copy on Amazon...

Look at this for a starter: http://www.datapigtechnologies.com/flashfiles/subforms1.html

never took place

I can't find an image of the 2013 Ribbon, but if it is similar to 2007 and 2010 then open your form in design view. Highlight the controls you wish to align/space and look on the ribbon on the Arrange tab that has become available and look at the size/space icon. Alan

I wanted to suggest that you use conditional formatting, but for some reason that I cannot determine when the event controls are highlighted, the conditional formatting is greyed out. However, when the date control on the form is highlighted, conditional formatting is allowed. You might want...

Try highlighting the labels and right clicking. You should get an alignment and sizing option.

will, but not

Been gardening for many years. Lots of flowers, vegetables and herbs. Freeze the tomatoes for sauce bases. Dehydrate the herbs and peppers and use in cooking all winter. Mint is important for Derby Day (Kentucky Derby) when Mint Juleps are the drink of the day.

In the QBE, have you changed your Select Query to a Delete Query? Is that where you are getting the error message?

and sexy other

If you build a form that has unbound text boxes that are the criteria for the query, add a command button to run the report based upon the query. When the report is run it will call the query which will use the latest criteria in your form to provide the data to the report.

while Shaq explored

This should get you started. You will have to modify slightly for last viewed. http://www.datawright.com.au/access_resources/tracking_data_changes_in_access.htm Alan

Cross Posted: http://www.accessforums.net/programming/converting-excel-vba-macro-into-access-module-33299.html Please read this link: http://www.excelguru.ca/content.php?184

Jennifer; Go to this link and scroll down to the three lessons on Combo boxes. http://www.datapigtechnologies.com/AccessMain.htm Alan

Look at your query in design view. I am guessing that you probably changed something in a table design after the query was built and when you run the query, there are former field names that Access cannot identify and this its way of telling you.