Particular List Order help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am building work orders database and I have status list table that attached
to the WO form as combo box.
What I am looking for is to be able to organize the status in particular
order with no option to go back to previous status(step):
Step 1-Waiting on Scheduling

Step 2- Approved
or
Cancelled

Step 3- Completed
or
Contracted Out
or
Cancelled
Is it possible to do so?
 
UNTESTED --
Build status table like this --
Step Status_ Status
1 1 Waiting on Scheduling
2 2 Approved
2 3 Cancelled
3 4 Completed
3 5 Contracted Out
3 6 Cancelled

Use a ListBox with the following source --
SELECT Status_, Status FROM STATUS WHERE STEP =
IIF([Forms]![YourFormName]![YourListBoxName] = 1, 2,
IIF([Forms]![YourFormName]![YourListBoxName] = 2, 3))

Default -- 1
 
Thank you for the reply.
Am I doing it in query or in macro?
I'm quite new to the programming part of access, so could you please help me
with it?

Thanks again,
Anna

KARL DEWEY said:
UNTESTED --
Build status table like this --
Step Status_ Status
1 1 Waiting on Scheduling
2 2 Approved
2 3 Cancelled
3 4 Completed
3 5 Contracted Out
3 6 Cancelled

Use a ListBox with the following source --
SELECT Status_, Status FROM STATUS WHERE STEP =
IIF([Forms]![YourFormName]![YourListBoxName] = 1, 2,
IIF([Forms]![YourFormName]![YourListBoxName] = 2, 3))

Default -- 1

--
KARL DEWEY
Build a little - Test a little


Anna said:
I am building work orders database and I have status list table that attached
to the WO form as combo box.
What I am looking for is to be able to organize the status in particular
order with no option to go back to previous status(step):
Step 1-Waiting on Scheduling

Step 2- Approved
or
Cancelled

Step 3- Completed
or
Contracted Out
or
Cancelled
Is it possible to do so?
Click to expand...
Click to expand...
 
Neither. Use a ListBox on your data entry form instead of a textbox. Open
your form in design view, click on menu VIEW - Properties. If you are using
a textbox now then delete it and replace with a listbox.

In the properties of the listbox enter your field name as Control Source
(you type it or select from field list by expanding the pulldown on the
right). Then in the properties of the listbox enter the below as Row Source
(I omited part the first time) --
SELECT Status_, Status FROM STATUS WHERE STEP =
IIF([Forms]![YourFormName]![YourListBoxName] = 1, 2,
IIF([Forms]![YourFormName]![YourListBoxName] = 2 OR
[Forms]![YourFormName]![YourListBoxName] = 3, 3))


--
KARL DEWEY
Build a little - Test a little


Anna said:
Thank you for the reply.
Am I doing it in query or in macro?
I'm quite new to the programming part of access, so could you please help me
with it?

Thanks again,
Anna

KARL DEWEY said:
UNTESTED --
Build status table like this --
Step Status_ Status
1 1 Waiting on Scheduling
2 2 Approved
2 3 Cancelled
3 4 Completed
3 5 Contracted Out
3 6 Cancelled

Use a ListBox with the following source --
SELECT Status_, Status FROM STATUS WHERE STEP =
IIF([Forms]![YourFormName]![YourListBoxName] = 1, 2,
IIF([Forms]![YourFormName]![YourListBoxName] = 2, 3))

Default -- 1

--
KARL DEWEY
Build a little - Test a little


Anna said:
I am building work orders database and I have status list table that attached
to the WO form as combo box.
What I am looking for is to be able to organize the status in particular
order with no option to go back to previous status(step):
Step 1-Waiting on Scheduling

Step 2- Approved
or
Cancelled

Step 3- Completed
or
Contracted Out
or
Cancelled
Is it possible to do so?
Click to expand...
Click to expand...
Click to expand...
 
Now I have on the form combo box for the status and I need that it will show
the actual status name and not the step or the number. Can I replace the
number (1,2,3) to the name of the status wiht the default "waiting on
scheduling"?

Thank you very much again,
Anna


KARL DEWEY said:
Neither. Use a ListBox on your data entry form instead of a textbox. Open
your form in design view, click on menu VIEW - Properties. If you are using
a textbox now then delete it and replace with a listbox.

