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 wOOdy-Soft 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: *

  • Users: Rascelon
  • Content: Threads
  • Order by date
  1. Rascelon

    Not sure how to get what I want with SQL code

    OK. I have 2 tables, tblAnalyte and tblWQStandard. There is a one to many relationship between the 2 tables. Unique analytes are stored in tblAnalyte and water quality standards for an analyte are stored in tblWQStandard. There can be more than one standard for any analyte but only one analyte...
  2. Rascelon

    Generate SQL FROM clause on-the-fly using code

    Does anyone have code to generate on the fly a SQL FROM clause based on a list of user chosen tables? I am creating a database for my boss that has a form that is an attempt to make a more user-friendly version of the Access Query Builder Environment. It is a simple multiple step form to help...
  3. Rascelon

    Can't get Delete query to run

    I get an error message that says, "Could not delete from specified tables." when I run a simple delete query between 2 tables with NO dependencies. Here is the SQL. DELETE Table1.* FROM Table1, Table2 WHERE (((Table2.ID)=[Table1].[ID])); The ID column is the primary key for each of the...
  4. Rascelon

    Can't grab description property value for a Linked table

    I have code that goes through my database objects using ADOX and records table,view or linked table names, columns, data types and descriptions into a table. The code works fine for tables but when I come across a linked table the field description is always blank. I can grab the Linked table...
  5. Rascelon

    SELECT WHERE Field Names from 2 tables are equal

    Is it possible to select fields from two tables where the field names are equal? I know that the field data types are all the same but I want to make a query that contains data where the field names are the same in both tables. Vince

Part and Inventory Search

Back
Top