Search results

Hi check this this how you should reference between forms/subforms Also note that in this line you have double exclamation mark

try re-linking the table in your FE.

you are welcome :) And welcome to the forums!

probably the line causing the problem is this: lookup_ref = DLookup("[Ref]", "working days table", "[working_day] = start") try lookup_ref = DLookup("[Ref]", "working days table", "[working_day] = '" & start & "'")

Hi, goto tools -> references and make sure you have the reference Microsoft Office XX.X Object Library checked. XX.X being the version of your access database

try hitting the F11 key and it should display the database window.

if you create a sub in a module and place your code there then all you have to do is on the OnMouseDown event put Call YourSubName

check out this link how you should reference forms/subforms.

You should check with this other person as probably he disabled the button on purpose until some criteria is met to enable it.

Congratulations Pat and thank you very much for help and support.

it could be a requery problem.

that happens because probably your combo is "bounded" to just 1 column. If you would like to display the other fields why don't you do that at query level by joining the lookup table in your query. Also you can populate them via a dlookup, however, it is less efficient than the query method.

if the fields are already in the combo box then you should set the column count property to 3 and set the width property as well.

you can go to the form properties and set the "Data Entry" property to Yes

It means that calculated fields are not meant to be stored in tables. You should create a calculated field in your query and then do the math there i.e. your new field would be: NewField: [IDTo] - [IDFrom]

try searching for the DoCmd.TransferSpreadsheet method.

not sure why you want to do this, but you can create a button on a form and from the wizard choose the "duplicate record"

Thank you very much for all the feedback. Actually my original post wasn't related to a particular database i am working on, but i was wondering what approach other developers take in such circumstance. Once again, thank you.

i perfectly agree with you. Once again, Thanks

creating the shortcut and entering the target manually did the trick :) i wonder why in the outlook help file it says: Thanks Minkey