Search results for query: *

Using Excel 2003 and Access 2003. I need to import Excel files from a third party. All files consist of one worksheet (different names) that contains results from a particular survey and, therefore, has a varying number of rows (300+) and columns (100+). I'm interested in 15 columns, only a...

My understanding of 2NF dependency is that non-key column values are implied by their entire associated primary key. In other words, for the composite key ProjectID+ProduceItemID, ProduceItemType is fully dependent because it describes the particular item identified by the key. But...

Thanks, rac2, your comments make sense and I have streamlined my relationships accordingly. But I think I may have bigger problems/confusions... First question (that seems like it should be an FAQ, but maybe I'm just overthinking things): Whenever a lookup query is used to populate a list of...

TablesProductDetails: Primary table with a text-based primary key (ProjectID). pdProduceItems: Secondary table with an autonumber-based composite primary key (ProjectID + ProduceItemID). pdOnions: Tertiary table with an autonumber-based composite primary key (ProjectID + ProduceItemID + OnionID)...

Thanks, Remou! I ended up having to delete all my code and import everything to a new database (the second recommendation in the FAQ), but being able to do that saved me a huge amount of time. Everything is back on track now. Much obliged, j

Please help me if you can...see thread702-1316841 for original details. Since that posting, I removed all code from the problematic form hoping that I'd be able to rewrite it. While I can properly compile the VBA project now, "Value" is still the only property available to any fields active on...

More information on this confusion... I wrote almost identical code for another form in the database and it's working perfectly. It remains functional after having closed out of Access and reopened the database several times. Also, when I try to rewrite the problematic code within the...

I'm working in Access 2003. I have a form containing code that was entirely functional earlier today, but now gives me the following error when opened: This form performs the following actions in response to the following events. Actions: * changes the Enabled property of various controls...

Traingamer, Doh! I can't believe I missed that. Nor can I believe two IT people in my company missed it! Thanks a bunch, j IGPCS, I didn't try your method since traingamer's worked, but thanks for the reply. -j

AceMan, Thanks for replying and for the links. I certainly do want to understand as much as possible. Sorry for all my Tek-Tips faux pas, especially if my reply to your initial recommendation was offensive. Upon re-reading it, I realize that what seemed succinct but playful in my head came off...

When I try to use the Percent format for a field, I can never enter the data I want. If I enter a decimal, the field returns 0%. This happens no matter how many decimals are allowed. If I enter a whole number (3), the field returns as expected according to the format description (300%). I've...

AceMan and DanVlas, I can't get either of your suggestions to work. Can you be more explicit as to how to incorporate them? Remember! I'm a novice! Thanks, j

Hey all, I just started using Access about two weeks ago and am managing for the most part. Just now though, I've been stumped. I'm using the Function below to ensure that data entry doesn't occur out of order. In other words, additional fields aren't visible until the currently visible...