dropdown list to depend on other field

It worked, Paul...delete key is working. I'm ready to start on the switchboard.

Thanks,
USEN
 
I'm saying that's what I do, yes. Many people like the switchboard though. In versions previous to 2007 you specify the startup form in Tools/Startup. In 2007 it's in the Access Options area off the Office button, if memory serves. In the same area you can tell Access not to open the database window on startup.

I usually just leave the "main menu" form open underneath the next form being opened, so when they close that they're back at the main menu. You can be more proactive and close the main menu then open it when they close other forms. The point of it would be to provide structure and organization to the application. Depending on the complexity of yours, maybe you don't need it.

Security is a whole topic unto itself. You can use Access security to protect things, you can distribute an MDE to your users instead of an MDB, etc. At the end of the day, Access is not a high security application, so be aware that a knowledgeable user can get around virtually anything. I distribute MDE's so users can't accidentally change anything, but have never used Access security. I often put a password on a particular form or report, and use self-built security on some applications, but it's mainly to track who is using the application.

Glad it's going well for you. If you keep developing, you'll look at this application in 6 months and wonder why you did things the way you did. In other words, you'll have found better ways. That still happens to me, and I look back at stuff I wrote years ago with almost embarrassment (my God, why did I do it like that?!?). Yet that old stuff is used daily and like the Energizer bunny, is still going and going. It's a nice feeling. :D
 
Thanks for the advice, Paul, as well as all the help you've given me over the last few weeks. I'm serious when I say I would NOT have made it without you. I'm truly greatful.

Now...I more dumb question for the road...what the heck is an MDE and how to I send it instead of the MDB? I know that MDB is the normal file extension for Access files (I assume it mean Microsoft Database?), but have never heard of MDE. Never mind...I just looked it up in my "Access 2000: The Complete Reference" book...lol. I've been sending them some MDB files all along for occasional approvals, but just might send the final one as MDE. I'm not concerned about high security...just accidental changes. I know that a few times when testing things, even I accidentally deleted something and had to go back to a "copy" and get it. I'm good at making copies of everything before experimenting...especially when it come to Access. I especially made them once you taught me how to make zip files...lol.

Thanks again, Paul!
USEN
 
No problem; good luck with the project!
 
Hi Paul,

I've found another problem in the Freelancer's Information Table with the Skills & Rates - or perhaps it's only a bug. It works correctly until you navigate to another record; howeever, once you've entered any rates next to the skills, when you navigate to another record and then return to the 1st record, only the last skill and it's information is shown. The data is posted and retained in the actual table, but the re-query doesn't pick it all up and re-display it on the form. Should the strSQL include all the fields rather than just the one that have ID #'s?

USEN
 
Hi Paul,

