Can I take a varible created by a text box from a form and input it into the TransferSpreadsheet file location in a Macro. Can I do that in VB is it cannot be done within the macro itself.
Example: Form Input:. User puts a file name in a text box. (this is the file he is nameing for a report). The text box is call fname.
Macro Test: TransferSpreadsheet:
Table name: RPT
File: C:\Reports\Forms!Input!fname (Is this part possible)
Sometimes MS breaks things just for fun...
In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset.
Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers.
Hopes this gives you ideas on visualizing your data in new ways ~
Create a calculated field in a query: