Recent content by MarkRennes

Point taken, Pat: normally it's the owner of the data source that needs to create an ODBC driver. But since Google has not done so - and has other priorities! - might a third party take an interest? Because the underlying problems are these: 1. Google Docs / Drive does not include a relational...

I continue to tear my hair out that standalone Microsoft Access is not really web-accessible. I've come to like and depend on Google Docs, now Drive; Since I work in a business school we use them via Google Apps for Education. All quite useful. We also teach our students basic Microsoft Access...

Hello and thank you for your reply. I realise that I have asked my question badly, so I'll try again. . I am using a form in view mode. It's a master - detail - subdetail, so form - subform - subform. I wish to paste data from Word into a particular field of a particular row in a detail or...

The Format Painter seems not to work in Access 2010. The Format Painter button is not in Home / Text Formatting, where you might expect to find it. I create a New Group and add the Format Painter icon. I cannot then use it. It stays greyed out. I add Format Painter to the Quick Access menu...

I think that you've almost answered your own question. You are quite correctly storing different kinds of data in different tables - one table for each kind of thing or entity. In the subtable, you should keep the part number as what is called the foreign key - it's a foreign key because it's...

Thanks for your reply. I appreciate that only the field names in the first part are visible. But it's the value in the second table that I want, that is, the news attribute - that's the whole point of using a UNION query in the first place. If I reverse the order of the two components of the...

I have used a SELECT UNION in order to get round the fact that Access truncates Memo fields. My query reads: SELECT DISTINCT [surname] & " " & [forenames] AS fullname, Answer.grade, Answer.[grade mark], Answer.[actual mark], Answer.[penalty type], Answer.[penalty percentage], [Project...

Yep! Rennes, France - a city with a population a litlle lower than - say - Brighton at about 210,000. It's in Brittany, in the north-west of the country. Main activities are telecommunications, car-making, education (60,000 students) and administration - France is the happy home of bureaucracy ;)

1. Sorry to cause you unnecessary work. Yes, it's Access 2010, and yes, the database does use 2010 features. 2. Yes, as I've already said, your suggestion was 100% helpful. Many thanks.

Thanks to vbaInet for your suggestion and to Bob Larson, whose answer has solved my problem! Bon week-end, as we say in these parts...

Hello and thanks for the suggestion. I'm new on this forum and cannot as yet upload images. I've "emptied" my database of sensitive data and compacted it so that I can attach it (an exercise which has taken all afternoon, getting a 7Mb database down to 2Mb, the forum limit). The problem is...

I am reluctantly reaching the conclusion that Microsoft Access is a great way to learn about databases, a great way to build a single-site client-server database for a restricted population of users, and effectively useless in a web environment. Access 2010 databases integrate fairly well...

When I print or print-preview a report with a subreport, a completely unwanted header appears and overwrites the first line of each subreport. It cannot be seen in report view. In appearance it is like a watermark: that is, it is faint while the actual data is in a normal font. The text is the...