Search results

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?

i am getting a syntax error when trying to run an access select query - the query works fine until i include this Switch statement; genderStatus: Switch([gender]="M","Male",[gender]="F","Female",[gender]="X","Cross gender") should this sql statement work?

hi Gina, they are linked on the surname field; link master field = surname link child field = surname the linking works fine once the parent form record is updated - it's only when the form is first opened that they don't match. thank-you...

i have a subform linked to it's parent form (linked via Master/Child fields) so when a surname is selected using a Combobox on the parent form only the matching records are listed in subform. this works Ok except the whenever time the main form is opened the subform doesn't match the record...

i have a boolean (yes/no) field that i need to have available for user selection in forms. the preference is to display the chosen option as 'Yes' or 'No', rather than a check box (selected or deselected). can te user change the option by just clicking on the form control (ie one click changes...

thanks jhb for posting that! did you have to specify the X axis labels to be vertical? does your chart adjust/scale in size if you adjust your report page setup size (ie, from A3 to A4)?