Help with IsNull function
- Thread starter spudracer
- Start date
As far as the VBA code goes, do you think that the fact I'm working off of a computer with oodles of restrictions will limit that code from working? I know when I ran it earlier I had it display help for it and it said that I'm not running the latest Jet patch. Maybe a possibility?
LPurvis
AWF VIP
- Local time
- Today, 14:44
- Joined
- Jun 16, 2008
- Messages
- 1,269
Actually, that said, to be honest I hate "magically fixed" issues.
I'd rather something stubbornly refuse to reveal itself and only after a long battle does the root cause and fix become clear.
I prefer to understand what's happened and it be fixed for an identifiable reason.
But this situation hopefully has a logical explanation - that simply isn't obvious via a forum's text based interaction.
If it rears its head again post the example immediately as I mentioned.
I'd rather something stubbornly refuse to reveal itself and only after a long battle does the root cause and fix become clear.
I prefer to understand what's happened and it be fixed for an identifiable reason.
But this situation hopefully has a logical explanation - that simply isn't obvious via a forum's text based interaction.
If it rears its head again post the example immediately as I mentioned.
LPurvis
AWF VIP
- Local time
- Today, 14:44
- Joined
- Jun 16, 2008
- Messages
- 1,269
Hmm. Well it's always important to have the latest Jet patch.
(Especially since some of the intermediate Jet 4 patches were less than perfect).
I'd doubt that would be your culprit per se.
The Access expression being used in your report shouldn't be succeptable to any small database engine nuances.
Always worth doing though. (And there's no reason for IT not to implement it).
(Especially since some of the intermediate Jet 4 patches were less than perfect).
I'd doubt that would be your culprit per se.
The Access expression being used in your report shouldn't be succeptable to any small database engine nuances.
Always worth doing though. (And there's no reason for IT not to implement it).
Will do. I think I know what it was. That VBA code was laced in somewhere it shouldn't have been and I think that was restricting the expression to run properly. Maybe, maybe not. Whatever the case, thanks for the assistance!
Call me crazy, but I actually think I attached my head today.
When I created a new button, I noticed something I should've noticed last week. I wasn't using the Private Sub and End Sub. I was just copying and pasting that code in with nothing else there.
This time, I cut everything else out with the exception of Private Sub and End Sub and pasted the code in and voila!
This can finally be marked as case closed!
When I created a new button, I noticed something I should've noticed last week. I wasn't using the Private Sub and End Sub. I was just copying and pasting that code in with nothing else there.
This time, I cut everything else out with the exception of Private Sub and End Sub and pasted the code in and voila!
This can finally be marked as case closed!
I do have one more question though.
I'm wanting to have a field as a drop-down menu.
Within that drop-down, I have a couple options to choose from. What I want to do is whenever one of the options in the drop-down is selected, I want for it to automatically populate two other fields with the information both fields need.
It might be a long shot, but I figured it would save me a little time instead of having to type them in everytime.
I'm wanting to have a field as a drop-down menu.
Within that drop-down, I have a couple options to choose from. What I want to do is whenever one of the options in the drop-down is selected, I want for it to automatically populate two other fields with the information both fields need.
It might be a long shot, but I figured it would save me a little time instead of having to type them in everytime.
Ok, I'm back with another problem related to this. I don't know why I didn't try before, but it wasn't really at the top of my to-do list.
When I open up a specified report tied to each record, it won't print. It shows that it printed, but it doesn't in fact print.
I changed the coding supplied by LPurvis in order to generate what I want, and changed it from acPreview to acPrint. Still nothing.
Any help is appreciated!
When I open up a specified report tied to each record, it won't print. It shows that it printed, but it doesn't in fact print.
I changed the coding supplied by LPurvis in order to generate what I want, and changed it from acPreview to acPrint. Still nothing.
Any help is appreciated!
