Search:
Type: Posts; User: martin_hop
Search:
Search took 0.01 seconds.
-
So long story short i trained in VB6 back in 99/00 but my career to date has taken me along the line of a contracts manager and draughtsman in the architectural field for the last 17 years. I've...
-
Ok all sorted having just reviewed the new user added to the computer it turns out they had changed their windows login password which then didn't match their server credentials which meant the...
-
Unfortunately like i said most of the code was written before my time so cannot give answers to all the queries. Just a case of if it wasn't broken don't mess with it. I certainly would have coded...
-
I have an issue where a users computer has started giving a "Bad file name (Error 52)" message when trying to execute VB6 code to create a spreadsheets and save it to the C:\. What is confusing me...
-
Thanks, this was exactly what i needed to point me in the right dimension. I am pulling the data so each range within the text string will become a separate row within the spreadsheet being produced.
-
So i'm sure this is a simple one but i am having a brain fart. What would be the best way to take a range of numbers stored in a string (e.g 1-10) and convert that in code so the output is 1, 2, 3,...
-
Ok so was bugging me and knew i wouldn't sleep until solved. Currently i have the following code i'm going to implement initially to populate the array that i can pass to my excel routine. I'm sure...
-
It is meant to be vb6 but i pinched the basis of this code above offline so may have accidentally pulled VBA code.
-
Sorry for late reply got called away. You have it spot on, been thinking whilst in gym (how sad but i find walking away helps at times) a array will do the job. (As you say creating the excel...
-
Hi All,
I have a routine that creates a spreadsheet, currently this spreadsheet creates three tabs (Header, Summary, Schedule) based off a single quote. What i want to do is create multiple...
-
Thanks for the info i will have a play over the next few days when i can get back onto the project and try to implement some of your suggestions
-
Hi All,
I'm setting up a new spreadsheet in our program here. I'm following exactly the same method i have done previously but getting weird behaviour. Basically i create a new spreadsheet from...
-
Thanks for the explanation. I will try to implement over the next week when i can get back on the project and post my findings.
-
Have never tried implementing a dump-file. Would happily try if someone could explain where to start (how to implement into code). The logging isn't working as the crash must be happing outside the...
-
Ok so i've added a routine to log errors as below
Public Sub WriteToLog(dDate As Date, sProcedure As String, sErrorNum As String, sError As String)
Dim sPath As String, lBytes As Long
...
-
Thanks for the replies i will investigate further. Although i think by accident i may have stubbled across the issue. The program uses MAPI to generate various emails and by pure accident I've...
-
Forgot to mention this crash only seems to happen afer a user has had the program running for awhile. If a user logs on and performs one two actions then exits the crash doesn't happen.
-
Hi
I've noted recently we have started to receive the follow crash when exiting our program. This is happening on all computers. The program functions fine until exit. Has anyone come across...
-
Hi Chris,
Worked like a dream as far as i can tell. It picked up at least a dozen open recordsets on exit. I'd rather close them after use but this snippet of code will hopefully elevated...
-
Hi,
I'm working on developing a program which has been passed onto me which has one database connection but hundreds of recorsets. The majority of the recordsets have been created globally. I've...
-
Found this little rountine that does the job perfectly.
https://stackoverflow.com/questions/9373082/detect-whether-excel-workbook-is-already-open
-
I've got hopefully a simple one here. I've got a excel sheet that is created automatically at code level and then saves to the users local C drive without prompts (see code below). The spreadsheet...
-
Had a chance to get back on this today and using the outlook automation had the exact tools i needed to generate the email in html to create a table in the body of the email.
-
Think i'm good for only programming for Outlook in this instance as worked for this company for over 15 years and they will not use anything else although i will have a look at CDO though as i always...
-
I did some further research after posting and i think using MAPI as has been used is not the way to go. I as you rightly say need HTML in the email which MAPI does not support directly. I will have...
-
Hi,
I am creating a automated email from my VB6 program. This is my first attempt at this. I am using the MAPI to create the email as i have taken over a project where emails are created using...
-
Adding a with block did indeed seem to shave a few more seconds off the routine. With all the calcs and formatting a 500 line packing sheet is taking approx. 7 seconds to complete which i believe...
-
Thanks for the advise i have changed this and it seems to have made a difference. I was struggling with long run times to create the spreadsheet especially on the larger jobs. This has knocked a...
-
I don't think it's creating a second copy. I can follow the process in task manager and 9 times out of 10 it creates a background process of Excel and once the routine is ran the Excel process is...
-
Further to the previous post i forgot to include the code that i've used to speed the routine up namely 'OptimizeCode_Begin' & 'OptimizeCode_End. I've shown these below.
Private Sub...
-
Hi please see full code below, i didn't post it as it's quite a large routine. I will have another look through to make sure i'm not referencing variable and then not destroying them.
Dim...
-
I'm creating a spreadsheet but have a slight issue. The spreadsheet seems to stay in the system memory after it's been create whether excel is open or not and so it cannot be deleted unless you go...
-
Ooops sorry about that i completely missed OP saying he was using ADO.
-
Hi
I use something similar to the below to populate my datagrids. Hope it helps.
Dim qsql As String
Dim rstest as Recordset
-
Probably also a very valid point.
-
The app has been under construction since approx 2004 but the original developer was old school and had only used VB6 and guess he was stuck in his ways and preferred to code using ADO.
-
Hi all thanks for the replies. As many of you have stated it's forward thinking to start migrating over to .net now rather than when falling into the "Obsolescence Trap" as i am aware the migration...
-
Ok so a quick background i have taken over development of a front end system (access database back end) which consists of approx. 75+ forms 500K+ lines of code. Over the last 6 months i have been...
-
Thanks for the reply. It's not the disk size that's the issue (data base is only approx. 400mb) i think it's more the clipboard size when trying the change the field size. On my test data I have...
-
Not really sure if i am posting in the right area. I have a VB frontend program with a access backend. My client has asked me to increase one of the text fields from 50 characters to 65 characters....
|
Click Here to Expand Forum to Full Width
|