Recent content by metaltree

Hello, I need to sum the values of several columns but want to avoid the $1+$2+$3...+$100 syntax. I tried the command below, but apparently I'm doing something wrong. $ cat infile 1 2 3 4 5 6 wanted result 6 15 $ awk -F "\t" '{x=0; for (i=1; i<=NF; i++); x = x + $i...

Is there a way (SQL or client command) to get the date of creation of a column in a table?

Okay, thanks. Yes, I agree, there doesn't seem to be a lot of activity here!

Hello all, sorry for the late reply. I stored the variable into a table finally, and it worked. I used it to store the path and filename chosen by the user with the .FileDialog(msoFileDialogFilePicker) method. Many thanks,

Okay, the problem was the missing rake command apparently. I reinstalled it. But now, I can't get passed that new problem: C:\testror\depot>rake db:migrate --trace (in C:/testror/depot) ** Invoke db:migrate (first_time) ** Invoke environment (first_time) ** Execute environment ** Execute...

Hello. When I use rake bd:migrate, it sends this: C:\testror\depot>rake db:migrate --trace c:/ruby/bin/rake.bat:24: undefined method `require_gem' for main:Object (NoMetho dError) Any clue?

Okay, thanks for your quick and helpful comments.

Okay. However, when I actually call that procedure on the second form, it sends me an error message: Compilation error: undefined sub or function. My code is as follows On form 1: Call abc On form 2: Public Sub abc() (...code...) End Sub

Is there a way to declare and initialise a variable on a form that retains its value even when that form is closed and reopened ?

Is there a way to call from a first form (form1) a procedure written on a second form (form2)?

Thanks AceMan1, I'll try that.

Awesome. Thanks!

Please, ignore my last piece of code, here is the right one (that doesn't work): From subform1 Private Sub field1_AfterUpdate() Forms![subform2].Enabled = False End Sub Where subform2 stands for the name of the form (source object in properties) However, the following code works: From form1...

I have a menu form (form1) and 2 subforms (subform1 & 2). When I update data in subform1, I want to disable subform2. I tried from subform1 Private Sub field1_AfterUpdate() Forms![subform2].Disable End Sub but VBA keeps telling me that he is unable to find that name. Any ideas?

Sorry, posted on the wrong place ;-)