[thewebbmasterone]

The other thing that i wanted to do but wasn't sure how, was be able to attach before and after pictures to each entry. So when something was reported you could add a picture from a digital camera of the issue to the entry. And then when the issue is resolved a picture of the are in the proper condition could be added. This was when someone queries the database for spacific entries they can also see pictures that show the before and after conditions. If i add pictures like that, would they become part of the database? or would they have to be in a folder and have links to them in the database? how exactly does that work? Any suggestions on how to set something like this up? if it is possible, i'd like it to be set up so that the pictures were imported into the database so that it was all just one big file. that way there would be no accidental deletion of the pictures.

[OBP]

Yes you can add photos to the database and when you say one BIG file you are not kidding. It is for that reason that we normally recommend just having a the photo's "Path" in the database and then load them as required.
But you can have them in the database as long as you don't mind it getting very large.
You can also have a Search form to locate your Safety concerns as well.

[thewebbmasterone]

Can someone explain to me how to set the record source of a dropdown list on a form, if the list in control source is empty?

thanks

[OBP]

You should try to be clear between what you want as the Record Source and what you want as the Control Source.
The Combo Control Source is the Field on your Form where you want to store your Selection made in the Combo.
The Combo Record Source is where you want to get your List of items for selection.
So you can either use a Table or Query for the Record Source, I usually use a Query.
If you have a Query that is suitable just click on the Record Source in the Combo's Properties and from the drop down select your query.

[thewebbmasterone]

ok sorry, guess i was getting things confused. i have fields with no control source. i can select the information i want but i don't have anywhere to put it. earlier in this thread i was told that all i had to do was select the column from the dropdown list under control source to select where i wanted to store the information. the only problem that i'm having is that i don't have a list under the control source on some of fields in my forms. It is just blank and also has the three dots beside it. i've tried to go and do it by selecting the three dots but that didn't work for me. I'm guessing it's pretty easy and that i'm just missing something simple.

[thewebbmasterone]

can someone explain to me how to set up a bound object box on a form so that if it is selected by the user you will be asked to select an image to insert in the box. Also, i want the image to be displayed in the box and i want it to be saved in a column on a table along with the rest of the record. Does anyone know how to set this up?

[OBP]

Does your Form have a Record Source?
If it does and one of the fields in the Form's Field List is where you want your Combo's data to go make sure that that field is on your form.
When that field is on the form it will appear in the Combo's Control Source Drop down.

[thewebbmasterone]

I dont know what is wrong, i can't figure it out. Can someone download my latest update of my database and see if you can figure out what is wrong with it. if you open up the new safety observation form and look at the different catagories they look fine and work normally except them do not save the information anywhere. I haven't been able to figure out how to set the control source of them to the appropriate field in the Safety observations table. The fields on the form have many different record sources because i have different tables with the information i want to select from on it. What am i doing wrong? help please

[OBP]

Can I ask why you didn't use the last copy of the database that I posted as a Starting point?

[thewebbmasterone]

sorry, i didn't like the layout of it. i have an image in my head of what i want it to look like and that wasn't quite it. I actually broke down and went and bought a book. The ms Access Bible, it seems to have alot of my answers in it and it has a lot of good ideas that i would never have thought of.

[thewebbmasterone]

I have a new problem now. I'm trying to create a column that tell me how long it took to close out a report. I have two columns, Date, and, date verified. Date is the date the report was opened, and date verified is the date that the report is closed. I want to have a third column that will tell me the ammount of time between the two columns. I looked and found a function called DateDiff() and tried to use it but it didn't seem to work. This is the exact string that i put in the default value box under the properties of my third column.

DateDiff("d", [safety.date verified], [safety.date])

I also tried using

=[safety.date verified]-[safety.date]


It all seemed ok to me and it almost matched exactly to some examples i've seen. But, it gave me all kinds of errors when i tried to run it. At first is said something about a syntax error, so i tweaked it a bit and then it told me that it could not find the field [safety.date verified]. So just for fun i switched the two fields in the string and then it came up and told me that it couldn't find the other field. So i must be typing something wrong. Can someone please help. thanks.