Search results

Minty Excellent. I knew i was missing something but just couldn't see what. Many thanks for that, works like a charm now!!!

Hi all, not been here for a while....a few years anyway! Created an un-bound form that does what I want except for one thing. I have a cbo box that needs to be set to either yes or no. The I have a button which processes various things, but crucially dependant upon what the cbo box says, it...

Spike I have changed the strings to variants as i noticed that if one of the fields was blank the code would error. However, I cant seem to get my head around the iif and len statement. I can see what its supposed to do but there will be times when two fields are null. Any advice would be helpful

Hi Ted. thanks for the suggestion. I have resolved this issue in a slightly different way

Could I change the stings to varients?

Thanks for that, I will check out the iif function. several lines of the address might be null

I have some code that outputs to a text email currently whereby it sets the Venue address in the correct format, for example if there is only one address line, it concatenates the string to exclude the missing line and formats the address correctly This is part of the code that does that I...

Ted Many thanks for that. I'm aware of Redemption but that's not the issue i really have. My issue is my lack of ability to create a recordset to populate the Bcc part of the email. My code currently sends one email per person, so if my query throws up 10 recipients, then outlook will send 10...

Hi I have some code that takes from a query, an email address and sends out an email. Due the security warning that happens for each individual email, i want to create ONE email for all email address in the query and populate them to the BCC section of the sendobject. Here is the code that I...

BINGO!!!!! I see it all now, works a treat. Many thanks for that

I must admit, I didnt try it, I cant seem to work it in with my code.

Will that not produce the same result? The fields are as followws: VenueName VenueAddressL1 VenueAddrssL2 VenueTown VenueCounty VenuePostcode. Not all addresses will have a VenueAddressL2 field. If thats the case, I want the resultant email to look like this: VenueName venueAddressL1...

Hi all I have a form which has a button to email the data out in a standard email message. Here is the code: This works well enough, however, FIELDS 11 through to 16 contain the venue address. This is all we ll and good if every field of the venue address is populated. here are times when...

Rx Many thanks for your reply. I have been away from the pc more or less since.However, I managed to get it working in a very similar way as you have described. Here is my code

Hi all I am using Access to open a csv file and then populate a table with the data. This works fine with no problems. However, in order to do this efficiently I have had to modify the csv file to remove the last 5 lines that the crm package has added to the file. I have a excel macro that...

Glad to be of help. Yes, i'd be happy to check it for you. Like i said, it's a very dirty databases i have provided, but gives the idea. Calculated totals are best displayed on forms which then become more relevant to what is happening.

As a very quick setup i have created a small database based on your dataset. Very simply, create a query to give you a sum of products IN, another query for products OUT and a third to give you the qty on hand. its not a pretty database, just something i managed to do in my lunch break, have a...

Qty on hand should be a calculated field, based upon a query which will add up all of the SRV's and deduct all of the SIV's to give you the qty on hand figure

Spikepl Hadn't thought about, up till now, that hasn't happened, but I can see there will be a time when it does happen. plog thanks for the link. i will have a look at that

Hi all I am creating a access db for use with a training company. All is working great. What I want to do is create certificates within Access and then print by the Course load. Easy enough and I can do this. The courses usually last two or three days, so i want to create a field which has...