Search results

Make a (wizard) combo box again when selecting two fields such as FunctionalAreaID and name of Functional Area. Check the Hide Key Column (Recommended). hth, Michael

Are you trying to get total number of hours worked? If so, use this in blank text box..control source. DateDiff("h",[Start Time],[End Time]) hth, Michael

Try saving a picture in a document. Make a command button..Properties..Format Tab..Picture..Trying browsing through folder where you have pictures saved. hth, Michael

I would suggest that you not insert pictures into a table as this will increase the size of your database to an almost unacceptable level. But if you must be careful on your database size. There is information in Access help on how to link to a picture so I would suggest you look there. Since...

I've looked at your database. The reason why you can't get the cascading combo box work is because you made your Wildlife form only from report table. That is why it won't recognize the BirdSpecies table. You can make a query from 2 tables and connect it to a form. I wish I can help you more...

Congratz! I'm glad I can help. :) Michael

I have your database. I'm going to take a look at. I'll have the answer for you tomorrow cause I'm leaving work now. Michael

See attached file. hth, Michael

I'm not sure if you got my private message earlier. If not, try these steps below. Make sure you make a form from your query or table. Add all your fields in a form. Now to cascade combo box you have 2 ways of doing it. Make a blank combo box.... Set your Row Source Type = Table/Query Row...

Try this code in After_Update for a combobox. Me.RecordsetClone.Findfirst "[FieldName] = " & Me![ComboBoxName] Me.Bookmark = Me.RecordSetClone.Bookmark If that doesn't work, than you might want to attach your database so I take a look at it. Michael

Get rid of BirdSpecies! second line after rs.FindFirst hth, Michael

Try again. There's no attachment. Winzip it than attach the file. Michael

Attach your database. Michael

Make a blank text box in a Form. Add this formula in the Control Source =([Sick Until]-[Sick From]) Is that what you're looking for? Michael

Try something like this. Make a query with all your fields you wish to have. Make an extra field for expression. Paste the sample below. DateDiff("y",[DateFieldName1],[DateFieldName2]) DateFieldName1 will subtract from DateFieldName2 and that will give you a total. hth, Michael

You should see a checkbox in a toolbox. hth, Michael

You can search the forum on date calculation. You will find plenty of samples. Especially in a query forum. hth, Michael

You can make a field in a table for Yes/No in Data. Can you be more specific where and why you want to use the radio button? Michael

Make a blank table with 2 fields. Field Name = Picture Data Type = OLE Object Field Name2 = BirdName Data Type = Text Save the table. Run the table in datasheet view Right click on Picture first record. Select Insert Oject. Run through the directory drive and select your picture. Give it a...

Check the link below. http://www.mvps.org/access/reports/rpt0011.htm hth, Michael