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!

Register Log in
  • Congratulations strongm 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: Lzorza
  • Order by date
  1. Lzorza

    Problems Updating Graph

    My Friend, you can try to disvinculate the OLE from the graph's base query setting the RowSource property to &quot;&quot; and revinculate it. <br> <br> Write the following code at any event procedure that is executed when the new record is added.<br> <br> 'disvinculate<br>...
  2. Lzorza

    Data cleaning of values with a blank character

    My Friend, you can create an Update Query and insert the expresion below to remove the existing blank character from the field;<br> <br> iif(InStr([c1];&quot; &quot;)&gt;0;Mid$([c1];1;InStr([c1];&quot; &quot;)-1) & Mid$([c1];InStr([c1];&quot; &quot;)+1);[c1])<br> <br> Good Luck<br> <br>

Part and Inventory Search

Back
Top