V vbaInet AWF VIP Local time Today, 20:31 Joined Jan 22, 2010 Messages 26,328 Jul 23, 2010 #21 It still wouldn't work PNG. ADP syntax is slightly different. It's a headache. I think it might be something like: Code: WHERE (Job = @Enter_Job_Number)
It still wouldn't work PNG. ADP syntax is slightly different. It's a headache. I think it might be something like: Code: WHERE (Job = @Enter_Job_Number)
V vidus Confused User Local time Today, 12:31 Joined Jun 21, 2009 Messages 117 Jul 23, 2010 #22 vbaInet said: It still wouldn't work PNG. ADP syntax is slightly different. It's a headache. I think it might be something like: Code: WHERE (Job = @Enter_Job_Number) Click to expand... Code: This designer does not graphically support the @Enter_Job_Number SQL construct. Id imagine it would be something like this though.. ill have to play around with it unless anyone knows?
vbaInet said: It still wouldn't work PNG. ADP syntax is slightly different. It's a headache. I think it might be something like: Code: WHERE (Job = @Enter_Job_Number) Click to expand... Code: This designer does not graphically support the @Enter_Job_Number SQL construct. Id imagine it would be something like this though.. ill have to play around with it unless anyone knows?
V vbaInet AWF VIP Local time Today, 20:31 Joined Jan 22, 2010 Messages 26,328 Jul 23, 2010 #23 Keep the thread open and someone who has used ADP might chime in. Your other way would be to build the sql and get the criteria from a textbox?
Keep the thread open and someone who has used ADP might chime in. Your other way would be to build the sql and get the criteria from a textbox?
V vidus Confused User Local time Today, 12:31 Joined Jun 21, 2009 Messages 117 Jul 23, 2010 #24 vbaInet said: Keep the thread open and someone who has used ADP might chime in. Your other way would be to build the sql and get the criteria from a textbox? Click to expand... not sure where to start for that. you would think there is a simple solution just like normal access. doesnt get any easier than []... hopefully there is just a small bit of code im missing here.
vbaInet said: Keep the thread open and someone who has used ADP might chime in. Your other way would be to build the sql and get the criteria from a textbox? Click to expand... not sure where to start for that. you would think there is a simple solution just like normal access. doesnt get any easier than []... hopefully there is just a small bit of code im missing here.