In the properties of the listbox enter your field name as Control Source
(you type it or select from field list by expanding the pulldown on the
right). Then in the properties of the listbox enter the below as Row Source
(I omited part the first time) --
SELECT Status_, Status FROM STATUS WHERE STEP =
IIF([Forms]![YourFormName]![YourListBoxName] = 1, 2,
IIF([Forms]![YourFormName]![YourListBoxName] = 2 OR
[Forms]![YourFormName]![YourListBoxName] = 3, 3))


--
KARL DEWEY
Build a little - Test a little


Anna said:
Thank you for the reply.
Am I doing it in query or in macro?
I'm quite new to the programming part of access, so could you please help me
with it?

Thanks again,
Anna

KARL DEWEY said:
UNTESTED --
Build status table like this --
Step Status_ Status
1 1 Waiting on Scheduling
2 2 Approved
2 3 Cancelled
3 4 Completed
3 5 Contracted Out
3 6 Cancelled

Use a ListBox with the following source --
SELECT Status_, Status FROM STATUS WHERE STEP =
IIF([Forms]![YourFormName]![YourListBoxName] = 1, 2,
IIF([Forms]![YourFormName]![YourListBoxName] = 2, 3))

Default -- 1

--
KARL DEWEY
Build a little - Test a little


:

I am building work orders database and I have status list table that attached
to the WO form as combo box.
What I am looking for is to be able to organize the status in particular
order with no option to go back to previous status(step):
Step 1-Waiting on Scheduling

Step 2- Approved
or
Cancelled

Step 3- Completed
or
Contracted Out
or
Cancelled
Is it possible to do so?
Click to expand...
Click to expand...
Click to expand...
 
Set the ComboBox properties as below --
Column Count - 2
Column Heads - No
Column Widths - 0"; 1.5"
Bound Column - 1
List Rows - 4
List Width - 2"

You might want to adjust the widths some.
--
KARL DEWEY
Build a little - Test a little


Anna said:
Now I have on the form combo box for the status and I need that it will show
the actual status name and not the step or the number. Can I replace the
number (1,2,3) to the name of the status wiht the default "waiting on
scheduling"?

Thank you very much again,
Anna


KARL DEWEY said:
Neither. Use a ListBox on your data entry form instead of a textbox. Open
your form in design view, click on menu VIEW - Properties. If you are using
a textbox now then delete it and replace with a listbox.

In the properties of the listbox enter your field name as Control Source
(you type it or select from field list by expanding the pulldown on the
right). Then in the properties of the listbox enter the below as Row Source
(I omited part the first time) --
SELECT Status_, Status FROM STATUS WHERE STEP =
IIF([Forms]![YourFormName]![YourListBoxName] = 1, 2,
IIF([Forms]![YourFormName]![YourListBoxName] = 2 OR
[Forms]![YourFormName]![YourListBoxName] = 3, 3))


--
KARL DEWEY
Build a little - Test a little


Anna said:
Thank you for the reply.
Am I doing it in query or in macro?
I'm quite new to the programming part of access, so could you please help me
with it?

Thanks again,
Anna

:

UNTESTED --
Build status table like this --
Step Status_ Status
1 1 Waiting on Scheduling
2 2 Approved
2 3 Cancelled
3 4 Completed
3 5 Contracted Out
3 6 Cancelled

Use a ListBox with the following source --
SELECT Status_, Status FROM STATUS WHERE STEP =
IIF([Forms]![YourFormName]![YourListBoxName] = 1, 2,
IIF([Forms]![YourFormName]![YourListBoxName] = 2, 3))

Default -- 1

--
KARL DEWEY
Build a little - Test a little


:

I am building work orders database and I have status list table that attached
to the WO form as combo box.
What I am looking for is to be able to organize the status in particular
order with no option to go back to previous status(step):
Step 1-Waiting on Scheduling

Step 2- Approved
or
Cancelled

Step 3- Completed
or
Contracted Out
or
Cancelled
Is it possible to do so?
Click to expand...
Click to expand...
Click to expand...
 
