help with access

[gersheff]

is there anywhere i can post my database and someone can help me work through some of the issues. for me that would be a lot easier than trying to explain it.

 

[commandolomo]

Usually the best way is to provide an explanation of the problems / issues / questions and attach a zipped copy of your db - be sure to remove sensitive & confidential info - to your post

Hey presto, your db and questions are public, and I am sure the resident Access geniuses that grace this boars will provide any help they can - please note I am not one of the Access geniuses!!!

HTH

 

[gersheff]

ok everyone attached is my problem database. there are a couple of issues. the most important one being that the SubstanceTrackingID is not being transfered from the Substance tracking table to the priority source tracking table, and consequently not being passed on to the Instrument/Tool tracking table. As well PrioritySourceID is not being passed on to the Instrument/Tool tracking table.

The way this database works is that you start at the substance tracking form, and follow the buttons.

thank you so much everyone for your help

 

[gersheff]

can noone help me?

 

[john471]

Not AC97

Tried to help; but I'm stuck on Access 97, and therefore can't open your database. Sorry.

 

[ecniv]

Thoughts:

- Read up on naming conventions more
- don't use spacing in the naming of objects, nor special characted like slash
- never ever use macros in Access - use VBA coding (read up on this if you need to)
- the first form doesn't need to be linked to data (its editing a record?)
- try not to link the fields in tables to other tables/queries... mainly because you cannot see the base data, its covered... But that is your choice

+ general table layout seems ok

You need to check the forms data sql statements too...


Good luck


Vince

 

[gersheff]

ok here is the new databse with proper names for most objects and the buttons are now controlled by VBA not macros. thank you.