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...
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.
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.
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...
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...
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...
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.
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...
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...
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...
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.
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...
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...
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...
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...
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...
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...
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...
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...
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.