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 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: *

  1. imendi

    Mouse Pointer Hourglass with movement ??

    Hi, I know how to set the mousePointer of the screen to vbHourglass. But somewhere I have seen that this pointer (vbHourglass) can also move 180 degrees ! Any ideas on how to do that ? Thanks, Imendi
  2. imendi

    How can I Find a string in the value of a field?

    Uf !! That is what I call an extremely quick answer !! Many thanks!! imendi
  3. imendi

    How can I Find a string in the value of a field?

    Sorry, I forgot. The value of the field Name could be somthing like: imendi/IM/smith
  4. imendi

    How can I Find a string in the value of a field?

    Hello, I have a SQL that I want to send from VB6 to an SQL Server Database. Before I was using an Access ddbb, and I had something like: IIf(InStr([Name],&quot;/&quot;)<>0 And InStr(InStr([Name],&quot;/&quot;)+1,[Name],&quot;/&quot;)<>0 ...
  5. imendi

    Reduce to rows to one, putting some values together

    Hi, This is a complicated. I have two Tables: Client (fields: ClientCode, ClientAddress...) Vendor (fields: VendorCode, VendorName...) Then, doing ------------------------------- select VendorCode, ClientCode where Client.VendorCode = Vendor.VendorCode ------------------------------- I may...
  6. imendi

    Delete record in table from a Recordset

    Just for the records, I think everything come from the point that in the real situation there is a form with a subform on it. I tried to delete a record of the main form in table1 but there is still a relationship of that record in table2, which is shown in the subform. By closing the form...
  7. imendi

    Delete record in table from a Recordset

    Solved ! For some reason it did not want to allow me to delete a record while the form was open. Thanks for you interest, GHolden. imendi
  8. imendi

    Delete record in table from a Recordset

    Well, it is something funny, because I tried your code and it does work either. As like with my code, it doesn´t give any error message, but it does not delete the row either ! strange... I keep finding out the reasons. Regards and thanks for your reply. im
  9. imendi

    Get Current Path name

    Sorry, wrong answer, it is: Dim a as string a =CurDir(CurrentDb.Name) There you are! im
  10. imendi

    Get Current Path name

    Have a look to Dir into the Access 97 help. Im
  11. imendi

    Delete record in table from a Recordset

    Hello, I have the following code behind a delete button in a Form: MySQL = &quot;select * from Mytable where (MyTable.Cod = &quot; & Me!txtCod & &quot;)&quot; Set Myrs = MyDB.OpenRecordset(MySQL , DB_OPEN_DYNASET) If Myrs.recordcount > 0 Then Myrs.Delete MsgBox &quot;Register deleted...
  12. imendi

    Pass var of ASP to JavaScript code

    hi, I have an asp page where I have some code to read the conents of a text file. That is in asp, using <% ... strFileName = Server.MapPath(&quot;/muestras/avisos/actual.txt&quot;) Set FSysObj = Server.CreateObject(&quot;Scripting.FileSystemObject&quot;) Set TS =...
  13. imendi

    Change bgcolor in TD with onMouseOver

    Hello, I am trying to change the bgcolor of a TD when the user moves the mouse over it. So I have: <TD onMouseOver=&quot;TDColor(this,'#808080');&quot;> and the function function TDColor(a,b) { this=a; a.bgcolor=b; } and it doesn´t work, what is wrong? Thanks, im
  14. imendi

    Update INPUT BOX onChange of Combo Box

    Hi, I have a combobox with some records extracted from a table in Access. Then, in the same table there is another field that I want to display in an INPUT BOX after the value in the combo box has been changed. For the combo box I actually extract both fields, the one that is displayed on the...
  15. imendi

    Images in a Frame, how can I set a hyperlink behind?

    Hi, I have some frames where I have images. I want to by clicking image called &quot;Home&quot;, go to the main page for example. Now I have: <frameset cols=&quot;100,100,*&quot;> <frame id=&quot;btn1&quot; name=&quot;btn1&quot; src=&quot;btnhome.jpg&quot;> ... </frameset> I want the user to...
  16. imendi

    HDD not recognised after motherboard burned !!

    Thanks for your answer, I will try it this afternoon and let you knwo the result tomorrow. Thanks, imendi
  17. imendi

    HDD not recognised after motherboard burned !!

    Hi, The other day there was a storm where I live (it sounds like a story for children, I know) and my PC went off. I took it to the shop and they told me that only the processor, memory and floppy are &quot;alive&quot;, the rest is broken. However, I know that there are some companies that try...
  18. imendi

    How to open a report on another database from a form?

    Thanks Danvlas. I´ll try your code now. Related to the 20 MB I have solved it; I have created a table, where I have three fields: ID, description and and OLE object, which is the image itself. You only have to copy and paste into the field once you open the table. Then I have created a report...
  19. imendi

    How to open a report on another database from a form?

    The reason is that the 5 reports that I have, imply 20 MB, so I don´t want to load these unless it is necessary. Most of the people will work with no so powerful notebooks, and most of the times (95% I would say), they won´t use these reports. But just in case, I want to have them available. Imendi

Part and Inventory Search

Back
Top