Search results for query: *

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

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

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.

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

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

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.

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

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

Another thanks!

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!

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

Thanks for your 2 cents worth. Good to know.

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?

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?

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

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

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

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.

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

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