UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Form Link In Sql Doesn't Work In Runtime Version, Office 2010    
 
   
MrSiezen
post Feb 13 2012, 10:52 AM
Post #1

UtterAccess Ruler
Posts: 2,198
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
Go to the top of the page
 
+
MikeLyons
post 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
Go to the top of the page
 
+
MrSiezen
post Feb 14 2012, 03:34 AM
Post #3

UtterAccess Ruler
Posts: 2,198
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?
Go to the top of the page
 
+
« Next Oldest · Access Runtime, Packaging & Deployment · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 19th June 2013 - 08:54 AM