Yes No question - Microsoft Access / VBA

Jan Hansen

I need some help, and im not very good at this.

I have a Yes/No field and i need to make access 2003 write DONE i a tekst
field when Yes in the Yes/No field is set (-1). I know it is in the code
window (VBA) it is done, but not how.

Please help me.

Jan Hansen, Denmark

Nov 27 '07 #1

Subscribe Post Reply

2522

Salad

Jan Hansen wrote:

I need some help, and im not very good at this.

I have a Yes/No field and i need to make access 2003 write DONE i a tekst
field when Yes in the Yes/No field is set (-1). I know it is in the code
window (VBA) it is done, but not how.

Please help me.

Jan Hansen, Denmark

If your text box is called Text0 to display something and the YesNo
field is called YN, you could make the control source (data tab in
properties for Text0)
=IIF([YN],"Done","Incomplete")
or
=IIF([YN],"Done","")
to keep the field blank if false.

Nov 27 '07 #2

DavidB

On Nov 27, 2:10 pm, "Jan Hansen" <hundestederen(replace this with
AT)privat.dkwrote:

I need some help, and im not very good at this.

I have a Yes/No field and i need to make access 2003 write DONE i a tekst
field when Yes in the Yes/No field is set (-1). I know it is in the code
window (VBA) it is done, but not how.

Please help me.

Jan Hansen, Denmark

Where are you attempting to update this TEXT (not tekst) field? Is it
on a form for example? Do you want the TEXT field to be updated as
you change the value of the Yes/No field or is this simply a display
only field? Give us more info on what it is you are doing...

Nov 27 '07 #3

Jan Hansen

"DavidB" <je***@yahoo.comskrev i en meddelelse
news:c3**********************************@r60g2000 hsc.googlegroups.com...

On Nov 27, 2:10 pm, "Jan Hansen" <hundestederen(replace this with
AT)privat.dkwrote:
>I need some help, and im not very good at this.

I have a Yes/No field and i need to make access 2003 write DONE i a tekst
field when Yes in the Yes/No field is set (-1). I know it is in the code
window (VBA) it is done, but not how.

Please help me.

Jan Hansen, Denmark

Where are you attempting to update this TEXT (not tekst) field? Is it
on a form for example? Do you want the TEXT field to be updated as
you change the value of the Yes/No field or is this simply a display
only field? Give us more info on what it is you are doing...

Hmm this is dificult in english, but i will try.

The above was only an example, this is the case.

I got at database where i write jobs fore my crew.
And the Yes/No field is to set urgent on some of the jobs.
And i want the urgent jobs to have a yellow background on the repport i
print out.
And i know how to get yellow background by conditional formatting but that
require a specific tekst or value in the field.
That was why i wanted the field to get the tekst "Urgent" så i could use
that as a condition.
In short. Yes in the Yes/No field makes my Urgent field write "Urgent". And
it is only on the printed report i want the yellow background.

I hope it makes sence. And im sorry for my bad english.

Nov 27 '07 #4

Jan Hansen

"Jan Hansen" <hundestederen(replace this with AT)privat.dkskrev i en
meddelelse news:47***********************@dtext01.news.tele.d k...

>
"DavidB" <je***@yahoo.comskrev i en meddelelse
news:c3**********************************@r60g2000 hsc.googlegroups.com...
>On Nov 27, 2:10 pm, "Jan Hansen" <hundestederen(replace this with
AT)privat.dkwrote:
>>I need some help, and im not very good at this.

I have a Yes/No field and i need to make access 2003 write DONE i a
tekst
field when Yes in the Yes/No field is set (-1). I know it is in the code
window (VBA) it is done, but not how.

Please help me.

Jan Hansen, Denmark

Where are you attempting to update this TEXT (not tekst) field? Is it
on a form for example? Do you want the TEXT field to be updated as
you change the value of the Yes/No field or is this simply a display
only field? Give us more info on what it is you are doing...

Hmm this is dificult in english, but i will try.

The above was only an example, this is the case.

I got at database where i write jobs fore my crew.
And the Yes/No field is to set urgent on some of the jobs.
And i want the urgent jobs to have a yellow background on the repport i
print out.
And i know how to get yellow background by conditional formatting but that
require a specific tekst or value in the field.
That was why i wanted the field to get the tekst "Urgent" så i could use
that as a condition.
In short. Yes in the Yes/No field makes my Urgent field write "Urgent".
And it is only on the printed report i want the yellow background.

