Search results

Re: Really Weird Graph Problem Excel 2003 Solved Hi Everyone I have finaly solved the problem. When I reinstalled Windows 7 the problem appeared to be resolved and my graphs were back to normal. When I reinstalled my printer which is a Samsung ML 1510 "Ouch" the problem re-appeared. It...

Hi I ended up having to re-install Windows to cure the problem. I think it was a Malware issue. Regards Tony

Hi Everyone I wonder if anyone can help me with a problem that has only just started happening. I've been using Excel 2003 professional edition for years now with no issues when it comes to making line graphs. When I now make a line graph, it's perfect when you make it and then if you click on...

Hi everyone I have a database where you click on a music track listed in a listbox and it plays it from its location on my C: drive. When double clicked the file opens and plays in windows media player where it stops at the end with media player still open. Is there a way in access vba to...

Hi Josephff All I can say is WOW Having never tried that before I would not have thought it possible. That's a real help to me and thankyou again for the info. Kindest regards Tony

Hi Josephff Thank's for your reply. Do you know I had not really thought of a dll. The reason that I didn't want to use external graphics is in case I wanted to give the program away to others. Oh well I guess I will have to use external images after all and zip them up with the program. many...

Hi Everyone When creating a Command button you can click the picture builder to the right of the picture property and select a picture from the dropdown list of bmp pics that access already has built in. What I would like to do is to change the image on the button if a text box on another form...

Hi Missinglinq Thankyou for your reply. Using this method I have been able to solve the problem. Many Thank's again Tony

Hi Everyone I have a PoPup form with a textbox that displays text from a database search. What I want, is for the user to be able to double-click on a word that they don't understand, the word will then be selected and I need to Copy just that one word into a Public Variable so that i can do...

Hi Again I have found the solution. If anyone is interested it is:- Open Word View/Toolbars/Database Toolbar Click 7th button along (Insert Database) On the Popup Box click Get Data Browse for your database table or query, Select it, click OK On the Popup Box click Insert Data ***Important***...

Hi Everyone I have been asked by my friends daughter who is doing her GCSE IT Course at school, how to embed an access database query into a word document and have the word doc update if the data in the query has changed in the database. I have tried paste special and I can copy the query...

Hi Bob Thank's for all of your time and answers. I managed to get it all working with a bit of jiggery-pokery. Kindest Regards Tony

Hi Bob I would like it to trigger a message box if all of the boxes in 1 group are empty, asking the user to fill one in before closing the form. Can you give me the final bit of code to do this please? Thanks Tony

Hi Bob Hey! No more error messages However what is it supposed to do? If I fill all of the boxes the form closes ok without any message. If I leave all of the boxes empty the form closes without any message. Should there be a msgbox prompt when they are all empty or something? Cheers Tony

Hi Bob If I call the routine from my close button with:- Call TestForNulls(Student_Details) It returns the error 424 object required When I click Debug It Highlights Call TestForNulls(Student_Details) in yellow Cheers Tony PS Is the above call syntax correct?

Hi Bob Thank's for the code it looks great and I'm sure it will do the job if I can work out how to call it properly. I made a new module (module1), pasted the code into it as instructed. I then put all of the 1s, 2s etc. in to the tag properties on my form. I have a close button on my...

Hi Everyone I wonder if anyone can help please. I have a form with 40 textboxes. They are divided into 4 groups of 10. I need my user to fill in at least one box in each group before closing the form. Is there a way to test each group to see if this has been done and to pop a message box up...

Hi Chergh and Ed Thank's for both solutions, it is really appreciated All the best Kindest Regards Tony

Hi Everyone I wonder if anyone can help with this I have a spreadsheet where in just column A on the first row there is an address. On row 2 there is a phone number. This situation goes down the column for a thousand addresses and phone numbers. What I would like to do is to join each phone...

Hi Boblarson and Starman Thanks for your help, no I did not have a backup as I had only just created the form, about 2 hours work down the drain. Most unlike me I usually back things up before I get a chance to do something stupid. kindest regards Tony