Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: MSWhat
  • Order by date
  1. MSWhat

    Set Focus to a Text box, NOT the sub-form, like it's doing.

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

    Set Focus to a Text box, NOT the sub-form, like it's doing.

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

    Default to Maximize Form when Open MS Access file.

    Worked perfectly. Thanks, PH!
  4. MSWhat

    Default to Maximize Form when Open MS Access file.

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

    Set Focus to a Text box, NOT the sub-form, like it's doing.

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

    Alphabetizing a column in a report, made of multiple controls.

    Brilliant! Thank you, thank you, thank you.
  7. MSWhat

    Alphabetizing a column in a report, made of multiple controls.

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

    Very Difficult Text Box Question

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

    Alphabetizing a column in a report, made of multiple controls.

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

    Alphabetizing a column in a report, made of multiple controls.

    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?
  11. MSWhat

    Alphabetizing a column in a report, made of multiple controls.

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

    Making Text Labels Not Show Up If Corresponding Vale Is Null/0.

    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:"...
  13. MSWhat

    Default Page Settings for Report--Landscape, Legal.

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

    Making Text Labels Not Show Up If Corresponding Vale Is Null/0.

    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)
  15. MSWhat

    Making Text Labels Not Show Up If Corresponding Vale Is Null/0.

    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]...
  16. MSWhat

    Making Text Labels Not Show Up If Corresponding Vale Is Null/0.

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

    Making Text Labels Not Show Up If Corresponding Vale Is Null/0.

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

    Making Text Labels Not Show Up If Corresponding Vale Is Null/0.

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

    Making Text Labels Not Show Up If Corresponding Vale Is Null/0.

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

Part and Inventory Search

Back
Top