Search results

Reset the Combobox's rowsource after the text field has been updated. For example, assuming the Combobox gets it's data from a table called 'Titles', it's basic rowsource might be "SELECT [BookTitle] FROM Titles ORDER BY [BookTitle];" In the AfterUpdate event of the Text field you could add...

Ta very much.

What's 'Wisk'? I can't make out the other text on the image.

Parts of Canada have snow in the Summer. I know that some paths near my father-in-law's house in Newfoundland still has enough snow left in July as to make them inaccessible.

If [Forms]![form name]![Field Outstanding] = 0 Then [Forms]![form name]![Paid] = True End If

In the form's Before Update event you could add a check to see if the selected date is correct. e.g. If Format([Forms]![form name]![date field],"DDDD") <> "Friday" Then Msgbox "You must pick a Friday" End if

Okay, as always someone's suggestion nudged me in the right direction. For the benefit of anyone who may have the same problem, what I ended up doing was as follows. I used the same query twice, thereby removing the need for the YTD query. SELECT Format(qry_Month_Totals.Date,"mmmm...

Thanks for the reply. It was originally a one-off query on one month's data at a time, so I didn't actually 'join' the queries. All the person running it wanted was to be able to call up the most recent month's data and also see the YTD figures. Now, they want to see a list of all months...

I'm trying to get my head round this query and not having much luck. I have table that contains. amongst others, two fields I need to use - Date and Amount. I already have a query that returns me the number of entries for a given month, along with the total value. SELECT Count(*) AS [Number of...

This may help you http://www.access-programmers.co.uk/forums/showthread.php?t=117044&highlight=postcode+format

Put 'DoCmd.Maximize' in the form's On Open event. You can also use the 'SetFocus' function here to move focus to whichever control you want. You can set the overall tab order for the form by opening the form in design view and going to View - Tab Order.

I think something like this should do it. Select [Address], [City], [Zip] From [Employee Address], [City Zip] Where [Employee Address].[City] = [City Zip].[City] AND [Employee Address].[Zip] <> [City Zip].[Zip]; Hope it helps.

I can't speak for anyone else, but I taught myself by working out exactly what I wanted to do in English, then searching for keywords (validation, enable, visible, etc.), on this forum and other places. At the risk of sounding like I'm trying to avoid helping, I found I learned the most by...

They certainly seem to. That and the 'Wait XXX minutes' one posted by KalelGmoon.