I.T. Discussion Community!
tc [Unspecified] -Collapse +Expand
-Collapse +Expand
tcronin
-Collapse +Expand Profile◄╣
Member Info
Member Narration

POSTS:
MB Posts (13)

Search tcronin:

Advanced
Personal Account . . .
tc
 (Inactive)
Saint Louis



Real Name:  tc [Unspecified]
Primary Role:  Coder
Joined: May 2001 (18 years ago)
Visits: 16
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Message Boards Activity

13 posts.
More...

Thread 6 of 6
Thread Starter or a Reply (but not last)  Group

tc
Game is over (reality check)
I did support and development for RBASE, then Paradox. When Access 1.0 came out no threat, 2.0 was better and 97 flat out buries Paradox. Sorry folks, being an expert in Paradox is like being a Novell expert, no one cares, the game is over. If you wise up you'll also realize that if you can do VBA the next step is VB and you can be a real programmer.
Posted to MB Topic: Just Conversation « PrestwoodBoards Board
18 years ago

Melody.W
{Too Long!}
36 months ago
Nothing New Since Your Last Visit
3503
Hits

PrestwoodBoards

Thread 5 of 6
Thread Starter or a Reply (but not last)  Group

tc
counts on group level items in Access 2000
I have a report grouped by state,location, and person. Each person may have more than 1 record. How do I count the number of people at a location? If I do a count on the persons id field which is in that group header it still counts their detail records. So if I have 3 records, two belonging to John Smith, and one to Martha Helms inside of a location, I get a count of 3 people, even though there were only 2. Help (I am sure I am missing something easy)
Posted to MB Topic: Access VBA Programming « Access Board
17 years ago

ScottCybak
If you add the expression:, , =count(PersonField), , in the person fields grouping footer, it will relay the proper results despite of the number records in the detail section., , Note that this will only work if your database is normalized properly - if all of these fields belong to one table then you will need to use a query like jd described.
17 years ago
Nothing New Since Your Last Visit
2408
Hits

Microsoft Access

Thread 4 of 6
Thread Starter or a Reply (but not last)  Group

tc
ODBC Error trapping
I have an Access 97 Front End to SQL 2000. On a add record button I am trying to trap the error message for duplicate ID's in a table. I have (I think the correct error number), but I can't get the error message to trap. Any help appreciated., , If Err.Number = 2046 Then, MsgBox "Duplicate Inmate Number", vbInformation, "Data Error", End If, MsgBox Err.Description, Resume Exit_but_addinm_Click
Posted to MB Topic: Access VBA Programming « Access Board
17 years ago
Nothing New Since Your Last Visit
1237
Hits

Microsoft Access

Thread 3 of 6
Thread Starter or a Reply (but not last)  Group

tc
Problems with ODBC data sources and linked tables
I have some Access 97 applications that have linked tables to SQL 2000 using NT authentication. Here in development I will have the linked tables attached using the same DSN to server1, database1. WHen I move the application linked tables to point to server2 database2, using the same DSN that is now pointing to server2, database2. I have to delete and re-add all the tables when I do this, or I am not able to update any of the tables. Is this standard, or is this possibly an issue with using Access 97 with SQL 2000. Thanks
Posted to MB Topic: Access VBA Programming « Access Board
18 years ago

dynamictiger
I am not sure, but in Access 2000 the table link manager will do this task. This maybe available in 97., , HTH, :)
17 years ago
Nothing New Since Your Last Visit
1318
Hits

Microsoft Access

Thread 2 of 6
Thread Starter or a Reply (but not last)  Group

tc
Obtain either NT login or computer name
Depending on a solution from a vendor I will need to extract either the NT login name, or the computer name when starting up a small Access 97/2000 application. I will be passing this item as a parm to SQL 2000 stored proc. Is there a quick way to obtain this?, Thanks
Posted to MB Topic: Access VBA Programming « Access Board
18 years ago

dmichael
{Too Long!}
18 years ago
Nothing New Since Your Last Visit
1407
Hits

Microsoft Access

Thread 1 of 6
Thread Starter or a Reply (but not last)  Group

tc
Re: Game is over (reality check)
Gee, I thought the childishness and nastiness was from the other side(Example, anyone from any consulting firm referring to VB programmers as cowboys, PLEEEASE). Here is a clue folks, what I said is like Dragnet, just the facts. I didn't tell MS to win the PC DB war the buying public made the choice. You give me too much credit.
Posted to MB Topic: Just Conversation « PrestwoodBoards Board
18 years ago
Nothing New Since Your Last Visit
2
Hits

PrestwoodBoards
More...
Follow PrestwoodBoards on: 


©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech