Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: pduncan
  • Order by date
  1. pduncan

    need query limited by month

    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...
  2. pduncan

    need query limited by month

    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...
  3. pduncan

    have a field on a form sum totals from text boxes?

    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
  4. pduncan

    Excel macro wont save

    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
  5. pduncan

    Excel macro wont save

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

    Excel macro wont save

    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...
  7. pduncan

    have a field on a form sum totals from text boxes?

    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
  8. pduncan

    have a field on a form sum totals from text boxes?

    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...
  9. pduncan

    have a field on a form sum totals from text boxes?

    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
  10. pduncan

    have a field on a form sum totals from text boxes?

    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...
  11. pduncan

    need help to change "modal" property

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

    need help to change "modal" property

    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
  13. pduncan

    need help to change "modal" property

    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
  14. pduncan

    need help to change "modal" property

    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
  15. pduncan

    need help to change "modal" property

    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...
  16. pduncan

    Weird Snapshot format problem

    yes - I double checked everything. Thanks, PDUNCAN Memphis, TN - USA
  17. pduncan

    Weird Snapshot format problem

    I have an application that among other things creates and e-mails as attachments (using VBA) invoices that are in the snapshot format. I have used this daily for several months while developing and tweaking the system. Today I handed it over to the "real" end user. For some reason, when she...
  18. pduncan

    non updatable record set

    OK - I tried this... SELECT tblController.RCName, tblEvents.Controller, tblEvents.Date, tblEvents.Event, tblLocations.BranchName, tblEvents.LocationName, tblEvents.Complete, tblEvents.Attended, tblEvents.Amount, tblEvents.Comments FROM (tblController INNER JOIN tblEvents ON...
  19. pduncan

    non updatable record set

    Here is the query: SELECT tblController.RCName, tblEvents.Date, tblEvents.Event, tblEvents.LocationName, tblEvents.Complete, tblEvents.Attended, tblEvents.Amount, tblEvents.Comments FROM (tblController INNER JOIN tblEvents ON tblController.RCNo = tblEvents.Controller) INNER JOIN tblLocations ON...
  20. pduncan

    non updatable record set

    PH - you refereed me to this page last week. I am not trying to be obtuse - I really appreciate your help but I spent all weekend trying to redesign my query based on the information provided on this page - I made several attempts to change my query but when I did it still was not updatable...

Part and Inventory Search

Back
Top