Search:
Type: Posts; User: marktheman
Search:
Search took 0.03 seconds.
-
Cheers, Thanks Hack. Just wondering is ASP.net part of Visual Studio 2005 or is it a seperate product? Does Visual Studio 2005 offer an XML/XSL option? Say for a database project, could one use ASP...
-
Hi,
My department have a licence for visual studio 2005 professional. I currently only use VB6. What features in it are good for developing web-sites with visual basic included. I know there wasn't...
-
Hi,
Anyone know what's the best facilities in Vb6 for developing web applications?
Thanks.
-
Hi,
Try this idea.
http://vbcity.com/forums/topic.asp?tid=13208
Thanks.
-
Hi mate,
Thanks for your help in a lot of questions I have posted! Hope this can help;
http://www.dbforums.com/archive/index.php/t-939814.html
Cheers.
-
-
Hi,
God your code looks fine. Did you try to trap an error. Any result?
-
Hi,
Use the "Microsoft Excel Object Library" in references.
Create a form and use the library like this
'create excel application
Dim oXLApp As Excel.Application
'create excel workbook
...
-
Good. If you're happy with solution, mark thread as resolved.
-
Hi mate,
I see what you're trying to do, but read the following article; The version of access you are using might not be compatible with the command....
-
Hi,
Don't know. "LTProf" is another option and the licencing for that is tiny so that would be a better solution than building your own.
Cheers
-
Try the Goto Label: statement to continue from where you wanted to previously.
"Rows("94:94").EntireRow.Hidden = False"
'put the Goto Label
or
'Exit Sub
I meant after each condition in the if...
-
Yes mate,
You have 2 options. You can use the "Microsoft ActiveX Data Objects Library" and treat the sheet as a database or alternatively use the "Microsoft Excel Object Library" and insert/delete...
-
Why not just place an Exit Sub after each of the if statements? Therefore this stops the looping. I don't see any procedure to loop, therefore this should work.
Thanks.
-
Yes,
There is 2, I know of "VB Watch 2" and "VBA Code Profiler System (VBACP)", but unfortunately they're not free, just trials and require a licence after this. If anyone knows any freeware...
-
I used the Microsoft Word Object Library for this and it did a terrific job. Need any code snippets, let me know.
-
Hi mate,
I think what could be happening is that 2 stop bits might be sent out. Therefore the second stop bit would be factored into the delay resulting in the 3ms delay. No idea how to test for...
-
Cheers. Please mark thread as resolved if your query is satisfied.
Thanks,
-
Hi mate,
Did a quick scan for this on google, is there some sort of a connection being opened that is causing this 3ms delay for each byte. If this is the case, is it possible to open the...
-
Hi,
Ya, you're obviously using access's default behaviour. Try this guy's idea.
http://www.databasedev.co.uk/disable_mousewheel.html
Hopefully that should work.
Thanks.
-
Hi,
There's a product called webDav, which is open source, which apparently copies excel workbooks to user machines and allows them to perform multiple updates seperately. Not too such how it works...
-
Hi,
Yes. You can automate all this using access 2003 and vb within access.
Here is a listing of tutorials to get you started.
http://inpics.net/access2003.html...
-
Hi,
Can you not go to references, browse and select the new dll(ocx) and double click it? You can then select it and dereference the other word reference.
Hope this helps.
-
Hi,
Not too sure what format you have times but something like this should work
'assume european stadard dates
Public dateEntered1 As String
Public compareDate As String
Public TimeString As...
-
Hi,
You should have a control in your Tools->references called "Microsoft Internet Transfer Control 6.0". Enable this and then select your toolbox on your form. Select Additional controls and then...
-
Hi,
I know how to do this and can help you but I think you need some VB basics first:
http://www.vbtutor.net/vbtutor.html
And then learn how to link to spreadsheets using ado:...
-
Yes mate,
Use VBA from Excel
(1) Firstly create a template word document with bookmarks. (New template is as attached.)
(2) Next use VBA to connect to excel spreadsheet to read data using ado....
-
Hi,
Got a work around for this. Discovered if the maximum value that I'm graphing against in the spreadsheet is less than 10, then the graph would display strange values for the y axis. Therefore...
-
Hi,
I have an issue with generating charts. When I try and generate a chart with a large range of data there isn't a problem. But When I try with a small subset of data, the axes don't emerge with...
-
Hi,
I don't know what version of Access you are using, but you can always use the built-in "jet" driver to connect excel and access, therefore eliminating the need for installing ODBC drivers on...
-
I have a good one for VB6 but it is very similiar to VBA. It's called the "Visual Basic 6, Black Book" by Steven Holzner and is excellent. You can also go into safari books, get 30 day trial and...
-
Hi,
I've tried 2 different methods to maximise forms using API calls and the "GetSystemMetrics" method to set the forms height and width. I tested the forms on screens of different resolution but...
-
Hi,
The problem seems to be when I shut my connection to the database before I exit the form. Why would their be a problem with this? Any help would be appreciated as I'm clueless!
Thanks.
-
Hi,
I have tried the first idea on this, the modeless option, and it does work well when I initiate the first form. I am using a flexgrid on this form, when I click on the flexgrid, I enter another...
-
Hi,
Cheers. Thanks everyone for their contribution and the interest. Yes I think that "vbmodeless" is the ShowModal property of a form, isn't it? I tried this, and the mimimise and maximise...
-
Cheers,
Actually knew those 2 methods but spent ages trying to get the first one working. Did something with the second one in the end. Wondering is it possible to shut the workbook window behind...
-
Hi,
God, could someone please, please help me with this! Is there api calls I can make to minimise workbook/application?
-
Hi,
I actually have that placed on a userform. I have the code functions declared locally within the form. Will this work? If not, is there a way I can place min/max buttons next to close button on...
-
Hi,
I have created 2 buttons on a form for minimising and maximising application. But I can't get these to work. When I click the minimise button, nothing happens! Why
Code:
Private Sub...
-
Wow! Cheers, mate! Must learn about those VB dlls and what they do. Thanks once again and hope I can return the favour in the future.
Cheers.
|
Click Here to Expand Forum to Full Width
|