Search results

Hi Linq, That's weird. I just tried it too - not that it's a biggie because, as you suggest, one wouldn't normally do it. Also Access 2003. And placing a label or rectangle over a textbox does obscure the data. The effect is more dramatic if you set the backcolor of the label or rectangle...

Not strictly true, Linq. I mean, you can put a label or a rectangle or whatnot over the top of a textbox or combobox, for example, and obscure data. But listboxes and subforms and tab controls all behave differently. I'm guessing that Jesse wants to have a label do some fancy manoevre...

Jesse, I don't believe I have ever tried it. But if it's not possible, I'm not surprised. Can you say what is the reason you want to do this? Someone may be able to suggest an alternative idea.

Bill, Really? Why is that? That's not my experience. If the primary purpose is data presentation, as against date entry/editing/manipulation, then a report's the go, in my opinion. What version of Access are you using? If 2007 or 2010, have you tried the Report view of a report? Has...

Dennis, You can use a subquery, or perhaps a domain aggregate function may also be applicable (depending on the details of what you want). You need to be cautions with both these approaches in the case of large sets of records, as it can get pretty clunky. If you want more explicit help, let...

Hi Bill, No, there is no built-in equivalent for a running sum for forms. And no, there are a lot of differences between forms and reports! Maybe if you could describe the specific scenario you are trying to achieve, someone will be able to come up with a helpful idea.

dL, Sorry, you didn't tell me the name of your table before, but I assumed from what you said that it would be named Purchase Orders. So it's "Payments Received"? And the names of the fields have a space in them, as in "Date Recd" rather than "DateRecd"? So what you told me before was not...

dL, As a simple example, monthly totals, for the current year, could be obtained from the above described table by a query whose SQL view would look like this: SELECT Format([DateRecd],"mmmm yyyy") AS MonthRecd, Sum([AmountRecd]) AS Collected FROM [Purchase Orders] WHERE...

Kevin, I believe the only way you will get #Num! displayed here is if both textboxes are zero. So if there is no data in either of them, that should be fine. Therefore, you possibly need something like this: =IIf([text77]=0 And [text88]=0,Null,[text77]/[text88])

Sorry, Chaos, I beg to differ here. "End financial year" should be handled by a variable. Otherwise you have to go editing your code next year, which may not seem like a big deal, but is in fact regarded (quite correctly so) as poor form.

Yes, it is. 4:50pm. ;) Whereas for you, shouldn't you be sleepy-byes? :cool:

Chaos, However, in practice it is unusual to be using hard-coded actual dates in your VBA code. It is more common to be referring to the value of controls on forms, or to variables, or whatnot.

dL, Maybe you could give us a bit more information about what this data is all about, and what else is being tracked in the database, and whether these payments have to be related to something else such as orders or invoices or subscriptions. Specific examples can sometimes help. But on the...

DL, I am sorry to say this, on what is apparently your first visit to this forum, but you have made quite a big mistake here. This is sometimes called the "fields as data trap". To put it bluntly, you simply should not have a Payments by Month table with 12 fields, one for each month, nor...

BBryan, No, the parentheses are in the wrong place. And you should get the Max before applying the Format. I think (without testing!) that this would be better: NextRtgNo: "Rtg-" & Format(Max(Val(Mid([RtgNo],5)))+1,"000")

Adam, Fair enough. Web frontends are cool, and Access web application functionality is very exciting. But a web frontend can never compete with a desktop application for rich features, so I would expect only consider as a matter of necessity where local deployment is not possible.

Tina, No, you should have appended the data to a Date/Time data type field, and the data should now be treated as proper date data. Have you encountered a specific problem?

Juliekay, I think we would really need to know some more details of your table, and the data in it, and the meaning of "two highest balances", before anyone could give a good answer to the first question. Can you give some specific examples? Entering <5 in the Criteria of the Cost field in...

Tina, You can do either. But my preference would be to use the Format property of the control on the report.

BBryan, My apologies for the error in my earlier expression. It looks like it will work without the Val function, but I still recommend using it. Thus it should be: NextRtgNo: "Rtg-" & Format(Val(Right([RtgNo],2))+1,"00")