Recent content by NSAMSA

I tried creating a query off of the original table that takes the multi-select values and makes them a list and using that as my source. While that query continues to work, the query in questions continues to fail. How can I work around this, as the nature of this database is to enter multiple...

All: I created an access database almost 2 years ago that was functioning fine. A key query started giving me an Enter Parameter Value error a couple of months ago without me changing anything. If I make other queries around the same tables, they work but if I duplicate this query, it does...

I've managed to get the dataset updateable in my query. However, it still will not update on my subform. Is there some setting that I'm missing? Before adding the schedule element, I had no issue with updates on the subform. Regards

I put the unique record in the query to "yes" if that is what you are suggesting. Otherwise I do have keys on both tables.

I did this and am still getting the same result. The suggestion does make sense, and I'm actually surprised its still not yielding an updateable form.

All: I've been trying to figure out what the issue is with a query of mine that is not updateable. I have a training database and my query is pulling from 2 tables. One table is the records table with employee number, name, course, department, date completed, etc. The parameters of Name...

I suppose the reason I delete and repopulate, is to avoid having too many records. e.g. if I assign basket weaving to the workgroup A, which Suzy and Jake are a part of. I populate the Record Entry Table and it has two lines for Suzy and Jake doing basket weaving. Suzy completes basket...

All: I am trying to create a training tracking database. I have a table that has the workgroups and the courses assigned to each group, a table with employees and the workgroups that they belong to, and a query that deletes all records and repopulates in a record entry master table based on...

That would be this one: SELECT [01-qryHENEQP].LineName, [01-qryHENEQP].LocalText, [02-qryIOReject].Inspected, [02-qryIOReject].Rejected, [02-qryIOReject].PlantDate FROM [01-qryHENEQP] INNER JOIN [02-qryIOReject] ON ([01-qryHENEQP].EquipmentID = [02-qryIOReject].EquipmentID) AND...

SELECT dbo_tblIO_Rej.dtoDateTime, dbo_tblIO_Rej.LineID, dbo_tblIO_Rej.EquipmentID, dbo_tblIO_Rej.Inspected, dbo_tblIO_Rej.Rejected, dbo_tblIO_Rej.DayNoUTC, CDate(Left([dtoDateTime],10)) AS RejDate, Left(Right([dtoDateTime],15),8) AS DynTime, CDate(IIf([DynTime]<"08:00:00",[RejDate]-1,[RejDate]))...

I'm having an odd issue where my date will not recognize the year when I use "Between" in my query. Just a quick rundown of the issue: The original date from the ODBC connection is in a short text format. I used CDate to convert it to Date/Time. However, now when I type in a month after...

I believe I've discovered the issue, and its not what I originally thought. The form is based off of a Union Query which is not updatable. I need to figure out a way around this. I have two buttons on the original form. One for "Open" and another for "Closed". In one query I ask that if the...

I will try to explain as best as I can. I have a database for product specs. There are three kinds of specs used for items. spec C is the most specific followed by B and then A. So, I have two tables in the database. One shows what the B spec is in relationship to C specs. The other shows...

Hi: I have a query that references a linked table's dataset to filter the datasets down. The issue I'm running into is that I cannot update any of the items that are not in the linked table, because the dataset is filtered by the linked table. Is there any way around this? Thank you

That worked great! Thank you!