Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mrussell71

    XSL, transform XML to XML for MS Access

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

    Using a Delete Query without a Primary Key Field

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

    Using a Delete Query without a Primary Key Field

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

    Finding Duplicate Records in a Table

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

    Export Data from Access to Fixed-Width .txt file

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

    UPDATE Stored Procedure using Replace function

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

    Delete Records from Code using a recordset

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

    Delete Records from Code using a recordset

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

    Combine Fields from two Tables

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

    Combine Fields from two Tables

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

    Automate Delete Queries using VBA or macro

    Thanks Mike that did the trick.
  12. mrussell71

    Using VBA to Automate Delete Queries....

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

    Automate Delete Queries using VBA or macro

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

    Iif statement driving me insane

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

    Split a text field into two separate fields

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

    Split a text field into two separate fields

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

    doCmd.SendObject .... Can't get it to work!!!

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

    Send Email from a Form...Help!

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

    Send Email from a Form...Help!

    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]...
  20. mrussell71

    Dependent Combo Boxes and Null Values

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

Part and Inventory Search

Back
Top