Recent content by reddevil1

jdraw - apologies, i wasn't aware this was the necessary etiquette.

Hi, Please be gentle with me…..J I would be extremely grateful if anyone would be willing to spend a little time to give a critique/review of the Tables & Relationships and highlight any areas that need to be improved. Brief Requirements At this stage, I have done everything within my...

It is very interesting to hear different opinions on whether the autonumber should be used/shown. I think i will use the autonumber in certain cases and include other relevant data to guide the user as well. looks like trial and error will be used here. thanks for your inputs

plog - that is really funny, but probably very true.

sjr1917 That's really great help sjr. Now it works like a treat - thanks for all your patient guidance. I guess i was hopefult that code in the OnFocus and Lost Focus would be sufficient, but extra code needs to also go in OnChange (or OnClick) to cover every possibility. Just hope I...

Unfortunately, i couldnt work out how to convert 2010 to 2003? i did "Save Database As" but th eonly option was to 'Save As Type' Microsoft Access Database, but no option for2003 or 2007 version? Does anyone know how to save to an earlier version?

oops, no i haven't :( i will try this at work tomorrow - it seems my home PC is not able to do this.

Hopefully I have converted correctly to 2003 version....

Hi, I have read that AutonumberID's should NOT be shown to the User? But are there any exceptions to this rule? I have tblFinance which, hopefully, will have hundreds of different income and expenditure transactions every day and thousands over the month? I was thinking that a simple...

sjr1917 - thanks for your sample database - i think i should have uploaded one myself a long time ago? your sample DB works 90%. thank you. the last thing i need is to keep all the same apart from:- a) when the Form is first opened, and the ContractID is Clicked, then the ContractDetails turn...

Yes, even though i do not leave the current record. i want the ContractDetails backcolor to be Yellow every time the ContractID is in Focus (apart from the very first time the Form opens). Hope that clarifies.

Thanks RainLover - you have put a lot of effort into this thread - cheers. My thinking was that this the ContractID would be used as the Contract Number - that way the Contract Number would be unique???

as far as i know, this is the way the code works:- 1) Form OnCurrent - sets ContractDetails backcolor to Pink 2) ContractID OnGotFocus - sets ContractDetails backcolor to Yellow (this seems to override the Form OnCurrent coding) So when i first open the Form i want ContractID to be in Focus...

sjr1917 - i have not come across any of your suggestions before. but they seem like they could work - i will try. thanks a lot.

Sorry guys - I have been sick for a few days - but thanks very much for all your suggestions. They are very much appreciated.