Recent content by Metta

Thanks for the heads-up, Paul. This looks really interesting. Now, to find some time to implement it...

Hi JHB, thanks for giving it a go. It seems to be a problem only sometimes. I've gone around the issue by creating an accde for users, so it's a non-issue from their perspective.

Update: The working solution for the time being is a query of businessID and the dates, then import the query into Excel. The Excel file uses: - a table of the imported data, with names defined in columns - a table in which all the cells contain a generalised formula which identifies the...

I put the code in the OnLoad function, and it works fine - thanks. However, when I close the form which contains two datasheets with this code in their OnLoad settings, I get a prompt to Save the subforms - even when no change has been made to the forms by the user. Is there something I can do...

Awesome! Thank you both.

Using Access 2010, I have a subform in datasheet view and I want to set the font size to 10pt. Setting font sizes for datasheet fields in the Format tab does not change the font size displayed. I understand that the font size can be set using VBA (for example: Me.DatasheetFontHeight=10). Where...

I'm aiming to create a stacked area chart to display the progress of multiple projects over time, so we can review and forecast project load over time. The data comes from this table: tblProject * ProjectID * DateProspect * DateConfirmed * DateStarted * DateComplete A project passes through...

Hi everyone! I finally registered today and I want to say a huge thank you to you all - everyone who's answered questions and helped to solve problems, and everyone who's taken time to pose questions and problems too. I've been using Access for 2-3 years now, first of all using one of the MS...