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!

Register Log in
  • Congratulations derfloh 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: *

  1. sohunter

    2007: need solution for exporting table based on sql string

    Hi SkipVought, That doesn't addresses my problem. I'm pushing data out of Access, and want it in Excel.
  2. sohunter

    2007: need solution for exporting table based on sql string

    I have a "find record(s)" form that builds an sql string (and pulls results into subform) based on multiple text fields user fills in. Once you get records returned, there's an enabled drop down where user can choose a report based on these records...vba within that report goes to said sql...
  3. sohunter

    Vertical scroll bar missing

    Good questions. My screen resolution is small. I can easily see where the vertical scroll bar should be (the right border of the screen) it just isn't there. In design view it's there, but in form view it's gone.
  4. sohunter

    Vertical scroll bar missing

    I'm running Access 2002, and have a form with a tab control on it. The vertical scroll bar is suddenly missing, and I need it to get to bottom of screen. I can tab into fields beyond view, but it doesn't scroll down so that I can see what I've tabbed into. This occurred at some point when I was...
  5. sohunter

    Validation Rule/Text not working

    ...field. No validation message, which is what it's supposed to do. I'm requiring a comma before and after entry, so my validation rule is Like ",*," and my validation text is: Please make sure that each clone has comma before and after it. ----- The rule is enforced, so I don't think...
  6. sohunter

    Combo box losing drop down list after first selection

    Although I must add, I have a sneaky feeling qualifying the ReportQueryName is going to do it, as that's the only field that's missing the qualification, and the only field that stops showing after opening a report.
  7. sohunter

    Combo box losing drop down list after first selection

    As always, thanks and thanks. I'll try both of these things. As far as the references... I am making a screen shot of references that show on my own machine in code mode, and then will check against what I find when I am at that computer again, next week. Does that make sense? (Other wise I'd...
  8. sohunter

    Combo box losing drop down list after first selection

    ...AS ListName, tblReportsQueries.ReportQueryDescription FROM tblReportsQueries WHERE (((tblReportsQueries.ReportQueryName) Like "rptF*" Or (tblReportsQueries.ReportQueryName) Like "qryF*") ORDER BY Mid([ReportQueryName],6); And then they click the OPEN button, which is successfully opening...
  9. sohunter

    "Enter Key Behavior" text field property makes quirky data

    Another thanks!
  10. sohunter

    "Enter Key Behavior" text field property makes quirky data

    Thank you. I see what you're saying. And didn't realize it's so easy to change the row height when looking at raw data in tables!
  11. sohunter

    "Enter Key Behavior" text field property makes quirky data

    I have a field in a table called "notes" and the data type is Memo. I put a text box on a form, control source = Notes, set the Enter Key Behavior property to "New Line in Field". Gives you a carriage return ... nice way to edit and view notes on a form, for separate thoughts/ideas/dates etc...
  12. sohunter

    Password limitations?

    Thanks for your 2 cents worth. Good to know.
  13. sohunter

    Password limitations?

    I can't seem to find any Access documentation stating what characters (and character length) are acceptable when creating a password. (Not admin level, but just the basic password for any user to open the file.) Any tips?
  14. sohunter

    Password doesn't work, database permanently naccessible?

    Ok, thanks. So yes, the database is not inpenetratable, so this is good, and bad . When you say program, do you mean code, or software that one would have to buy somewhere? Know what it's called?
  15. sohunter

    Password doesn't work, database permanently naccessible?

    I want to implement simple password protection on FE/BE multi-user database at a very small organization. (I'm not talking user and group accounts, but just one password that everybody uses, basically to protect the confidential data from the "outside world.") I've read up on it, and tested...
  16. sohunter

    Show Report names AND DESCRIPTION in combo box

    ...for showing just the reports that I want: SELECT Mid([msysobjects].[Name],7) AS Expr1 FROM msysobjects WHERE (((msysobjects.Name) Like "rptDM_*") AND ((msysobjects.Flags)=0) AND ((msysobjects.Type)=-32764)) ORDER BY msysobjects.Name; When I try this: SELECT Mid([msysobjects].[Name],7) AS...
  17. sohunter

    Form "open" but not loaded yet (still calculating DCounts)

    Where I'm developing at home it's not a network, but at the nonprofit that uses the database, it is a network. Anything that runs slow at my home PC doesn't tend to do much better there. I am using an older Dell Optiplex GX1 ... 128 ram, am about to upgrade finally! My Count queries are looking...
  18. sohunter

    Form "open" but not loaded yet (still calculating DCounts)

    Great to have that code. Thank you. It works! It still takes a while, perhaps 20 seconds now as opposed to 30 or something) so I'll still be looking for a way to notify user the form won't load instantly.
  19. sohunter

    Form "open" but not loaded yet (still calculating DCounts)

    oops - you said SQL... SELECT Count(qryDM_PossibleDuplicates.ClientID) AS CountOfClientID FROM qryDM_PossibleDuplicates; SELECT Count(qryDM_NotArchivedA.ClientID) AS CountOfClientID FROM qryDM_NotArchivedA; SELECT Count(qryDM_NoCountyA.ClientID) AS CountOfClientID FROM qryDM_NoCountyA...
  20. sohunter

    Form "open" but not loaded yet (still calculating DCounts)

    You are very kind. qryDM_PossibleDuplicatesCount qryDM_NotArchivedACount qryDM_NoRaceACount qryDM_NoCountyACount qryDM_BirthdateACount The field we're retrieving in all of these (just one row per query, of course) is CountOfClientID. I've named my form's text fields, but I'll get the idea...

Part and Inventory Search

Back
Top