Search results

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

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

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

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

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

Hi, I'm trying to order a subform by a date in descending order, so I used the orderby property of the form like this: "DateServed Desc". This then doesn't seem to translate when the form is a subform of another. It's not ordering as specified. Do I need to do something additional in the subform...

How do I use the Now() function as a default on a form without including the time? All I want to do is default a date to today's date. Thanks so much.

I can't get the subform requery to work after making a selection from a combo box from the main form. Note the attached after update event code. I don't think the statement Me!fra_sbfrm_ClientSearch.Requery is working. Any suggestions? Thanks. Dim qryT As DAO.queryDef Dim duz Dim SQLR As...