Search results

thank you thank you thank you thank you!!! :) :) :) :) :) the whole thing works beautifully. thank you sooooooooooo much for your help. i hope you have a wonderful Christmas and a brilliant New Year!!

Absolutely no need to apologise. I hope your child is well now and that you didn't have too many piles of working waiting for you :) field sizes....yes...a bit embarrassed i didn't work *that* one out....i changed it and that particular error is gone and has now been replaced with: No even...

bumping question up the list

Thank you soooooooo much GumbyD. I've hit a couple of snags which I'm kinda hoping you could look into if I'm not pushing the friendship too far ;) We do have some loans which are associated with 3 or more names (4 is the most we've had to date). When i run the code i get a msg box telling...

my attachment isn't attaching :( damn file size limits......need to put them in bigger font so blonde ppl like me don't take 2 hours to work out why their file isn't attaching.. ok here goes.....

Thanks GumbyD :) What you said kinda made sense to me, although i got a little confused by this whole looping thing. As you can possibly guess I've very little experience in VBA code......in fact none, but I'd really appreciate it if you could point me in the right direction. I've attached a...

Ok, i'm not entirely sure that what i'm about to ask is possible, but here goes. there are 2 tables CLIENT & LOAN which are linked by a junction table. A person can only appear once in the client table but any given number of times in the loan table. i'm ultimatley trying to write a query...

Hey y'all, I have a form which has our clients contact details (phone, mobile, etc) up the top and then a subform in datasheet view where all the interactions with the clients are logged. The first 3 fields are lookups (no probs there) but the 4 field is a memo field which can often have...

I'm having a similar problem and have basically less than zero knowledge re: vba. Would anyone be able to point me in the right direction as to where I'd be able to find code to enable text wrapping in a datasheet subform? I'm hoping the answer is yes :) Thanks Row

Nope autocorrect features were not on. I just can't work out why this is problem is not occurring across all the queries. But I guess when I (or anyone who wants to help) figures out what I've done (or not done as the case may be) that answer should also become apparent. : )

Ok, apologies if I don't explain this as clearly as I possibly should. The background to this problem relates to 2 tables which I shall creatively call 'x' and 'y'. Yesterday, I renamed table X to be called Z and table Y was renamed X. (table y was an updated via cutnpaste version of the old...

Will do. Thank you very much for your help Neil. Rowena

Sorry for not being specific...... I'm having difficulty working out how to put 2 or more persons on the one mailing title line..... unfortunately, the records are kept so that all the personal information is in the one table (in the one record), so it looks like title, first name, surname...

Ok so, attempting to write a query for a mail merge... in my table i'm running it off i have a field for salutation/title, one for first name and one for surname...with ones later on for mailing address (street address, suburb, postcode/zipcode) i've worked out how to do the query where it...