I know you're probably just busy, but I wanted to make certain that you'd seen my latest /problem (post #53) and had received the latest update to my database (post #54). I've completed all else (except the switchboard form...because my books say everything else should be completed before creating the switchboard) and am really anxious to see the final finished product.

Thanks, as always, for your time and assistance. I KNOW you'll be glad to get this one out of your hair as well...lol! I don't blame you.
 
Hi Paul...

I hope you've been real busy and haven't just given up on me this close to the end. I've tried practically everything I can think of, but nothing seems to make this work once other data has been added. I'll keep working on it, but would appreciate any ideas you or anyone else may have to offer.

Thanks,
USEN
 
Sorry USEN, I have been busy but I also lost track of the thread (and sent a daughter off to Kazakhstan for 2 years, had an anniversary and we had a fire on our block that burned down 6 houses). I'll try and look today when things slow down. Your previous post mentions that the problem is in post 53, but post 53 says:

Never mind everyone...I finally found the problem....

Can you clarify which post has the current problem?
 
Hello Paul...I'm sooooooooooooooo sorry to hear about the fires. Is there anything I can do to help those families? I have all kinds of clothing that I can donate if anyone is near my size & if I can figure out how to get it to them as I'm in Kentucky. I've been holding on to a lot of clothes ever since my sister passed away...some of hers; some of mine. I just couldn't see giving them to an organization that would just sell them for only pennies of what they were worth. Instead I've been saving them until I could find someone who would REALLY benefit from them. Please let me know of any female clothing sizes that are needed.

On the brighter side, congratulations on your daughter (where is Kazakhstan?) and on your anniversary.

The problem I'm still stuck on is still on the sfrm_Freelancer's_Skills_and_Rates. I'm not certain if the problem lies with the cmd_Store_Skills button or with the cbo_Skill_ID combo box? They both work fine as long as none of the other additional information (Other skills, Primary/Secondary rates, and/or any of the rate per boxes) have been completed. Even when I enter any of this additional information, the data IS posted to the correct table and everything appears fine until I navigate to another record and/or close the form...at which time, the data in the combo box as well as all the other boxes disappear (they are still in the table) and I can't get them back unless I delete the additional information. I've tried listing all 11 fields in the SQL with 0" on the ones that I don't need, but then I get a message saying the the # of columns don't agree (yes, I changed the 3 columns to 11). I also tried choosing one item at a time from the listbox and completing the other information before clicking on the cmd_Store_Skills button, but then I kept getting an error saying that the records can't be added because it required an entry in the RatePer table; yet, that information was being entered. I may have gotten past that problem by entering a "defualt" value for that table...not certain. I've also tried changing the SQL to get the information directly from a query that in essence provides the same informaiton. If we can't somehow get this to work on the form, I might just have to tell them they must rely on the query for this particular form. Problem is...they won't have the convenience of the delete button.

I'm fairly certain, Paul, that it's just something I'm missing somewhere. I honest tried my best to solve this on my own. I promise I did. I've also tried adding all the fields in the query to the VBA coding...but that didn't work either. I had so many things that I was trying that I kept getting confused myself. :confused: I even somehow messed up the cmd_Store_Skills button at one point where it wouldn't post to the table at all. All the VBA coding was perfect, and the Proceedure Click was there...yet it just wouldn't work. I kept messing with it so much that it finally got to the point where Access couldn't open the main form any longer. I ended up having to go back to a backup copy of the database. :eek:

It seems as if I'm so close, yet so far from the end.:( I may be learning a lot from this experience, but I sure will be glad to more on to another. I've uploaded the most recent version without any of the additinal information added. I'm sure you'll be able to duplicate the problem easily; however, I do have a backup where the form is NOT working due to the table having the information already added. If you need for me to send it to you, just let me know.

Once again, Paul, you KNOW I deeply appreciate your time. Be SURE to let me know if I can help those 6 families in any way. If not all these clothes, perhaps a financial donation? Anything...just let me know.

USEN (Karen)
 

Attachments

Hi Paul,

Haven't heard back from you & wanted to make sure you received my last posting...especially the part about helping the families from the fires. Please let me know what I can do to help...

USEN
 
I'm sorry, I did look at it and didn't see right off what the problem was. If I was younger I think I'd be diagnosed with ADD, because I seem to have a short attention span. Point being that I figured I'd come back to it and try again with a fresh mind, and forgot about it. What exact steps do I take to recreate the problem?

I appreciate your thoughts and offer for the families. Realistically, there's not much you can do from far away (too expensive to ship stuff), and both the Red Cross and the community are helping them out. It looks like a war zone here; 4 houses are down to rubble, and the other 2 don't look so good.
 
Hi Paul,

Concerning the families, let me know if anything does come up that you think I might be able to help with from a distance.

Concerning the database. To duplicate the problem, go to the main Freelancer form...frm_Freelancer_Information, then drop down to the area that contains the subform...sfrm_Freelancer's_Skills_and_Rates. Now choose 1 or more of the skills from the unbound lsb_Skills & then post it to the table (tbl_Freelancer_Information by clicking the button cmd_Store_Skills. Everything looks & works fine...the selected item(s) show up in the cbo_Skill_ID...as it should. Now...fill in one or more of the text boxes to the right of the cbo_Skill_ID...everything still appears OK, and the data you just entered will be posted to the tbl_Freelancer_Information table just as desired. Working perfect, you say? NOT....! Once you close the form and/or navigate to a new record, then return or re-open the form, the data you just entered will no longer show up...yet it's still in the table and will show up in the query if you run it...including the SQL query.

I know without a doubt that it's somehow in the VBA codingl. Problem is, I don't know if the error is connected to the cmd_Store_Skills code or if it's in the cbo_Skill_ID. Like I said, I've tried adding all the fields to the SQL for the combo box and changing the column count # in the properties (using 0" for the columns that I don't need posted), but then it keeps giving me an error saying the # of columns didn't agree with the source. Next I tried adding all the fields to the VBA code for the cmd_Store_Skills button and got different errors there (I can't recall now what they were). I tried other things as well, none of which worked, and I finally gave up when I began receiving errors that Access could no longer find the form. I have no idea what broke as Access still couldn't find the form even when I put everything back the way it was when I started. I ended up having to revert back to a saved file to fix it. I sure was glad that I learned long ago to make backups before making any major changes...especially when dealing with Access...lol.

Paul, I even thought about possibly making separate entries for each individual text box, but by that time, I was receiving the can't find form error so gave up. Wasn't quite sure how to do that anyway. Everything is right there & it's posting to the table correctly. The delete button works fine as well although I can't recall if I got around to trying it once any additional information had been added. I'd want that button to delete everything on that particular line...the skill and any rate information for that particular skill.

Oh...one thing I need to mention. In the actual query section, you'll find 3 similiar queries...

1 was requested by my employer:
qry_Freelancer's_Skills_&_Rates

The other 2 of them are a result of my experiments: qry_Freelancer's_Skills_and_Rates, qry_Report_Freelancer's_Skills_&_Rates

I think the only difference in these 2 is that one indicated the RatePer Code ID while the other will indicate the text that corresponds with that ID #. It would be best, if possible, to have the "text" show up rather than trying to remember what the ID# means. BTW, the default is "1" with the corresponding text being "----" to indicate that a choice has not been made yet. I had to do this because since it is a required field, I kept getting errors when I first made the selection for the skill. It automatically wanted this data with the selection, but wasn't giving me a chance to enter it.

Oh...another possible solution that I thought of but wasn't certain of how to implement here is to have the SQL use a Parameter Query that would request the additional data to be entered at run time. Is this possible in an SQL and/or would it work as I'm needing it to in this situation?

As always, Paul, do whatever you feel is best & easiest. I don't care "how" it works, I just need it to work like all the other subforms work...only this one has extra data that also needs to stay there even after the form is closed and reopened.

I'm once again in your debt...so far that I'll never get out...lol! Thanks Paul!

USEN
 
Hi Paul...just checking back to make certain that you haven't forgotten me again. It's been quite a while since I received and answered your last post inquiring as to the steps to take that will cause the problems.

Hope all is going well on your street now!

USEN
 

Users who are viewing this thread

Back
Top Bottom