Search results for query: *

I got it. Turns out I am an idiot also. Thanks for the help.

Thanks for the replies. I have tried setting the field size to 255 characters and also to a memo field. Neither of which has any effect on changing the size of the recordset field.

Q: How do you change the default size for a recordset text field? When the recordset is created, the fields are set 50 characters long. I can see the setting in the Locals Window but nothing I do seems to change it. If, for instance, OldValue is greater than 50 characters long, I get a “Run-Time...

Thanks for the try. I am in the same boat...no way to do it without saving it.

Any idea how to open a word document or template and rename it without saving it. The idea is that the document/template is filled with data and the user has the choice of saving or not, will only need to click the x and then yes to the save question. If yes, it will be saved as the new file...

I am kind of new to Access, an old dbase programmer. I need to create a table(b) using the data from another table(a). The first table(a) has 2 fields #1-name, and #2-number. If the data in field #1 is "Smith" and the data in field #2 is "5", I need table(b) to have fields #1...

I am kind of new to Access, an old dbase programmer. I need to create a table(b) using the data from another table(a). The first table(a) has 2 fields #1-name, and #2-number. If the data in field #1 is "Smith" and the data in field #2 is "5", I need table(b) to have fields #1...

I am kind of new to Access, an old dbase programmer. I need to create a table(b) using the data from another table(a). The first table(a) has 2 fields #1-name, and #2-number. If the data in field #1 is "Smith" and the data in field #2 is "5", I need table(b) to have fields #1...