Recent content by Russyfoot

Hi all. I have table; tblBuildings one field of which is Supervisor which looks up a field in tblSupervisor which contains contact details etc.. Then a query gives me a report listing the contact details for each building.Note, one supervisor can be responsible for more than one building...

:eek:Malcy..words fail me ! Thankyou so much. This is exactly what I was trying to achieve. I was expecting help and guidance and you've gone and done the thing for me. If you're ever south of the border and near J24 of the M1 let me know, I'll buy you a well-deserved pint. Once again thanks :D

Hi Malcy. yes it is continuous. I've attached db for you to have a look at. Form is frmAssets1

:confused:Hi Malcy. Thanks for the reply. Yes & No. I had created a form as you describe, however, when I select a check box it enters a tick in all of the records.:confused: I never thought of a temporary table..I'll work on that but how can I solve this form problem ??

Hi. I have a database based on Microsoft Assets Database template. I have three tables: tblBuildings; Parent. PK BuildingID tblAssets; Child. PK AssetID, linked to parent via BuildingID tblMaintenance.Child of tblAssets. linked via AssetID Service reports...

I don't know if you can. I can't think of a way to do it.

Application background Ah. Missed that one. It's the application background item on the appearance tab in Windows display properties. This will change the background for ALL appications not just Access.

Colour management You can change the colour of datasheets, including font and gridlines, by selecting format then datasheet, when in datasheet view. This will change the colours for all datasheets. For forms, click on the form property button when in design view & scroll down, you can select...

Aren't these field properties ?? I seem to be 'missing' a few form properties In Access 2000 These properties are field properties. Select the fields you want and hopefully solve your problem.

Try this Hi Rita Use the help facility. Enter "select highest" then click on "customize list boxes..etc" There's a bit in there about changing the sort order which may acheive what you want. HTH

Wow SJ. I was off exploring your thread re DAO & ADO differences as I had a feeling this maybe where my problem was. I have got the DAO reference selected bu the ADO was above it in the reference list. Swapped them round & now it works. (Well got a problem with the loop..but I'm getting there.)...

As I said earlier, I'm confused. I put in some message boxes to step through the code and have found I was barking up the wrong tree completely ! it seems the type mismatch relates to he line Set rs = CurrentDb.OpenRecordset("tbltest1"). Think I need to do a bit more research.

I've tried that previously with the same result. Just tried it again in case I'd done something really silly but again..same result.

Yes it is. Sorry should have made that clear.

Hi. I'm trying to add several records, 7 days apart between two dates. This is my first attempt at coding and after lots of reading and poring over various fora I've come up with the following code which I'm using in a simple test prior to adding to my existing DB. My problem is that the...