Recent content by pduncan

I am glad you replied - because my report is modeled after your calendar report. if my reports query has this for the date : WeekOf: DateAdd("d",-Weekday([Date]),[Date])+1 I thought by putting something in the criteria field would do the trick. I used your example - this is my code now...

I have a report that is based on a query - it is essentially a calendar based report. I would like to limit it by month. Right now the reports underlying query has (among other things) a date field, and the report reflects all dates. I would like to have a form with a combobox (cboDate) that...

PHV, that worked exactly as I needed. Thanks. I have been working on another project for the last week and just got a chance to get back to working on this. how about a star? I really appreciate the help from everyone. Thanks, PDUNCAN Memphis, TN - USA

Dave - thanks that worked perfectly. Although this probably is a simple mistake, I bet a lot of people have this problem. Also - you really helped me out of a bind. How about a star for your trouble? Thanks, PDUNCAN Memphis, TN - USA

how do I make the macro part of the default template? Thanks, PDUNCAN Memphis, TN - USA

Can someone tell me what I am doing wrong? I record a macro and save it. After I save it (and before I close Excel) if I go to the macro menu, it's there. However, when I close and open Excel and then try to run the macro, it isn't there. How can I record a macro and have it available the...

1. Yes - Single Form 2. Yes - each is bound to a field in tblListing (as is txtGrossTotal) 3. I want to add the (4) values that the user enters on the form. The total is displayed in txtGrossTotal. 4. Yes - it's bound to tblListing.GrossCost 5. tblListing Thanks, PDUNCAN Memphis, TN - USA

I tried this both ways that were suggested and the txtGrossTotal field still does not update (or save the value on closing) Could there be a property set on this field that prevents it from being updated? AceMan1: I assume I put the txtGrossTotal code in the default value property? Thanks...

I forgot to say this: the "sum" to txtGross total isnt working - I havent even addressed the writing of that value back to the table - Thanks, PDUNCAN Memphis, TN - USA

I have 4 text boxes (txtA, txtB, ... all currency) that the user enters - I need to have a "total" (txtGrossTotal) that is the sum of the four. I would like to have the total value change as the values are entered. Then when the save button is pressed, write this value (txtGrossTotal) back to...

Thanks Roy-Vidar. Thanks, PDUNCAN Memphis, TN - USA

Thanks PVH and AceMan1 - both of you have really helped me greatly in the past and I really appreciate all your suggestions and your help Thanks, PDUNCAN Memphis, TN - USA

Thanks - it was the shortcut menu. I have learned the hard way to not change things unless I know what they are. Do you know where one could go to learn more about all the various properties available on a form? Thanks, PDUNCAN Memphis, TN - USA

OK - my bad - I found the "Modal" prop - and that took care of not being able to click on other forms - can anyone tell me how to enable the "right-click" on title prop? Thanks, PDUNCAN Memphis, TN - USA

I have been asked to update an access app that was written by a contractor who is long since gone. He has set the forms in this app with an interesting (yet annoying) property - and I haven't figured out how to change it. While I am working on this, I would like to change this property so that...