I hope it makes sence. And im sorry for my bad english.

No help on this ?

Nov 28 '07 #5

Salad

Jan Hansen wrote:

"Jan Hansen" <hundestederen(replace this with AT)privat.dkskrev i en
meddelelse news:47***********************@dtext01.news.tele.d k...

>>"DavidB" <je***@yahoo.comskrev i en meddelelse
news:c3**********************************@r60g20 00hsc.googlegroups.com...

>>>On Nov 27, 2:10 pm, "Jan Hansen" <hundestederen(replace this with
AT)privat.dkwrote:

I need some help, and im not very good at this.

I have a Yes/No field and i need to make access 2003 write DONE i a
tekst
field when Yes in the Yes/No field is set (-1). I know it is in the code
window (VBA) it is done, but not how.

Please help me.

Jan Hansen, Denmark

Where are you attempting to update this TEXT (not tekst) field? Is it
on a form for example? Do you want the TEXT field to be updated as
you change the value of the Yes/No field or is this simply a display
only field? Give us more info on what it is you are doing...

Hmm this is dificult in english, but i will try.

The above was only an example, this is the case.

I got at database where i write jobs fore my crew.
And the Yes/No field is to set urgent on some of the jobs.
And i want the urgent jobs to have a yellow background on the repport i
print out.
And i know how to get yellow background by conditional formatting but that
require a specific tekst or value in the field.
That was why i wanted the field to get the tekst "Urgent" så i could use
that as a condition.
In short. Yes in the Yes/No field makes my Urgent field write "Urgent".
And it is only on the printed report i want the yellow background.

I hope it makes sence. And im sorry for my bad english.

No help on this ?

I would drop the YesNo field (I'll call it YN) in the report and make
it's visible property False. I would create a textbox (I'll call it
YNDescription. In it's control source (under data tab in Property
Sheet) enter
=IIF([YN],"Urgent","")

You could even display or not display the field. Let's say the YN field
in in the Detail band. Make it invisible. Put in a label that says
"Urgent". Give the label the name UrgentLabel. Put a yellow background
in it. Now in the Format event of the Detail band enter
Me.UrgentLabel.Visible = Me.YN

Nov 28 '07 #6

Jan Hansen

Damn, how blind can a man be.

Thanks for the help everybody. It works fine.

Dec 5 '07 #7

Similar topics

Simple Java/XML question

by: Stevey | last post by:

I have the following XML file... <?xml version="1.0"?> <animals> <animal> <name>Tiger</name> <questions> <question index="0">true</question> <question index="1">true</question> </questions>

.NET Framework

Filling question ID automatically by using query or VBA

by: Ekqvist Marko | last post by:

Hi, I have one Access database table including questions and answers. Now I need to give answer id automatically to questionID column. But I don't know how it is best (fastest) to do? table...

Microsoft Access / VBA

Question about the clc string lib

by: Jeff | last post by:

In the function below, can size ever be 0 (zero)? char *clc_strdup(const char * CLC_RESTRICT s) { size_t size; char *p; clc_assert_not_null(clc_strdup, s); size = strlen(s) + 1;

C / C++

Question about the *= (and similar) operator

by: spibou | last post by:

In the statement "a *= expression" is expression assumed to be parenthesized ? For example if I write "a *= b+c" is this the same as "a = a * (b+c)" or "a = a * b+c" ?

C / C++

Matrix question and nested repeaters

by: Allan Ebdrup | last post by:

Hi, I'm trying to render a Matrix question in my ASP.Net 2.0 page, A matrix question is a question where you have several options that can all be rated according to several possible ratings (from...

C# / C Sharp

question in regard to precedence of CSS selectors

by: Zhang Weiwu | last post by:

Hello! I wrote this: ..required-question p:after { content: "*"; } Corresponding HTML: <div class="required-question"><p>Question Text</p><input /></div> <div...

HTML / CSS

I want to be able to select multiple options for a question.

by: love91501 | last post by:

I was wondering if anyone would be able to help me figure out how to make my Q010 have the ability to chose 2 answers, I'm hoping to stay away from checkboxes but I am willing to take in any advice....

Javascript

Cannot add or update a child row: a foreign key constraint fails (`kims`.`question`,

by: semanticnotion | last post by:

Hi sir i want to transform the data of one table into another through foreign key but the following error come to my browser Here is my code and data base structure. CREATE TABLE IF NOT...

PHP

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice