Recent content by peter2012

I have a report that fits nicely onto one A4 page. Then I had to add an ID column to be able to sort by ID (would not sort by ID unless I added the column to contain the record ID numbers, even though the query on which the report is based is sorted by ID). Because I added another column (on...

Ah, conditional formatting of forms, didn't know that. Thanks. So I'll use a form. Any ideas anyone how I proceed from there? Peter

I have a report reporting events that occurred today, using =Date() in the query. I want to have a control/box on the report which shows today's date by default, but enables me to select a different date with the outcome that the report refreshes and shows the events on the selected date...

Thanks JHB, that fixed the error message issue! On the other issues, for the benefit of others who might encounter the same problems: On the issue about data disappearing where I completed more than one record at a time before refreshing/saving, and moved from one record to the next, that was...

I have a form (frmTimecardsDataEntry3*) that needs to requery combo boxes to narrow down the selections offered in the dropdown of each combo box. It is a data entry form. I.e. Dataentry is set to yes. The ClientName combo box has an after update event which requeries the matter combo...

Thanks Bob and Plog I am still struggling as to what function to use, given the error message reported earlier. In Excel I have no problem at all summing hrs:mins, by formatting the relevant cells [h]:mm, but there is no equivalent in Access so far as I can tell. Peter

I have a table of timecards each recording minutes spent on each task for each client and I have summed those minutes by client in a query. I have then in the same query converted each sum of minutes to hrs:mins format using this calculated field: HrsMins: [SumOfMinTime]\60 &...

Rainlover, sorry I do not understand that. I already have thousands of records in the Matters table with data in the units field, and on those matters and some future matters I still need to be able to add new records in units and report those matters in units. Are you suggesting a combined...

I have a time-recording database, and the relevant tables are Client, Matter and Timecards. Each timecard records one piece of work for a client on a matter (e.g. Letter out) and the time spent on it. Any matter can have one of two possible billing methods - either units of time (minimum...

Paul, where is that control set? I cannot see anywhere a way to set a control for a paragraph. Is it in Report/Design View or where please? What I want to do is make one setting for the field which will cause it to show the paragraph breaks (which show in the equivalent form) in all of the...

I have an Access 2010 database with a memo field formatted for Rich Text. I created a simple form. It accepts and shows paragraphs, i.e. I press Return and a new paragraph appears (with a blank line in between paragraphs). I then created a report based on the same fields. In the memo field...

I am trying to create a report or form (not sure which is most suitable) which when opened will show a summary of my data. My data is essentially a table of timecards, with various linked tables which together enable time working on a lot of different projects to be recorded and reported on...

Beetle, yes that works, you are a star - reference to the form control particularly important - I was referencing the field value (and too many tables!). I've definitely learnt a few things. Thanks Peter

I am working on a database (in Access 2010) which records time worked for different clients on each of their many matters. So there are the following tables: Clients, Matters, Timecards, Rates, MatterStats. Matterstats joins Matters to Rates as it is a many to many relationship (each matter...

Simon and Ling, thanks Yes in the form's property sheet in the data tag (in A 2010) I have an "order by on load" of ID DESC. And the query behind the form (and the table that the query is based on are both sorted as ID DESC, though this does not make a difference to the problem first...