Search results for query: *

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

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

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

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

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?

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

I have a form that alerts users to various data clean up tasks needed -- by giving them report/data issue names, a button to open that report, and a count (before they even open the report) as to how many records are in that report. These dCount expression text controls - there's about 5 of...

I want to show 5 most recent payments for each client (in a report that shows multiple clients) in a payment subreport. When I put the TOP 5 SQL into the the databasource for the subreport, most clients have nothing to show in the payments subreport, because the TOP is literally filtering the...

Suddenly, in one of my workbooks, formulas aren't being evaluated. eg A B FullName Jane Doe =TRIM(A2 & " " & B2) The FullName column simply returns the formula. This same formula works fine in other workbooks. (And it's not just this formula...it's any formula...

Hello I'm trying to get a value into a text box within the detail section of a report using DCount. ProviderName is the name of another control (it's text box, control source is providerName, which is text) on a report. =DCount("CampaignID","qryDistinctCampaigns","Name='" & [ProviderName] &...

Greetings fellow Access-ers. I need to count distinct combinations, and am stuck on how to do it in a query. Code: Blue ID Type 1 A 1 B 2 A 3 A Code: Green ID Type 5 A 5 B 5 C 6 A With the sample data above, I would want to end up with DISTINCT TYPE COUNTS BY CODE AND...

But I forget how to solve it? I want a user to be able to pull by date (without figuring in time) and the date field they're querying looks like this: 6/4/04 8:31:49 PM The parameter looks like this: >=[Enter start date:] And <=[Enter end date:] Even though there's plenty of records from...

I'm trying to put a textbox in a report header that displays a name instead of ID. The user enters an id in a parameter from the report's underlying query, and I was hoping to base my dLookup criteria on it, but I keep getting error in that field. Is it something with my quotes...

Within a query, I want to turn a number(with decimals) into an integer (no decimal places...truncated, not rounded) AND I want the number format to include commas. When I do this: format(int(1000.5),"standard") I get 1,000.00 I want 1,000 And I need to keep the data as a number, as I'm doing...

I'm trying to create a text string for one of the target fields in an Insert Into statement, but can't seem to combine a text literal -- in this case, the characters Invoice: $ with a reference to a field on an open form. db.Execute "Insert into Payments (donorID, PaymentMemo) VALUES (" &...

I'm dealing with thousands or rows of names that need to be broken up to two columns: first (with middle initial sometimes) and last Right now they're in one column. Some are like this Jane Doe some are like this Doe, Jane and then again, some are like this Jane S. Doe They need to end up...

I'm working on somebody's Access 2000 database file, and when I try to run wizards, for instance the report wizard, nothing happens. (I open Reports object, click on the New button, choose Report Wizard, choose a table/query it's based on, and Click Ok. Nothing happens.) It doesn't open...

Anybody know if one can make a cursor invisible (or atleast not flash) in an enabled, unlocked text field on a form? You probably wonder why...well, it's a read-only form, but there are blind users as well, that tab through the fields, (using &quot;JAWS&quot; software) so the fields need to be...