Search results

thanks for the formula, as i said im a little thick on access i have attached the data base and i would like it to pick a client name for the contract procedual table, using query pick a contract,and opening up form pcik a contract i do hope this makes sense and again thank you

good afternoon i have a front page and this there is a command button, what i would like is a command button the once clicked you a re able to choose from a drop down box and then once you pick it takes you to that record is this possible kr a beginner

superb thank you very much it works a dream, get well soon

the button on the opening page is the one i want to password protect

im lost can i send the data base to you

sorry to sound thick as im not that well adversed to this, where do i put this formula ?

I have used a macro to download information into an excel spread sheet and this works fine.using a command button it downloads fine but the file is very sensitive and i want the macro or button to be password protected is this possible

sound good the navigation button that only a certain user sounds the best idea, how do i do this

I have a simple macro that down loads info into a spread sheet this information is confidential, so i need some sort of password that protects this down load being accessed by everyone, the button is on the opening page. Or the navigation button open up another data base then i can protect that...

ok i will try and explain a little more contracts have an expiry date and from that point i want to run a query and it finds all the contracts that a re due to expire in a month and earlier so if the expiry date has not changed they will keep re-appearing on the query report until they have...

sorry about this they are random dates we have contracts in out system that have expiry dates for eg 01/08/09 25/03/09 30/01/09 and so on in a query i want all contracts that are due to expiry in 28 days so out of the example only one contract would appear, i hope this is a better explanation.

not sure if that will work if i have dates upto a 1000 for eg 12/01/07 14/05/07 31/12/07 these are contract expire dates and i want a report that contracts that are due to expire 28 days before does that make sense.

I have a data base with dates in, these are dates when contracts expire I want a query where it shows all contracts that are due 28 to expire within 28 days The expiry dates will differ