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

I'm trying to use field/control properties (instead of code) to enforce a simple validation rule. But it doesn't work. I've tried setting the property for the field (and/or control) at both table level, form level, and table and form level. It catches the validation problem, but doesn't let you...

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

Well - it's a little more involved than that. It's no longer populating a column named "ListName" in drop down list after I open a query or report. And only happens on the machine that's running Office 2003. Not on machines running Office XP or 2000. I've created an interface where user is...

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

I would like a report's Description to appear in a combo box that's retrieving certain report names. This works great (in the row source) for showing just the reports that I want: SELECT Mid([msysobjects].[Name],7) AS Expr1 FROM msysobjects WHERE (((msysobjects.Name) Like "rptDM_*") AND...

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