Search results

I am so stuck. I use this function all the time to filter combo boxes and it works just great. I am trying to get it to filter the form itself and nadda, nothing. Okay here is the form's row source SELECT qryrmt_Job_Descript.CO_NO, qryrmt_Job_Descript.DIV_NO, qryrmt_Job_Descript.JOB_NO...

Awesome. Worked, first try. Thank you

Sorry for the late response. Thank you,

I have a Text field in which the user types; then clicks a Command Button that opens a report in preview mode. However (I think) going from the Text field to the Command Button does not update the Record (or field???). When the report is displayed it does not include the users changes or...

This is soooo simple... if you know it. It is the obvious that I have the most problems with. Thank you

I set a date variable to Now(). It stores the date and time. Is there anyway to have it only store the date itself. Visually this is not a problem. But when the users edit the field it shows the date and time. Thank you,

Remember, CMSqry_Vendor_and_Contacts is a PT query (READ ONLY)

Here is what does not work. UPDATE tbl_Vendor_Release_Info INNER JOIN CMSqry_Vendor_and_Contacts ON (tbl_Vendor_Release_Info.Vendor_No = CMSqry_Vendor_and_Contacts.VENDOR_NO) AND (tbl_Vendor_Release_Info.Div_No = CMSqry_Vendor_and_Contacts.DIV_NO) AND (tbl_Vendor_Release_Info.Co_No =...

You have: INSERT INTO tblTarget (column1="A", column2=1) Yet this value must come from the Pass-Through query. i.e. tblTarget.column1 = Passthroughquery.column1

P.S. What about the original question regarding combo boxes. Should I rephrase this is a new thread?

I understand (I think) EXISTS, but not your applicataion of it.

Yes I read it, but I wasn't sure if I understood entirely. Well that stinks. Yet, oddly, simultaneously explains my problem and therefore my lack of solutions. Sigh... I could always write a dlookup, compare it to what is found and then use a straight forward insert statement. Thanks,

Here's the rub... I am not actually trying to update the PT query. I am trying to update the MSSQL table (directly) and set it to values from the PT query. The actualy query is in thread 'Why is this not updatable?'. If you wish I can copy it here as well.

In the MSSQL tables yes, in the Pass-Through query no. Not sure how to set one. Note 'Why is this not updatable?' thread.

If I had to guess it would be "The fields in a JOIN are not indexed correctly: there is no primary key or unique index on the JOINed fields." The Pass-Through query does not show any PKs at all. Is there a way to set any of the fields to (as) a PK?

Operation must use and updatable query.

The only solution I have found (and I do not like it) it to create a temporary table that is appended to each time the db is open and have that update the vendor table in MSSQL and still worry about a multi-user enviroment.

Banana I was really hopping on that one. But... I got the same message. As far as change I don't think so. The vendor information is on the iSeries and part of our business system. This application is external to add funcationality that we need.

If I add a where statement I can get it down to one record. It still gives me the same message.

I have an Access FE with MSSQL BE an Pass-Throughs to and iSeries (AS-400). Okay I am already over my head. I would like to build a subform (data sheet) that allows the user to select vendor records. This will store the Vendor Number in an MSSQL table. Selecting the Vendor Number is easy...