Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: sherree
  • Content: Threads
  • Order by date
  1. sherree

    Need help validating data in Access

    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...
  2. sherree

    HELP! Populating fields in a form

    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...
  3. sherree

    HELP! Populating fields in a form

    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...
  4. sherree

    Populating an Access Table

    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
  5. sherree

    Excel97:Exporting from Excel to an Ascii File?

    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...
  6. sherree

    MSAccess97:import multiple excel wrksheets using VBA code?

    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...
  7. sherree

    Access97:How to change a Chart's Colors dynamically

    I created a bar chart in MSAccess 97 and I want to keep the same format but be able to change the color of the bars for each new chart. What am doing now is copy/paste the format and editing the colors for each chart,<br>is there a better way?<br><br><br>Can you help me?

Part and Inventory Search

Back
Top