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

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

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

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

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

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