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 dencom 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
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. MSWhat

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

    Hi, all. I'm wondering if it is possible to set some code/formatting to make it such that the text lable does not show up on a report if its corresponding value is either null or zero. For example, if my report looked like this: Number of red popsicles purchased: 17 Number of blue popsicles...
  5. MSWhat

    Default Page Settings for Report--Landscape, Legal.

    Hi, all. Is there a way to set the default report settings to Landscape, legal sized paper when using the wizard? Thanks in advanced for your help.
  6. MSWhat

    Retrieving the Wizard on Finished Reports to Change Grouping

    Hi, all. I was wondering if there is a way to bring BACK up the report wizard once a report is finished? I've created several reports that I now realize I want to add/change grouping levels to, and don't know of any way to do this other than through the wizard. I just don't know how to bring...
  7. MSWhat

    Retrieving the Wizard on Finished Reports to Change Grouping

    Hi, all. I was wondering if there is a way to bring BACK up the report wizard once a form is finished? I've created several reports that I now realize I want to add/change grouping levels to, and don't know of any way to do this other than through the wizard. I just don't know how to bring...
  8. MSWhat

    "Snap-to" Function; or Default Curser target.

    Hi, all. I'm having an annoying issue with my DB that I can't seem to figure out how to fix. I have a form with multiple tabs. In one of the tabs towards the middle there is some information (most of which is actually carried over in locked text box from information entered on previous tabs)...
  9. MSWhat

    Default Access to Open A Form

    Hey, all. I was wondering if there is a way to have Access, or this specific project I'm creating, to automatically default to opening a form when the whole database project is opened. In other words, is there a way to set the properties such that whenever anyone double-clicks the file, the...
  10. MSWhat

    UserName show in Multi-User Environment.

    I'm trying to integrate my Access database into a multi-user environment, by making it accessable (pardon the pun) through a shared network drive. Whenever, for example, someone tries to open a Word or Excel document on the shared drive that another user has open, an error message pops up with...
  11. MSWhat

    Combo box of "Find a value based..." in a form with related tables

    I am creating a form off of two tables, joined in a query, "Conglomerate," which serves as the recordsource for my form. Before I expanded into a second table, I had a combo box at the top of the page to find values based off of what they began to type in. This served as a really easy way for...
  12. MSWhat

    I can't add more fields to table w/o the error Too Many Fields Defined

    I am working form a database that has two related tables--Master List & Bank Account Info--which are joined in a Query, "Conglomerate," as the recordsource of my form. In aggregate the number of columns in both tables is at or near 255. I know that each individual table can only contain 255...
  13. MSWhat

    Saving one field in a form to multiple related tables, et al.

    I am working on creating an Access database, with a form based on two tables. I have had no prior experience with Access until I began working on this project. I have three questions, in order of importance: 1. My two tables--Bank Account info & Master List--are joined in a one-to-one...

Part and Inventory Search

Back
Top