Loads of help needed!!

[Hellfire]

Hi, Most of you have probably noticed that I have been posting rather stupid question all over the Forum today.

I have been struggling with this damned database for weeks now, and I am at the point where I have decided to start all over again. I need Help!

I need a basic database to keep track of parcels delivered to and collected from my offices. This should record the member of staff who handled the parcel as well as when it was collected/delivered and who it was addressed to. That is basically it. The one I have at the moment is working perfectly, but...

1.) I have split the database, the back end on the server, and then three front end (*.MDE) version on the PC's in the postroom. Since this morning, the MDB-file doesn't want to allow me to create new *.MDE files. WHY???!!!!

2.) Certain Courier companies are used on a daily basis, I have there names in a combo-box, but it is not set to "limit to list" since we do use other unknown companies from time to time. How do I change the values in the list, WITHOUT having to change the *.MDE file everytime?

3.) I also have the names (first and last) in ONE Combo box named "recipient" How do I get the text box on the form to automatically "update" when a new name is entered for the first time? ie. John Smith receives a parcel for the first time, next time he receives one, the postroom staff will only start typing Jo*** and his name will pop-up.

This is the only problems I have with the database as it is at the moment. I would REALLY like to get this sorted out, otherwise I will be forced to start again...from nothing!

 

[FloBob]

1. What is it saying when you try to create one?

2. Bind the combo box to a linked table on the BE. That way you just have to add to the table on the BE and wala your combobox will have the new records.

3. See number two just have the MDE update that table on a new entry.


Hope this helps and let me know

 

[Hellfire]

*.MDE

When I try to create an MDE file, All it says is:

Microsoft Access was unable to create an MDE database.

I have no idea how to get around this, it is not crucial that I get to create a new MDE, but, there has been some changes, and if I implement the suggestions you made, I will have to do it once more. Is there a way of forcing Access to create the MDE for you?

 

[Lord Byron]

Hellfire,

I would go with the solution FloBob proposed. If you use a seperate pop-up form to enter the name of the courier company, and you link the dropdown to this table (or possibly a select query on this table to get the result alphabetically).

The third problem could be solved in a similar way. Start of with a table with all the names in it, and create a pop-up form to enter new names. Then use a dropdown on this table.

Hope this helps you.