Search results

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?

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

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

Being discussed in duplicate thread...

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

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

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.

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

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

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

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

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

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

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

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

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

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

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

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

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.