Search results

Thanks a lot. Worked for me as well.

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

Dear Trevor, Thanks. The document gives a general overview of linking or importing tables. Unfortunately it doesn't answer my question about pictures. :(. Do you have any other idea?

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?

Unfortunately not. They stay in normal mode.

Thanks for the reply. I have tried what you recommend and selected the plain white background (Autoformat None). The background colour changes, but the horizontal lines stay. Any way to get rid of those?

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

Thanks for the replies. Unfortunately that didn't work and for sure it is no picture. It is the background that was generated automatically when I created the form. See http://picasaweb.google.com/jan.vanbekkum/201003Access#5451341439966389170 Any other suggestions?

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?

Thanks a lot, this works really well.

Thanks a lot for the help!:):)

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?

Thanks a lot! This works.

CreateOpportunity

Thanks for your reply. I call it through a button I made in the subform. My objective is to append data from one table into another, but to let that happen only once per record in [Proposals] The macro contains a conditional open query. The query appends data to the table and sets a flag in...

Thanks, I guess I'll need to learn VBA. In the macro I entered [Me]![FlagProductListCreatedSet]=False (the square brackets are added by access) but get "The object doesn't contain the Automation Object 'Me'.