My Assistant
Site Message
(Message will auto close in 2 seconds)
 Form Link In Sql Doesn't Work In Runtime Version, Office 2010
|
|
 Feb 13 2012, 10:52 AM
Post
#1
|
|
|
UtterAccess Ruler Posts: 2,196 From: Den Bosch - Netherlands  |
Hi all,
I've got a simple database with a form with some reference to forms as parameters, like: CODE SELECT article_composition.basic_code, articles.name, article_seasons.seasonID FROM article_seasons INNER JOIN (articles INNER JOIN article_composition ON articles.basic_code = article_composition.basic_code) ON article_seasons.article_compositionID = article_composition.ID WHERE (((article_seasons.seasonID)=[Formulieren]![frmVerkoop]![cmbSeason])) OR ((([Formulieren]![frmVerkoop]![cmbSeason]) Is Null)) GROUP BY article_composition.basic_code, articles.name, article_seasons.seasonID ORDER BY article_composition.basic_code; This works fine, but if I convert this database to a runtime file, it gives missing parameter errors for all these forms references. I'm a complete newbie to runtime, am I missing something? Harm |
 |
 
|
 |
Replies
(1 - 2)
|
Feb 13 2012, 12:55 PM
Post
#2
|
|
|
UtterAccess VIP Posts: 1,857 From: BC, Canada |
Not sure... I did notice you referencing a collection called [Formulieren] which I am going to guess that this means [Forms] in Dutch.
Are you running the runtime version on a different install of Access on another machine, perhaps an English language version? Not sure - I have never had a need to develop international versions of applications so am not sure if the language makes any difference when embedded into a SQL statement in a query. Anyone else? Mike |
|
|
|
|
Feb 14 2012, 03:34 AM
Post
#3
|
|
|
UtterAccess Ruler Posts: 2,196 From: Den Bosch - Netherlands |
Hmm good thinking! I think that that is it!
I've changed formulieren to forms, and it's ok... I started working with the Dutch 2010 version about a month ago... Is it possible to don't let it use (or better, suggest) Dutch terms in SQL? |
|
|
|
 |
 |
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 18th May 2013 - 09:02 PM |