Recent content by ezykiwi

ok cool, cheers thanks for that....

oppsy, i didnt know i had to, but sure... Thanks for the info... :) Cheers Ezy I went and put solved in the title (i edited it) but its still not showing up in the forum with the right name, am i doing something wrong?

*SOLVED* Grabbing info/rearranging question Hi everyone Ive got a spreedsheet which ill attach, basically its got the format of Name (Position) Description What id like to be able to do .. is automatically pass the information into 3 cells going across, such as A1 A2 A3...

Im trying to bring meta tags into excel and Ive got it getting the title with Cll.Offset(, 1).Value = IE.document.Title but what im trying to do is also get other information such as keywords and descriptions... ive tried using IE.document.Keywords but no luck.... Anyone got any ideas...

I got a reply on the newsgroup and am working on it at the moment, I think ive found the answer, Cheers Ezy

Hello everyone, Ive got a sheet which draws data in via a web query, It then pull all the info and puts it into my sheet down the sheet in rows.... Depending on which page of my site it draws it from.. depends where the starting point in..... for example... Page 1 = A1 = blah blah 1 B1 = blah...

Hi again all, Im wondering how I can stop the messages that pop up when im about to run a update query, I get the following 1. You are about to run a update query blah blah.... 2. You wont be able to undo the changes this action blah blah 3. You are about to update X Rows Idealy Id love to...

Awesome, thanks for that , Ive got it working awesomely now, Though it keeps coming up with the message boxes when im about to update and id like to get rid of them, but ill put a more specific question for that... Once again cheers for the help. Cheers Ezy

Awesome, thanks alot for your help, Im just abit unsure about where I put this function, do I make a module or do I put it somewhere differant, I know where to put the code if it was in say a form, but since its in a query im just abit confused.... Any advice would be awesome, Cheers Ezy

Thanks mate, Im not trying to pull records, im just trying to update the feild in a table... and populate each record with its own random number in the randsort field.... Cheers for the help though Ezy

Hello Everyone, Im trying to make a query which will allow me to run a query update so that all my listings will get a new random number generated for them, Ive got it selecting any listing with a ID of >0 (so basically thats all of the listings) What id like it to do is then assign a...

Awesome, Thanks very much for that, thats awesome

Hello all, Im trying to append data from one table in one database to another table in another database, my problem is... I have a field in the first database which has a value say 5 or 123 etc... but I need it to go into the other database as "5" or "123" , is there a way I can do this? Any...

Howdy all, The other night I was playing around and deleted code from my database, which now seems to have stopped allowing me to continue to a blank form after I add a record.... It used to work, that once I pressed the save button it would then goto the same form but the form would have the...

In the code of a button, ive got.... Which should be pulling the value in cb1 in the last cat query, but im getting an error saying it cant find the field "|" refered too... Basically there is a table called Last Cat, and I want to draw the value of cb1 out of it where the catpathid = 5 so i...