Search results for query: *

You are right about it being a many to many relationship, but it's not quite the same as students & classes because there is only one premises table, and I want to return all the combinations of parents and children premises ids. tblPremises PremID PremName 1 Steve Court 2 Steve...

My organisation performs a number of different collection services from a large number of premises. The most complicated situation I am trying to model involves a block of flats/ apartments / retirement home. In this scenario we might have 16 flats in 4 blocks of 4. Blocks 1 & 2 have collection...

Create a form for printing the report. Use unbound text boxes or combo boxes for the user to enter / choose the criteria, then write a query using the criteria entered on the form. The base your report on the query, and finally add a button using the method above to open the report.

To Ace-Man I have a similar problem, and was wondering where you need to put the code. Can it run once on startup, up do you need to include it anytime you open a form or run a query using the linked tables? Thanks Steve

figured it out now. Steve

Hi I have to have two tables for sites and master addresses, as the occupier of the site may change with time and we need to keep historic records. I have two forms, one based on the sites table and one on the master address table. When a user enters a partial address in the sites form, they...

I have a similar problem, but rather than exporting the results of a query from a subform, I am amending data in a table using a subform, and need to update an excel spreadsheet with the results of a query based on the modified information in that table. The code above looks almost ideal...

Thanks, that seems to have sorted the problem Steve

I've writen this code For i = 1 To Iterations Set db = CurrentDb strSQL = "INSERT INTO tblTempSchedule (MultiColln) VALUES (#" & CollDate & "#)" db.Execute strSQL MsgBox CollDate CollDate = DateAdd("d", 14, CollDate) Next Which inserts the dates correctly except for the first iteration...

Thanks for the reply, let me elaborate. Ideally I don't want to store the dates at all, I want to create a query to extrapolate the dates to make a calendar, then mail merge that with the customer address and send them a calendar. I specifically don't want to have repetitive column headings...

My organisation provides a biweekly collection service for our customers, and I want to produce a calendar of collection dates. So far I have made a query that takes the collection code for the customer and produces a start date for the first collection in the next financial year. What I want...

Works a treat. Thanks very much. Steve

I am trying to write a query that searches a table with address data based on criteria input using a form. The trouble is that if the field in the form is null the criteria in the query is "Is Null". I want to return all values for a field if the form in the form is null, i.e. the equivalent...