Search results for query: *

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],"]"))

I have a text field (Description) that I want to split into two different fields (Part_Def) and (Footnote). The Description field has a text string at the beginning, i.e. "[part definition]". After the closing bracket there is another string that I want to parse out into a separate...

I'm at the end of my rope on this problem. I have a form that allows a user to select a manufacturer from a combo box [mfg] and then select what type of records to view/send, corrected or uncorrected, via checkboxes. I have queries that are run based upon the checkbox selections above, which...

I'm still having difficulty with this issue. With the following code changes I am getting this error message, "Too few parameters. Expected 2". This error is getting thrown at the "Set rst = db.OpenRecordset(SQL)" line. I've been unable to find any help at the knowledge...

I have a form from which I want to create an XLS report and send the report to an email contained within the .xls report. The action that I would like to happen "on click" is: 1. Run a query based upon a combo box selection and based upon a selecton of check boxes on the form. [mfg]...

I am running into a problem with null values within combo boxes which are dependent on other ones for their values. Each box is based on one underlying query. The combo boxes are cmbYear, cmbMake, cmbModel, cmbSubModel, cmbEngineType, and cmbLiter. cmbMake only shows the makes for the Year...