Recent content by martinr

hello, i am trying to work out the best way to build a small database that will record bookings for theatre seats. does anyone have a sample design or suggestions for a good design i could refer to? i was planning to have a table for seating (each seat has unique id) , a table for the ticket...

Thanks Pat & Doc_Man for your suggestions and explanations.

Thanks Pat, Using your code and it's working well. btw, What is the best way to check if the ComboBox is cleared or has a Value selected – would any of these statements work? If Me.ComboBox1 = Null If Me.ComboBox1 <> Null If Me.ComboBox1.value = Null If Me.ComboBox1 Is Null If Me.ComboBox1 Is...

i've built a form with a Combo box that works well as the criteria selection tool, to run a query that returns and displays the data in a subform and also serves as the recordSource for a report. The query gets it's criteria from the combobox: eg Where (TblTransactions.Type)...

is there a way to get the same results without using Transform?

Thanks arnelgp, your solution is working well!

Thanks MajP and plog for your help. The first query returns the number of loans for each book per membership type, which is great. The second and third queries are a bit different... If I change one of the aggregate types to Max it just returns the max value of the respective values in the...

I have a set of records that is a list of borrowed books (book_id) and the borrower's details (member_id, category). Each borrower belongs to a membership category (ie, Student, Teacher, Pensioner). We want to write a query to identify, for each book, how many times it was borrowed by members...

Ok, Thanks for your suggestions. i have put the Purchases & sales amounts into the same field (-ve amount for Sales) If i aggregate the transactions by type i can get a sum that is the 'balance' for all transactions for each product type. How do i create a query to show a running balance/total...

Yes, just trying to run the query atm - no point building the form until the query is working...

i have a Transactions table for recording product Sales and Purchases and want a Query to show a running balance for sales and purchases for each product. i'm getting an error when trying to use the Dsum function below: (Type is product type and Tdate is transaction date) balance...

what is the considered to be the best database model for simple inventory tracking? ie product type X is purchased and sold, product type Y is purchased and sold with a query at any given point in time to show: what is the current stock level of product X (total purchased - total sold) a...

thanks for all your helpful suggestions /posts :) i found that this worked Ok - just activated the code via button Me.name_of_subform_control.LinkMasterFields = "" Me.name_of_subform_control.LinkChildFields = "" then re-applied the code with the matching field names inserted to reset the...

i have a sub-form that is linked to the parent form (using a product_type field) as the default setting. Is there a simple to way to enable/disable the parent/child link so the user could see all records if desired? otherwise i expect i need to set up a filter and re-query the sub-form?

is it possible to how to update a boolean (yes/no) field on a form based on the values of other fields on the form? eg = in the afterupdate property on the form could i use a statement like; IIf([Purchased]>0,[yes_no]=-1,[yes_no =0) and add other conditions to include other fields?