Recent content by howardr

Thanks Martin! I checked Tools > References and the Microsoft DAO 3.6 Object Library is selected. I'm not sure why this isn't working yet, but I think it is close. Thanks again for your help, RH

Hi Roy-Vidar, Thank you for your suggestion. I changed the declarations as you stated. It did help, but now I am getting the "Complile Error: Method or data member not found" and ".Fields" is highlighted. This is right under the "On Error GOTO Missing Property" statement. The line of code...

Thanks PH! I appreciate your help. I am now getting another "Compile Error: Method or data member not found" and ".CreateProperty" is highlighted. This is in the last part of the Module code commented 'Only Format in this case! Please let me know if you have any suggestions on what to do...

Hi AceMan, I'm trying your code now, and I am getting an error when I try to run it. I have copied your code in the module and I am trying to call the module code, but when it gets to Call SetTblProps("MyTableName", "Column1;Column2;Column3;") I get a Compile Error: Argument not Optional and...

AceMan, No need to apologize. Mom comes first :). Thanks for the code. It looks just like what I was looking for! I will give it a spin tomorrow, and let you know. Thank you again for helping me out!

PHV, Thanks for the post. I thought of trying something like that, too. I was just trying to find a way to do it from my code. Thanks for your post!

Hi AceMan! Thanks so much for responding! I'm doing great. How are you? I hope I can explain my my question so it makes sense. I have a table created by a Make-Table Query. When you open the table in Design View, in the General Tab under Field Properties, in the Format line, it is blank...

Hello, I am trying to use VBA to change the Format of an existing table in Access 2003 to Standard and the Decimal Places to 6. I need to do this from the VBA code, as it is part of the code I need to run (if that makes any sense). Can someone please help?? Thank you in advance. Your help...

Thanks 13badar, I guess I didn't state that I wanted to make this format / decimal place change within the VBA code I am writing. Any suggestion on that? Thanks!

Hello, I am probably missing something very obvious, but I am trying to Format a field in my Access table so that it is Standard and has 6 Decimal Places. Eventually, I will need to know how to format another field in the table to Text (I thought I would ask now, while I was here) Thank you...

Thanks TheAceMan1 !! Worked like a charm. Your help is greatly appreciated!

I need to change the names of the columns in an Access table that I am pulling in from another Access database so that I can run the pre-written queries I have. Is there a way to import a table from another Access database and then rename the fields / columns in VBA to what I need them to be...

This worked like a charm PHV! Thank you so much! RH

Hello, I have just started using VBA, and I have a VB program in an Access database that needs to copy information from an Access Table into an Excel Spreadsheet. I have the coding for this completed, except for the fact that once the Excel spreadsheet is saved, I would like to make it Read...