Recent content by mrussell71

I am trying to transform an XML file to another new XML file that will allow me to import the new file into Access. Access will not import 'attribute-centric' XML files so the new file will have to be 'element-centric'. I have the VBA code to perform the import and it works properly. What I...

Thanks Ken, I did try running those queries as SELECT and they also gave me different results. They did not give me the same number of records as the DELETE query which I found odd. A SELECT query for the first example above returns 16607 records while the DELETE returns 15604 records. The...

I am receiving unexpected results from a Delete Query that uses two nonrelated tables. The first table is the base table that I want to remove the records from and the second is a list of all of the records that should be removed. The fields in each table are: appID, 7 digit number catID, 4...

How do I find which records are duplicated in an Access table? I have been removing duplicate records from tables by creating a copy of the original table (structure only) then set each field in the nonduplicate table as a primary key. I create an Append query using the original table and...

I have been unable to find any articles on how to create a fixed width text file from an MS Access DB using VB.Net. I have an application which runs stored procedures to delete records based upon pre-determined criteria, it then compacts the DB, and finally I need it to create fixed-width text...

I am using stored procedures to update an Access database. The majority of these procedures are DELETE queries and these run flawlessly. However, I am unable to get the right syntax for an UPDATE query. sSQL = "CREATE PROCEDURE procEPCUpdateNGKPOUND " _ & "AS SELECT...

Kevin, How can I tell whether or not the recordset is returning any records? I threw a MsgBox curRST.RecordCount before the Do While curRST.EOF = False line and it is returning a "-1". Not sure what to make of this. Thanks for your help

This code as been giving me trouble for a number of days. I've tried different variations to no avail. What I am trying to accomplish is automate a large number of DELETE queries by creating a recordset for each query's SQL SELECT statement, delete all records from that recordset and then move...

Thanks oldduffer. This works to an extent, however if a record has more than one 'footnote', then this query will not add both of these footnotes to the DESCRIPTION field. ex. If a Part has an value in FN1 and in FN2, it will make two records, the first has DESCRIPTION + FN1 and the second has...

I have two tables, tblPart and tblFootnote, and I need to combine data from both of the tables. tblPart contains data for all parts available on a particular vehicle. Fields for tblPart are: VID, MFG, PART_NUM, PART_DEF, DESCRIPTION, FN1, FN2, FN3, FN4, and FN5 Fields for the...

Thanks Mike that did the trick.

I have two tables tblIndex and tblParts in this database provided by an outside contractor. I needed to delete corresponding records out of both tables. Unfortuneately, the tables are not linked and cannot be linked. To work around this I created a select query using the tblParts as the...

I have two tables tblIndex and tblParts in this database provided by an outside contractor. I needed to delete corresponding records out of both tables. Unfortuneately, the tables are not linked and cannot be linked. To work around this I created a select query using the tblParts as the...

Have you tried using "Like"? Size: IIf([Pricing].[size] Like "A0" Or [Pricing].[size] Like "A1" Or [Pricing].[size]Like "A2",100,0)

Never Mind, I figured it out. part_def: Left([DESCRIPTION],InStr([DESCRIPTION],"]")) and then, TempDesc: Right([DESCRIPTION],Len([DESCRIPTION])-InStr([DESCRIPTION],"]"))