Search results

Adding 'True' worked. Thanks for the Help!

Thanks Ken for the response. I tried the acFormattxt and it gave me a type mismatch error when I ran the command. Any more ideas?

Currently I am using the following code to export to a .csv file, however, the table headers do not come across: DoCmd.TransferText acExportDelim, , "QueryName", "test.csv" I can use the following code to export into a .xls file and the table headers come across. The only problem is that I...

I now understand what you are saying. I actually misread what you were trying to get across and I didn't explain myself very good. The problem is that I can't actually reformat the table. The table of data That I have to work with contains 1000's of records with the data already there. The...

Thanks for the post Len. That would work great, the only problem I see is that the reformat table process needs to be dynamic because Bob may have 5 addresses representing 5 address fields and Jane may have 2 addresses representing the first 2 address fields. Not sure how to produce this...

I've thought about array's and recordsets, but was wondering if there is an easier way. I have table like this: Name Address Bob 123 Main Street Jane 89654 Elm Street Bob 3547 Island...

I would like to be able to click on a button from one form(Property) and open up a record in another form(Owner) where it ID is equal, and not using a filter. The Access wizard, open form with specific records feature only opens the records that equal that particular ID in a filter. I would...

Great, That worked. Thank you so much!

I have searched the forum for this problem, and the related issues have not helped. The below code is rather simple, but access will not allow me to insert the Property_ID into the form. Error: You can't assign value to this object. Any helpful advice would be much appreciated. Thanks...

This is a common problem that has alot of help docs out there but none seem to apply. I have coded a small function in VB and this function works within Access 2000 (in queries, reports, and Data Access Pages). But when I try to pull the Data Access Page up in Internet Explorer 5.5, It tries to...