Search results for query: *

I'm not sure how to accomplish the following, so any help is much appreciated: I have a table in MS Access that holds information about orders. What I want to do is loop through each record in the orders table, reading the value for the Quantity field. Then I'd like to add the current row of...

I apologize if this is the wrong forum for my question. In any case, I just downloaded SQL Server 2005 Express and I have an issue with a CSV import. I established a "Linked Server" to a directory where my csv files are. I then issue Insert statements using the csv files in the "from" syntax...

Just a quick question. If I develop an app (VB.Net) that uses an MDB to hold data, does the target machine have to have MS Access installed? Randy [afro]

Development Platform: Visual Basic 6 If someone knows of a FAQ that will answer my question, please post it. I didn't find one elaborate enough to do so. Okay, here's what's happening. User types in a PO Number into a field, and on the Lost Focus event, a function in the form attempts to...

The task: I want to read in an XML file that contains instructions to format a label. No problem here, but where I'm stuck is making the XML file dynamic. If I have 10 labels to print, each with a different recipient, how do I structure the XML to know that the 'varRecipient' value in my VB...

I have two forms that I need to communicate between. The first form (Form A) will take several entries into a listbox. After each entry into the listbox, I need to raise an event that will tell Form B how many entries have been added currently. Here's what I have so far (it doesn't work)...

I have the following element in the original XML file: <AddressLine1>1000 MANSELL ROAD</AddressLine1> I am using an xslt to place the value of the element above using: <xsl:element name="DestinationAddressLine1"> <xsl:value-of select="//Shipment/ShipTo/Address/AddressLine1"/>...

To all: If there's an article on this already, please post the link. Okay, here's what I want to accomplish: Convert this XML structure: <employee> <empid>123456</empid> <firstname>Jon</firstname> <lastname>Doe</lastname> </employee> <employee> <firstname>Harry</firstname>...

To all: From what I've seen, there's very little descriptive (i.e. helpful) documentation on the MapPoint Object Model and I'm stuck right now. I have successfully created links to an Excel sheet(s) and created a DataMap and DataSet. However, if I try to link to an Access DB table, I get the...

Can someone check my logic here? I have two tables and they are as follows: Table: Factors ------------------------- Factor_RID (PK) ============= Factor_Name + ------------------------- + + Table: Elements +...

Here's what I'm trying to accomplish: I have a query with two columns. The first column can be one of three types (Year, Quarter, Month) and the second column holds the number of business days according to the time period in column one. We are using a program called Siebel Analytics that...

I need some guidance on selecting all text in an IE window, copying it to the clipboard and then pasting it to notepad. This should all be done from a class residing in a seperate VB program. For the life of me, I can't seem to figure it out. I can use SendKeys easily, but that's too...

In short, I have an Access module that opens an IE window, sets some parameters which at some point opens another IE window. This all works fine for me until this stage. In the new IE window, I want to be able to 'Select All', 'Copy' and 'Paste' into Notepad. For now, I need help with the...

For the life of me, I can't figure out why the code below does not work any more. It was fine about a month ago. I haven't made any changes to MS Office nor have I changed my MDAC from the time when the code worked. Option Compare Database Public oIE As SHDocVw.InternetExplorer Public oHTML...

To all, I have several queries built in A2K that can take different values for Time. I did this so that a user could choose to view reports in the following 3 categories: Current Week Month to Date Year to Date I obviously don't want to have 3 sets of the same queries. Rather, I would like...

Here's the scenario: I have a bookstore that sells various items. I've broken the types out into 5 groups: 01) Books 02) Stationary 03) Apparel 04) Media 05) Trinkets I have a pretty good handle on how to deal with adding a new type of apparel to my inventory. What I can't...

Is it possible to create your own 'multi-level' properties using VBA? For example, I want to have something like: oClass.Title.First_Level = "My First Title Line" oClass.Title.Second_Level = "My Second Title Line" I am making an Excel Export class for use mainly in MS Access. Regards, Randy

Over the last two days, we have had 5 databases 'grey out' and get labeled as 'suspect'. The MDF files for some are on one physical disk and the others are on another disk. So, I can't assume that we are having hardware problems. All other applications are running fine. One other note, the...

Has anyone attempted to create a function that will show how closely two strings match? In particular, if sWord1 = &quot;Drs Vision Center&quot; and sWord2 = &quot;Doctors Vision Center&quot;, I want to be able to say that the two strings match, although not 100%. They differ because of the...

Since the search function is not working on this site, I apologize if I am asking a question that has already been answered. Any way, here's my problem. I set up a linked server on SQL Server 7 to an Oracle db. When I expand the linked server to see the tables, everything is there. However...