Recent content by JerSand

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

Thanks, Duane -- I'm grateful for your tip. JerSand

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

Thanks for the suggestion, pweegar. I'll pursue it. JerSand

Thanks, John. Your method should prove useful. I'm grateful. I'm especially grateful inasmuch as it's the only response so far. Yesterday, I discovered the "Access Cookbook" (authors: Getz, Litwin, & Baron; Publisher: O'Reilly), and found that pages 289-293 are devoted to this...

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

Thanks, rac2. I followed the implications of your response, deleted ActivityCd, and the query ran smoothly. I'm befuddled, but satisfied. I had brought ActivityCd into the query in design view, using the simple drag-and-drop method. After deleting it and getting the query to run smoothly, I...

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

AvGuy, MichaelRed, Rick Sprague: Thanks for your helpful responses. I'll have to find someone who knows VBA to implement your ideas, but it's good to know it's possible. I'm truly grateful. JerSand

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

Thank you, GingerR. I'll use your suggestion -- I'm grateful. JerSand

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

Thanks, foolio12, nerd1003, CMOOREJr, and GDGARTH. I'm grateful for your helpful observations and will try to assist the interview team in building an application. I should have noted that they'll want to enter the data using forms, and they'll want to produce many reports that -- I'm sure --...

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

Many thanks, lameid, WildHare, and missinglinq. Each of your responses was clear, useful, and worked to solve my problem. I'm grateful. JerSand