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 Wanet Telecoms Ltd 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: macca007
  • Order by date
  1. macca007

    extract certain characters

    once again thanks for your reply. your script will work for certain scenarios. However sometimes the users who write the filename may change the format of it. e.g the actual format(98% of times is this) 2345_dx3945_29_10_50_Blogs_joe the other 2% may write it like this dx3956_Blogs_joe...
  2. macca007

    extract certain characters

    Hi all, I would like to extract certain numbers and characters from string of letters and numbers e.g 3452_dx2443_joeBloggs what i would like to extract is the dx2443 which is the example patient hospital number it always starts with 2 letters then followed by numbers. i only know very...
  3. macca007

    Get next filename still not working

    ...Dim strFolderName As String, strFileName As String Dim i As Integer strFolderName = "C:\Database\Images\" strFileName = Dir(strFolderName & "*.*", vbNormal) If Not IsEmpty(strFolderName) And Not strFolderName = "" Then Dim FileList As New Collection ' List of files in...
  4. macca007

    Get next filename

    ...Me("DetailHeight") = 0 strDirectory = "C:\Database\Images\" ' strTest = GetFileName(strFolderName) strFileName = Dir(strDirectory & "*.*", vbNormal) ' Me.txtFileHyperlink = strInputFileName ' If DBPixMain.ImageBytes > 0 Then ' Update the thumbnail...
  5. macca007

    Advance VBA Code - need some assistance

    Thanks PHV for reply, Me!ItemId & ".jpg" that just gives me itemID which is an autonumber that has been used in the folder. So each image has a unique id. What i would like to retrieve is the actual filenames for the hospno. for example in folder images, there would be 3 images and there...
  6. macca007

    Advance VBA Code - need some assistance

    ...of files in folder (to prevent potential recursive calls to Dir) Dim strFile As String strFile = Dir(strFolderName + "\" + "*.jpg", vbNormal) Do While strFile <> "" FileList.Add strFile strFile = Dir Loop For i = 1 To...
  7. macca007

    DBpix Load images

    cheers phv that worked. Heres star
  8. macca007

    DBpix Load images

    ...of files in folder (to prevent potential recursive calls to Dir) Dim strFile As String strFile = Dir(strFolderName + "\" + "*.jpg", vbNormal) Do While strFile <> "" FileList.Add strFile strFile = Dir Loop For i = 1 To...
  9. macca007

    DBpix Load images

    Hi, I am currently using dbpix to load images to the database (the images are linked not embeded). However the sample database i got from http://www.ammara.com/downloads.html uses a button to load the images to the database and then stores them. The feature i would like in my database is to...
  10. macca007

    Batch Printing &quot;Letter&quot;

    Hi all, I have created a mail merge document with suppliers address. I have a table called tblSuppliers which contains addresses for many suppliers. My question is, can it be done by code to press a button and it will loop through each address and print the letter off. There is only one...
  11. macca007

    Goto very first record in listbox and highlight

    Finally worked it out. lstClinicalDetails.Selected(0) = True nearly similar to yours but it helped.
  12. macca007

    Goto very first record in listbox and highlight

    thanks for the reply dean lstClinicalDetails.ListItems(1).Selected = True i get the following error on listitems "method or data member not found"
  13. macca007

    Goto very first record in listbox and highlight

    Hi, My situation is after person has selected a patient from a combo box, many treatments are shown in a listbox (1 to many relationship). What i would like to do is when a patient is selected from combo box i would like the first record on the listbox to be selected and highlighted. Can this...
  14. macca007

    Subform control criteria

    thanks for the reply lupins46 Could you explain that more clearly, don't know what you said.
  15. macca007

    Subform control criteria

    Hi, all Basically i am tryin to make a reference to control that is on a subform. The main form is called Patient4 the subform is called frmTreatmentSecton and the control (textbox) is called txtClinDet the criteria i came up with is this...
  16. macca007

    Web page not showing properly

    give it a go now it should work http://www.shef.ac.uk/~ns/Test/TreatmentDay.htm
  17. macca007

    Web page not showing properly

    Hi, this my first website i have constructed it displays well on dreamweaver and my computer when i run it. However when i upload to our server comes out quite messed up. Its particularly effecting the scrolling layers (when user uses mouseover to scroll up and down the web page layer would...
  18. macca007

    error parsing styles

    cheers
  19. macca007

    error parsing styles

    Hi all i get this error error parsing styles on this line of code. The "<a href" is underlined in red. <div id="down" style="position:absolute; left:942px; top:505px;<a href="javascript:;" onclick="return false" onmouseover="dw_scrollObj.initScroll('wn','down')"...

Part and Inventory Search

Back
Top