Search results for query: *

I've designed a simple application in which users are getting a message I haven't seen before. Sometimes, a user is a poor marksman with the mouse and clicks in the area of a form that -- in design view -- is the detail area. The text in the popup is: Microsoft Access can't find the macro...

I have received a highly streamlined documenter list (no properties, no relationships) of 120 tables. The type of field in some of them is ": Delete Query". I'm unfamiliar with this field type and would be grateful for an explanation or hint. Thanks. JerSand

I have been given an Access database consisting of one table. There are 10 fields, eight of which are text or memo. The person who collected the data would like an interface that would permit users to search for phrases or words that the users would type into a dialogue box. Upon receiving...

The SQL for what seems a very simple query (it doesn't even involve a join) rounds-out this request for advice. When I run the query (which is saved, with its own distinctive name), ACCESS launches a "Query1.ActivityCd" box asking for a parameter value. I'd be grateful if someone...

I work at an agency where we often read/import ACCESS tables and queries for analysis in statistical packages such as SAS and SPSS. The ACCESS field names become the variable names in the statistical package. When the designer of a table has taken the trouble to fill-out the field description...

I have been given a database containing mostly check boxes. My task is to produce a variety of reports using different configurations of the check boxes. The requester has asked that I distinguish the check boxes with different colors, but I'm finding that even though the border color property...

I've been asked whether a team of interviewers could use ACCESS to collect interview data. The interviews would be structured, but responses would not be limited to "yes/"no" items or even to responses small enough to fit into text fields. There will will five interviewers...

I thought this would be simple. My form contains, among other fields, short date fields entitled "Expected date of first separation" and "Date of the letter". Each appears simply as the result of dragging the fields from the table on which the form is based onto the form...

A colleague (honest -- this is not the proverbial "a friend of mine") uses ACCESS 2000, but only the datasheet view. He and others enter data using the datasheet view and basically just store data that they export for analysis with other software. He has asked me how to lock entries...

A query in my database computes the number of calendar days elapsed between two dates. The syntax is simply: SELECT Main.[Date Received], Main.[Date Returned], [Date Returned]-[Date Received] AS [Review Time] FROM Main; I would like to change this query so that it counts only workdays -- not...

A table called "Main" includes twelve fields having values ranging from 1 to 3. I wish to compute an average for each field after excluding the 3s. Each record has 3s in a few fields, but the records vary regarding the fields in which their respective 3s occur. I haven't figured-out...

I have a combo box with 892 alphanumeric entries from which the user must choose. The entries appear in the dropdown list arranged in ascending order, from 11-0003 to 99-9919. The scrollbar is proving to be a fairly clumsy way of finding the right entry for a record. Is there a way by which I...

I posted this on the General Discussion Forum, but got only one response, so I'm re-posting here. My task, as I understand it, is to use two combo boxes to enter data for two fields in a table. The first combo box is called "Source Reference" -- it's the titles of the documents from...

In the MS ACCESS PC environment, I have tried to concatenate two strings using what I thought was the proper SQL syntax. The error message I received indicated that ACCESS doesn't recognize || as proper SQL syntax. Is this true, or must there have been something else wrong with my syntax? I'd...

My task, as I understand it, is to use two combo boxes to enter data for two fields in a table. The first combo box is called "Source Reference" -- it's the titles of the documents from which the user has taken some information. The combo box list is to display distinct titles as the...

The status bar on a form I've developed displays the table Description of a field when the cursor enters the text box for that field. A user has asked whether I could make the status bar words more prominent by changing the colors (perhaps a nice fluorescent green). I'm aware only of the...

I'm attempting to build a fairly simple two-part set of cascading combo boxes. I have constructed two tables -- agencies and subagencies -- with the following SQL (creating a query called "qryAgencies"): SELECT DISTINCT [Agencies].[Agency], [Agencies].[AgencyID]...

I should be embarrassed to post this inquiry inasmuch as a search yielded about a dozen related questions posted in the past. But I still don't get it and am hoping that a description of my specific situation may elicit some help. I have a list of 12 agencies. Within each agency, there are...

A fellow programmer has warned me that I am in for something completely different -- that my next ACCESS 2000 application will inevitably be buggy because it will be shared. (He says I should instead use SQL Server -- with which I have no experience -- and use ACCESS 2000 as a front end...

I almost always begin a query by using the QBE approach, but then often summon the SQL View in order to enter some adjustments (for instance, "TOP 10" or "DISTINCT," or simply changing the output names when executing aggregate functions). I'd like to be able to enter...