Recent content by chancer1967

  1. C

    Group by a range of values

    Hello I am stuck trying to group my data in a query, and am hoping for some help. I have a table which I am interrogating. It details sales transactions, including all the usual stuff like product, quantity, price, customer, etc A separate 'inventory master' table has category codes for...
  2. C

    subform requery (beginners level)

    Apologies in advance for the basic nature of this, but in the past two years I have forgotten everything i ever knew! I have two tables - Holders (holderID, name, current address) and Addresses (addressID, address1, city, etc) current address is linked to addressID I am trying to create a...
  3. C

    Put results of a query into a text box

    I'm sure the title could be more elegant, but anyway... I am creating a data import feature in my database. And it works like this: - user clicks the menu item "import data" - a form loads and a file open dialog opens - if they cancel the dialog, the form is closed - otherwise, they select...
  4. C

    Subform problem with VBA code execution

    I am getting exactly the error in the first point - code that works in the mainform is bombing in the subform I have tried it with an On Dirty and and On Load and it doesnt matter what the VBA is, I get the error in IanMilly's gif - even when the only code in the VBA sub is 'test What I am...
  5. C

    Conditional criteria

    Peachey! I can see that I am going to have to start looking at the SQL view a lot more :)
  6. C

    Conditional criteria

    I have a form/subform that shows invoices for a selected customer. I have created a checkbox on the main form, that if ticked will exclude paid invoices (zero balances) from the subform. That's the intention anyway, But my conditional criteria is working backwards - when ticked I only get...
  7. C

    Refreshing a form

    re Question 2 - I tracked down the answer and its pretty ugly :eek:
  8. C

    Refreshing a form

    Now THAT worked a treat! :)
  9. C

    Refreshing a form

    Question 1: I have a form/subform that lists invoices owed by a customer The user can click on an invoice and click a 'write-off' button that opens up a new form populated with the invoice data. They select a reason code then press submit, which closes the write-off form (using a macro)...
  10. C

    subform footer

    Could we get a tutorial of form/subform totals in the FAQ? After trawling through several similar posts, this one solved my issue.
  11. C

    Pass data from a form to a new form to a table

    That worked a treat. What I did not explain properly is that the contents of frmAdjust then need to be added as a new record to the table Adjustments, using a submit button on the form. Erm... how? :)
  12. C

    Display subform when no data

    Perfect! thanks :)
  13. C

    Pass data from a form to a new form to a table

    I have a form/subform that lists outstanding invoices (frmOutstanding) for a selected customer I want to be able to have a button on that form for writing off a balance. Pressing the button opens a new form (frmAdjust), populated with invoice number and outstanding balance (both from...
  14. C

    Display subform when no data

    I have a database for credit control and within this there are tables for invoices, credits and payments. As a reconciliation tool I have created a form that gives activity totals for a given month. The top of the form has two text boxes for year and month (they will become combos at some...
  15. C

    Filtering a subform

    A have (finally!) successfully created a form/subform that lists invoices by customer. A combo box lists all the customers, and the subform lists all invoices for the specified customer, with invoice value, payments received and a calculated net balance (invoice value less payments) Over time...
See more
Back
Top Bottom