Recent content by Krysti

Nevermind... I just figured it out... I didn't realize you could put an expression into the conditional formatting under the menu Format option. Thanks for trying! :)

I need it to be on the event for the control, not the form. Thanks for the suggestion though...

Hi All, I created an Event Procedure on the After Update event for a control in a continuous form. Basically, if certain conditions are met, I want it to disable another control. It works perfectly, except it is disabling the controls for all the records instead of just that record. Does...

Hi, I have been searching and searching and cannot find any info on this specific problem. I have a subform that users go into and enter data into the fields. Intermittenly, when a user closes out and then goes back in, the data in one of the fields (always the same field) is missing and has...

Excellent! Thank you so much for your reply, this will save us a lot of time with testing it :) Christy

Hi, Has anyone ever run Office XP on Windows 98? Will it work? Does it cause any problems with Access? Any feedback would be greatly appreciated! Thanks, Christy

Hopefully this is a question with an easy answer. I created a union query from two tables. One table has a field [DateTerminated] and the other table does not. I put in NULL for that field. However, the data type is now no longer formatted as a date and I need it to be. Is there a way to...

Thanks for the responses. I have the download pdf995 which will output the report to a pdf. But, then you have to save the file and attach it to the email manually. Unfortunately, the people who will be using this database are not really computer literate so I want to automate it for them...

Hi there, I've seen lots of threads on this subject, but haven't come across any that answers this question... I'd like for users to be able to click on a button and automatically e-mail a report in .pdf format. I'm not that versed in code, but I know the code for .xls format would be...

OH!!!! DUH!!!! I could have sworn I had tried that before and it didn't work! Thank you :D :D :D

Okay, really really really dumb, basic code question. As you can see from this question, I am pretty code illiterate, but still try to write it. This always drives me crazy, I don't know the proper way to do this!! What would be the proper way to write this? If [pH] < 10 or [pH] > 12 and...

Either way, I'm getting an error now that says Method or Data Member not found. Enabled is not one of the options when I type ctl. The only options I have are: Application Count Item Parent Ugh! :mad: Krysti

Hi Chief, Thanks for the reply. I'm having problems with the code you gave me for some reason...it's driving me crazy. I know how to write some code, but am not all that knowledgeable. The error I'm getting is "Object doesn't support this property or method". It looks like "ctl.Enabled =...

Hi there, This may be a stupid question, but... is there a way to refer to all fields, in a form, in code? For example, I have a form and I want to write code that says if all the fields that are enabled are not null, then...blah blah blah. Is this possible? Example: If AllFields.Enabled =...

Perrrfect!!! Thank you so much :):)