Karl thank you for the help and the patience.
I tried to do as you told me: I have created the status table, but when I'm
trying to update the row source of the combobox it is asking me for "You
invoice the query builder on a table, do you want to create a query?". When I
press No, I can't do anything else further.

What am I doing wrong?


KARL DEWEY said:
Set the ComboBox properties as below --
Column Count - 2
Column Heads - No
Column Widths - 0"; 1.5"
Bound Column - 1
List Rows - 4
List Width - 2"

You might want to adjust the widths some.
--
KARL DEWEY
Build a little - Test a little


Anna said:
Now I have on the form combo box for the status and I need that it will show
the actual status name and not the step or the number. Can I replace the
number (1,2,3) to the name of the status wiht the default "waiting on
scheduling"?

Thank you very much again,
Anna


KARL DEWEY said:
Neither. Use a ListBox on your data entry form instead of a textbox. Open
your form in design view, click on menu VIEW - Properties. If you are using
a textbox now then delete it and replace with a listbox.

In the properties of the listbox enter your field name as Control Source
(you type it or select from field list by expanding the pulldown on the
right). Then in the properties of the listbox enter the below as Row Source
(I omited part the first time) --
SELECT Status_, Status FROM STATUS WHERE STEP =
IIF([Forms]![YourFormName]![YourListBoxName] = 1, 2,
IIF([Forms]![YourFormName]![YourListBoxName] = 2 OR
[Forms]![YourFormName]![YourListBoxName] = 3, 3))


--
KARL DEWEY
Build a little - Test a little


:

Thank you for the reply.
Am I doing it in query or in macro?
I'm quite new to the programming part of access, so could you please help me
with it?

Thanks again,
Anna

:

UNTESTED --
Build status table like this --
Step Status_ Status
1 1 Waiting on Scheduling
2 2 Approved
2 3 Cancelled
3 4 Completed
3 5 Contracted Out
3 6 Cancelled

Use a ListBox with the following source --
SELECT Status_, Status FROM STATUS WHERE STEP =
IIF([Forms]![YourFormName]![YourListBoxName] = 1, 2,
IIF([Forms]![YourFormName]![YourListBoxName] = 2, 3))

Default -- 1

--
KARL DEWEY
Build a little - Test a little


:

I am building work orders database and I have status list table that attached
to the WO form as combo box.
What I am looking for is to be able to organize the status in particular
order with no option to go back to previous status(step):
Step 1-Waiting on Scheduling

Step 2- Approved
or
Cancelled

Step 3- Completed
or
Contracted Out
or
Cancelled
Is it possible to do so?
Click to expand...
Click to expand...
Click to expand...
 
As I said this is untested.
Does your get data from a query or directly from the table? That might make
a difference. I always use a query.
--
KARL DEWEY
Build a little - Test a little


Anna said:
Karl thank you for the help and the patience.
I tried to do as you told me: I have created the status table, but when I'm
trying to update the row source of the combobox it is asking me for "You
invoice the query builder on a table, do you want to create a query?". When I
press No, I can't do anything else further.

What am I doing wrong?


KARL DEWEY said:
Set the ComboBox properties as below --
Column Count - 2
Column Heads - No
Column Widths - 0"; 1.5"
Bound Column - 1
List Rows - 4
List Width - 2"

You might want to adjust the widths some.
--
KARL DEWEY
Build a little - Test a little


Anna said:
Now I have on the form combo box for the status and I need that it will show
the actual status name and not the step or the number. Can I replace the
number (1,2,3) to the name of the status wiht the default "waiting on
scheduling"?

Thank you very much again,
Anna


:

Neither. Use a ListBox on your data entry form instead of a textbox. Open
your form in design view, click on menu VIEW - Properties. If you are using
a textbox now then delete it and replace with a listbox.

In the properties of the listbox enter your field name as Control Source
(you type it or select from field list by expanding the pulldown on the
right). Then in the properties of the listbox enter the below as Row Source
(I omited part the first time) --
SELECT Status_, Status FROM STATUS WHERE STEP =
IIF([Forms]![YourFormName]![YourListBoxName] = 1, 2,
IIF([Forms]![YourFormName]![YourListBoxName] = 2 OR
[Forms]![YourFormName]![YourListBoxName] = 3, 3))


