Search results

  1. SteveSchapel

    "On Current" Event Confusion

    Well, I don't think it can be a datasheet, because Mhermher is talking about command buttons. And if it was a continuous view form, it still wouldn't result in the behaviour that he/she described. No?
  2. SteveSchapel

    Query for items within a date range for a weekly report

    TMC, I am happy to help, and thanks for letting us know of your success. Best wishes with the rest of the project.
  3. SteveSchapel

    Help needed urgent!!!!!!!

    Waris, Wow! Well, I have no right to say this, of course, without knowing the full story. But on the face of it, it looks like your school has let you down badly here, by not providing you with adequate resources to pursue your assignment. They don't even give you enough information to know...
  4. SteveSchapel

    Need help urgent!!!!!

    Being discussed in duplicate thread...
  5. SteveSchapel

    Taking Data from Main Form

    Gareth, Like this: =[Parent].[Parent]![SalesOrder]
  6. SteveSchapel

    ACCDR vba open with password

    Beachldy, Using the accdr filename extension is a handy way to emulate runtime equivalence for the developer's testing purposes etc. But it would not be a recommended way to distribute your application. I would suggest saving the application as an accde. If, for some unusual reason, it is...
  7. SteveSchapel

    Book Recommendation

    D, I am particularly impressed with "Access 2010 Programmer's Reference", by Teresa Hennig et al. Also, the forthcoming "Access 2010 Inside Out", by Jeff Conrad, promises to be a beauty.
  8. SteveSchapel

    Help needed urgent!!!!!!!

    Waris, Actually, as is the case with other technical forums and newsgroups, duplicating your post does not increase your chances of getting a good answer. Now, can you say what you mean by "pseudocode"? And, can you also say what you presently understand to be the way in which the...
  9. SteveSchapel

    Designing a database table structure. Advice appreciated.

    Max, There appear to be some problems with your data schema. There is some stuff I don't understand, of course, and as such not really able to comment specifically. You are relating Publisher to IssueDetails. Does that reflect the real-life relationship between publisher and magazine...
  10. SteveSchapel

    How to call a Public variable in a query?

    Latex, If you are using Access 2007 or Access 2010, you can use a TempVar, which is the simplest solution.
  11. SteveSchapel

    Code for Using F3 needed

    Ian, You shouldn't need to try and mimic the behaviour of Function keys. If I am understanding you correctly, then code like this should do what you need... Me.NameOfYourControl = NameOfVariable
  12. SteveSchapel

    Query for items within a date range for a weekly report

    TMC, The Weekday function returns a digit to indicate the day of the week. So it doesn't relate to the concept of working days and weekends. By default, the Weekday value of Sunday is 1 and the Weekday value of Saturday is 7. Which is handy, as you can use it, for example, to find the date...
  13. SteveSchapel

    "On Current" Event Confusion

    Mhermher, Using the Current event of the form is the correct approach, and I can think of no reason why it wouldn't work correctly. The results you are reporting are unexpected. If you could attach a zipped copy of this database, someone may be able to have a look at it... but to me this is...
  14. SteveSchapel

    Query for items within a date range for a weekly report

    Mind you, having slept on it, I now see that I did make it more complicated than needed. If the Service Request was "alive" at the beginning of the week, or if the Service Request was started during the week, should cover all eventualities. The other factor I included, of whether it was alive...
  15. SteveSchapel

    Display a result in a textbox depending on two other criteria

    BBK, I guess it depends on the reason for wanting to calculate a monthly amount, and what you want to do with these figures. If you have 52 weekly rental payments in a year, then [RentAmount]*52/12 will give you the average amount per calendar month. So, as long as this is underatood to be an...
  16. SteveSchapel

    IIF Value Error

    TooManyReports, I would normally enter the criteria in cases like this as follows: [Forms]![Basic Form]![Pricing Region]="*" Or [Forms]![Basic Form]![Pricing Region]
  17. SteveSchapel

    Display a result in a textbox depending on two other criteria

    BBK, Set the Control Source property of the MonthlyAmountDue textbox to like this: =[RentAmount]*Switch([PaymentFrequency]="Monthly",1,[PaymentFrequency]="Weekly",4) So then, the only question I would have is... Is it correct in your circumstances that monthly amount = weekly amount * 4...
  18. SteveSchapel

    Query for items within a date range for a weekly report

    Bill, No worries. My thinking may be twisted here too. But this is the way I understood the question... Connolly wants his query to return all Service Requests that are current/alive during any part of the current week. So this is the way I figured it: 1. Date()-Weekday(Date())+1...
  19. SteveSchapel

    Embedded Macros don't convert to 2003

    In addition to the information that Allan supplied, let me also say that it is an important principle to develop your application in the earliest version of Access that it will be deployed to. The problem you have encountered is just one of many possible examples of where a new feature was used...
  20. SteveSchapel

    Query for items within a date range for a weekly report

    Fair enough, Bill. I see we are interpreting the original question quite differently from each other. Maybe Connolly will come back and clarify the requirement, or maybe we will never know.
Back
Top Bottom