Search results for query: *

Now I get nothing when I export. I want it to export all of the fields of the modified record in the table. I have this for the On Click of "modified" field: Private Sub Modified_Click() Me.Modified = "Null" End Sub Now nothing exports. Thanks so much for taking the time to...

HI James, Thanks for the help. How do I manually reset each control??? I only have one and it's called "Modified". Please help.

How do I reset the value of a field? I am using TransferText and after it exports, I want the value of a field to be reset (yes/no). I need it to go back to no for all records.

Thanks so much! Works great!

I am exporting data from a table when a certain form is closed. When exporting the data, I need the filename to be a specified format. For example, the filename has to start with a "T" and then include the day of the month followed by the time in military format. For example...

Thanks! That works great. Now I need to get rid of the space between quotes (from null values). I need the exported data to look like this: "33338","doe","nancy","","2" instead of this: "3338","doe","nancy",&quot...

Using Access 2000- I am using the OutputTo method on a form, but when it exports the data, the data is formatted with all these borders around each piece of data. All I need is a comma delimited text file to be exported, without including the field names. Only the data in the recordset. Here is...

Access 2000 - sorry!

I have a table and I need to write code that exports the data as a comma delimited text file only when new records are added to it or records are modified. Any suggestions?