Recent content by sherree

Thanks for responding Jimmythegeek, I need to achieve this from a button on a form. The form is an excel spreadsheet that I imported which has the code values and I have to check these code values against the code value table to see if they are current. Thanks Again, Sherree

Help Me! I have a table where I need to test one of the fields (called CPT/ICD-9)against another table (called code value). Example Data: Form Element Table CPT/ICD-9 Element Name 10001 Anesthesia 12000 Biospy Code Value Table Code Value Code Desc 10001 Anesthesia 12001...

Hi,<br><br>How do I retrieve the IP Address of the local machine and the file path in Access using VBA Code? And automatically populating the text box once you retrieve the files?<br><br>Example of My Form:<br>&nbsp;&nbsp;<br>This is the button:&nbsp;&nbsp;Import the Data Definition...

Hi,<br><br>How do I retrieve the IP Address of the local machine and the file path in Access using VBA Code? And automatically populating the text box once you retrieve the files?<br><br>Example of My Form:<br>&nbsp;&nbsp;<br>This is the button:&nbsp;&nbsp;Import the Data Definition...

Thanks Guys,<br><br>It works using the query.&nbsp;&nbsp;But I have to use VBA code only.<br>But I figured it out.<br><br>Here's the code for future references:<br><br>'This module selects all records in the Excel Import File table and copies them into the<br>'form elements table.<br><br>Sub...

I had a similar problem importing an excel spreadsheet into an access table.&nbsp;&nbsp;Try settin all the fields in excel to general and all the fields in access to text.<br><br>Sherree

I want to populate an access table used the excel spreadsheet I imported using VBA.<br>Here's an example of excel spreadsheet table and the table I want it to...

Hi!<br><br>I need help populating an access table using VBA code only.<br>Also, how do you concatenate two fields in an access table using vba code?<br><br>Thanks,<br>Sherrie

Hi Brian,<br><br>&nbsp;Congrats! Thanks for your help last week.&nbsp;&nbsp;I am trying to convert Excel into an Ascii File using code.&nbsp;&nbsp;I figured out the type conversion issues.&nbsp;&nbsp;I set all columns in Excel<br>to General format and all data types in Access to...

Hi,<br><br>I need help exporting an Excel multiple spreadsheet to an Ascii File.&nbsp;&nbsp;Any suggestions?<br><br>Also, I am importing an excel spreadsheet<br>into Access and I am getting import errors;<br>Type Conversion Errors (#num!). I change all fields to text.&nbsp;&nbsp;And I am still...

Brian,<br><br>I've tried you're advice once more.&nbsp;&nbsp;And guess what it works!<br>Thank you very much :)<br><br>Now I have to try an excel file that has multiple spreadsheets to import.<br><br>

Thanks harryrich,<br><br>I 've tried your advice, but it does not work.&nbsp;&nbsp;I get this error message:<br><br>The action or method requires a File Name argument.<br><br>You tried to use the TransferSpreadsheet or TransferText action or method.<br>In the File Name argument, enter a file...

Hi Dan,<br><br>My name is Sherree I am almost having the same problem you're having, I wrote<br>the sample code Brian showed you.&nbsp;&nbsp;It does not work you have to specify the file<br>name and enclose it with quotes.&nbsp;&nbsp;I am trying&nbsp;&nbsp;to import multiple excel...

Brian Famous<br><br>I appreciate your help but your code was unable to help me.<br>I recieve an error message Microsoft Jet database Engine could not find the<br>object 'f:\excelspreadsheets ' Make sure the object exists and that you spell<br>its name and path name correctly.&nbsp;&nbsp;The file...

Hi,<br><br>I'll greatly appreciate any help or suggestions on the following questions:<br>How do I import multiple excel worksheets <br>into an Access table use VBA code only?<br>I've tried this code:<br>DoCmd.TransferSpreadsheet acImport, 8, &quot;spreadsheet&quot;, &quot;w:abc.xls&quot...