Access Help Please

[mrstarface]

I've got an Access Database up and running with tables, queries and forms.

The forms are running off queries but I've just realised I've put some fields into the database that arent needed. I need to delete them and any references to them safely. I've tried methodically going through the db and deleting from the queries and the tables but when I open up the forms I get an error message pop us saying Enter Parameter Value as if its looking for the fields I deleted even though I've deleted all the references I can find to them. I do notice however that when I look at the field list on the form they are still there even though I have deleted them?

Can anyone help, please dont tell me I have to do these forms from scratch again, they took bloody ages!

[sdkfz]

Sounds like you ned to edit the references themselves, what version of access is this?

If (like you have said) you have worked your way back through the forms(not mentioned) , queries and tables Ii am not seeing how else the BD can know about the relations.

How big is this DB? can you e mail it?

[mrstarface]

Cheers for the reply, its using access 2000 and its about 900k in total so can e-mail it if you can take a look.

Its nowhere near finished, sort of an early version but its the Customer Order Details and Customer Order Details Subform that throw up the error messages.

If you can tkae a look be much appreciated, doing this for a friend and my knowledge of access aint what it used to be (havent touched it for 2 years!)

[doctorgonzo]

One major source of those "Enter Parameter" problems when you are deleting fields from a form or report is the "Sort By" value. If you, for example, delete the field [Last Name] from a form or report, but you have set the form or report to sort by that field, you will get the "Enter Parameter" box.

You can e-mail to me if you want and I will take a look: doctorgonzo@stones.com

[mrstarface]

Thanks for the offer doctorgonzo will take you up on that! You should find the (badly written) db in your inbox anytime now

[doctorgonzo]

I'm assuming you were having problems with the "After Discount" and "Total" fields on the Customer Orders subform. Those fields were still in the RecordSource property of the subform, so thaty's where the problem was. I e-mailed your database back to you with the change.

[mrstarface]

They were the ones, cheers Doctor G, will go and pick that up now

[sdkfz]

Dr, once again you have the answer, thanks for looking at that, I was really busy and did not have a chance to get back to this thread till now.

[mrstarface]

Sorry me again....need some more help!

Basically I dont think I've designed this DB in the best possible way and the idea of starting from scratch again fills me with dread as been working on this for a while now.

I cant find a decent way to input a customer order! I have an order table (containing order details) and an order line table (containing amounts and products). The idea was I could build a form to input an order for a customer and record the employee who took the order. With the customer and employee data being completed automatically via a drop down.

But no matter how many ways I try I cant get a working form, I think my relationships are set out right but something obviously isnt right somewhere.

And there was me thinking I'd got the hang of it.........

Can one of you guys be kind enough to help me out again?

[doctorgonzo]

It's not that hard to do. You can nest subforms, which is one way to do it.

Main form: Customer info
Subform of main form: Order info
Subform of subform: Order details.

It looks like your relationships are set correctly. Try setting it up this way, and if it doesn't work, come back and explain what happens. Sometimes minor tweaks need to be made.

[mrstarface]

OK I've got my 1 main form and 2 subforms up and running and they seem to work fine.

But how can I do the drop down for products? When I get to those fields I have to type in the code which then brings the description and price up (e.g. I enter Product Code 2 and when I tab to the description and price fields it then displays what they are) but I want to display the item description and price and select from a drop down so its a bit more user friendly?

[doctorgonzo]

I'm not sure I understand what you are trying to do. It sounds like you want the description and price in the dropdown menu, so people can select things without using the product code. It is easy to put more than one column in a combo box. Just use the Row Source property to select the fields you want to display, as well as the field you want to store.