Search results

Experts, I have done many subform inside main form and produce a report with the combination of subreport to main report. All in one page. Today ironically, I tried to do the same but shockingly , the system seemed to think that each record from the subform (continuous form) must have a page...

sub txtBox_Afterupdate() If me.typeofentry = "new" then me.typeofentry = "old" end sub Dear This is exactly what I have. But sometimes the " new" stuck and did not change after update. Pls help and thanks

Experts, Im still having a problem where the data after update event ,sometimes did not stay updated, instead it stays in its original position. The code Im using as follows: If me.typeofentry = "new" then me.typeofentry = "old" What can i tell in vba code to ensure that after update event...

Please it's the same system. If you can help I appreciate.

Hi . I tried the first choice and I did what u recommend. Now what. ? What I need to do for the duration change? Thanks

Thanks man. I will try and let you know Cheers

Much thanks. I will try them and will let u know. Cheers

Guys, I have a field that calculates the expiry date once I entered the duration starting from the entry date as so: Me.expirydate = date + duration It's fine until I want to add 14 days to the duration if the expiry date is today. I tried as follows: If me.expirydate=today then me.duration =...

Gents I know this is suppose to be easy even for newbie like me but I couldn't get the text of a field to change to another text after update permanently. I used: If me.type = new then me.type =old. It worked most of the time, but sometimes the text "new" got stuck and no change to old. Any...

Hello I have a table consist of three columns. I used the populated codes as follows: me.emailto.value = table.column(1)............ this works fine but me.gmemail.value =table.column (2).........Never appear (Why is this)? but if I use the (0).....it works fine. Why the column(2) never...

Wow, It really works Thank you thank you thankyou. Love you!

I need to know if i can use hyperlink in my auto email body. this is my code: .Body = " Task Number:: " & rs!MUAMALANO & vbCr & _ " Expiration Date : " & rs!expirydate & vbCr & _ " Subject : " & rs!SUBJECT & vbCr & _ " The email is auto...

Experts, I am able to create an auto email to send to people and of course it has the .subject =" Project 123" .body = " This is a warning email for more information, click the subject" My question is : Is there anyway that I can do the hyperlink on the text "Project 123" to transfer to...

Fantastic !!!! love you man.

Hi JHB, thankyou very much for your response , but not being that expert this is my code, where do i put your suggestion as im using by day name. Private Sub Form_Load() If Weekday(Date) = vbTuesday Or vbWednesday Then Call GenerateEmail(" SELECT * FROM qryDuein7days") Thanks

Experts, Need some help. I have a program that runs an autoemail when the form is loaded. All are fine except the autoemail keep running everytime i load the form. Is there a code that I put behind the " ON-LOAD" where it should run only one time. or a code that I can say...

wow. that really works. thanks.:D:D:D:D:D But now if i want to see the non-active, i guess i have to create a separate query.

I thanks for your prompt reply. the "nonactive" or "active" is a field in the subform.

hi guys, I have a small problem, (i think). I am using access 2010 and i have two forms, main and subform (Continuous). In the subform i have a field that if it is NONACTIVE i dont want the data in the subform be printed in the report. and when it is ACTIVE the whole thing appear...

Thanks guys, the height=0 really helps.:):):):):)