Search results

Much appreciated, ghudson. :)

Is anyone aware of an Access function that replicates the Proper Case spreasheet format, i.e. each word begins with an Uppercase character? Or is it necessary to build a VB procedure to update the text property of a text box? I having trouble building such a format. Thanks. :confused:

Is anyone aware of an Access function that replicates the Proper Case spreasheet format, i.e. each word begins with an Uppercase character? Or is it necessary to build a VB procedure to update the text property of a text box? I having trouble building such a format. Thanks.

I know it should work, but i get a 'Can;t assign a value to this object' error message.

I tried that the 1st thing. I get a "#Name?" displayed as a result. And I can't findout what that means anywhere thru the Help system.

I have an unbound text box that I want to use to display the one field result of a query. I've tried this code but wont work: DoCmd.OpenQuery "qryGetMax" Me.txtMax.Value = [qryGetMax]![MaxOfWgt] The query give the correct result but I can't assign it to the text box. What am I doing wrong...

I have a form that enters variable data to a table, 12 fields. I want to access that record and evaluate it for the maximum value in the record. I've tried several approaches but i can't seem to open the table from VB and read the fields of the 1st record. Can someone please assist?

Many thanks, guys

I have a problem with this a simple declaration: Dim dbs As Database I get a compile error for a user defined object. Which reference library should be loaded to correct this error? Thanks