Search:
Type: Posts; User: DataMiser
Search:
Search took 0.25 seconds; generated 53 minute(s) ago.
-
I got it, just had to remove the first select from and the ( ) that surrounded the other selects. Seems to be working now.
Thanks for the assistance.
Working query looks like
Select...
-
hmm once I got into the code I see that it is actually dealing with two join queries so I am not sure if the union all still works or what I would need to do to make it work. I tried coding it as...
-
Well, unfortunately it is a foxpro DBF and it is being accessed from Excel so that throws a wrinkle into it.
WHat I have right now are two completely separate queries the history is query first...
-
I have two identical tables one is current and the other is history.
I need to select fields from both tables and need to sort them by date.
Initially I used two queries assuming that the...
-
If you have AMD graphics on it you may want to reconsider.
I recently build two new systems and put Windows 11 on both of them everything seemed fine at first but started having major display...
-
I am a little reluctant to change versions of VS mid project. Sometimes that does not go well. VS2017 was working fine until the update.
I am setting up a new machine and will put the newer version...
-
Hi guys, wondering if anyone has ran into and solved this issue yet.
There was a recent update for windows 10 that is causing an issue with VS2017 possibly other versions.
Once the update has...
-
D: is not valid you need either D:\ or D:\FolderName ......
Can't remember off the top of my head if the destination filename is also required quite possibly may be.
-
Not sure what you did or where the error came up. There is no subscript in the line I posted.
-
Dim i As Long
For i = LBound(chunkContent) To UBound(chunkContent)
MSComm1.Output = Chr(chunkContent(i))
Next i
Get rid of that part.
Send the whole chunk instead
...
-
You are converting it to text and send one byte at a time. You need to be sending the entire chunk as binary. This will increase the speed dramatically.
Yes serial communications is slow by todays...
-
I don't know, haven't really looked at it but also have not had much going on with VB6 or even VB.Net over the last few years pretty much everything I have did has been coded in either C#, JS or B4A....
-
https://www.grapecity.com/forums/ar2/latest-version-of-active-reports-for-visual-basic-6-0#:~:text=The%20latest%20version%20for%20use%20with%20VB%206,a%20supported%20design%20environment%20for%20Activ...
-
IMO Active Reports is as good as it gets. I've been using it since VB5 and would not want to use anything else.
-
Looks like I have it, I added the id to the th part as well and it looks to be only affecting the table desired.
$('#ITCase td:nth-child(3),#ITCase th:nth-child(3)').hide();
-
I have also tried
$('#ITCase td:nth-child(3),th:nth-child(3)').hide();
Where ITCase is the id of the table in question.
This also correctly hides the column in the ITCase table but also hides...
-
I have a page that has multiple tables on it. I need to be able to dynamically hide/show one of two columns on one table and need to show or hide 3 of 6 columns in another table and I need to do this...
-
What result are you getting?
What result do you expect it should give?
-
What message do you get when it crashes?
Are you doing any sub classing in the project?
Using any custom or 3rd party controls, dlls?
-
In the 80s? That would be quite a feat given that VB6 was released in 1998 ;)
VB3 was not yet around in the 80s
-
First thought is a memory leak, something being loaded and not properly unloaded causing the program to eventually crash for lack of memory. I would have a look at the memory used by the program over...
-
Really? I did not know that. I have a habit of installing and using Power ISO so never bothered to check.
-
I think Wend predates all of those End Whatever statements. Can't remember if Select Case goes back that far but none of those others existed in early forms of basic while wend did but once the Do...
-
Looks like they are ISO files.
You can mount them with a program like PowerISO and have them behave as a virtual CD or you can burn them directly to CD and use them that way.
-
I think the last time I used a While Wend in BASIC code may have been in GWBasic, possibly VB3 or VBDos. As of VB5 I never even consider using them in VB code. I have used the While loop in other...
-
Well, I would have to say that no you did not try that because the code posted in post#2 works exactly as expected.
Output is as follows
Line1
Line3
Line5
Whatever you are doing you have a...
-
For the most part no it should not lead to problems with over writing, provided of course that the source files are all in that folder tree and you are not linking to source files in some other...
-
You can use the timer but what you need to do is just have the code in the timer that unloads the form and then in your routine that prints the form at the end of that code start the timer that way...
-
LOL
Yep, I was very surprised but had to try it and see, went through and looked at the data and everything looks good,
Thanks again.
-
Thanks for that info on RecNo()
Turns out to be simple after all
Update TableName Set RowNO=RecNO()
Worked like a charm
-
The DB is FoxPro I think version 8, though I am trying to execute the query through code from within my program.
I tried looping through and updating with a simple VB6 piece and it failed after...
-
I find myself needing to update a rather large table with a new field.
What I need is for this new field to hold basically a row number. There are already a lot of records in the table and the...
-
I've did quite a bit with dbfs and sqlserver no problems there either.
-
cursor location.
When using client you should get an accurate recordcount
When using server you will not get an accurate recordcount.
-
Well you have not gave a clear description of what you are really trying to do. The code you showed does not give much of a clue as to what you want your end result to be and clearly you have not...
-
So your items are not in a list? That code just tries to write the same text multiple times to the same location in the file which is apparently a bad location. ListIndex is most likely = -1 when...
-
You only have one spot in the code that does a write and that spot writes only 1 record.
If the intent is to write everything from the list then you need to loop through the list and write each...
-
That is kind of what I was thinking, I did create a new clean Windows 7 VM this morning and could put the VS2008 on there I suppose, That may be the best option anyway as I am unlikely to need it...
-
I have a customer that wants some changes to an old project. The project is for a Windows Mobile Device and was done with VB 2008. The issue I have is that my current system does not have VB 2008...
-
So at least that is one thing I don't have to worry about now. I rarely ever have a need to boot up XP but I did have a request from an older customer last week wanting some upgrades to an old piece...
|
Click Here to Expand Forum to Full Width
|