Search results
-
Z
text box that look up value from another table than the forms record source
I see :-) Entry_NO is an autonumber Though Changing to Brackets I still get an error. See attached. Also I would like to run through all records -
Z
text box that look up value from another table than the forms record source
I know what you mean :) So know that you are fueled up with coffee maybe you could guide me in a query issue. :) I have a reservation table "dbo_KonfAir DRIFT$Reservation Entry" from where I need to filter out. Entry No_: need to be distinct but is shown in pairs Source Type "37" and "5406"... -
Z
text box that look up value from another table than the forms record source
I have 3 records with the same production order number. If I change for example 800 to 80, the value on the form change to 700, which is the correct behaviour. -
Z
-
Z
text box that look up value from another table than the forms record source
Haven't been able to force an error yet after some testing, so this must OK for now :) The above issue is part of a little time clock database that I am doing at work. Its purpose is to keep track of which productionsorders are beeing worked on. Now.. this i work in progress and and feature... -
Z
text box that look up value from another table than the forms record source
That gave me an #Error in the textbox However the below code seem to work. The CLng conversion doesn't seem necessary =DMax("antalemnerproduceret";"tbl_tidstabel";"[No_]='" & [Produktionsordre Nummer] & "'") Thank you very much for all your help. Saved me a lot of time :) -
Z
text box that look up value from another table than the forms record source
Thanks a lot... That did the trick. :) I little additional question. If there are duplicate values in "tbl_tidstabel" "No_" and I would like to only return the highest value of "antalemnerproduceret". Would that be possible?? Remember both "No_" and "Produktionsordre Nummer" are short text... -
Z
text box that look up value from another table than the forms record source
Now I dont get any errors... But I also don't get the result I want.. I tried to use ; as a separator. I use a Danish version of Access... Maybe it translates differently. However... My text box only show #Name? =DLookUp([antalemnerproduceret];"tbl_tidstabel";"[No_]='" &... -
Z
text box that look up value from another table than the forms record source
Yes - unfortunately same error. Anything else I could be doing wrong... maybe in the referenced Form or table ? -
Z
text box that look up value from another table than the forms record source
Yes - Just tried to rule out some wrong spelling What I mean is... if for example there is an error in the referenced fields I wouldn't get this kind of error (Invalid character or comma etc...) This error relates to characters "'[]& misplaced, missing or maybe added where it shouldn't -... -
Z
text box that look up value from another table than the forms record source
No luck either If the syntax is correct then the expression builder should accept it - Correct ?? -
Z
text box that look up value from another table than the forms record source
Thanks for your reply...:) hmmm. Still cant get it to work though. I get the same error. The field [Produktionsordre Nummer] is a query field name but actually comes from a Production order table where the field name is [No_]. Could that cause this error ? I have tried deleting the field name... -
Z
text box that look up value from another table than the forms record source
Hi Totally new to access vba so bare over with me if I ask stupid questions :) I have a text box on a continuous form where I would like to show a value from another table that the forms record source. I would like to look up "AntalEmnerProduceret" from the table "tbl_TidsTabel" where field...