Take a look here: I got the statement from a tutorial. It’s easy to join and it’s free. Surround strings with single quotes ‘. I am not a computer guru; neither am I a neophyte.

Uploader: Arashizilkree
Date Added: 4 October 2014
File Size: 6.87 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 12200
Price: Free* [*Free Regsitration Required]

I have the file upload process squared away, but I woule like to display a randome image so microsift user could click a link that posts back to the same url just showing a different image Home Forum What’s New? Thanks for your feedback, it helps us improve the site.

Are you trying to insert the value [ Marc Microsovt, Nov 11, Tell us about your experience with our site. Marc Everlove, Nov 13, Red Flag This Post Please let us know here why this post is inappropriate. Thanks very much Ed. This forum is now closed to new posts, but you can browse existing content. I am not a computer guru; neither am I a neophyte.

What’s amiss with it??? You might be able to have a list of possible images in memory, and choose one at random from that and explicitly select that image back.


Click Here to join Tek-Tips and microsofy with other members! As I implied, if you’re not calling from within Access, I don’t believe there’s any way you can return random rows.

[Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause HELP!!!!!-VBForums

Results 1 to 5 of 5. However, the randomizer query you linked to has come up a few times, so it is probably the best option.

I will post my code I am using Dreamweaver 8 and the Interakt extension which is supposed to support asp but unsurprisingly doesn’t work Victorsfunnies.

Wow that was quick! For debugging, add a line like. Thanks for marking this as the answer.

[Microsoft][ODBC Microsoft Access Driver] Syntax Error in ORDER BY clause

Undefined function ‘rand’ in expression Looks like another looooong night Take a look here: I really appreciate all the assistance! Can anybody tell me what Midrosoft have done wrong? Thank you for helping keep Tek-Tips Forums free from inappropriate posts. I have been attempting to look up information on how to accomplish this all, but have not been very successful.


You can now find them here. I really appreciate your assistance, I value your time.

Microsoft OLE DB Provider for ODBC Drivers error ‘80040e14’

It doesn’t really matter though because I am not using it for anything. Best Regards, Marc Everlove. Hi, I am building a SQL query on the fly – part of the code is as follows: The unique key is an autonumbered field so I was thinking I could use that, BUT if I delete records the count won’t be contiguous. If I understood correctly you had me change the word acceas to values.