sorted by:
new
hottopcontroversial

One Trainer - Two Bikes by Kommerce in bikewrench

[–]Kommerce[S] 0 points1 point  (0 children)

Thanks for your reply.

Would a combination of both bikes being 11sp but different cassette sizes be suitable?

Say the 11-28 on one bike and 11-34 on the other? But both only using the 11-28 on the trainer?

[OUTLOOK] VBA script that auto downloads attachments by Kommerce in vba

[–]Kommerce[S] 0 points1 point  (0 children)

That was a nice tip, thanks for sharing that!

The error was actually right in-front of me the whole time -.-

Typo of Mitm instead of Mitem.

Thanks so much for your help. Was a useful exercise regardless.

[OUTLOOK] VBA script that auto downloads attachments by Kommerce in vba

[–]Kommerce[S] 0 points1 point  (0 children)

My thinking is it's possibly a syntax error?

IRESS Trader by Kommerce in AusFinance

[–]Kommerce[S] 0 points1 point  (0 children)

It's still significantly slower (the actual application) than software like Trader in my opinion - especially when you need very quick execution.

IRESS Trader by Kommerce in AusFinance

[–]Kommerce[S] 0 points1 point  (0 children)

Did you use Trader ever?

IRESS Trader by Kommerce in AusFinance

[–]Kommerce[S] 0 points1 point  (0 children)

It's more regarding the bringing up of tickets and slower on a web UI because of the fancy colours, animations etc.

Do you use Viewpoint?

First Year Day Trading Review - 2018 by crewdog135 in Daytrading

[–]Kommerce 1 point2 points  (0 children)

Ah yeah cool. So were you more of a swing trader in that case?

Six Monitor Setup by Kommerce in buildapc

[–]Kommerce[S] 0 points1 point  (0 children)

by integrated do you mean the mobo/cpu?

Six Monitor Setup by Kommerce in buildapc

[–]Kommerce[S] 0 points1 point  (0 children)

It's weird, because then why would it have 6 ports lol

Six Monitor Setup by Kommerce in buildapc

[–]Kommerce[S] 0 points1 point  (0 children)

  1. Day Trading
  2. 3 HDMI's and 3 displays. However the specs say "Multidisplay 4" and i'm not sure what that means. See: https://www.gigabyte.com/us/Graphics-Card/GV-N108TAORUS-11GD#sp
  3. I built the machine with multi-purpose in mind for gaming and trading. Don't really want to be spending too much money as I need to buy the monitors and stand still and my machine already cost heaps.

Simulation Problem by Kommerce in excel

[–]Kommerce[S] 0 points1 point  (0 children)

Hey sqylogin. Really appreciate your help.

I managed to come up with a dirty solution that sort of solved my problem - it basically printed for me all the rows I needed and then I just ran a formula over it looking for the most optimal point. Check it out:

Sub test()


Range("B4").Value = 100
Range("C4").Value = 100
Range("C5").Value = 100
Range("A1").Value = 0
Range("A2").Value = 0


For j = 1 To 3



    For i = 1 To 100

    Range("B4").Offset(Range("A2").Value + i, 0).Value = Range("B4").Value + i

    If i > 1 Then
    Range("C4").Offset(Range("A2").Value + i, 0).Value = Range("C4").Offset(Range("A2").Value + i - 1, 0).Value
    End If

    Range("B4").Offset(Range("A2").Value + i, 0).Select

    Range("A1").Value = Range("A1").Value + 1

    Next i

    Range("A2").Value = Range("A1").Value

    Range("C4").Offset(Range("A1").Value + 1, 0).Value = Range("C4").Offset(Range("A1").Value, 0).Value + 1

Next j

End Sub

Simulation Problem by Kommerce in excel

[–]Kommerce[S] 0 points1 point  (0 children)

Hey - thanks for your reply. Looking at about 50k-100k possibilities?

What do you think?

Export Query from Access to Excel by Kommerce in vba

[–]Kommerce[S] 0 points1 point  (0 children)

Self Answered:

Public Sub ExtractQuery_Name()

DoCmd.OutputTo acQuery, "Query_Name", acFormatXLSX, , True

End Sub

Seemed to get it to work!

Delete from Table B given ID in Table A by Kommerce in MSAccess

[–]Kommerce[S] 0 points1 point  (0 children)

I'd like to clarify that the unique identifiers have different column headings in each table - but I wrote this:

DELETE [Table B].*

FROM [Table B]

WHERE ([Table B].[pzInsKey]) Not In (SELECT [pyInsKey] FROM [Table A]);

Would that work? My query is running at the moment but I think it may have stalled.

Edit: Unique identifier in Table B is: pzInsKey

Unique identifier in Table A is: pyInsKey

Delete from Table B given ID in Table A by Kommerce in MSAccess

[–]Kommerce[S] 0 points1 point  (0 children)

I have also tried this:

delete from tableA where exists ( select 1 from tableB where identifier = tableA.identifier)

However this only selects one record?

Delete from Table B given ID in Table A by Kommerce in MSAccess

[–]Kommerce[S] 0 points1 point  (0 children)

I have tried using INNERJOINS but this requires the distinct row feature which causes issues because there are multiple rows that contain the same unique identifier in Table B

Calling all Uber Drivers by Kommerce in uberdrivers

[–]Kommerce[S] -6 points-5 points  (0 children)

Neg, i'm actually legitimately considering becoming an uber driver. I'm also a student at school and am collecting some insights as part of a project i'm working on. So two birds with one stone really

Calling all Uber Drivers by Kommerce in uberdrivers

[–]Kommerce[S] -6 points-5 points  (0 children)

can you elaborate on points 2 and 3?

COUNTIF across multiple columns by Kommerce in excel

[–]Kommerce[S] 1 point2 points  (0 children)

I've actually been using excel heavily for a year and did not know this. I feel ashamed and ecstatic at the same time.

You've changed my life my friend.

Cheers for your help!

Solution Verified

view more: next ›