--
KARL DEWEY
Build a little - Test a little


:

Thank you for the reply.
Am I doing it in query or in macro?
I'm quite new to the programming part of access, so could you please help me
with it?

Thanks again,
Anna

:

UNTESTED --
Build status table like this --
Step Status_ Status
1 1 Waiting on Scheduling
2 2 Approved
2 3 Cancelled
3 4 Completed
3 5 Contracted Out
3 6 Cancelled

Use a ListBox with the following source --
SELECT Status_, Status FROM STATUS WHERE STEP =
IIF([Forms]![YourFormName]![YourListBoxName] = 1, 2,
IIF([Forms]![YourFormName]![YourListBoxName] = 2, 3))

Default -- 1

--
KARL DEWEY
Build a little - Test a little


:

I am building work orders database and I have status list table that attached
to the WO form as combo box.
What I am looking for is to be able to organize the status in particular
order with no option to go back to previous status(step):
Step 1-Waiting on Scheduling

Step 2- Approved
or
Cancelled

Step 3- Completed
or
Contracted Out
or
Cancelled
Is it possible to do so?
Click to expand...
Click to expand...
Click to expand...
 
I did the query. Thit is the SQL:
SELECT qryStatusListTry.Status_, qryStatusListTry.Status
FROM qryStatusListTry
WHERE
(((qryStatusListTry.Step)=IIf([Forms]![frmWork_Orders]![Status]=1,2,IIf([Forms]![frmWork_Orders]![Status]=2 Or [Forms]![frmWork_Orders]![Status]=3,3))));

But in the form, when I'm trying to change the status is giving an error:
"circular reference caused by "qryStatusListTry", and the combobx is empty.

Thanks again for the help.

KARL DEWEY said:
As I said this is untested.
Does your get data from a query or directly from the table? That might make
a difference. I always use a query.
--
KARL DEWEY
Build a little - Test a little


Anna said:
Karl thank you for the help and the patience.
I tried to do as you told me: I have created the status table, but when I'm
trying to update the row source of the combobox it is asking me for "You
invoice the query builder on a table, do you want to create a query?". When I
press No, I can't do anything else further.

What am I doing wrong?


KARL DEWEY said:
Set the ComboBox properties as below --
Column Count - 2
Column Heads - No
Column Widths - 0"; 1.5"
Bound Column - 1
List Rows - 4
List Width - 2"

You might want to adjust the widths some.
--
KARL DEWEY
Build a little - Test a little


:

Now I have on the form combo box for the status and I need that it will show
the actual status name and not the step or the number. Can I replace the
number (1,2,3) to the name of the status wiht the default "waiting on
scheduling"?

Thank you very much again,
Anna


:

Neither. Use a ListBox on your data entry form instead of a textbox. Open
your form in design view, click on menu VIEW - Properties. If you are using
a textbox now then delete it and replace with a listbox.

In the properties of the listbox enter your field name as Control Source
(you type it or select from field list by expanding the pulldown on the
right). Then in the properties of the listbox enter the below as Row Source
(I omited part the first time) --
SELECT Status_, Status FROM STATUS WHERE STEP =
IIF([Forms]![YourFormName]![YourListBoxName] = 1, 2,
IIF([Forms]![YourFormName]![YourListBoxName] = 2 OR
[Forms]![YourFormName]![YourListBoxName] = 3, 3))


--
KARL DEWEY
Build a little - Test a little


:

Thank you for the reply.
Am I doing it in query or in macro?
I'm quite new to the programming part of access, so could you please help me
with it?

Thanks again,
Anna

:

UNTESTED --
Build status table like this --
Step Status_ Status
1 1 Waiting on Scheduling
2 2 Approved
2 3 Cancelled
3 4 Completed
3 5 Contracted Out
3 6 Cancelled

Use a ListBox with the following source --
SELECT Status_, Status FROM STATUS WHERE STEP =
IIF([Forms]![YourFormName]![YourListBoxName] = 1, 2,
IIF([Forms]![YourFormName]![YourListBoxName] = 2, 3))

Default -- 1

--
KARL DEWEY
Build a little - Test a little


:

