Search results for query: *

How do I print out table structures in Access 2000. Thanks in advance Quinny

Thanks Schof, How do I get the recordcount? I tried on the recordsource but that itself is a query. So I thought there may be some way of getting the number of recs from the filter?

Hi All, I have a form which allows the user to enter parameters for a filter on another form. This is done by constructing an sql "where" clause and passing it as a filter to the calling form. If the combination of parameters returns no values I want to be able to trap the error and...

Hi All, I have a form which allows the user to enter parameters for a filter on another form. This is done by constructing an sql "where" clause and passing it as a filter to the calling form. If the combination of parameters returns no values I want to be able to trap the error and...

Hi there Could anyone help with this problem? I am using the window.open function to open a new window. If the window to be opened can't find the page then I would like to be able to display an error message saying the page cannot be found and close the window. The code is below: set...

Sameal Thanks for your help Quinny

Raskew Thank you very much.Exactly what I wanted! Quinny

Hi everyone I have a main form , “House ” containing a subform ,”works”.The main form has a one to many relationship with the sub form. How can I display a total on a mainform which is the sum of a field ,”estimate”, on the subform which corresponds to the id field on on the main form.I.E...

Hi everyone I have a main form , “House ” containing a subform ,”works”.The main form has a one to many relationship with the sub form. How can I display a total on a mainform which is the sum of a field ,”estimate”, on the subform which corresponds to the id field on on the main form.I.E...

Hi Everyone, I wonder if you can help. I have a form with a subform on it which contains several fields. The sub form is based on a table called "Works" which can have several records for each one record on the main form. The problem is I need several fields on the main form...

Hi Everyone, I wonder if you can help. I have a form with a subform on it which contains several fields. The sub form is based on a table called "Works" which can have several records for each one record on the main form. The problem is I need several fields on the main form...

Hi all, I wonder if you can help. I am trying to write a query that sum's the value of a field in a table according to what the lookup value of this field is on a corresponding table.IE. Table "External elements" contains fields "Element name" and "Work Required&quot...