Fixong errors in Geogetown Drycleaning Services

[Lou_Reed]

http://www.functionx.com/access/Lesson22.htm

The Georgetown Dry Cleaning form as shown in the link above is almost
complete. I have a few errors that I am unable to get rid of.

The first is the "Cleaning OrderID" starts at 2 instead of 1. I do not know
how to change it so it starts at 1. I did not know until five minutes ago it started
at 2 instead of 1. I need to change it.

Secondly in the Order Status combo box, I have one choice misspelled;
it should be picked up, instead of pciked up. Whenever I change it in the


properties area it goes back to the original and incorrect misspelling.

Those are the only two option available for now. How do I permanently
fix them?

Any help appreciated. Thanks in advance.

Respectfully,


Lou_Reed

[ranman256]

you cant change OrderID. They are set by Access and once set ,it's forever.
renumbering them is meaningless. It a reference.

misspellings you can fix in the table.

[June7]

Delete data and run Compact & Repair to reset the autonumber seed. However, as ranman stated, number gaps should be irrelevant in an autonumber field.

You changed what spelling in what property?

[Lou_Reed]

In the choices of order status I have used one term which should read: Picked up. Instead it reads Pciked up
I changed it in the Form in design view in the property section. I simply went in and corrected the spelling. That is all.

It did not help though. It still shows in the combo box : Pciked Up, instead of Picked Up.


How can I change it for good. Period!


Respectfully,


Lou Reed

[June7]

The RowSourceType is ValueList, not Table/Query?

If RowSource is simply like: Picked Up;Not Ready;Lost - changing the RowSource property will not change value already saved into record. Will have to edit the data to fix it.

[Lou_Reed]

How do I edit the data? I want to fix it. You are right - changing the RowSource property will not change value already saved into record. I guess I must edit the data. I went back and changed the value in the Cleaning Orders Table and it did not help either.

I guess the only way to fix this is edit data. But How?

Respectfully,


Lou Reed

[June7]

Open table, go to each record, edit field.

Or run an UPDATE sql action. Use the query designer to help build the query.

UPDATE tablename SET fieldname = "Picked Up" WHERE fieldname="Pciked Up"

[Lou_Reed]

I went in the Cleaning Orders Table and deleted the original filed. I then in created the field as listed in the instruction of this lesson. See top post.

I made sure that the choices were all spelled correctly. I accepted the new table and went to the form and it was there all spelled correctly. No worries.

I then saved the database - it is now saved. I still have the CleaningOrderID starting at 2 instead of 1. That would be nice to fix, make it 1.


Respectfully,


Lou_Reed

[Lou_Reed]

In a similar error I had the familiar #NAME? in the subtotal for item 4 in Cleaning Orders form. I went into the table and noticed this:

quantity item1
quantity item2
quantity item3
quantity item 4

I changed the last entry from quantity item 4 to quantity item4 and it worked. My question is why did it work? I just made it look like the other ones and then
it all fell into place. But why? I realize that quantity item 4 is not the same as quantity item4.


Respectfully,

Lou_Reed

[June7]

Because subtotal must have been an expression that used a field named [quantity item4].

Changing the field name in table carried through to the form RecordSource so now the expression was referencing a valid field name.

[Lou_Reed]

I am almost complete on this tutorial Lesson 22. My only issue is in the Georgetown Dry Cleaning Services form. It does not like
the Net price calculation. I even copied and pasted the txtTaxAmont from the previous calculation (TaxAmount, which knew to be okay) and it still
does not like it!

I am unsure what is wrong. May I compact and post the database so someone on the forum can look at it?



Respectfully,



Lou_Reed

[June7]

Yes, you may.

[Lou_Reed]

Georgetown Dry Cleaning Services.accdb

Okay here is the Georgetown Dry Cleaning Services. The cleaning orders form has an error.

I have isolated to txtTaxAmount. I am not sure what is wrong now.

Thanks in advance.

Respectfully,

Lou_Reed

[June7]

txtNetPrice and txtTaxAmount are not listed alphabetically in the SelectionType dropdown of the Properties Sheet - they are at the top. The names for txtTaxAmount and txtNetPrice have a space in front in the Name property. Remove the space. I didn't even know Access would allow this - and that is why they are listed at top, space sorts before alpha/numeric. Now the controls list alphabetically.

Both controls use Nz() function but do not specify alternate value. Try

=Nz([txtCleaningTotal],0)*Nz([txtTaxRate],0)

=Nz([txtCleaningTotal],0)+Nz([txtTaxAmount],0)

In fact, none of the Nz() expressions in any of the controls provide alternate value, therefore will default to an empty string. An empty string is not valid in arithmetic. Should always specify the alternate value.

[Lou_Reed]

I removed the two spaces and things are fine now. I am not sure why a space in front of a name would be a problem. The name of the calculation is unchanged whether

it has a space in front of it. I am not sure why you wanted to include the ,0 on the variables on the right side of each calculation. It seems that

Nz will do the trick just fine.


Elaborate on this last question. I do not follow your reasoning.


Thanks in advance.


Lou_Reed