Search results for query: *

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...

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...

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...

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...

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'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...

On a Windows 98, at startup Norton's Anti-Virus (part of System Works 2003) causes the dialup internet connection dialog box to appear. This must be cancelled 4 times. Then bringing NAV up via the System Tray icon prompts it another 2 times. Live update is disabled; is there a part of NAV that...

When you go into Windows Explorer and click the + to expand a folder, if that folder has more sub-folders than will fit on the screen vertically, the folder that you expand shifts to the top of the screen (I guess so you can see as many sub-folders as possible). Is there any way to stop this...

Is there a way using VBA to check if a table has any records at all locked/being viewed or edited?

Event Viewer only has events that occured about a month ago (at least on the Windows XP installation I am talking about). Is there a way to view events older than that?? Would they happen to be archived?

I have a query with the criteria for one field being In (Form.TextBox) where the value of the textbox is a comma delimited row of numbers. However, while the query will return rows when a single number is in the textbox, it won't return any if there are multiple numbers. Am I missing something...

I've searched around on the Internet for this and found bits and pieces, but so far nothing has fixed the problem. With a previous version of Windows Media Player, CDs would burn just fine. Once WMP9 was installed, it returns with the error "device not detected" when trying to burn a...

When you have a drop-down box on a form you can set a default value out of all the values in the list. Is there a way where you can link to the file with that form, passing some sort of parameters after the file name, and have the drop-down list default to one of the parameters?

When creating an e-mail message from VB, is it possible to over-ride the HTML/Text/RTF default format settings for messages using a line of code (perhaps a propery or method)? Here's my basic current code: Dim olApp As Outlook.Application Set olApp =...

On a PC with Office XP, it isn't possible to mail as attachment a document from in Word itself. I am assuming this may be a security setting of some sort, but can't find what setting (of course, it might be something else). Unchecking "Mail as Attachment" in Options sets it to Mail as...

Is there a way to edit Access system tables? I've set the Owner of MSysRelationships to Admin (it's normally Engine) and all the permissions to allow, but I still can't edit it.

Let's say I have three tables as below (this gives the basic idea of my problem; the actual tables and data are bigger and more complex): Customers --------- CustomerID (PK) CustomerName StateID (FK to States.StateID) AgeID (FK to Ages.AgeID) States ------ StateID (PK) StateName Ages ----...

What's a decent book/set of books (with CDs) for users to learn Word and Excel? Preferrably the CD will have multimedia/interactive training on it (rather than just a copy of the book).

I'm developing a function that takes a given date, adds 7 days to it, then checks what the resulting day is; if it is a Sat, Sun, or Public Holiday, then it adds one, and checks again. It'll keep checking until the result is a Mon to Fri that isn't a Public Holiday. The Sat/Sun check is easy...