active x list view?

[shutzy]

i have been guided by mr b to this point. he has pointed out that a listview might be able to solve my query.

the query is, i have a diary(again curtacy of mr b) that displays the days appointments. each appointment has a status(not displayed in the diary view) of 1=default 2=client has arrived and 3=client has paid for the treatments. the view i have at the minute is from a list box. the 1st cloumn is the time intervals from 9am until 8pm every 15mins. the 2nd column is the client that has booked the appointment and the 3rd is the appointment end time.

what i really want is to 'block out' the appointment duration in a designated colour. i would like to be able to have 4 different colours. one for each of the status' and one for if the appointment time has elapsed and the client has not shown then i think blocking this out in red would be appropriate.

i have search the internet about list view but i am a little daunted by what i read. im wondering if anyone could push me in the right direction of the end result i want to achieve. i have uploaded my database in full (minus personal details) for you to browse. the main diary is frmDiaryView.

thanks for any help regarding this

 

[MarkK]

I get an Unrecognized Database Format error trying to open your accdb. Keep in mind, if you are using Access 2010, that anyone with a previous version is not able to open your file. If you save it in an older format and repost it, you'll expand the pool of people able to help.

To vastly simplify working with Listviews check out http://www.kleindata.ca/Tools.aspx on the Listview Builder tab.

Cheers,
Mark

 

[shutzy]

sorry about that i keep forgeting. ive tried to save it as mdb but it is saying that the specified database sort order, general, is not supported for the target database format. any help on this as i cant save it as mdb unless i resolve this seemingly simple issue.

 

[MarkK]

Possibly you have used or implemented features that are not available in an MDB. Can you save it as an accdb for Access 2007?

 

[shutzy]

all i can save it as is accdb. it dosnt specify wether it is 2007 or 2010. 2007 access should be the same format? if you are using 2007 i dont see why you cant.

 

[MarkK]

Your call about how to proceed. I can't do any further troubleshooting with what you've posted. Maybe if you remove attachement fields and multivalued fields from your tables your conversion to mdb will work, but I don't know for sure that is the problem.
Cheers,

 

[shutzy]

thaks for the advise. i dont use attachments or multi-value fields yet so i dont think that that is the problem. it happened a while back while i was building the database further and i dont know what i did to cause it. even after stripping out all non essential tbl,qry,and froms for the diary the same error appears so i dont know what it can be.

 

[vbaInet]

Make a brand new 2003 database > import all the objects into it. Post that db.

 

[shutzy]

more than 1 way to skin a cat eh vba?

here it is.2002-2003

 

[vbaInet]

Sure is

There's no listview control in your database. If you want to learn about working with the listview control you can follow lagbolt's example. You need good programming skills before delving into something like a listview control.

 

[shutzy]

no i havnt started the list view at all. i have a list box in the frmDiaryView that i want to make a little more visually identifiable in terms of appointment status etc. i have been told that a list view may be the way to go.

i have next to no programming skills as you can probably guess so i was looking for guidance. where to start, any good info, any tips.

 

[vbaInet]

It's seriously not a control for beginners. You need a good grounding in programming to procede. Everything about the control is programming.