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 Mike Lewis 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: ictoo
  • Order by date
  1. ictoo

    Router to Router Help(wired problem)

    Hello, i'm not sure if this is in the correct section but i'll go ahead and hope someone can help me. So i have a super hub from Virgin down stairs(call it router 1) but was having trouble with my wireless signal upstairs so i install another router(router2) in my room and just connect it to...
  2. ictoo

    Sort two excel lists to match up.

    Ok I was using lookup and vlookup sort of wrong, but I think i've got it to work now i've used. =VLOOKUP(C2,$A$2:$B$9500,2,FALSE) and I think it's working it looks like it has still sceptic.. as always but thanks for poking me back in the right direction Glenn.
  3. ictoo

    Sort two excel lists to match up.

    Find/Replace.. why didn't i think of that thanks a lot that's sorted. But I tried a lookup and i'm not sure if i'm using it right how do i make it so they line up and the data in the other rows then line up. so i can then just copy all the image url from the 10000 list to 5000 list.
  4. ictoo

    Sort two excel lists to match up.

    Sorry if this is in the wrong place but this is all i could find. My problem is I have two lists in excel one with 5000 products and another with 10000, what I want is to sort the 2nd list by the first so I get all the right products ID's matching up in the 5000 i have URL/descriptions and...
  5. ictoo

    Office 2003: Access - Mail Merge problem

    Hello, ive got a access database im currently working on, i havent used access in along time(i dont rememeber coding this much stuff when i last used it) its thrown me back in to coding something ive been meaning to mess about with again. Now my problem im having problems with a mail merge...
  6. ictoo

    Forms loading slow

    The tables are accessed from a local server, and like you said it would be slow if the network decided to be slow on that day. The pageframe was used so all information could be accessed at the same time, the tabs are hidden and the user just uses buttons to get around them, but i'll see if i...
  7. ictoo

    Forms loading slow

    i have alot of text boxes being filled from tables in my data environment, i did think they get first when the form is run but when the page they are on is activated? Also i have alot of tables in my data environment and tables that are added more than once.
  8. ictoo

    Forms loading slow

    I’ve been working on this program awhile now and its got quite bulky, its basically one page frame with about 30 pages, now when I run the form it seems to have no problem, but when I’m closing it and first opening the form from the project window that it takes about 5 seconds to load, is this...
  9. ictoo

    BOF() EOF() error

    Well im doing it this way as it’s leftover from code im using to locate last record and then displaying a value associated with it, so it’s always showing the latest value of say the temperature of something. When i look for the latest occurrence for that record i go bottom and then display it...
  10. ictoo

    BOF() EOF() error

    Hey so my problem might be really simple or im just going about it all wrong. So im coding a program that views information from a table, i have code that searchs for a record in the table and then displays the value, but if it cant find that record it will add it in the the table. Now im...
  11. ictoo

    TextBox Skipping on Delete?

    Ok, SET COMFIRM ON solved another problem when the user would go over the maxs char of the text box but still when using backspace to delete it jumps to the next textbox in the tab order, looks like I’ll just have to educate my users like griff has.
  12. ictoo

    TextBox Skipping on Delete?

    Yes.. the backspace im sorry i meant when using the backspace and you get to the end it jumps to another textbox in the tab order, and it irritates my users and then they irritate me, ive told them i cant find a way of stopping it so i thought i'd put it out there so see what you lot had done in...
  13. ictoo

    TextBox Skipping on Delete?

    Hello everyone, I wouldn’t say i have a problem, but it has bugged me since i started programming with FoxPro the way when you are deleting text out of a text box and you come to the end you will jump to the next text box in the tab order and this can be bad with users and they will continue to...
  14. ictoo

    Scan a listbox

    Yet again, thanks alot mike ive been looking at this for the past 4 hours now, thanks alot for all your help. I just need to get it to lookup the filename now, i think i can do that by changeing the way the files are executed, think i can just let it look up the file name instend of the unique...
  15. ictoo

    Scan a listbox

    Ive looked in to it more and the ?thisform.pageframe1.page3.List1.ListCount is showing 4 as there are 4 items in the list and, ?thisform.pageframe1.page3.List1.List(lnI) is showing "0019" thats the descno that is used to point to the filepath but dosnt store it sorry, so its just sitting on...
  16. ictoo

    Scan a listbox

    Sorry to bring this back up again, but i never fully finished this project as something bigger came up. The code you showed me mike doesn’t seem to work with the way im using it. FOR lnI = 1 TO thisform.pageframe1.page3.List1.ListCount IF thisform.pageframe1.page3.List1.List(lnI) = "CHANGES...
  17. ictoo

    Case Sensativity in search

    I tried using upper but it then only showed the uppercase words. code below works but as i said only shows Uppercase words, i really cant get my head around this.. i guess the easy way out is to make another field in the table with the words all in upper case and then another field showing the...
  18. ictoo

    Case Sensativity in search

    Hello everyone, this is another aspect of FoxPro I’m not sure on so I hoped to be enlightened again by you all :) I want to write a simple program that will search a table for all occurrences of a letter and will keep going down tell you type in the full name of what’s in the table, lets say in...
  19. ictoo

    Select and Indexs

    Well i was looking at all the suggestions and working out how i would use them when you said using my index as a simple where clause in my select would work and didn’t think I could do that so i tried it and it didn’t work, but then i found out it was just the way i had set up my select all...
  20. ictoo

    Select and Indexs

    Ok ive got it working i put something together and it seems to be holding, and working the way i want it to thanks to everyone for your help i was looking at this for most of the day yesterday and just couldnt see what i was doing wrong.

Part and Inventory Search

Back
Top