Search results

If i ever have to use it again I will have a closer look at that idea - yeah! Thanks for your help!

ah, sorry vbaInet - seems we came to the same conclusion at the same time!! Thank you!

right, ive found a way around this... slightly better than how i did it last time, but still not great. For anyone who's interested: - Table A holding "live" data, Table B holding the "stored" data i.e. from last week - Create a Query with every field from table A and a corresponding field...

Thanks for your replies. Chrism2 - its such a shame, hey - the 2007 excell has massivley improved the conditional formatting... seems access was forgotten about though! vbaInet - thanks for that link - it looks like it could be of some use but I cant find the code they used to do it!! If you...

Yeah, i tried but i think it won't work for 2 reasons: 1) I need it on more than 3 cells, and conditional formatting only works for 3 (unless thats changed) 2) I need a dlookup in the criteria for the conditional formatting, I had a go at that but it didnt seem to like it. Can conditional...

Hi, I have tried to do this before but had to go a really complicated route round to get what I wanted... but I was hoping access 2007 had a nicer solution to my problem...! Basically, I have a continuous form with 20 or so fiends in each record. (It looks like a register) What i need to be...

Thanks for this!

Thanks for your reply... I'm afraid I don't get what you mean though!

Hi, I have some experience in access & VBA but i have just started using Acess 2007 and I'm coming across a few funny things! I am trying to put logos into a form. The logos are stored in a table as OLE objects, and are included in the record source of the form... however, when i put the...

dont worry - I needed to set it as a decimal rather than an integer... out of practice!

I am trying to add decimal places to a field (set as Number, long integer, fixed, 2decimal places). Its showing as 32.00, but if i try to change it to 32.59 it returns to 32.00 as soon as i click outside the box. any ideas? Thankyou!

ghudson - I'm afraid I am doing that. I first set up this code a long time ago, when I was very new to access, so it was very much a 'what can I do... ooh, that could work' rather than a 'what's the most efficient way of doing this'. Thanks for all your suggestions everyone, I'll do a bit of...

Hi. I have some VBA that has been working for a long time, but has suddenly decided to stop! The following steps are run via vba: - open a table - filter for a specific record - copy that record - Paste append record into a temporary table (and close original table) - run a query which pastes...

Hi. thanks for your suggestions. I have played around with it, and I think I found the culprit - I should have mentioned that it had some code on teh form for conditional formatting. I think there was a slight corruption in the form which somhow meant there was too much conditional formatting or...

Hi, I have a report that was working fine, but now whenever I try to view it, it doesnt work. Basically, if I try to open it it thinks for a while and then just stops as if you'd never done anything. If I have it in design view (which I can get to fine) and then try to preview it it thinks for...

ahHA! Finally found it - knew it would be something like this - just a spelling error. Eurch! Thankyou!

Yeah, theres a lot of code in the module, but it never gets executed as the code i showed was the 1st few lines - there was nothing before.

Hi. Thanks for the reply. I changed it to your suggestion but im getting the same error. ProjNo & PNo are actually text - they are called numbers, but they have letters in aswell... just to confuse!! Any other ideas?

namliam, Thanks for the suggestion - I keep meaning to set out my SQL like this, but i find it easier to read just keeping it neat and all in 1. Personal preference i guess. Ill give your way a go for the next few times though and see if it works for me!

Thanks DCrake, thats a very handy hint!!