Recent content by Kraeg

I've got a DTS package that transfers data from an on-line mySQL database to a local SQL Server 2000 database. One mySQL DB field (of collation Latin1-Bin) doesn't get transferred correctly (I've tried a few SQL Server 2000 column collations). Both fields are varchar(255). Example: mySQL: W14...

If I had any choice I wouldn't be working in Access 97 (or any other version of Access, except maybe as a backend). It does handle collections though (I've contemplated resorting to writing each line to a temporary table then exporting it, but I'd rather avoid that).

In Access (97; that's what I'm stuck working in in regards to this) I've got a Class Module defining an output file class. Properties include path of output file and its name. To write to the output file I call the Output method of the class, which accepts a bunch of values, then writes them to...

In Visual Basic 2005 I have some classes that hold various items (such as person ID and e-mail). These are data sources for combo/list boxes, and sometimes saved to a csv file. I use "for each... next" to go through each class item to save it all, but am wondering if there's any way to, say...

But it works if the mdb is created on another machine (Win 98, whereas this machine is W2k, both Access 97). It also doesn't shorten the name for other network shares. At first I thought it was a LFN to 8.3, but if that was the case shouldn't it truncate it to six characters, tilde and a number?

Requirements have changed a bit since I posted this, and I'm meeting with the users to discuss how to handle individual and organisation memberships (I'll also be a user of the system, but they've all used the current flat file system longer than I have so know more). But basically, all...

In MS Access 97 I'm using the CurrentDb.Name property (in a Visual Basic for Applications module) that gets the database path and filename. When it displays this path it shows as this (G is a network share): G:\F0CWXX~T\G2VNK4~T\IO228C~A when the path is this...

There won't always be an MBS record for the IND and ORG records, so supertype/subtype isn't going to really do it. I can now see why I wouldn't need the extra field for option 1; because I'd check whether IND_id or ORG_id is null to determine the Membership type (assuming the other field didn't...

I'm seeking input/advice on a design issue. I have a DB I'm designing that has an Individual (IND) entity, Organisation (ORG) entity, and a Membership (MBS) entity. Each IND can have none or one MBS, the same with ORG. Each MBS has one of either IND or ORG (ie; one or the other, but it must...

The Aussie Post web site has info about Aussie post codes, as well as a downloadable post code data file: http://www1.auspost.com.au/postcodes/

Thanks, Patrick. It's Access97 and appears to only have the RecordSetClone property for the form (I see 2003 has a RecordSet property). But it allows me to do what I need.

I have an Access (97) frontend that retrieves data from a SQL Server 2000 database using a pass-through query. Once the data is showing in the form (continuous), I need to save it in a comma delimited text file. Is there a command or other way to do this? I've been unable to find one.

I've got it working Rob, but thanks.

Many thanks John..... I've got it working thanks to your advice.

I'm trying to create a Trigger that will execute when a row in a certain table is deleted. It will ever only be one row at a time, and I need the trigger to determine which row it is (by its primary key). So I am thinking an INSTEAD OF trigger that will grab the PK value, perform the trigger...