Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. JerSand

    "Microsoft Access can't find the macro"

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

    :Delete Query????

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

    :Delete Query????

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

    Text as Input for Parameter Queries]

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

    Text as Input for Parameter Queries]

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

    Text as Input for Parameter Queries]

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

    Select Query vs. Parameter Query

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

    Select Query vs. Parameter Query

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

    External Use of Descriptions of Fields

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

    External Use of Descriptions of Fields

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

    Check Box Formats

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

    Check Box Formats

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

    Seventy-Eight Memo Fields?

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

    Seventy-Eight Memo Fields?

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

    Dates and Calculated Fields

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

    Dates and Calculated Fields

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

    Locking Records in Datasheet View

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

    Locking Records in Datasheet View

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

    Extracting Weekdays

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

    Extracting Weekdays

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

Part and Inventory Search

Back
Top