I am building work orders database and I have status list table that attached
to the WO form as combo box.
What I am looking for is to be able to organize the status in particular
order with no option to go back to previous status(step):
Step 1-Waiting on Scheduling

Step 2- Approved
or
Cancelled

Step 3- Completed
or
Contracted Out
or
Cancelled
Is it possible to do so?
Click to expand...
Click to expand...
Click to expand...
 
Does your get data from a query or directly from the table?
What is the Record source of the form. A form may have the name of a query
in the record source or a select statement in the record source.
The select statement I gave to you was for the list box and not for the
form. It was not to be used as a query even though it looks like the SQL
from a query.

Again differently - The form would have a query as the record source. The
list box would have the field from that query as control source but have the
select statement I gave you as row source.
--
KARL DEWEY
Build a little - Test a little


Anna said:
I did the query. Thit is the SQL:
SELECT qryStatusListTry.Status_, qryStatusListTry.Status
FROM qryStatusListTry
WHERE
(((qryStatusListTry.Step)=IIf([Forms]![frmWork_Orders]![Status]=1,2,IIf([Forms]![frmWork_Orders]![Status]=2 Or [Forms]![frmWork_Orders]![Status]=3,3))));

But in the form, when I'm trying to change the status is giving an error:
"circular reference caused by "qryStatusListTry", and the combobx is empty.

Thanks again for the help.

KARL DEWEY said:
As I said this is untested.
Does your get data from a query or directly from the table? That might make
a difference. I always use a query.
--
KARL DEWEY
Build a little - Test a little


Anna said:
Karl thank you for the help and the patience.
I tried to do as you told me: I have created the status table, but when I'm
trying to update the row source of the combobox it is asking me for "You
invoice the query builder on a table, do you want to create a query?". When I
press No, I can't do anything else further.

What am I doing wrong?


:

Set the ComboBox properties as below --
Column Count - 2
Column Heads - No
Column Widths - 0"; 1.5"
Bound Column - 1
List Rows - 4
List Width - 2"

You might want to adjust the widths some.
--
KARL DEWEY
Build a little - Test a little


:

Now I have on the form combo box for the status and I need that it will show
the actual status name and not the step or the number. Can I replace the
number (1,2,3) to the name of the status wiht the default "waiting on
scheduling"?

Thank you very much again,
Anna


:

Neither. Use a ListBox on your data entry form instead of a textbox. Open
your form in design view, click on menu VIEW - Properties. If you are using
a textbox now then delete it and replace with a listbox.

In the properties of the listbox enter your field name as Control Source
(you type it or select from field list by expanding the pulldown on the
right). Then in the properties of the listbox enter the below as Row Source
(I omited part the first time) --
SELECT Status_, Status FROM STATUS WHERE STEP =
IIF([Forms]![YourFormName]![YourListBoxName] = 1, 2,
IIF([Forms]![YourFormName]![YourListBoxName] = 2 OR
[Forms]![YourFormName]![YourListBoxName] = 3, 3))


--
KARL DEWEY
Build a little - Test a little


:

Thank you for the reply.
Am I doing it in query or in macro?
I'm quite new to the programming part of access, so could you please help me
with it?

Thanks again,
Anna

:

UNTESTED --
Build status table like this --
Step Status_ Status
1 1 Waiting on Scheduling
2 2 Approved
2 3 Cancelled
3 4 Completed
3 5 Contracted Out
3 6 Cancelled

Use a ListBox with the following source --
SELECT Status_, Status FROM STATUS WHERE STEP =
IIF([Forms]![YourFormName]![YourListBoxName] = 1, 2,
IIF([Forms]![YourFormName]![YourListBoxName] = 2, 3))

Default -- 1

--
KARL DEWEY
Build a little - Test a little


:

I am building work orders database and I have status list table that attached
to the WO form as combo box.
What I am looking for is to be able to organize the status in particular
order with no option to go back to previous status(step):
Step 1-Waiting on Scheduling

Step 2- Approved
or
Cancelled

Step 3- Completed
or
Contracted Out
or
Cancelled
Is it possible to do so?
Click to expand...
Click to expand...
Click to expand...
 
that is the row source for the combobox and not for the form.

