Search results

Good news. Glad it was figured out. Sorry again for not noticing. Thank you Charityg for picking up the slack. :-)

:eek: Ohh. I did not hear that lesson yet. Is there any time when you make these attributes in the table instead of the form? Would anyone recommend going through current databases and un-doing the specifications done at the table level? (Perhaps small databases?) Or just keep going until a...

Hmmm. This thread wasn't marked as unread. I missed your last two posts. Sorry! Write back when you try Charityg's solution please. :)

Thank you for the note Chris. In this instance, I think IsNull will suffice though. Possibly only because I enjoy the word 'Null'. At any rate, I'm still trying to figure out this recommendation.. Call SendButtonInfo(Me.MyButton) See my previous post for additional details. Thanks for the time.

This is the best thread on this forum that relates to what Calvin is saying: http://www.access-programmers.co.uk/forums/showthread.php?t=55486&page=1

You're welcome. What I lack in knowledge I make up in speed. :p

Can you right-click on the Main bar? Customize.. Toolbars.. Reset? Probably not eh? Close the db and when you are reopening it, hold down shift.

ROFL. Yikes! :eek: *steals ribbon back and redistributes accordingly* :)

Holy Buckets. That's the longest SQL statement I've seen as of yet. *gives blue ribbon to bliesveld* I don't have the time to help you out on this one. But others will pick it up (ie sonny). Good luck!

Hm, Do I have to put this in a macro? I don't see any Expression Functions relating to Call. (I suppose one macro is better than multiple/unlimited OnClick VBA calls.) Edit: I've thrown it in a macro using RunCode command but it says "The expression you entered has a function name that...

So Public Sub SendButtonInfo(ctl As Control) skips this because you will always be passing the control instead of the Tag? Witty! I saw this post when I woke up this morning.. but sadly it confused me more than when I went to bed. I'm finally understanding it. :o :p That's what I will do...

You could create a table (or value list) with the years you want to limit the users entry to. Then use the "Limit to List" option. (You wouldn't even have to mess with the format then.)

Have you double-checked to see if the shared folder has the appropriate users & permissions set? And made sure it propagates to all the other objects under the folder? If that is no help, try messing around with the permissions of the account Everyone. See if the change is noticed from the...

Hellooooooo! Right-click the form Click Design View Open up the form's properties (View -> Properties) if it doesn't already show them. Click the Data tab. Is Record Source empty?

Well.. if we consider the following (taken from here ) The first day of the current week (assuming Sunday = day 1): Date() - WeekDay(Date()) + 1 The last day of the current week: Date() - WeekDay(Date()) + 7 We could just subtract 7 from each?

You're welcome. I wasn't sure if that would fix your issue or not. The issue is slippery. :p

Hm. How is the crosstab query getting NULL values if all values in tblAccum have atleast a default value? :confused: What calculations is the crosstab doing?

LOL. Did it again. Oops! Double-check and get back to us. If it doesn't fix it, I can either post an example database or you can post what you have and we can go from there.

Sorry, After I posted my first response I noticed I didn't need any response. :o :p You are correct about the criteria, not needed. My second response should do it. :D

I mean setting a default value to the objects where the crosstab query gets it's data. Sorry.