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 Chriss Miller 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. WhyMeAndNotYou

    Query A Database Table Name, Type, and Description

    Below is the Microsoft's function code that supposedly provides similar functionality as the subroutine code that Gary has generously provided and which Tony helped me use successfully. Using a function has the advantage of being able to be included in a regular query, but when I run the code...
  2. WhyMeAndNotYou

    Query A Database Table Name, Type, and Description

    Tony: Ignore last post. After I exited out of everything and re-entered the database, the code worked. Thanks for all your help, but I have one final question. The sub name is testing(), the external module name is modtesting. In the immediate window if I try to run testing, the error...
  3. WhyMeAndNotYou

    Query A Database Table Name, Type, and Description

    OK. I assume the format is module.procedure (where module is the external name and procedure is the internal name). Unfortunately, the description field is still not being produced. Since the error trap for 3270 is Resume Next, I assume that the module is encountering this error when...
  4. WhyMeAndNotYou

    Query A Database Table Name, Type, and Description

    Gary: I want to thank you for your help. The error is: Microsoft Visual Basic Compiler Error Expected variable or procedure, not module Since I am copying your code exactly with the replacement of only the "Table3" string, and since I do not appear to be able to access the "Descriptions"...
  5. WhyMeAndNotYou

    Query A Database Table Name, Type, and Description

    Gary: I copied your code into a module and saved the module as testing; substituted "MyTableName" for "Table3"; opened upon an immediate window, type testing <ENTER> and received the following error message: "expected variable or procedure, not module". Microsoft KnowledgeBase Article 125773...
  6. WhyMeAndNotYou

    Query Listing a table's field name, type, description

    Thank you for replying. I tried modifying Jeremy's code using the various subparameters available for the Fields paramater since there are no listed parameters identified as "description". Some of the options resulted in listings of various field parameter values, others resulted in errors.
  7. WhyMeAndNotYou

    Query A Database Table Name, Type, and Description

    Tony: Thank you for the suggestion. It would address part of the objective but not all. First, it would not facilitate hardcopy documentation (the documenter provides either too little or too much data). Second, if the data could be obtained via a query, the query could be used to create a...
  8. WhyMeAndNotYou

    Query A Database Table Name, Type, and Description

    Thank you for the suggestion, but the solution is too kludgy to be practical. It was the initial approach to the problem and entailed running the documentor, outputting the report result to Excel, manually deleting all the rows which were not useful, coping the remaining information so that all...
  9. WhyMeAndNotYou

    Query Listing a table's field name, type, description

    Reply: JeremyNYC: Your code was instructive, but since it was essentially a list to printer using the output would involve cutting and pasting; moreover, I was unable to access the Description property of the table. PHV: Was unclear how to implement your suggestion. Looked at TableDefs in the...
  10. WhyMeAndNotYou

    Query A Database Table Name, Type, and Description

    How can I access a table's field name, field type, and field description using a query? I am working with someone else's database to solve a problem. You can look at the structure of a table in the database in design view, but you cannot work with the database with a table design view open...
  11. WhyMeAndNotYou

    Query Listing a table's field name, type, description

    I am working with someone else's database to solve a problem. You can look at the structure of a table in the database in design view, but you cannot work with the database with a table design view open. The table structure visually appears as a table with a field name, type, and description...
  12. WhyMeAndNotYou

    Query Listing a table's field name, type, description

    How can I access a table's field name, field type, and field description using a query?
  13. WhyMeAndNotYou

    Form/Subform Data Entry/Synchronization

    Application is a survey data entry form containing several sections with more data elements than can be contained on a single form. Desired solution: make each section its own table linked in a one-to-one relationship on a record_id field. Create a subform for each table. Then create a Master...
  14. WhyMeAndNotYou

    Microsoft Access Field Validation on a Form

    Thank you all for your suggestions, but in the end I just gave in (up?) and coded the validation rules using a macro and assigning it to the onexit action. The validation criteria was coded as the macro condition with the macro actions of Msgbox and GetFocus. In one attempt at creating an...
  15. WhyMeAndNotYou

    Microsoft Access Field Validation on a Form

    I am not sure what you mean by procedural validation, but if you are using it synonymously with form level validation, then your conclusion is not 100% accurate. I have tried testing various scenarios and the results appear to be inconsistent. If the validation rule for a test field on a form...
  16. WhyMeAndNotYou

    Microsoft Access Field Validation on a Form

    Thank you for your suggestion, but the goal is not to convert a null value to a non-null value. The validation rule should resolve itself to either False -0 [zero], or True - a non-zero value. Based upon the values in two fields, the conditional statement would either be True (resolving to a...
  17. WhyMeAndNotYou

    Microsoft Access Field Validation on a Form

    Using a simple rule, e.g., field1<10, the validation process when entering an incorrect value is: a) the validation message appears; which upon closing, b) the cursor is placed back in the field being validated; if the value is not corrected, c) a message appears stating that the...
  18. WhyMeAndNotYou

    Microsoft Access Field Validation on a Form

    I am not sure the additional information you requested is relevant since for the purposes of activating the validation rule the process appears to work (but not for holding control until the validation rule is satisfied). However, who knows what is going on behind the scenes: Field1 is a long...
  19. WhyMeAndNotYou

    Microsoft Access Field Validation on a Form

    I am trying to create a validation rule for one field based upon the value of another field using the Form.Field validation rule (in Field2): =IIF(Field1Condition,IIF(Field2Condition,T12,F12),IIF(Field2Condition,T22,F22)) The validation rules appears to work in that the appropriate invalid data...
  20. WhyMeAndNotYou

    Microsoft Access Form Command Button Fill Color

    Is there a way to change the background color of a command button on a form from the default grey to another color? The back/fill property when right clicking a command button in Design View is not activated.

Part and Inventory Search

Back
Top