Recent content by jdelano

Which database? I did a test project with an MS Access database that worked just fine.

I added this to handle what you are looking for Dim writingToWorksheet As Boolean ' flag to skip executing this event if the K or I column is doing the changing Private Sub Worksheet_Change(ByVal Target As Range) If writingToWorksheet Then Exit Sub ' Check if the change was made in...

True, that could be the Order By given the list looking at the example.

This handles if there could be a different car Option Compare Database Private Sub Command1_Click() Dim carTable As Recordset Dim groupedTable As Recordset Dim currentCar As String Dim currentColor As String Dim previousToQTY As Integer Dim previousCar As...

Nice, my issue is I see VBA as my hammer, and everything is a nail. You're welcome, happy to help.

I was thinking that because the colors aren't grouped (so they aren't looking for the min/max) I used VBA on a form to group the records into another table. Option Compare Database Private Sub Command1_Click() Dim carTable As Recordset Dim groupedTable As Recordset Dim...

"TB is not a replacement for Access." - correct it is just a VBA and VBA IDE replacement, not a database in and of itself. Plus, it isn't a given the tBA will even go past the POC phase. Now, the "regular" twinBasic IDE and language has come a long way and has reached the point of being a...

Yes (y)

got to the vbforums site, there is a dedicated subforum for twinBasic (I'm not allowed to post links here as of yet)

In any event, if you want the complete lowdown of it there is a dedicated subforum on vbforums with a pretty active community.

Okay, are you talking about the twinBasic that extends VB6 for Windows desktop apps or the proof of concept that a recent video was about? (since posted by Josef)

You can use an Access database with twinBasic. This is of course super simple example using beta 546 currently. The Access version DB tested here is 2000. I've attached the project (just 2 buttons) if you're interested. Class Form1 Sub New() End Sub Private Sub...

Maybe overkill for what you're looking to do but, you could write VBA to launch a console app written in .net (vb or c#) that you pass in some parameters, it executes the report to PDF, saves the attachment as a file and merges the PDFs, then deletes the PDF it created from the attachment file...

I think this is what you're asking. Here is a query that compares when a payment is made against the due date using the DateDiff function. If the DateDiff function returns a negative number (which means the payment was before the due date) then no penalty is required. However, if the DateDiff...

Guessing because you haven't included what the error message is or on which line. Place a breakpoint on the lines where you're creating the query and check the values of the variables that you're concatenating to make sure the values are what you are expecting.