Recent content by kadams0920

How do you create a multiple valued data type in Access 2007 that can be used in Sharepoint?

Re: SOLVED: arranging controls on a form (Access 2007) Got it. Thanks.

Boy, I'm not new to Access, but new to Access 2007. I've been creating forms in Access 2007, but can't seem to move the controls around to rearrange them. Am I missing something? Thanks. Karyn

Wow, thanks Doc Man. Not sure I'm following it all after the first and second read through, but I'll give it a try.

Doc Man, Yes, product #1 could be dependent on (#2 AND #3) OR #4. Not sure how much layering you need defined? Some products can be dependent on one other product, some can be dependent on multiple products. How do you suggest I document the structural depth constaints - by product?

I'm maintainign a database of software products, and some of the products rely on others to run. It's not so complicated as manufacturing and assembly. I'll try to explain a little better: Products table: abc def ghi jkl mno pqr let's say Product abc is dependent on products def and...

I need to come up with a data model that represents product dependency. I have a table of products. I need to create another table that represents the depenencies of some of those products on other products. A product could be dependent on others in the following ways: - on one other product -...

Sorry for not responding - I've had a few days off for the Thanksgiving holiday. I'm back at this and appreciate your help. Here is a converted 2003 database. spaddhu, your query didn't work. Thanks for trying though. I hope we can figure this out. Karyn

I'm attaching the database for your review. I followed the find duplicates query wizard, but am not getting the results that I want. Can you please take a look at the query and let me know what I'm doing wrong? Much appreciated.

Thanks Adam, but it doesn't appear to be working. I created a find duplicates query from the query wizard and included ProductName and LicenseName. Here is the SQL query: SELECT data_ProdLic.[ProductName], data_ProdLic.[LicenseName], data_ProdLic.ProductName FROM data_ProdLic WHERE...

Hi, I need to identify from a table that includes fields, product and license key, if there are any products that have the exact same set of license keys. So for instance: product A has license keys 2, 3, 4 product B has license keys 3, 4, 5 product C has license keys 7, 8, 9 product D has...

Ah, that's it. I didn't think about the subform within a subform. This is working fine now. How do I make this a 'solved' post? Thanks so much. Karyn

Thanks - file's attached.

The attached database has a field that is calculating the dateDiff between today's date and the most current date on a subform. I can't get that working. On the form navigate to the Food Pantry tab, you'll see the calulated field called txtDaysElapsed. Can you please help me get this working...

SOLVED: Re: subform orderby I figured this out by invoking a query and sorting there.