Search results

Absolutely sad, more and more true. What ever happened to the hard work that built this country?... I'm not sure what you mean by 'moved focus off the combo box'. I've tried to run it with the form open; form closed; saved, closed, and reopened the db and tried again. Nothing. Never a drop...

First, I didn't know the form has to be open for this method to work. I'm pretty sure the form was open anyway when I was testing this but just to be sure I just retried it. What happens is nothing. Whenever I run the query I get no results except one blank record. No pop up window - no text...

Hello, I'm trying to create a query parameter which provides a drop down list rather than a blank form to manually enter the parameter. The main reason is to avoid mistakes in typing since I will not be the only person using this db. I've searched and searched the net for a solution but just...

Nevermind. I fixed the problem. I had entered one of the numbers wrong. No kidding it balanced everywhere but on the report! Sorry for the bother - I honestly thought I had a problem with the formula or something related.

Thanks for the info...now I see what Kiwiman meant in his first question. To answer that: the fields on my table are set to Currency, 2dp, so the results on the report aren't rounded. Now to answer your first question, I believe [Balance] is a control on the report. It comes from a query...

Sorry for the delayed answer to your questions...I do appreciate the help. Unfortunately I'm not an experienced user of Access so I'm not privy to the jargon. I don't really know what 2dp, Recordsource, or Control is. What I have is a query with a 'Sum' total for each separate 'account'...

I'm trying to sum a bunch of account fields (it's a financial db) in a report to see if they balance. I used the formula '=Sum([Balance])' in a text box in the Report Footer but unfortunately the summed value displayed is incorrect. When I visually added the numbers in the print preview I get...

Well thanks for trying it. Since my main issue was solved I won't worry about this too much. As I said before thank you very much.

I tried to implement and run ELookup () but just couldn't get it. Allen Browne is a bit above my level. I read thru the article a few times and did the best I could. I copied that lengthy code at the bottom of the page and entered it into a module like the ProdGetLineNumber. Then I tried to...

Thanks. I'll try it out when I'm home in a couple hours and let you know.

Yes I saw that but didn't really notice it fully at first. I see what you mean. Well, the formula works perfect, as I said before. I can't thank you enough. I appreciate the help. The only small issue now is that the numbers display slowly. The query has a noticeable delay calculating...

Good gracious, that's perfect! I'll add those expressions to my other data once I'm at home and go from there. Iif () was exactly the addition it needed. Being an Excel person you'd think I could have thought of that. That's why I'm not an expert at Access and you are. By the way, for...

Do you mind looking at what I'm doing? I think that might clear up a few things. Here's the link: http://students.uwf.edu/mcm40/. If not that's ok. I'll post again an a little while. I want to try one more thing first. But if you've had a chance to look at the db before I do post next, please...

No I don't want to use N=1, I want N=-1 because I have to display the previous record. So I do need the DLookup. But that exact formula <b: DLookUp("[a]","Am Ex","[N] = " & [N]-1)> gave me the solution I was looking for before. Except when the reference numbers were disjointed - which you so...

(accidentally pressed 'Post' before I was finished) ...the reference to [N]-1? Could it be that it can't account for nothing being before the first record? (That's my guess with my limited knowledge.) By the way I meant to add that all I get as a result of my formulas is '#Error'.

I had forgotten to import the module. Once I did import it I was able to use Serialize. However then I had a problem referencing that field as part of my DLookup function. Here it is again as I use it: b: DLookUp("[a]","Am Ex","[N] = " & [N]-1) N is my quick name for the Serialize field...

It didn't work. A message pops up saying 'Undefined function Serialize in expression'. Furthermore I looked up Serialize () on the Access homepage and returned no results. One thing that might be a problem is that I'm not sure of the syntax of that expression. It goes: Expr1...

Ok, told you it was my own ineptitude. I haven't dealt with zip files in forever - I forgot to actually unzip it, not just open it. Duh. Post again soon.

This will sound dumb <shaking head> but I can't find the file you told me to download in order to import the ProdGetLineNumber module. I'm slightly confused. Maybe I'm looking in the wrong place though. I downloaded the zip file on the RowNumber link you sent in post 10 but access won't let...

I will try that and let you know how it goes. Thanks.