Search:

Hello Everyone,

I have created a short cut on my desktop that launches a webpage on the intranet. The short cut opens, however if I am using my browser, it overwrites the page I have open.
For...

Hi Everyone

Can anyone explain in simple terms the difference between Tools, Option Calendar tab fields and the Tools, Change Working time.
I know that if you change the Hours per day on the...

Hello Everyone,

I have setup a macro so that I will move to the last cell and then copy that column of data and the column before it.
Then I move to another column and paste.

My problem: The...

Hi Steve,

What is needed so that it is added to the list?

Kerrie /forums/images/smilies/smile.gif /forums/images/smilies/smile.gif

Hi Andrew,

Thank you for your help /forums/images/smilies/smile.gif /forums/images/smilies/smile.gif
When using combo boxes is it normal that you can only type in one new value? For example, if...

Hello Everyone,

I have created a combo box that has 10 values to choose from however I would like people who access the worksheet
to be able to type additional values. This is where my problem...

Hello Everyone,

I was wondering is there anyway in Project 2000 to protect your file from others writing to it (unless they enter a password)? Similiar password protection to Excel.
I know you...

Hi Steve,

Brilliant it worked, no alerts, the data form appeared. /forums/images/smilies/smile.gif /forums/images/smilies/smile.gif
One more thing /forums/images/smilies/smile.gif, I only want...

Hi Steve,

Thank you for you suggestions /forums/images/smilies/smile.gif I have tried the code however I still get the error messages.
Your previous posting "hit the nail on the head". I have...

Hi Steve,

Yes data is the name of the sheet, I previously tried your suggestion and I still got the error on the .showdataforms
command.
It does seem to recognise the selection.

Kerrie...

Hello Everyone,

I have a spreadsheet and I would like to create a macro that selects a range of headings and then create a data form.
I can create the macro - OK, however when I run it I get an...

Hello Everyone,

I have created a macro and it works except for one thing.
Basically, I copy data from a .csv file and paste it into excel. That works OK.
However, depending on where my mouse is...

Hello Everyone,

I have a column of values that may change, at the bottom of the column "TOTAL:".
I only want to add the values that have changed, is this possible?
I was thinking of using the...

Thank you Hans, it worked /forums/images/smilies/smile.gif

Hello Everyone,

If I have a formula SUMIF(A1:A4,"<10000,B40:B50) and I don't want a static test.
Instead of "<10000", I want <c5, and the value will change.
Any ideas on a formula?

Thanks...

Brilliant, Thank you very much /forums/images/smilies/smile.gif /forums/images/smilies/smile.gif

Hello Everyone,

I have a pivot table and I am adding the row, column and data information, and
the pivot table displays the summarised results as it should - however is displays
all the data...

Hi HansV,

I have setup the database and form, everything is working except for one last thing, the tab order.
I have a main form (personal details) with 8 subform on it.
I have setup up the...

Thank you, Thank you HansV.
It all made sense.
Did you attach a zip file - because it didn't appear - I would be very interested in viewing.

Kerrie /forums/images/smilies/smile.gif

Hi HansV,

This is the one I was working on: before trying to recreate everything.
The error message I get when I try and enter a new record.
Firstly it says "You cant go to the specified...

Hi Charlotte,

I am had lots of problems with linking. So I recreated the database.
I will try and attach a copy

Hi Charlotte,

I think I have a problem with the way I have created and linked the tables.
I have sent your a sample from a previous posting.

Thank Kerrie /forums/images/smilies/smile.gif

Hi Everyone,

Any ideas, I have a list box on a form. List box and I types in the values, I type 4 values, store the values in the particular field. The
first time I did it everything was ok....

Excellent.

Thank you Hansv.

Kerrie:)

Hi WendellB,

I tried and you are right, it creates lots of trouble.

Thanks for the advice.

Kerrie /forums/images/smilies/smile.gif:)