Search results

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

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...

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...

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...

Howdy All, Im hoping someone might be able to please help me... Ive got code so that when a combo box is updated the code runs, Private Sub combo1_AfterUpdate() Which works fine, but Ive also got a button, which updates the value of that combo box, and I need to get that button to run the...

Howdy all, Ive got combo boxes, in a cascading style working well... but what id like to also have is a another dropdown list that shows the last 5 selected options (because often the data will be entered in batches and it should just save time) there is combo1 combo2 and combo3 If Sport is...

Form Layout/Styles Ive been using the form wizard, with columnar but I find it squishes up some of the words, and doesnt use the whole screen width, is there a way I can change this? and is there anywhere that you can download more styles? Any thoughts would be awesome. Cheers Ezy

Hi again everyone, With help on my first question Ive now got my cascading combo boxes working to a stage that shows all the information I need, Currently Ive got 4 cbs and they work bring in and updating depending on what is selected in the previous etc etc. combo1 = 2 combo2 = 5 combo3 =...

Howdy Everyone, Im just new to using access, so hope someone might be able to point me in the right direction. Ive got 2 tables, ive used the form wizard to help set up a form for one of the tables, so I can input data, which works ok, but for one of the fields in the form I need to use values...