Search results for query: *

Stewart, the first step is to set the row source of the second combo box. An appropriate place to do this would be in the after update event of the first combo box. If you are not sure about the operators have a look here http://www.mvps.org/access/forms/frm0001.htm To go to the record chosen...

Heres some code that fills a list box with queries that a user has made. I use DAO but I think ADO is pretty similar. Make sure you set the row source type to Table/Query Dim strSQL As String Dim db As DAO.Database Dim rs As DAO.Recordset strSQL = "SELECT QueryID...

Bruce, try putting it in the afterupdate event. Ewen.

thanks Ed, I'll give that a try. Incidently how to I go about repairing a corrupted database? cheers, Ewen.

Hi, I am currently developing a database for our test department to enter and track bugs. They are currently testing it and twice now it has become unusable. They said it was working OK but when they tried to log in again after logging out they couldn't. When I tried to log in I got a message...

Hello, On one of my forms I have an Microsoft ListView Control v6.0 that is used to display a summary of information. What I would like to have is a horizontal scroll bar appear when all the data cannot be seen at once so the user can scroll the list view without having to resize the...

try this: go here http://www.rogersaccesslibrary.com/knowledge.html and download this file BangVSDot.zip hth Ewen

Hi, I have a form which contains four subforms. Whenever I change records on the main form the on current event only occurs for 3 of the 4 subforms. Also when I change records on the subform its on current event never occurs. All the subforms have the same parent-child relationship and where...