Type: Posts; User: Zvoni
Search took 0.03 seconds.
I remember doing something similiar some 7-8 years ago, and i think i did with bookmarks, which you can apply to the controls
And trust me: Yes, Wind-Tunnel is fun, but it's a completely different thing to see a plexiglas-thing in front of you and the net 4-5 feet below you, and standing at an open door and looking...
Wouldn't have expected my question to kick off such a discussion.
Ah, well. Got my Problem solved, the question was just out of curiosity,
and the weekend with brilliant conditions to...
OK, i got it.
LGLIDA=ShippingDate in Numeric Format YYYYMMDD
SUM(CASE WHEN SUBSTR(LGLIDA, 5, 2)='01' AND LEFT(LGLIDA, 4)='2015' THEN...
sorry for late reply.
Yes, i want to group by year and month (sorry, i forgot), since the time-window may include several years, but i wouldn't expect it to be that much more complicated...
In a table, there are columns for part-no, shipping date, quantity etc.
I want to group this table (actually it's going to be an SQL-Query for a report) by month, the months...
Nevermind that i see a whole bunch of issues with his code (initializing the indices to the last index and other stuff)
Entire file of what?
You do realize that you're creating a separate file...
Why not change the function around (See my code-sample)?
Inside your Sum-Function you're checking against illegal Return-Values, so instead of giving a boolean back, give the result back
Maybe this one here: http://www.vbforums.com/showthread.php?790019-Why-does-MSCOMCTL-OCX-give-me-an-error
And now i'll throw a bolt into the gear-Box: What if the very first (topmost) value is negative?
EDIT: The actual algorithm to get what he wants is IMO pretty easy (and i know that i'm ignoring...
I'll not go through the complete code, but two things:
Avoid your Goto Jump/Skip.
If you have to use Goto in a For-Next-Loop then your Algorithm needs to be reworked.
After Your MsgBox "Update...
And where in your code are you setting the limits for the month(s)?
Since when does a TextBox-Control have the AddItem-and Clear-Methods??? *confused*
Dim i As Long
Dim MyArray() As String
Dim MyJoin As String
Dim MySplit() As String
ReDim MyArray(1 To LVW.ColumnHeaders.Count)
He doesn't know, how to make the communication between parent-form and child-form
Parent-Form has a commandbutton, and probably some labels or textboxes.
He hits the command-button, another form...
If i remember correctly, you have to register the OCX from the System32-folder, not the Syswow64 (64-Bit OS?).
I had the same issue with 64-Bit-Windows, and placing it in the System32, registering...
OK, so i'll throw in another solution, that worked for me:
The reason why that OCX stopped working for me, was, that a windows update disabled that control in the registry.
is that just a typing error?
in your MkDir you have "Taget" as foldername (an "r" missing?)
you're using xls as the file-extension which implies Excel2003 or older.
if i remember...
Every reference i found had the imagelist-component, so no idea if it's possible
As far as i know not possible in Office/VBA, since the only way to change the backcolor of a listview in VB is with a picture-box, and you don't have picturebox in VBA
EDIT: Of course, you could...
Just a thought: The PDF and the real printer use the same paper-"size"?
e.g. PDF is set to A4, while the real printer is set to letter
Why not just put the Listitems into an array, and then use the Join-Function?
No need to wrack your brain, why there is a leading or trailing comma.....
Then the only explanation i'd have is, that the "real" printer displaces the position due to border-issues (which logically a PDF-Printer shouldn't have)
since CurrentX and CurrentY are logical...
let's do it this way:
Debug your code and read all values before printing.
CurrentX, CurrentY, Printer.ScaleWidth etc. and everything else.
Read them for your PDF-Printer, and then read...
Every reference i found had to do with the SetTextAlign-Function
Not sure about this one:
'Step 1 and 2
argste(pste_indx + 1).pcmFirst = argste(pste_indx + 1).pcmFirst - 1
Since a pointer is a 32-bit integer (a Long) i would have expected
Look at my attachment.
Enter something in a cell in Column "F" and follow the code
As for your bulk insert: i don't see any need to write it out into a file.
The question remains: Do you want to build/concatenate your SQL-String (fixed part and variable part) on the fly through...
Did you delete your declaration at the head of the worksheet?
The Declaration of MyRow should be only once within the whole workbook
EDIT: I've attached a very small sample for you, taking your...
Agree with Sam. Your input-file leaves a lot to be desired.
Do you have any influence on how this input-file is created?
If you have, then maybe getting it in INI-Format would make your life a lot...
Such posts always baffle me, in that the OP basically answers his own problem without noticing it.
Even if a Select Case is too tall an order, this at least should give him a clue:
And there is your Problem:
Your Variable "Myrow" is Public from the Worksheet-Object, meaning:
It works like a property of the Worksheet (Sheet10 in your case)
You either have to address it in...
And you've entered something in a cell in Column 6 (meaning: you've triggered the Change-Event)?
Why don't you just put a breakpoint inside the event, then you can see, if/when it's triggered
to get you started.....
Private Type UDTPerson
FirstName As String * 20
LastName As String * 20
Birthday As Date
MsgBox DateDiff("h", format(rs0.Fields("gtime"), "hh:mm:ss"), ServerTime)
Just to understand you correctly:
You have an Excel-File with two rows (!)
First row being the "Header" (containing the fabrics across columns), and the second row with the seasons (s/s - f/w)
Excel2003 can only handle some 65k of rows per sheet, so like vbfbryce said: does the imported sheet has more than 65k of rows
EDIT: i forgot:
you have to rename each imported sheet after...
If you name this specific sheet in each workbook you'd like to import from the same (e.G. "SheetToImport") you can use this String/Name to directly pick the sheet from the Sheets-Collection
Has anyone understood what he wants?
How about you use real words/sentences (and not that gibberish), to show us what the problem is
Don't forget that VBA in Office doesn't support Control-Arrays.
Even if he says "his VB6-Program", nowadays you never know if it's Visual Studio or if it's VBA/Office he uses
Click Here to Expand Forum to Full Width
Survey posted by VBForums.