Search results

I use MS Access 2007 and SharePoint 2007. I have designed a database that is shared in our group. I am using SharePoint to share the tables. Some tables I would like to keep always online. For performance reasons I would like to take other tables offline and synchronize them from time to time...

In a table I have links to a picture library (one picture per record). How can I show the picture in a report? Thanks in advance.

I have a table with products in SharePoint. The table links to Access. I have images of the products in SharePoint as well. How can I select the images in an Access form and show them in an Access report?

I have a list of products in SharePoint and I link to that list in an MS Access form, How can I show pictures that are stored in SharePoint (one picture for every product) in an MS form and report?

I have a table [DecisionMachine] with a master/slave relationship to a second table [DecisionOptions]. I also have a form with [DecisionMachine] as record source. In the form I want to use a listbox that only lists the records in [DecisionOptions] that correspond with the current record of...

I want to fill a property in a form with [Forms]![Opportunities]![Proposals].[Form]![SalesForceNumber] if the [Proposals] form is open and with 0 otherwise. Setting a default value for the property works well if the form is open, but I get (of course) #Name? if the form is not open. How can I...

I have created a form using the form wizzard. I got a form header with fancy colored bars. How do I get back to a plain background?

I want to make headers of columns in a report dependent of the language of the report. I have a control "AmountHeader". Dependent on the language it has to become "Amount" or "Bedrag". I created a table Translations with a.o. fields "AmountHeader" and "TranslationLanguage". The control...

When I create a report using the wizard I get the labels for the controls in the page header section and the controls in the details section. Somehow they are linked (visible by a dashed line around the two): if I move one to the right the other moves with it. How can I remove that link?

I use in a macro the condition [Forms]![Proposals]![FlagProductListCreatedSet]=False I trigger the macro using a button in form [Proposals] This works well if the form [Proposals] is opened directly, but if it is opened as a subform I get the message "MS Access can't find the form Proposals...

I have a table named "Proposals" with records with a field ProposalNumber. I have a second table named "LineItems" with a one to many relation through this field ProposalNumber. In a form in which I can update fields in "Proposals" I want to run a query that appends records to "LineItems". The...