Search results

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...

Hi experts, Just need to put together a chart (perhaps pie would be best) to show the percentage breakdown of all auditors results (their are 4 categories) out of the total number of audits for that company. I have the query working well, however, I have no idea to relay it in a chart. Here's...

G'day mate, Spent some time with it and figured it out. Turns out you have to use the sum function (count just counts the number of 1's, not sum them) and I changed a join type and it worked. (Initially it was returning all those where the Company had a name. Changing that to return an entry...

Thanks for the suggestion. I tried that with a small number to see if it works. Under the group by, if you sum them up manually you might see say 7, but then using the Count or Sum it shows you 40. This is incorrect.. Any ideas? Regards Jammin

G'day all, I have a table with each "Standards" as a Column Heading eg- Std1, Std2, Std3 etc... as each one is a YES/NO field. Background being that if a Company meets certain standards, the user can tick each standard that the company meets. Each of these are associated to a job the company...

Oh mate, you are a champ.. That was what was wrong. When I created the form and subform, I just dragged and dropped it in without thinking of the linking fields between the forms. That's why all the hassles. I've been staring at this for over 4 hours today. A fresh pair of eyes was a blessing...