Search results

Then one of the reference library is not checked and that is how the Mid function does not exist.

Don know why you are renaming WAVE3_PC_DL.UPC AS Sequence but anyway this below does not work? SELECT WAVE3_PC_DL.UPC AS Sequence, WAVE3_PRODS.PC, WAVE3_PRODS.PDESC, WAVE3_PRODS.PC_CAT, WAVE3_PC_DL.DEPT, UPC.Date, Mid([WAVE3_PC_DL.UPC],7,6) AS ShortUPC FROM ((WAVE3_PC_CATS LEFT JOIN...

I just tried in Access to write a query in design view and when I look at the SQL behind the design it gives me Mid([Field1],7,6) as SessString and it works. Are you trying to free hand SQL statements instead of design view with the expression builder?

I do not see it in the original code you posted so that is why I am confused then. SELECT WAVE3_PC_DL.UPC, mid([WAVE3_PC_DL.UPC],7,6) as ShortUPC, WAVE3_PC_DL.UPC, WAVE3_PRODS.PC, WAVE3_PRODS.PDESC, WAVE3_PC_CATS.CAT_DESC, WAVE3_PC_DL.DEPT, UPC.Date FROM ((WAVE3_PC_CATS LEFT JOIN...

Way wrong. Which field is the UPC code that you want to filter?

I am not going to try to figure out which is the UPCcode field in your query but when you build your query to just get the 0-71270 part of the database in your select you need to ask for left([UPCcode],7]) and put "0-71270" as the criteria. Also you need to ask for mid([UPCcode],7,6) to get...

Did you try putting the trim against each element you are concatinating like this strSQL = "UPDATE [TBL_TmpMonitorIn] SET DupeCode = trim([NumberOrName]) & trim([Postcode]) & trim(str([MeasureCategory]));"

I have dropped the idea for now for the message box and stuck with the idea to have the Record x of y display. The background of the BomDate field is red if it is null so my mentor says that is good enough and he will discuss this with the customer. Thank you for your help.

So that leads me to think that the Dynaset(Inconsistent Updates) is an override for when a query has informed you that you may not update the data. Somehow I felt it was referral to the data being displayed rather than a quasi-update permission bypass type of thing.

Yes. There is other events firing in the OnCurrent so I have to think of somehow to isolate that or something. I have this in OnLoad DoCmd.GoToRecord , , acLast DoCmd.GoToRecord , , acFirst so that I can display Record X of Y in a text box with this in OnCurrent Me.RecordCountField =...

Thank you. That is right up there so I do not think I will start a discussion about that with my mentor.

I am using Access2003. I want to make a little pop up message to inform the end user if the current data is missing an element they should be updating. So I want to place this If Nz(Me.BoMDate, " ") = " " Then MsgBox "This item needs a Bill of Material", vbOKOnyl, "Company Name LTD" End If...

Thank you for the link for the FMS demo to synchronize two subforms. That is cleaver to have a second field that is hidden so you can synch the two subforms. I got lost on the polymorphism part but if you have been trying to figure it out for 10 years then I had better not get into it.

Thank you. More curiosity then anything else. I read on a post on a other forum that you need the setting if to update multiple tables from a form when there is a complex relationships between the tables like "one to many to many" or "many to one to many" but that is the only reference I have...

In Access2003, in the property of a form on the Record Type there is a choice of Dynaset, Snapshot and Dynaset (Inconsistent Updates). I understand the Dynaset you can update, Snapshot you can not, but what is with the "Inconsistent Updates"? Thank you.

Sorry to cut into a thread. This is great I learned from this for 'read only forms' but I am wondering, on the Record Type there is a choice of Dynaset, Snapshot and Dynaset (Inconsistent Updates). I understand the Dynaset you can update, Snapshot you can not, but what is with the "Inconsistent...

I did not think you were battling it out, just I expected perhaps a post or two to suggest the best directions and not a big discussion. Anyhow I did learn a lot from these posts so I thank you all for your time so far. Yes there are 12 fields at the moment in a single table which will have...

woah. I did not think I would upset the apple cart witht at question. Thank you for your replies. Right now there are 12 fields that can take the poor to excellent criteria or 1 to 5, but I was told there could be more added in the near future. There would be thousands of records so it...

I am building a database with some parameters based on observed performance and I am wondering which is more efficient way to store the parameters. Allowing a user to select Poor - Fair - Good - VeryGood - Excellent would it be good practice to store the information numerically as 1 2 3 4 5...

Thank you for answering. It is not a subform but a new form that opens for the detail. While proof reading I discovered that I did not include the double quotes around the form names within the brackets. I had this Forms(frmDetails).Requery Forms(frmSummary).Requery I should have had this...