Search results

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

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

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

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

Dear Experts, I became intrigued with a function which Pat Hartman posted in her "BoundDenormalizedForm" zip some time ago, and I worked on this variation. I am trying to mimic the look and feel of a series of checkboxes. By virtue of Pat Hartman's query magic each check box creates a...

..Or: "What Access Can Do That Powerbuilder Can't"... Six years ago I picked up one of those 1500 page MS Access tomes, found Pat Hartman, The Doc Man, and many others here on this forum, then sat down for two weeks and laid down the foundation of a database ( "GINGER" ) that has been used by...

I’m struggling to fix a database for my state agency. Here’s what the social workers need: The agency holds several Foster Parent training sessions a year. Each session consists of 9 classes. We need to track ‘student’ attendance at each class. We also need to track class dates for each...

My database was working well but I decided to clear out unused objects, etc., because a major revamp is coming. I made several copies, ran FMS Total Access Analyzer on one copy and started removing objects. After removing a number of 'unused' queries, my modInitialize started yelling DEBUG at me...

I've searched the old posts and MS support for hours and I'm not finding the answer, yet I feel I'm simply missing something basic...please be patient. I have 20+ concurrent users in an Access 2000 FE/BE Win NT environment. They are constantly entering 'Contact Notes' which are sub records of a...

I'll try to keep this brief: my users are losing certain records; approximately 1 record lost every 2 weeks for past several months. Users create 'Contact Notes' which are part of a larger record; the larger record remains intact when loss occurs. Sometimes, not always, certain table...

I'm a social worker for the state of Maryland, pushing hard to build useful software for my fellow Child Protective Services workers. My partner in this is a great programmer who is overloaded with trying to keep the agency's 90 plus Access 2K up and running - and he can't devote much research...