473,320 Members | 1,920 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

if statements??

When using a form can i
put in a VB statement
saying
e.g.
if field from table "special needs"=deaf then field from query
"teaching assistant" "expertise" = deaf,)
I need to generate differing data held in seperate queries in the form
dependent on what data is selected from the first field.

Feb 22 '07 #1
2 2006
On Feb 22, 3:12 pm, "wannabeateacher" <s...@downtothewoods.me.uk>
wrote:
When using a form can i
put in a VB statement
saying
e.g.
if field from table "special needs"=deaf then field from query
"teaching assistant" "expertise" = deaf,)
I need to generate differing data held in seperate queries in the form
dependent on what data is selected from the first field.

In a query or form control you would use an IIF statement, in an event
proceedure you would use IF. (Note one has an extra I).

As a field in a query design grid FieldAlias: =IIF([Special Needs].
[FieldName]="Deaf",[teaching assistant].[Expertise]="Deaf",Null)

In an event:

If ControlName="Deaf" then OtherControlName="Deaf"

Read about these functions and see what you need to do to make them
work for you.

Feb 22 '07 #2
On 22 Feb, 20:34, "storrboy" <storr...@sympatico.cawrote:
On Feb 22, 3:12 pm, "wannabeateacher" <s...@downtothewoods.me.uk>
wrote:
When using a form can i
put in a VB statement
saying
e.g.
if field from table "special needs"=deaf then field from query
"teaching assistant" "expertise" = deaf,)
I need to generate differing data held in seperate queries in the form
dependent on what data is selected from the first field.

In a query or form control you would use an IIF statement, in an event
proceedure you would use IF. (Note one has an extra I).

As a field in a query design grid FieldAlias: =IIF([Special Needs].
[FieldName]="Deaf",[teaching assistant].[Expertise]="Deaf",Null)

In an event:

If ControlName="Deaf" then OtherControlName="Deaf"

Read about these functions and see what you need to do to make them
work for you.
THANKYOU SO MUCH
XXXX

Feb 22 '07 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Bart Nessux | last post by:
Should an if statement have a corresponding else statement? Or, is it OK to have an if statement by itself. For completeness, it seems the two should be together, but from experience I know that a...
9
by: Jaime Wyant | last post by:
I know I've seen this somewhere, but can't seem to google it. Is there a way to use an alternate statement separator, other than the default ';'? jw
1
by: Tom D | last post by:
I'm rewriting a database interface that our company currently has. Currently it's using the Pear::DB interface, but we found that that was introducing a bit too much overhead. I'm rewriting the...
39
by: slogging_away | last post by:
Hi - I'm running Python 2.4.2 (#67, Sep 28 2005, 12:41:11) on win32, and have a script that makes numerous checks on text files, (configuration files), so discrepancies can be reported. The script...
0
by: Fuzzyman | last post by:
Hello all, The following is a copy of a blog entry. It's asking a question about future statements and the built in compile function. I'd appreciate any pointers or comments about possible...
20
by: Neroku | last post by:
Hello, i would like to know what the serious definition of statements and expressions is: i know an expression are evaluated to a value, i.e: 1 == 2 5+7 foo( 1,2) and a statement is...
2
by: ojorus | last post by:
Hi! Some questions regarding the mysqli-extension (php5) 1) Prepared statements: If I understand things right, prepared statements will give better performance if you make several similar...
3
by: Dmitri | last post by:
Hello! I have a developer that is playing around with some SQL statements using VB.NET. He has a test table in a SQL 2000 database, and he has about 2000 generated INSERT statements. When the...
0
by: Gary Herron | last post by:
Ohad Frand wrote: There is no way you can consider 'elif', 'else', 'except', and 'from' statements. However, as someone pointed out, the kwlist from the keyword module is the closest thing we...
0
by: Ohad Frand | last post by:
Hi Thanks a lot for your reply I think the main uses for it is to study the language and to see that I didn't miss anything else or that something is changed from one version to another. The...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.