Search:

Good question. As I see it, it is a function of the number of people still using Classic. Most large IT departments go with the flow, that way they have an out and the ability to blame Microsoft...

Funky:

This is what I get using format:



Private Sub Form_Load()

Dim x As Double

Got the point of Format now.
Had given thought of using a string but rejected it in favor of comparing using DateDiff.



If (DateDiff(strDateInterval, dtmDate, dtmDateToCheck) < 0) Then
...

FunkyDexter:

Re: Design Issue: Program works great since 1994 -- other than an infrequent problem that is uncovered (this post case in point).



GOOD CATCH. Have remmed this line under...

Here is the "Seek" code --- very straightforward.



With rsTemp

'--------------------
'Save it
'--------------------
'See if Record Exists in DB

techgnome:



Not in the least. Always appreciate your $0.02. Thought we were having a discussion. I didn't take it personal, hope you didn't.

///////////////////
FunkyDexter:

As I...

techgnome:

Article for me pointed out three things:

1) Nothing wrong using Date as PK (this is what I got from jmcilhinney post -- my read between the lines)
2) May be faster
3) Disk...

techgnome:

Point taken regarding NOT UNIQUE ENOUGH. Maybe by truncating and adding back the seconds as "00" might resolve it. Thought I was doing it but will double check code.


You...

jmcihinney:

Even if I go with an AutoNumber field as the PrimaryKey, I'm going to end up with duplicate records (as far as date is concerned) .

I guess I could seek to see if a record with...

I find that once in awhile (several days to month can go by) that I end up with a duplicate record.
The PrimaryKey is DATETIME in Access. What appears to be happening is
that when Access...

Bump: Looking for more input.

martinc65:

Thanks for responding.

For sake of argument, say the Java program which is run (by me) to start the Gateway program and link to the server contains (which I'm sure it does) a library...

If wrong forum please move

I have a Gateway program (written in Java by some company) which allows me to login to a business sever(not mine nor in anyway controlled by me).
Once logged in I...

Update:

For those with "Loop Exit" concerns, you might want to check out
API-Guide "Wait Message" example.
Only thing that appears to work in VB's single thread environment without
resorting...

Stumbled across this article and thought would be of interest.
Don't have NET installed so can't try it unless component can be loaded without NET.
For those that have NET loaded here is the link:...

Thanks both for input:

Niya: Yes it is TCP/IP and remote with another firm.

Max187Boucher:

Yes, you are correct -- the final record is tagged with "fin".
Your first example (loop)...

Good Question:

I all know is they're running Java and provide an API to access it.

I'm getting data from a Server over which I have no control.
Sometimes it does not respond and the code I'm using causes the App to freeze.
Only thing I can think of maybe setting a timer in my...

Thanks Bonnie West -- easy solution.

I have a combobox as part of a toolbar where I select a text background highlight color.
Once the combobox receives focus, the RTB (richtextbox) loses the
selected text highlight (text is there...

dilettante: Thanks for the input; I found this link most informative >> http://msdn.microsoft.com/en-us/library/ee730343.aspx

Bobbles:

You probably then remember the old keypunches(w/o the...

OK, Pile On Guys!!!!!!!!



Thanks for the link



Yes, well aware of it.

Finally found a very old diagram which helps define Visual Basic and Access relationship to DAO.
This confirms "dileantte's" post.

So the *.mdb database is independent of Access and
any...

Finally got the generic to work (After 24 hrs of *&^% effort)!!!!

The format is:

INSERT INTO TableTo SELECT * FROM TableFrom IN 'dbPathFrom';

Not sure where SQL Server was mentioned in this discussion -- not by me or dac999 as I read the posts.
I did refer to "Microsoft SQL" which is Microsoft's version of SQL and its usage in DAO.
From...

dac999:

Just tried the "old school" method of:
1) Declaring a Recordset in each DB
2) Using ".AddNew" with each field name to move field values between each DB
3) Worked Great !!!!!!!

So...

dac99:
Thanks for response. Will try your "old School" suggestion.
If that works (feedback later this PM on this) then SQL should *(%$# well work!!

Thanks for feedback.
Guess I know my options.

DataMiser

Not trying to be argumentative, and I understand your point, but so is VB Classic, VB ADO, as well as a lot of other languages (ALGOL, PL1, etc. to name a couple).
If you have a large...

Thanks for input.

Logically (if I can rely on my logic??)

It makes since that if the OS on my machine defines *.mdb as being used by an Access database that somewhere there is information...

I'm trying to create multiple instances to MSAccess.
In doing so it raised the above question of "How Does VB Know I Want to Use MSAccess?".

--------------------------
I currently use Access...

Any suggestions to get this to work greatly appreciated:

Geting Error #3024, Can't find the Db2 Database and gives me the default Visual Studio directory instead of the directory where the *.mdb...

Doesn't just copying files raise issues of:
1) Overwriting files if same name on multiple disks.
2) Inability to install the software as a file copy would loose OS key files

I have heard you...

Like most I have lot of old software that came on 5 1/4, 3 1/2 floppy, etc.
I'd like to put it all on CD and wondering the best approach.
Though I would convert each disk into an ISO image, then...

This is how I handle them:
(TChart and TTemp are the same and both UDT's)




Public Function FreeTChartMemory() As Integer
'Free the Unneeded Memory Used by the TChart Structure
'NOTE:...

See: http://comsci.liu.edu/~murali/win32/SharedMemory.htm

Forgot to thank techgnome. Thank you techgnome.

si_the-geek: Code was just a quick example. Give user ALL options to save workbook. Thanks for the input and heads-up.

Thanks for responses to date:

techgnome:



As you aptly point out it appears when user is closing Excel directly, the ActiveWorkbook is closed (by Excel I assume) and consequently the...

Is there a solution to this when executing a program from VB (Excel for example) then closing Excel directly INSTEAD of closing the VB App which will close Excel.

For example:

1) Excel started...

deleted