KARL DEWEY said:
What is the Record source of the form. A form may have the name of a query
in the record source or a select statement in the record source.
The select statement I gave to you was for the list box and not for the
form. It was not to be used as a query even though it looks like the SQL
from a query.

Again differently - The form would have a query as the record source. The
list box would have the field from that query as control source but have the
select statement I gave you as row source.
--
KARL DEWEY
Build a little - Test a little


Anna said:
I did the query. Thit is the SQL:
SELECT qryStatusListTry.Status_, qryStatusListTry.Status
FROM qryStatusListTry
WHERE
(((qryStatusListTry.Step)=IIf([Forms]![frmWork_Orders]![Status]=1,2,IIf([Forms]![frmWork_Orders]![Status]=2 Or [Forms]![frmWork_Orders]![Status]=3,3))));

But in the form, when I'm trying to change the status is giving an error:
"circular reference caused by "qryStatusListTry", and the combobx is empty.

Thanks again for the help.

KARL DEWEY said:
As I said this is untested.
Does your get data from a query or directly from the table? That might make
a difference. I always use a query.
--
KARL DEWEY
Build a little - Test a little


:

Karl thank you for the help and the patience.
I tried to do as you told me: I have created the status table, but when I'm
trying to update the row source of the combobox it is asking me for "You
invoice the query builder on a table, do you want to create a query?". When I
press No, I can't do anything else further.

What am I doing wrong?


:

Set the ComboBox properties as below --
Column Count - 2
Column Heads - No
Column Widths - 0"; 1.5"
Bound Column - 1
List Rows - 4
List Width - 2"

You might want to adjust the widths some.
--
KARL DEWEY
Build a little - Test a little


:

Now I have on the form combo box for the status and I need that it will show
the actual status name and not the step or the number. Can I replace the
number (1,2,3) to the name of the status wiht the default "waiting on
scheduling"?

Thank you very much again,
Anna


:

Neither. Use a ListBox on your data entry form instead of a textbox. Open
your form in design view, click on menu VIEW - Properties. If you are using
a textbox now then delete it and replace with a listbox.

In the properties of the listbox enter your field name as Control Source
(you type it or select from field list by expanding the pulldown on the
right). Then in the properties of the listbox enter the below as Row Source
(I omited part the first time) --
SELECT Status_, Status FROM STATUS WHERE STEP =
IIF([Forms]![YourFormName]![YourListBoxName] = 1, 2,
IIF([Forms]![YourFormName]![YourListBoxName] = 2 OR
[Forms]![YourFormName]![YourListBoxName] = 3, 3))


--
KARL DEWEY
Build a little - Test a little


:

Thank you for the reply.
Am I doing it in query or in macro?
I'm quite new to the programming part of access, so could you please help me
with it?

Thanks again,
Anna

:

UNTESTED --
Build status table like this --
Step Status_ Status
1 1 Waiting on Scheduling
2 2 Approved
2 3 Cancelled
3 4 Completed
3 5 Contracted Out
3 6 Cancelled

Use a ListBox with the following source --
SELECT Status_, Status FROM STATUS WHERE STEP =
IIF([Forms]![YourFormName]![YourListBoxName] = 1, 2,
IIF([Forms]![YourFormName]![YourListBoxName] = 2, 3))

Default -- 1

--
KARL DEWEY
Build a little - Test a little


:

I am building work orders database and I have status list table that attached
to the WO form as combo box.
What I am looking for is to be able to organize the status in particular
order with no option to go back to previous status(step):
Step 1-Waiting on Scheduling

Step 2- Approved
or
Cancelled

Step 3- Completed
or
Contracted Out
or
Cancelled
Is it possible to do so?
Click to expand...
Click to expand...
Click to expand...
 
In your last post it looks like you may have created a query from the select
statement I gave you.
You said "I did the query. Thit is the SQL:
SELECT qryStatusListTry.Status_, qryStatusListTry.Status ....."

'qryStatusListTry.Status_, ' seems like you are using a query here instead
of the status table. I would think that you would name the status table
'qryStatusListTry' but something like MyStatus or StatusSteps.
--
KARL DEWEY
Build a little - Test a little


Anna said:
that is the row source for the combobox and not for the form.

