Search results

Paul Code works great cheers many thanks for that help Bob thanks for your help too it was most appreciated Cheers Jackie

Thanks for the quick replies Bob, I've tried your suggestion but still getting error "Else without an if” Paul my apologies I should have supplied some further info, I have used Bob’s code above and the line the error is coming up on is ElseIf Me.AccountHold = 0 Then I just can see...

Hi All I'm having a problem getting a bit of code to work :banghead: (see below) I have done if statements loads of times but I am having a real problem getting this to run without errors, I have changed it round and round different ways but can get it done. I need an if and else statement...

Cheers works great!! Many Thanks for your help;):)

Cheers for the reply got it working with Dlookup as suggested thanks Me.Forename = DLookup("[Forename]", "TenancyQuery", _ "[PropertyID] = Form![PropertyID]") however when the field in the query is empty it returns an error how do I go about handling a null value?? Jackie

Hi all Its been a while since I have been on here in fact its been a while since i have been using access and as usual I am stuck on one thing that I have been working on for hours trying different things to get it to work so hope someone could give me some advice please bear in mind I'm still...

Hi there I am useing access 2007 and it is built into the command button functions so I simply created a button and selected the option to email report! Sorry if this is not of much help to you, there are however some very good coded examples in this forum if you just carry out a search...

Thanks for the replies, I have set it up and it works great cheers!! :D

Hi gary thanks for the reply :) I'm still new to access so not too sure how to go about doing this? Regards Jackie

Hi all :) I'm not sure if this is the right forum to post on but here goes, I am exporting a query from access 2007 to excel 2007 and my yes / no columns are changing to true / false in excel is there any way to make these appear in excel as yes / no instead? regards Jackie :)

changed limit to list to no and it works great many thanks jackie

Hi there thanks for the reply, I can understand how that would work but I would have to restructure my table design and add in an address table, estate table and a postcode table as I want a combo box on each of these. At the moment I am just getting the combo box to look up the address on my...

Hi all :) This is probably a really simple question but one which I cannot find the answer too, I have an data entry form in my db which allows me to enter in a new job ( job id, customers address, postcode etc) but as we do a lot of work in the same area a lot of the addresses are the same...

Doh!! thanks wazz how stupid am I :o of course it is, I have been spending hours on this stupid db that I think my head has turned to mush, I think its time to take a break! thanks again jackie

Hi all :) I have a form with 2 combo fields one which shows who a job is initally assigned to, called Initials and one which shows who actually carried out the job called Initals2 what I want it to do is to automatically copy the name in the initials field to the initials2 field but be able...

Thanks Ian for having a look I have added this now and it still sends with the default email address but does state beside it that the message is being sent on behalf of my email address so that will work fine for me Many thanks for your help Jackie

Thanks Ian, I tried adding it to my address book etc, but still coming up with the same error anyone have any other ideas? Jackie

Hi Ian thanks for the reply I have added the code (see below) but I am getting a compile error :( which states "can't assign to read only property" any ideas? Private Sub Command20_Click() Dim mess_body As String Dim appOutLook As Outlook.Application Dim MailOutLook As...

Hi all :) I found a great email example on the web written by blue claw database designs see code below and (I have also attched the file for others to use)what I am looking to do is to get it to send using the out going email address I specify, I have two email address running out of outlook...

thanks gary I will have a look into this option jackie