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

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

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

Thanks for the responses, Omega36. I'm sorry to be so dopey about this , but . . .I can see all those properties in a form design view. However, these guys are working without a form -- just the datasheet view -- and when I display table properties, the display doesn't include the ones...

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

Thank you, MichaelRed. I was so wrapped-up in extracting approximately correct periods that I was letting the matter of holidays slide. However, it's clear from the FAQ to which you referred me that greater exactitude is indeed possible. This will be very useful. Thanks. JerSand

Perfect! Thanks so much for your speedy response, Ken. Jerry