S Springblossom Member Local time Today, 13:18 Joined Jan 18, 2022 Messages 55 Jan 18, 2022 #21 When I want to have the WBSElement from entered projectname, it gives a #Size! error. Would you please guide me through that?
When I want to have the WBSElement from entered projectname, it gives a #Size! error. Would you please guide me through that?
S Springblossom Member Local time Today, 13:18 Joined Jan 18, 2022 Messages 55 Jan 18, 2022 #22 Sorry this the code I entered : =DLookUp("WBS";"Projects";"ID = " & Nz([WBSElement];0))
Minty AWF VIP Local time Today, 12:18 Joined Jul 26, 2013 Messages 10,655 Jan 18, 2022 #23 MaryJavan said: I don't know why I got a calender next to it. Click to expand... It thinks it's a Date field. What is the datatype in the table?
MaryJavan said: I don't know why I got a calender next to it. Click to expand... It thinks it's a Date field. What is the datatype in the table?
S Springblossom Member Local time Today, 13:18 Joined Jan 18, 2022 Messages 55 Jan 18, 2022 #24 it looks like this: BBUK-17-5999
S Springblossom Member Local time Today, 13:18 Joined Jan 18, 2022 Messages 55 Jan 18, 2022 #25 How can I relate and write in the code, the fact that each project has a different WBS element?
Minty AWF VIP Local time Today, 12:18 Joined Jul 26, 2013 Messages 10,655 Jan 18, 2022 #26 In the table design that stores that field, what is the data type set to?
S Springblossom Member Local time Today, 13:18 Joined Jan 18, 2022 Messages 55 Jan 18, 2022 #27 I can't see any data type in the design table.
Minty AWF VIP Local time Today, 12:18 Joined Jul 26, 2013 Messages 10,655 Jan 18, 2022 #28 Can you simply post up a copy of your database? Remove or anonymise any personnel data Compact and repair it, then Zip it before uploading.
Can you simply post up a copy of your database? Remove or anonymise any personnel data Compact and repair it, then Zip it before uploading.
S Springblossom Member Local time Today, 13:18 Joined Jan 18, 2022 Messages 55 Jan 19, 2022 #29 I will try to do so.
S Springblossom Member Local time Today, 13:18 Joined Jan 18, 2022 Messages 55 Jan 19, 2022 #30 Minty said: In the table design that stores that field, what is the data type set to? View attachment 97619 Click to expand... It is short text.
Minty said: In the table design that stores that field, what is the data type set to? View attachment 97619 Click to expand... It is short text.
Minty AWF VIP Local time Today, 12:18 Joined Jul 26, 2013 Messages 10,655 Jan 19, 2022 #31 Okay that makes no sense, in the form design have you set a format?