Recent content by Rascelon

dojones: Are you saying that the query always takes awhile to load when you first open the form or have you tried opening the form using both queries and get quicker results with the 2nd query? If it is only that the initial loading of the form is slow, then it seems to me that that would be a...

Thanks PH. That worked exquisitely. You were also right about Rudy's syntax. Thanks too Rudy for keeping me straight on the terms. I can't tell you how long I've been calling them left-right inner joins. [blush] Vince

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

That is certainly a solution but not the flexibility that I was looking for. Thanks for responding though. Vince

Thanks for the link. The search form works well but unfortunately won't allow more complex queries where data are pulled from more than one table (i.e. when table relationships have to be expressed in the FROM clause). What I want to do may be too difficult for my skill level but maybe if there...

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

Well... that was easier than I thought. Thanks. Vince

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

It sounds as if you are initiating the Visible=true in the OnClick event of the Option Group. If that is the case then you would expect the code you made to Hide/Show the text boxes not to execute, because the Option Group did not experience the OnClick event. Maybe try a different route like...

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

Sorry for not being clear but I wouldn't know what the field names would be. My guess is that this isn't possible simply using SQL but I can do it using procedural code in Access (VBA), which is what I am working on now. Thanks anyway. Vince

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