KARL DEWEY said:
Does your get data from a query or directly from the table?
Click to expand...
What is the Record source of the form. A form may have the name of a query
in the record source or a select statement in the record source.
The select statement I gave to you was for the list box and not for the
form. It was not to be used as a query even though it looks like the SQL
from a query.

Again differently - The form would have a query as the record source. The
list box would have the field from that query as control source but have the
select statement I gave you as row source.
--
KARL DEWEY
Build a little - Test a little


Anna said:
I did the query. Thit is the SQL:
SELECT qryStatusListTry.Status_, qryStatusListTry.Status
FROM qryStatusListTry
WHERE
(((qryStatusListTry.Step)=IIf([Forms]![frmWork_Orders]![Status]=1,2,IIf([Forms]![frmWork_Orders]![Status]=2 Or [Forms]![frmWork_Orders]![Status]=3,3))));

But in the form, when I'm trying to change the status is giving an error:
"circular reference caused by "qryStatusListTry", and the combobx is empty.

Thanks again for the help.

:

As I said this is untested.
Does your get data from a query or directly from the table? That might make
a difference. I always use a query.
--
KARL DEWEY
Build a little - Test a little


:

Karl thank you for the help and the patience.
I tried to do as you told me: I have created the status table, but when I'm
trying to update the row source of the combobox it is asking me for "You
invoice the query builder on a table, do you want to create a query?". When I
press No, I can't do anything else further.

What am I doing wrong?


:

Set the ComboBox properties as below --
Column Count - 2
Column Heads - No
Column Widths - 0"; 1.5"
Bound Column - 1
List Rows - 4
List Width - 2"

You might want to adjust the widths some.
--
KARL DEWEY
Build a little - Test a little


:

Now I have on the form combo box for the status and I need that it will show
the actual status name and not the step or the number. Can I replace the
number (1,2,3) to the name of the status wiht the default "waiting on
scheduling"?

Thank you very much again,
Anna


:

Neither. Use a ListBox on your data entry form instead of a textbox. Open
your form in design view, click on menu VIEW - Properties. If you are using
a textbox now then delete it and replace with a listbox.

In the properties of the listbox enter your field name as Control Source
(you type it or select from field list by expanding the pulldown on the
right). Then in the properties of the listbox enter the below as Row Source
(I omited part the first time) --
SELECT Status_, Status FROM STATUS WHERE STEP =
IIF([Forms]![YourFormName]![YourListBoxName] = 1, 2,
IIF([Forms]![YourFormName]![YourListBoxName] = 2 OR
[Forms]![YourFormName]![YourListBoxName] = 3, 3))


--
KARL DEWEY
Build a little - Test a little


:

Thank you for the reply.
Am I doing it in query or in macro?
I'm quite new to the programming part of access, so could you please help me
with it?

Thanks again,
Anna

:

UNTESTED --
Build status table like this --
Step Status_ Status
1 1 Waiting on Scheduling
2 2 Approved
2 3 Cancelled
3 4 Completed
3 5 Contracted Out
3 6 Cancelled

Use a ListBox with the following source --
SELECT Status_, Status FROM STATUS WHERE STEP =
IIF([Forms]![YourFormName]![YourListBoxName] = 1, 2,
IIF([Forms]![YourFormName]![YourListBoxName] = 2, 3))

Default -- 1

--
KARL DEWEY
Build a little - Test a little


:

I am building work orders database and I have status list table that attached
to the WO form as combo box.
What I am looking for is to be able to organize the status in particular
order with no option to go back to previous status(step):
Step 1-Waiting on Scheduling

Step 2- Approved
or
Cancelled

Step 3- Completed
or
Contracted Out
or
Cancelled
Is it possible to do so?
Click to expand...
Click to expand...
Click to expand...
 
Karl, thank you very much. I will try to do it from the beginning because I'm
sure that I'm missing something and let you know.

Thank a lot,
Anna

KARL DEWEY said:
In your last post it looks like you may have created a query from the select
statement I gave you.
You said "I did the query. Thit is the SQL:
SELECT qryStatusListTry.Status_, qryStatusListTry.Status ....."

'qryStatusListTry.Status_, ' seems like you are using a query here instead
of the status table. I would think that you would name the status table
'qryStatusListTry' but something like MyStatus or StatusSteps.
--
KARL DEWEY
Build a little - Test a little


