Search:
Type: Posts; User: Chief Brad
Search:
Search took 0.02 seconds.
-
Hi Y'all - -
Before anyone asks why in the world I'm still writing lots of VB 6.0 code, I'll make it totally clear, I'M CHEAP, actually I like frugal better. Doesn't sound quite so negative. ...
-
Morning Y'all - -
I'm trying to do something that it seems should be fairly simple, but even after looking through this forum and other sources in depth, I just can't quite find what I'm looking...
-
This appears to be an answer to something I've been trying to do for some time now. While I'm very knowlegeable in much of VB6, I've never used user controls, and I'm at a loss on how to call or use...
-
GaryMazzone's response above does the trick!! I know I tried setting the date to Null in the SQL string before, but I'm betting I was leaving the ## on either side which still caused an error.
...
-
Here's the code snippet and the error that I'm getting. Before you look at the code itself, let me explain one thing, for various reasons now lost to antiquity, when I select a date using the...
-
Well, that might be headed in the right direction, or at least converging on the solution, but not entirely. Setting dtpicker.value=vbnull, either via the dtpicker checkbox or any other method,...
-
I have been working for some time on a large MS Access DB with a VB6 front end, and have come across an issue that I haven't been able to resolve or work around.
My DB has many date fields that I...
-
TO: akhileshb
That's an option that I can try.
Chief Brad
-
Sure, there's no reason that wouldn't work, but I'd always rather do something programmatically rather than hard code it.
Chief Brad
-
I've searched the archives and found several similar questions to this, but nothing that appears to be exactly what I'm looking for.
I'm working on an MS Access database with a VB6 front end. ...
-
BINGO!!
Adding the Scripting library name before the Folder, File, and Files declarations did the trick!!
Thanks Si and Hack for all of your suggestions.
Now on to other things . . . . . ....
-
Sorry, still no luck.
The Add Procedure under the Tools drop down menu defaults to Public, and I'll admit that I'm not very cautious about setting it back to Private when opening a new...
-
Hi Hack - -
Yeah, as I said in my original post, I originally wrote the subroutine in a totally seperate VB6 project, all by itself, just to test the code, and it works fine. But when I pasted...
-
Thanks Si - -
I had looked at that before and everything I read said that the "scripting" library name was optional, BUT I had tried that anyway with no success. I just tried it again as a sanity...
-
Ok friends, I've searched the internet and these archives and am at a real loss on this one.
I'm developing a pretty complex MS Access database with a VB6 front end and one thing that I need to...
-
I have an MS Access database front end written in VB6.0. This front end reads and writes to HKEY_CURRENT_USER\Software\VB and VBA Program Settings in the registry using SaveSetting and GetSetting to...
-
This a very interesting thread to me as I've been scratching my head over something similar for some time, and all I've gotten so far is dandruff under my fingernails!!
I have two maps of the same...
-
Good suggestion, but unfortunately I can't run either error checking or defrag without admin privileges, which the company won't give me. If this happens again I'll call the help desk and see if...
-
An addition to my above post:
Out of the blue, and without doing anything obvious, the error went away and the project has been saved. I am quickly saving a current back-up of the entire project,...
-
For the second time in the past week I'm getting the following error when I try to save my VB6 project:
"Permission Denied: <path>\file.frx"
The first time it happened I looked and looked for a...
-
I am building an MS Access database with a VB6 front end, and one part of this will send an occasional automatically generated email from the VB6 front end to the database admin. I can send email in...
-
-
Thanks. Before my original post I wondered if it might be reserved, but couldn't find anything in the MSDN help files.
Anyway, it's working now, so thanks!!
Chief Brad
-
Thanks, that worked like a champ!!
But why are the brackets required when I don't have to use them with any of my other field names??
Chief Brad
-
Thanks for the good suggestion, but it's already been tried.
I neglected to mention in my original post that the run-time error message that I'm getting is: -2147217900(80040e14) Syntax error in...
-
Good moening y'all - -
This one has me absolutely baffled, and I'm sure I'll feel REALLY stupid when I get it figured out, but so far nothing I've tried has worked.
The following SQL statement...
-
Yeah, that's exactly why I did it that way and I should have made that clear. This leaves the user the option of including appropriate wildcards in the txtCRNumber.text box. The only difference...
-
Thanks for the suggestions and a tip of the hat to both of you. I learned something new here and you'll be glad to know that the following works perfectly:
strSQL1 = "SELECT * FROM...
-
Thanks to both of you for the suggestions. Let me play with that and see what I can work out.
The number field that I'm specifically working with here is an "ID" field and not a numeric that I'll...
-
I'm in the middle of a database development project using MS Access for the back end and VB6 for the front end. I can easily do wildcard queries on database text fields using something like:
...
-
This thread is all good gouge and stuff that I've never known before. Reading more on this under "Tips For ADO Users" at http://msdn.microsoft.com/en-us/library/ms810829.aspx it appears to me that...
-
Thanks for the info. I missed the earlier mention of "connection pooling". Can you give me a very brief description??
-
Thanks for the info. I've seen it done both ways in tutorials, but wasn't sure what the best "real world" method might be. I hadn't thought about the network issue however, and my database will...
-
I've searched through the archives and can't find a previous answer to my question.
I'm developing a database using VB6 for the frontend and MS Access as the backend. I have been opening my ADO...
-
Thanks, and I think this is the direction that I need to go. What the heck, I've got all night to work on it anyway.
I don't have a good reference that shows TabStrip, but I see that I can't...
-
I just played around with TabStrip for a few minutes, and at least it will allow me to insert a new tab between two existing tabs, "C" between "A" and "B" in my previous example. Switching to...
-
As a way of answering your question, let me explain basically what happened. I the earlier stagesof my design, I identifed only two tabs ("A" and "B") as being required, and that's what I used. ...
-
I'm a new member of this forum although I have perused it a bit in the past.
I'm a very experienced VB6 programmer, but have never used ssTab until my current project. Yeah, I know, some...
|
Click Here to Expand Forum to Full Width
|