Search results

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 :):)

Uh oh Rob, I think it's your turn :D I'm not sure I'm following. I have the form set up as tabular, continuous. This is how it looks: FName LName Address FName LName Address FName LName Address After I enter a FName, I want it to tab down to the next FName and so on. Once I've...

Anudder question, thought I'd throw it out there for you both to fight over :) Before I waste hours and hours trying to come up with the code to do this, I'd see if you guys know off hand. I changed the form to turn off the tab stops. Now, any field I'm in, when I tab, it tabs down to the...

Aha! That will work! Thanks you guys :D Krysti

Kevin, That's why I want to change it only for one form. The users want to be able to enter a number of records at one time, a field at a time for a specific form. So I don't want to use the Tools, Options, Keyboard because that will change how the Enter key reacts for every form. Got any...

Rob, Weird. It works when I use 65 for the ANSI instead of 9. 65 is the letter A. So when I put an A in the field, it moves to the next record, but it won't recognize 9 as the tab key. Got any suggestions? I'll keep trying :eek: Krysti