Recent content by jammin140900

I want to insert Website ID, Site ID from tblASWebsiteSite and ArticleID from tblASArticleDetails into a table: tblASSiteSubmitted. Site ID at the moment contains about 24 entries. A website can have many articles which need to be posted onto each of the 24 sites. So, if I had say 20...

Thanks Mavexe for the time you took looking at this. I've been mulling over it and realised that my setup looks a little confusing to start with, hence the outcome is more difficult to achieve! To summarise, what I really need is: 1. A form to maintain the Sites (as you stated)- No probs, I...

Thanks guys. I've given it a go but I'm still not able to get it to work. Taccoo- really appreciated if you can shed some light. Just a few notes: frmWebsite- This is the form where I'll be adding any new websites I develop. From this, I will have navigation to the form: ASRegistration...

I'm putting together a database that will keep track of my Websites marketing efforts. I have a list of business websites on different niches and want to submit articles to article directories. To do this, for each website, I will have to register for an article directory to be allowed to submit...

Cool.. Thanks for the tips..

By the way, do you know how to stop making it go to the very first record after executing the code? I have a form and this is a subform in datasheet view. Quite annoying when it scrolls automatically to the very first record on the datasheet...

Mate, you are a legend! That actually did work.. It was only that it was the other way around: If IsNull(Me.DateReferredtoAuditor) And Me.AuditStatusID = 1 Then Thanks a lot for your help. I was really irriated and stuck with this for a day now! :)

Just tried that and it doesn't work either.. No error messages but it doesn't do anything... Any other thoughts?

Hi there, I have a datasheet subform with milestone items where users enter dates as each milestone passes and I'm setting up a automatic status box that continually updates as each milestone date get's entered. I've got a few "IF" statesments to work this and it works perfectly when a user...

Evan, My apologies. I didn't put it in correctly and so it didn't work. You're suggestion is spot on. It now works. Thank you. Regards J

Hi Evan, This didn't seem to work. This is a subform in datasheet view. Does that make the difference?

Hi Evan, I tried that and it didn't work. It's a subform in datasheet view. I'm not sure if that's the reason it doesn't work?

Hi All, I have some data validation for some date fields as listed below. This method works fine but the only thing is by using Me.FileCompleteDate = " " , the cursor moves along straight away to the next field instead of sticking to the same field and allowing the user to input the correct...

Thanks Bob. Yeah, you're right. I was linking it directly to a table. I've changed it so it queries the data and ordered it according to your tutorial. When running it, it still doesn't order by family name though... Anything else I'm doing wrong?

Hi all, Just need to know how to order a report which is currently grouped on Family ID (Number) so that it prints in ascending order according to Family Surname. I have tried putting [ttmpAllCancellation].[FamilyName] ASCENDING in the Order By field but this does nothing. Do I need code...