Search results for query: *

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 ;-)

Okay, I solved the problem. The Specification Name ("format_w_tab_header") must contain the same field names or types that the object (table or query) contains, otherwise it fails. Thanks to you all.

Yes, I have that right. I also tried on another drive, and it does the same. When I put the .txt extension, here is what it says: Execution error '3011': Microsoft Jet database engine could not find the object 'aaa#txt'. Make sure that this object exists and that you correctly spelled its...

No, there's no such folder named "C:\aaa". I changed the name for "C:\aaa.txt" and it doesn't work either.

Every time I try the following command: DoCmd.TransferText acExportDelim, "format_w_tab_header", "query123", "C:\aaa",-1 VBA tells me "Execution error 3027: update impossible, database or object is read-only." Still, the "query123" object is not a read-only one. Any clues? Thanks!

Suppose I have the 'abc' table: individual year size 1_4_5 1 112 1_4_5 2 123 1_4_5 3 146 1_4_5 4 157 2_8_3 1 92 2_8_3 2 104 2_8_3 3 98 ... I want to pivot the table to get: individual size_yr1 size_yr2 size_yr3 ... 1_4_5...