Anna said:
that is the row source for the combobox and not for the form.

KARL DEWEY said:
Does your get data from a query or directly from the table?
What is the Record source of the form. A form may have the name of a query
in the record source or a select statement in the record source.
The select statement I gave to you was for the list box and not for the
form. It was not to be used as a query even though it looks like the SQL
from a query.

Again differently - The form would have a query as the record source. The
list box would have the field from that query as control source but have the
select statement I gave you as row source.
--
KARL DEWEY
Build a little - Test a little


:

I did the query. Thit is the SQL:
SELECT qryStatusListTry.Status_, qryStatusListTry.Status
FROM qryStatusListTry
WHERE
(((qryStatusListTry.Step)=IIf([Forms]![frmWork_Orders]![Status]=1,2,IIf([Forms]![frmWork_Orders]![Status]=2 Or [Forms]![frmWork_Orders]![Status]=3,3))));

But in the form, when I'm trying to change the status is giving an error:
"circular reference caused by "qryStatusListTry", and the combobx is empty.

Thanks again for the help.

:

As I said this is untested.
Does your get data from a query or directly from the table? That might make
a difference. I always use a query.
--
KARL DEWEY
Build a little - Test a little


:

Karl thank you for the help and the patience.
I tried to do as you told me: I have created the status table, but when I'm
trying to update the row source of the combobox it is asking me for "You
invoice the query builder on a table, do you want to create a query?". When I
press No, I can't do anything else further.

What am I doing wrong?


:

Set the ComboBox properties as below --
Column Count - 2
Column Heads - No
Column Widths - 0"; 1.5"
Bound Column - 1
List Rows - 4
List Width - 2"

You might want to adjust the widths some.
--
KARL DEWEY
Build a little - Test a little


:

Now I have on the form combo box for the status and I need that it will show
the actual status name and not the step or the number. Can I replace the
number (1,2,3) to the name of the status wiht the default "waiting on
scheduling"?

Thank you very much again,
Anna


:

Neither. Use a ListBox on your data entry form instead of a textbox. Open
your form in design view, click on menu VIEW - Properties. If you are using
a textbox now then delete it and replace with a listbox.

In the properties of the listbox enter your field name as Control Source
(you type it or select from field list by expanding the pulldown on the
right). Then in the properties of the listbox enter the below as Row Source
(I omited part the first time) --
SELECT Status_, Status FROM STATUS WHERE STEP =
IIF([Forms]![YourFormName]![YourListBoxName] = 1, 2,
IIF([Forms]![YourFormName]![YourListBoxName] = 2 OR
[Forms]![YourFormName]![YourListBoxName] = 3, 3))


--
KARL DEWEY
Build a little - Test a little


:

Thank you for the reply.
Am I doing it in query or in macro?
I'm quite new to the programming part of access, so could you please help me
with it?

Thanks again,
Anna

:

UNTESTED --
Build status table like this --
Step Status_ Status
1 1 Waiting on Scheduling
2 2 Approved
2 3 Cancelled
3 4 Completed
3 5 Contracted Out
3 6 Cancelled

Use a ListBox with the following source --
SELECT Status_, Status FROM STATUS WHERE STEP =
IIF([Forms]![YourFormName]![YourListBoxName] = 1, 2,
IIF([Forms]![YourFormName]![YourListBoxName] = 2, 3))

Default -- 1

--
KARL DEWEY
Build a little - Test a little


:

I am building work orders database and I have status list table that attached
to the WO form as combo box.
What I am looking for is to be able to organize the status in particular
order with no option to go back to previous status(step):
Step 1-Waiting on Scheduling

Step 2- Approved
or
Cancelled

Step 3- Completed
or
Contracted Out
or
Cancelled
Is it possible to do so?
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Limit data in field to within 90 days of another field... 4
1) Run query through a table and 2) keep (or throw away) records 3
Access MS access forms list box problems 1
Help with complex query 1
Need help with creating condition to produce follow-up list in Acc 1
Excel Urgent help in Excel / Access Report 0
Need to Count by two different criteria in same Totals query 4
Querys using combo boxes 4

Back
Top