Search results for query: *

Brilliant, Remou! NO one could figure that out. Thanks for the suggestion. I just changed the tab order (didn't really know what that was) and now it's working perfectly. Thanks.

I think a great solution would be to set an OnClick event of GoToControl for the button of the tab itself. That said, the only OnClick event that I can set seems to be of clicking on the actual page, and not the button of the tab. .....Just a thought.

Worked perfectly. Thanks, PH!

Hey, all. I currently have my properties set such that opening the DB file that I'm working on will automatically open the database window, and the main form on top of that. I was wondering if there is a way to make it so that when the main form opens, it defaults to opening Maxmized within...

Hey, all. So this is posing to be a lot bigger of a problem and a lot more frustrating than earlier anticipated. I have a form which has multiple tabs. The third tab contains a column of information in the tab, and then a sub-form in it also. When you click on the tab to look at that page...

Brilliant! Thank you, thank you, thank you.

IGNORE THAT LAST POST! I'm hot on the trail, but still have one outstanding question. Here's the SQL statement, which should include every Allocatee from each Transaction, as well as all of the other information about the transaction. (Is that correct?!) My only other concern is that I...

JBL, I've got a similar situation. What I've done is set a BeforeUpdate event to run a SetValue Macro. The expression will be the formula (e.g.): CCur([TableName].[Invoice]-[TableName].[Payment Amount]) And the item will be the column in your table that you want this calculated value to be...

Hey, Duane-- It looks like you're exactly dead on! The only problem is that I'm not able to add more categories beyond the "Color" and "Brand Name." I'm sure this is only because I'm not very knowledgable at MS Access, not because it can't be done. Below is the code which you gave me...

I tried, though can't seem to make work, the following code: =IIF([COLOR=1] & [COLOR=2], [COLOR=1] & ", " & [COLOR=2]) It didn't work, but it might be along the right path?

I have sort of a tricky question, that I'm guessing will require a clever work-around that I can't think of. The actual substance is confusing enough, so I'll use an anologous type of example. Suppose I am keeping track of the different colors of popsicles offered by different brands. The...

My previously posted code is working exactly as I hope; "AM: __________" shows up (with the underlined space filled in by the specific Asset Manager, populated by [AM]) only if there is a value entered in the AM field from my table/form. If there isn't, nothing shows up, including the "AM:"...

Thanks for the help, TechSup, but unfortunately I don't think your solution will be a viable one. Firstly, I'm in a multiuser environment with 9 network printers. There is no single printer from which the reports will be printing. Also, I have a few reports which will not be printed in legal...

Thanks for your help, Danvlas, but I don't want the "AM" to show up if the expression is null. However, I did (accidentally) figure it out. The code is: =IIF([AM], "AM: " &[AM],null)

I'm now trying to work on a field which I only want to show up if it Is Not Null. So, on my report, if there is a value entered for the AM position, I want my report to display "AM:" and the AM's name. Here's the code for the textbox that I have, but it isn't working. Any clues? =IIF([AM]...

You're the best!

Brilliant! And for my other which has parentheses around it, I'll do ="(" & [Return of Equity] & ")", "Currency" Is that correct?

My final quesiton: I've done that, however my formatting of the number as a currency with no decimal points is lost. That is, whereas before it would have showed "$1,176,483", it now shows "NMTCs: 1176483". Any way to format it to show as a currency? This happened in another column when I...

OOOOO, I didn't realize this was supposed to be the control source! I thought this was code, built in association with the text box, which had a control source of "NMTCs". Brilliant. Thanks so much for sticking through all of this with me. Sorry for my ignorance.

Changed the text box to "NMTCs Text Box". So now the code reads: Option Compare Database =IIF([NMTCs Text Box]>0, "NMTCs: " & [NMTCs Text Box],Null) End Sub I also tried: Option Compare Database =IIF([NMTCs]>0, "NMTCs: " & [NMTCs Text Box],Null) End Sub "NMTCs" is the name of the column...