Search results for query: *

Thanks for both of your suggestions. Renaming the field did the trick so I went with that.

This is a super remedial question, but it must be asked. I have been asked to make certain fields in a printable form appear in all caps, although the data itself is to be entered in another form in upper and lower case. I thought it would be as simple as using this: =UCASE([field name]) for the...

Thanks for all your help on this. The document Analyzer does what I need it to do for this case. I tried fooling around with the querying in the ACWZUSERT.MDT database. I had to go firectly into that database - I couldn't link any table from it because MDT wasn't an option in my file type drop...

Thanks for your help. I endountered the following problem though. When the code got to this statement: Dim db As DAO.Database it returned an error message "User defined type not defined". Do you know what needs to be added in for it to work? (I'm using 2003) Thanks

I want to be able to print out the structure of two tables, each with about 100 fields, from two different databases, so I can more easily try to identify corresponding columns. This is so I can eventually create a query that appends the data from one table to the other. I can't seem to find any...