Search results

  1. M

    need some help pls with using a combobox as criteria for a query

    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)...
  2. M

    help needed with a count(?) query?

    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...
  3. M

    help needed using Dsum for running total in a query

    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...
  4. M

    what is the best data model for simple Inventory tracking?

    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...
  5. M

    how to link or de-link master/child fields in sub-form properties

    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?
  6. M

    how to update a boolean field on a form based on other values

    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?
  7. M

    help needed using the switch function in a query

    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?
  8. M

    how to open a subform to match parent record

    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...
  9. M

    what is the best way to format the yes/no option in forms? control

    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...
  10. M

    help needed with formatting charts

    I have inserted a 2d column chart into a report and it looks fine, however when it loads into 'print preview' or layout view only 12 of the 14 columns are visible (2 columns do not 'fit' into the chart). I adjusted the column gap but it just makes all the columns wider and the gap between them...
  11. M

    question about data bars and conditional formatting

    using Excel 2013, I’m trying to use conditional formatting to display data bars inside cells linked to percentage values, so a cell with a value of 10 % is easy to differentiate from a cell with 80 % etc. When I copy the format to multiple cells (1,000 rows) it automatically sets the range (in...
  12. M

    Conditional formatting - using data bars in excel

    Is there a way to format a data bar (inside a cell) with more than two colors? I can get the bars to appear green for positive values and red for negative values, but is it possible to show colors for other value ranges? Eg Value below 0 = Red Value between 0 – 20 = Orange Value...
  13. M

    Is this a design problem or SQL problem?

    I have a table (TbAttendees) for recording numbers of training course participants from different organisations (different rates may be charged to each organisation) and another table (TbGroups) to allocate facilitators and other resources for each group. I have a one to many relationship from...
  14. M

    need help using the max function in aggregate query

    I have a list of product sales for various regions. How do I write a query to only retrieve the record with the highest value in a region, but include the region and product code in the results? For example, If I run an aggregate query using the max function I still get the record for region...
  15. M

    how to run an sql from a subroutine in a subform

    I'm trying to run an sql update query (in VBA) to update values in a table, from calculated field values in a subform (using a query as a record source). Is this possible , and if so, can I call the subroutine from the parent form, and what would be the correct syntax for the VBA sql string...
  16. M

    how do i sort on group subtotals?

    i have a report with one grouping level that has subtotals for a field. is it possible to sort by the subtotals for the grouping level - so the group with the highest subtotal will be first, then the the group with the next highest subtotal, etc
  17. M

    can i change the default printer for the report?

    My workstation has a default printer that only prints A4, but I have an Access 2007 file with reports that require A3. When I open these reports they see the A4 'default' printer. If I try to change to the A3 printer in the report page setup (in design or print preview mode) it doesn't change...
  18. M

    excel 2007 datedif function question

    i have a problem with the datedif function in Excel 2007, (it displays #NUM! when i try to use it). I know this isn't an Excel forum - can someone recommend one? Thanks.
  19. M

    updating/adding new records to existing tables

    I have a table with more than 60 fields and need to update it with records from another Access file with a table with an identical data structure. Is it better to run an update query or an append query (i would have to delete the original records in the target table first) or a union query...
  20. M

    how do i handle report from a query that returns no records?

    A have a report that is based on a query that works fine when the query returns records. However if the query (legitimately) returns no records then the report fields (numeric) are blank. How can i get the query or report to show either "0" or "no data" when no records are returned? I have...
Top Bottom