Recent content by dddivers

Hi - what I know about coding is pretty much self-taught (I claw my way to hammer out solutions), and although conceptually I understand what both of you are suggesting, I think implementation of those concepts is outside of my modest coding skill set. I did play around with the using Recordset...

So beautiful. Works perfectly. Where I was stumbling was thinking that my record selection formula had to be tied directly to the parameter's name and trying to incorporate a similar formula to yours as part of the tie. I also was having a hard time reconciling the Parameter on a date field...

Hi - a user in another forum suggested I post this question here (even though it mostly involves Excel, it also involves Access). Here goes: I created a UserForm in Excel VBA (version 2003) that has Checkboxes folks can click to make particular choices. I have coded the checkboxes to feed...

Hi, I have a report in Crystal 9 that I'd like to make as easy as possible for users to query all sales from full previous month. They don't know how to create or use formulas via the Select Expert so I've been trying to tie a FullPreviousMonth function (based on a SalesDate field) to a...

Hi - I have created a UserForm in Excel VBA (version 2003) that has Checkboxes folks can click to make particular choices. I have coded the checkboxes to feed Textboxes (which are also located on the UserForm)....the purpose of the Textboxes is to show the added (or subtracted) value when a...

Hi Skip - I like your checkbox/textbox code much better than mine. Thank you very much. Regarding your BEFORECLOSE code above, I put it in the THIS WORKBOOK node in VBA but it's not working. Still getting prompted to save when I close and when I re-open the file, my checkboxes are still...

Hi Skip - most of the things I want to happen upon closing the workbook are not working: The Activeworkbook.Save code is not saving (I'm still getting the prompt to save the file.....I don't want the prompt...want it to save for me). The first two Checkboxes aren't clearing out, nor are the...

Hi - I have an Excel 2003 version worksheet where I'm tracking the number of items ordered (e.g. magazine orders). I've created 2 Checkboxes and 3 Textboxes (from the Control Toolbox toolbar). The 1st Textbox adds the number of times the 1st Checkbox is clicked and subtracts out if 1st...

Hi - That's what I thought, but sometimes there are ways of getting around the "can'ts". Maybe some VBA code trick or some added field trick. Anyway, Thank you for responding.

Hi - although I know you aren't "supposed" to be able to do this, I am wondering if anyone knows any tricks that would enable recipients to see who has been Bcc'd in email messages that they've rec'd? I tried adding the BCC field to the Inbox interface (via the Field Chooser) hoping that might...

XLBO: Macro worked like a charm. Thanks so much--dddivers

Hi - I need help with 2 Pivot table problems, please: 1) Can't find any way to easily determine the source data feeding an existing Pivot Table!!??? Would think there would be a property setting that would tell me where the feeding data is coming from, but no! 2) Love the drop-down buttons...

Hi - I created a .bmp splash screen that launches when I open a particular Access database. HOW CAN I GET IT TO STAY ON SCREEN LONGER? goes by so fast. Thanks very much - dddivers

Thanks again TSUJI! I'll check into this. Appreciate it very much -- dddivers

Hi tsuji. Opened wab.exe, and Options is not a listed choice under the TOOLS menu. Could this be a version difference?.....I have Windows XP Home Edition. I looked for the radio button option in a few other menu spots in the wab.exe address book (also looked for this option directly in...