Search results for query: *

Hi all, Downloading visual basic 2008 express is a 2 phase download; 1st you download a 2.6MB file that gives you the option to run or save. Then after running it it starts a second almost 200Mb download without the option to save. How do i save the conplete Visual basic 2008 express edition...

Thanks AceMan, calculator was a good idea...works perfectly eon5

That is exactly how i have done it in 2003 but in 2007 the property text box ix display "#FFFFFF" instead of the 16777215 value. Thus, Me.LoneID.BackColor = 16777215 works perfectly but, Me.LoneID.BackColor = #FFFFFF gives me an error? And this is the reading for light blue #8EA3BD, how am i...

Hi, Me.LoneID.BackColor = “then how do i look up the code for the specific color I want” In Access 2003 “16777215” represented the color white but in 2007 “#FFFFFF”. How do I use “#FFFFFF” in my coding? eon5

The code works perfectly, thanks eon5

Thanks PHV, it workds perfectly eon5

Thanks for the advice, i will give it a go eon5

Hi AceMan, It’s nice to get some good advice from you again. Thanks I will try the code and let you know. Hope this is not a stupid question, but what does the Nz stand for? Eon5

I have created a form with the following information; Key field1 field2 Records ID: Expense1: Expense2: 001 R20 R25 002 R15 R10 Of course the form is displaying only one record at a time with the values of...

It is an Access application Thanks

I have created a form with the following information; Key field1 field2 Records ID: Expense1: Expense2: 001 R20 R25 002 R15 R10 Of course the form is displaying only one record at a time with the values of...

Thanks for the advice eon5

Thanks for the info jsteph, at the moment it’s Greek to me but I will look into it. The last company I work for used SAP and I made use of cool excel spread sheets to manage a few things. The moment I opened the excel spread sheet, excel prompted me for a password and then it dumped all...

Hi, I have the opportunity at work to tackle a very nice system integration project. I can easily set up a very nice, user friendly database with access to integrate most or all of the current disjointed systems. The integration project includes things like; - issuing of job cards - managing...

Thanks a mil, works perfecly now

I trim from the right with this code: Sheet13.Range("p" & y).Select ActiveCell.FormulaR1C1 = "=RIGHT(RC[1],5)" I trim from the left with this code: Sheet13.Range("q" & y).Select ActiveCell.FormulaR1C1 = "=LEFT(RC[-14],8)

The cell content starts out as 00033433/3 then i trim it with code to 33433 and it works perfectly but the problem is that excel should then recognise it as a numeric number 33433 but it does not, i tried to fromat the cell to number, general etc but it does not recognise it as the numeric...

Hi, I have a cell with the value 00023455/2 in it, then i trim the content from both sides with a macro to the following value 23455 My problem is that one of my vlookups still don't see this as a unique number 23455. Thus the vlookup fails. i can even see that the cell content aligns itself...

Hi I use the following code to act on when the value is smaller or equal to 5% and it works perfectly. If Sheet9.Range("n" & y).Value <= 0.05 Then I need some advice on the code if the macro should act on a number that is between 5% and 10% Thanks

Hi, I need to concatenate some work, but can someone help me to get the code right. Recording the macro does not help me very much. Sheet2.Range("b" & x1).Value = Sheet1.Range("c" & x1).Value CONCATENATE Sheet1.Range("b" & x1).Value Thanks