Recent content by Sean O'Halloran

  1. S

    Merging duplicate rows and combining field values from the duplicates

    And that solution was? Link? Description? :confused:
  2. S

    "Type Mismatch" after conversion to Access 2007

    Thank you; I will research. I greatly appreciate your fast, accurate and informative assistance. Have a blessed weekend! Smilin' Sean
  3. S

    "Type Mismatch" after conversion to Access 2007

    Well - THAT was simple! THANK YOU! If I can impose on your goodwill - can you explain why the code worked in 2003, but not in 2007? Smilin' Sean
  4. S

    "Type Mismatch" after conversion to Access 2007

    Dear Colleagues, I'm in over my head. After converting an Access 2003 mdb to 2007 accdb I get a "Type Mismatch" error when trying to login. The error fires when it hits the code in red. "WorkerIDNumber" is a Primary Key - Autonumber - long integer. "Password" is a text field. Any help /...
  5. S

    Table dependencies - ARGH!

    One other thought: I suggest that your major issue is that you have split into two tables data which should be in one: What you should have is a table "Firms", which holds all law firm data. "Ours" and "Theirs" are just conditions for that data, in the same way that you would have a table...
  6. S

    Confused on this table relationship.

    Sorry - I neglected to wish you good luck in your project! Be well, Sean
  7. S

    Confused on this table relationship.

    Calvinle, I think you lost your forum audience because you did not explain what you are trying to do in simple language. Here is what I think they were looking for: "I have students who attend several different classes. In each class the student has homework assigned. I will correct the...
  8. S

    continuous from with subform

    Re: continuous form with subform I want to thank both of you for showing me a new way to pull multiple levels of data together on one screen. I appreciate the time, effort, and the mdb examples. Sincerely, Smilin' Sean
  9. S

    Null values must show in report list

    Thank you for your thoughts, Mike. For my agency's purposes we assume that not having a 'rent' income record means that income from rent is 0.00; so in this case the 'Null' record = 0, which I think leads me to my puzzle: How do I display all 10 items on the printout without having the...
  10. S

    Null values must show in report list

    Dear Forum helpers, I'm struggling for the words to describe my issue, which is probably why my forum searches haven't been fruitful. I have to match a pre-designed printed report which looks like this: Income -- Amount -- Period -- Verification Source...
  11. S

    Why is Left Join not working?

    Got it, I think. I created a query that filters for the 'tblAPS_Income.CaseIDkey' and made that the right-handed data source in the original query. Thank you again RNG, you D+D!! Smilin' Sean
  12. S

    Why is Left Join not working?

    Thank you! ...could you suggest any way around that issue? By the way - I fell off my chair laughing at your motto: "Build a man a fire.." :D:D:D
  13. S

    Why is Left Join not working?

    Hello All, My Goal: Have values which have NOT been entered by the user display on a report. What I've Done: 1. Searched the forum for an hour and came up with Pat Hartman's advice to create a Left Join / IS Null query structure. 2. Created a table of never-changing values that need to appear...
  14. S

    Linked Combo Boxes

    Watch out when attempting Cascading Combos in Continuous forms I fought all weekend with "Cascading Combo" issues, and let me just say that: 1. All novices - like me - should be told that Cascading Combos are NEARLY impossible in Continuous forms, which includes Datasheet view. 2. "Nearly"...
  15. S

    Inventory Database needed for School District...please help!

    Need to normalize I'm not the best person to help with this - "The Doc Man" is great with advice on analyzing which "entities" you need to assign to their own table, and I would strongly suggest you search for his name and read some of his numerous posts (try searching on these: entities...
Back
Top Bottom