Search results

  1. J

    Taking some SharePoint tables offline only, not all

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

    Show picture in report from field with html-link

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

    Question Display SharePoint images in Access forms and reports

    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?
  4. J

    Display SharePoint pictures in form and 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?
  5. J

    Update listbox dependent on data in form

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

    Using default value in form property if other form not open

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

    Remove fancy background in form header

    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?
  8. J

    DLookup struggle

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

    Unlinking labels and controls in report

    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?
  10. J

    Field in form not seen if subform

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

    Get parameters for append query

    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...
Back
Top Bottom