Search results for query: *

Cheers Skip, That's worked a treat, and the FAQ means I can stop using about half a dozen lines of unnecessary code. Cheers.

I have an excel spreadsheet that I upload on to a web page and so most of my users view the excel sheet through internet explorer. There is a macro in the sheet that laets you type a name into a cell ("Query Sheet").Cells(2, 3) and then it goes and finds all instance of that name in the data...

Is there any way to create a template userform that can be used in different databases, so that when the template is updated all the other forms are automatically updated as well? I have a master database which is surrounded by another 10 databases that reference it. This is mainly due to size...

Cheers. RoyVidar - did consider this method but didn't want to start messing around creating and deleting columns. Oharab - You're a star. Funny how it all makes sense when you can see the answer. The circular reference problem is because it's trying to assess its own field as well as those I...

I have an access query that makes a table. One of the fields is selective using the following code: future_date: IIf([TERMINATION_DATE]>Now()+3,"",[TERMINATION_DATE]) which basically returns blank if a date in the TERMINATION_DATE field is greater than 3 days in advance of today. I did want...

I have some excel vba that produces different types of reports from a form. One of the options is to export the data to word. In order to do this I copy the part of the spreadsheet and paste it into word using the following code: Set wordobj = CreateObject("Word.Application") With...

cheers

Whenever I enter a number into excel, it is converting it to 1 hundredth of the value. So I enter 2 and it puts 0.002 in the cell. It's been doing this for a while now and I can't seem to get rid of it. I have looked at what the cells are formatted as but it's just general. It does this at...

How do I filter in vba on more than 2 criteria? I have a list within a worksheet that populates the first column of cells and can be anything from a single value to 16 values. I need to filter a seperate worksheet with these values. It currently looks a bit like: selection.autofilter...

Is there any way I can perform a filter on a date value in a column of cells with reference to today's date? For instance, if I wanted to filter on just today's date I could write: strSearchDate = Date Selection.AutoFilter Field:=17, Criteria1:=strSearchDate but what I want to filter on is...

I'm trying to convert a PDF to a word document so that I can edit it and then create the PDF again. Whenever I try to save the document into a different format I get the error message: "Bad PDF; could not read page strucutre (bad page contents).[1]" I have tried to save it into a number of...

I have recently installed visual source safe in order to maintain a database for my work. We can upload the entire database into vss but we want to be able to amend only the forms etc. I spoke to microsoft and they advised we need the office 2000 developers edition to be able to drill down to...

I have a piece of code that generates a graph on the basis of values it works out from a form that is manipulated over the worksheet. I want to show this graph on the form itself. I have tried using textboxes, lables and images with the following sort of code: image1.picture = activechart...

cool. that'd great if you could. zidbinger@hotmail.com

I have built a userform that has combox lists in it. The first list uses the row source to look for it's values in the first sheet. I then want to filter what shows in the second box on the basis of what is selected in the first one. So column A in the worksheet list something along the lines...

Cheers

I did a city & guilds at college for VB6. I don't think you can do it online as such, but all the classes are at: http://physinfo.ulb.ac.be/cit_courseware/vb6/pt1_1.htm you will need to play around with the numbers after vb6/pt to get the entire course - it goes 1_1, 1_2...1_n, 2_1, 2_2 etc up...

Can anyone tell me if there is a free trial of Winrunner anywhere? I have trawled through the net but can't find any samples of it

OK. Thanks for the replies. There aren't any partitions currently on the disk - in fact there's nothing at all. WWhen I created the disk I don't recall getting the option to make it basic or dynamic, windows just seemed to do it by itself. The drive isn't the boot disk either, it's just an...

I have been trying to partition my 2nd hard drive but can't get it to change from a dynamic one to a basic one. I am running on Win2K and the microsoft support website says I need to do this. I have gone through the usual admin tools - comp management - disk management route but when I right...