Search results for query: *

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

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

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

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

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

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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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.