Help with Postal-System Database

[AccessBoy]

Hi guys. I work at this accounting firm and I was asked to computerise the postal system as they know I have some Microsoft Access experience (very little, but some!).



So I went ahead and designed it to the best of my ability on Microsoft Access 2007. When I was showing it to my boss I got yelled at because everytime you use a stamp it doesn't automatically deduct out of the inventory, as I have no idea how to do this. He basically said the system is useless unless this can be done and a warning given everytime there is 5 or less of a stamp in stock.

I do know that to do this the structure will probably need changing. Anyway I have uploaded my system here,

http://www.mediafire.com/?oznnzz2lcjo

any help would be greatly appreciated.

Thanks for reading!

[NassauBob]

So are you specifically hired there as an IT dude? If no, I'd remind him of that before he gets his blood pressure up again!

Anyway, you have two different tasks to work here. First, you want to design an update query, which subtracts number of stamps used each time the Outgoing Post SEND button is pressed. Just have the query run from the on_click event of the button. In the criteria field of the update query should be code to subtract the number value in the form field for stamps used from the current total for that stamp type.

Second, you want a warning alert when stamps have hit a predetermined low limit. This can be done with a simple messagebox statement, again in the on_click event of the SEND button. Run another bit of code, an IF statement that will fire a messagebox IF the count of that stamp type hits the low level. Note: this IF statement MUST be run after the inventory has been updated to reflect this transaction's usage! messagebox code will include message title, text value, and button type(s).

Is that clear as mud?

[AccessBoy]

Thanks for your reply!

So are you specifically hired there as an IT dude? If no, I'd remind him of that before he gets his blood pressure up again!

No, I'm just doing a placement year here for an accounting course. I actually got quite upset because I designed this last weekend and tried really hard.

First, you want to design an update query, which subtracts number of stamps used each time the Outgoing Post SEND button is pressed. Just have the query run from the on_click event of the button. In the criteria field of the update query should be code to subtract the number value in the form field for stamps used from the current total for that stamp type.

Unfortunately I have no VB coding experience so I have no idea what expression to use, or even how to design this update query to get the number of stamps used subtracted.

Any further help would be greatly appreciated!

[maximus]

hey can you do some thing email details of your database in plain simple terms. Tell me what you want to do nd not how!!. tell me the forms and reports that you need I will design the database for you. post it here or for speedy answer email at silverback_bats@yahoo.co.in

[AccessBoy]

All I'm trying to do is computerise the post system (ie record incoming and outgoing mail) so that it is searchable by date (and perhaps name).

I'm sure you will get a good idea by downloading what I've already done here, http://www.mediafire.com/?oznnzz2lcjo.

I need the stamp inventory to reduce every time a stamp is used on the outgoing post form and for a warning to appear when there is a low number (say 5) of stamps in stock.

Thanks!

[maximus]

Download you work need 3 days to build the database. Get back to you on Monday. I hope you can wait till then. if not let me know.

[AccessBoy]

Download you work need 3 days to build the database. Get back to you on Monday. I hope you can wait till then. if not let me know.

Wow thanks! Sure I can wait until monday.

Thanks again.

[maximus]

I have almost finished working on it can you answer a question for me will you require to print reports for stamp inventory.

[AccessBoy]

I have almost finished working on it can you answer a question for me will you require to print reports for stamp inventory.

Hi! No, that's not really necessary.

Thanks so much for this, I truly appreciate your help, (and all the previous posters aswell ofcourse!)

[maximus]

Will be uploading you database in 1 hrs time.

[maximus]

I am attaching a database. I build it in a very short time and didnot get an opportunity to check properly. your user name is Accessboy and password is maximus.A login form will open select user name type password in the text box and click login. This is the structure in which you can build on due to lack of time I could not include more features like user group privileges where you can assign rights to users.I have not been able to prepare a user manual for you instructions are on the forms follow them if you want I can built the next level of this database with more improved features.

let me know what you think about the db

maximus

[AccessBoy]

Unfortunately, I cannot seem to log in.

Any tips?

Thanks!

[maximus]

Select User Accessboy and then type Maximus and click on Log in button. A message box will open with a prompt Welcome to Postal database Click OK and then Main Menu form will open. If you are getting errors tell me. To see the structure as you are using Access 2007 make navigation Pane Visible.

[AccessBoy]

Select User Accessboy and then type Maximus and click on Log in button. A message box will open with a prompt Welcome to Postal database Click OK and then Main Menu form will open. If you are getting errors tell me. To see the structure as you are using Access 2007 make navigation Pane Visible.

For some reason when I click log in nothing happens. I've tried to show the navigation bar but access options is disabled. Please help!

Thanks!

[maximus]

Well you say nothing is happening thats strange if it is a code problem you should have got errors. i think it is your windows security that is blocking the macros from running. When you start the databse Access gives you an option either to enable or to disable macros. Please enable them. Anyways I attaching the mdb again without the login option.