Search results

There are more knowledgeable people than me on here who may have a better method, but I do something similar to what you are doing by looping between the start and end dates, writing a row of values to a table for each date and then displaying the table as a pivot chart. I do this in VBA - code...

Hi, I'm stuck trying to tally and summarise some data. I have clients with a current location. Locations have a value for Facility A and value for Facility B. This is in a separate table as it can change over time. I want to simplify it so that if a Location has Facliity A value > 0 then...

Hi, I have a pivot chart which shows data by week of the year. Is there any way to have Week 1 start on April 1 (or other arbitrary date)? Thanks. Mr Smin

Dear AWF, I need to distribute a Word form to people in other organisations and have them email it back. I want Word to at least default to, and ideally force, encryption as the form contents are confidential. I created a .dot which is encrypted and prompts for a password on opening. I then...

Thanks guys. Works well.

Dear AP Forums, I want to query my Sites table and then loop through some VBA for each of the sites returned by the query. I imagine I need to do this by putting the query results into an array but I can't figure out how. Please could someone recommend a tutorial, or explain this? (please...

Thanks HTC - solved my problem!

Hi, I have a subreport which works correctly when it displays a few records, but when it returns enough to make the subreport more than one page long, Access' status bar shows "Formatting - press ctrl+break to stop" and hangs. Please could someone tell me a way around this? Thanks. Smin.

Hello everyone, I have a situation where I want to report on occupancy in residential buildings. Some of the occupants are full time, staying one or more years. Some are 'testing the water' for a few weeks, possibly progressing to full time. In this trial phase, a single room may be used by...

Keep in mind I'm no specialist so although the following works, it may not be elegant, and I apologise for some confusing naming of objects. The following code is attached to a button called btnOK which is in a subform alongside the listbox List0. This is populated from table tblChecklist. The...

DCrake, thanks for the help. It's working now. The wheels of the IT dept grind slowly here, so no additional priviledges for the forseeable future.

I am trying to make a flexible checklist (of things which have to be done to discharge a patient from hospital). My preferred interface is a multi-select listbox - the user selects items which have been done and then clicks a button to confirm. I'm open to other suggestions. My intention is...