Search results

  1. C

    Unbound form with a bound subform

    Is this possible? I have a data entry form that I can't quite get to work. I have an unbound form with 5 fields on it... Part Number, Part Desc come from one table, Category comes from another (many parts - one category), and Source, Default Exchange Rate come from the last table (many parts -...
  2. C

    On Dirty, save all changes as NEW record

    Hi All, As the title states, I need to find a way to check if changes were made to a record, and if they were, save the info as a new record, leaving the original untouched. I would guess this could be accomplished using the on dirty event and perhaps some "insert into" sql, but in reading...
  3. C

    Getting a Data Type Mismatch error... I can't see why

    Hi guys, I created this module, and when I try to call the public function ProductPerformance, I get a datatype mismatch error. I'm hoping a fresh set of eyes might help me find the issue... Option Compare Database Public Function ProductPerformance() On Error GoTo Err_ProductPerformance...
  4. C

    Nesting JOIN syntax

    I am just wondering the proper procedure for nesting JOIN statements... I have a statement that is set up like this: FROM (((table1 LEFT JOIN (table2 LEFT JOIN table3 ON table2.fieldA = table3.fieldA) ON table1.fieldB = table2.fieldB LEFT JOIN table4 ON table2.fieldC =...
  5. C

    Need help adding grouping to an existing query

    Hi guys! Happy new year to everyone! I have a couple of existing queries that come together to produce sales information. Right now, it is done only at the national level but we are looking to calculate it by zone (atlantic, prairie, quebec, etc.). I have another table that is not currently...
  6. C

    Set report control visible=false based on value in detailed records (for each record)

    I think I pretty much described my issue in the title... I have a report, and in the details section, if a field is = 0, I would like to set a label's visible property to true, and if the field's value is <>0, set the label's visible property to false. As always, any help is appreciated. Happy...
  7. C

    Can't refresh a textbox that DLookUp's the result of a query

    Might be a slightly confusing title, so I appologize for that... But hopefully it was confusing enough to get some people to take a look at my problem! :rolleyes: To start, I have a table with 7 fields; six of which are attributes, the seventh being a unique number assigned to each unique...
  8. C

    data entry in a junction table

    Hello all, I just wanted to run this by some experts before I go mucking around in my db. Basically, I am creating a data entry form to populate with information about car parts, and the vehicles they apply to. This is what I am working with: tblParts tblModelsParts tblModels...
  9. C

    Field criteria: Is Null; there are Null values in that field; no records are returned

    I think the title pretty much sums it up.... I have a query where data is first sorted by user input; first field's criteria: [fieldname], then by another field's criteria: Is Null. I know there are records containing null values in the second field, as I have run a select query with the...
  10. C

    Rock, Scissors, ...Paper?

    A buddy sent me this, and I thought some people here might get a chuckle out of it...
  11. C

    Trying to plan out a db. Plan is attached. Advice welcome.

    Hello all, I have attached a rough outline of my best efforts at designing a normalized db. For anyone with some questions, rather than retype a whole page or so of information, I will direct you here first. Thank you for any and all suggestions. Colin
  12. C

    Limiting the number of available records in a table, and recycling/reusing them...?

    Well boys and girls, its about that time in the week where I have once again come up with a brilliant application for my little Access project, but have no idea how to make it happen. I will start with a little background info... In the course of the parts recoveries we have different reasons...
  13. C

    Combo Box won't update... and oh, how I have searched

    Hi all, I've been searching for a couple hours, and I can't seem to find the answer to my problem on any number of forums. I will start by explaining it... I have a combo box on an invoicing form that is populated by a select query that lists records of active projects (by project number - a...
  14. C

    Select and Append Queries... at the same time?

    I've done some searching, and haven't found any threads that match what I am attempting... I have a database that tracks expenses that are incurred under different ongoing projects. I currently have a report based on a query that asks the user for the project number, and shows all the expense...
  15. C

    entering data in a field through filtered records only

    uh.. I guess the title pretty much sums it up... Is there a way to enter data in a text box or something once, and have it applied to all the filtered records? I have it set up so that we can sort by project number, and it displays only the invoices that havent been assigned to a bill (we...
  16. C

    error message displays when trying to close the form/switch to design view

    I have a form with a subform in it. On the main form, I have a combo box with a list of program numbers to choose from. Once one is selected, the subform displays all the unpaid invoices under that program number. This part works fine. The problem occurs when I try to close the form, switch to...
  17. C

    display the next autonumber in a form

    OK, I guess the best thing to do first is give a little description of what I am working with here. I have a table that tracks invoices. For each invoice that is input, an autonumber is assigned. We take that autonumber and write it on the hard copy of the invoice, just in case we ever need to...
Top Bottom