Search results

And that solution was? Link? Description? :confused:

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

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

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 /...

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

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

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

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

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

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

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

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

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

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"...

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

Message to Self: It helps if you RTFM !! To anyone who reads this post: The way to build this report function is clearly presented in the Microsoft KB article whose link is shown in the thread-starter. I simply skipped a step in creating my report subform (the subform to display the trainers'...

Any bright ideas? I hope someone will post some code, because all the VBA I know would fit inside a thimble...my search for 'reset' 'requery' 'code reset', 'report instance' 'code reset', etc. Has Not Brought Me The Enlightenment I Seek. If anyone has any ideas I would be most grateful. Sean

Dear Mile-O, Thank you for your reply. I don't know how to do that; I'll start researching. By the way, am I covering well-trod ground or is this something that, when I get it working, is worth posting? I don't want to waste forum space / time, but I would like to share if others might find it...

I've searched for two hours here but can't find the answer on how to do this: My problem: Trainees get certificates when they complete a class. We print out certificates that say: "Joe Schmegacki attended 'How to Swim with Sharks' with the trainers Capt. Ahab, Mr. Jonah, Dr. Cousteau." I'm...

Thanks! I'll give it a try and post back... Sean