Search results for query: *

I can see your point too, and can see that you do help a lot of people. (I did my research this time). Anyway I think it is time to stop this mini arument and carry on with our work.

Since this post I have worked out how to do the problem myself, so I doubt very much that it is beyond me to take part in these forums. I am the first to admit that I get more out of this site than I put in, but that is because I am relatively new to it all. And learning day by day. And if...

In reply to a very unhelpful xlbo. In response to your comment...This is not a helpdesk..of course these formums provide of source of help and guidance on resolving problems people have. So they can in one form or another be described as a helpdesk. I would not have come onto this forum if...

what code would I need then?

Below is a typical line of information I have on a spreadsheet: ABC 0 AB 1 ABD 0 RTD 12 TGR 9 What I would like is that when I get a 0 in a field that that whole row can be hiden, is that possible?

Thats great it works fine. Just so I know what you did, Left,3 picks up the first three characters and Mid,6 picks up anything over 6 characters, so characters 4 and 5 are missed out. Is that correct?

I have a table, within which I want to update a field. Currently it has 5 characters within the field, eg: 5TR65 RTE32 I want to delete the 4th and 5th charcters for all recordss in the field. How can i do this?

Thats great thanks.

I have a master table that I import data into each month. Once i have imported the data I change or add certain fields within the master table. When I run the module that changes/adds data to the master table it edits all the existing data. I want it to just edit the newly added data, how...

I have a pivot table that I read data off. The formula used is as follows: IF(ISERROR(GETPIVOTDATA('By Trust and Specialty'!$A$3,"'RespWL IP - "&$B$4&"' "&$A12&" 'Current Month' '"&$D$192&" Total' '"&E$11&" Resp'")),0,GETPIVOTDATA('By Trust and...

tried that and it is not there, it is like it opens it and closes the worksheet!

no good, I think it is because there are too many rows in the sheet!!! It is a pivot table. DOes any know the max number of rows allowed in a worksheet?

Lucky for me on Monday we are having a rollout of Office 2000, so that should sort it all out. At least's that saves me having to chase IT to do it.

I have a workbook that I am trying to open, each time I click to open it, it goes to Excel and looks like it is opening up and everything. Even have the name of the file in the top of the screen. But nothing appears! What is wrong, everything else is fine just problems with this file!!!!

I thought I might have to do that, I was just hoping I didn't though.

I messed up my security settings within User Group and Accounts, how can I restore these back to the default settings?

extra complication, what if i just wanted to take only the first 5 characters from the surname?

if i take out: Private Sub Form_Open(Cancel As Integer) Call SetRef 'Updates Reference when Form is opened. End Sub Private Sub Surname_AfterUpdate() Call SetRef 'Updates Reference when Surname is changed. End Sub then it seems to work just fine, is this ok to do?

I tried this but it throws up an error, invalid use of null, it then highlights the following line: strDOB = CStr(.DOB)

THank for this, this is the first time I designed a form so where would this code go?