Search results for query: *

You can use a common dialog control. drop this onto your form and give it a name such as 'opendlg'. Then you can open up the control with a simple command like this: Me![opendlg].ShowOpen You can get the filename out by using the code below: Me![opendlg].FileName You may want to check that...

Thanks for you help Terry. It looks to be exactly what i want. Cheers, John.

Does anyone know how to add a reference to an object in code. Thanks in advance John.

I have some code that imports and appends a file. does anyone know a way to check that the file exists before the code tries to import it. Thanks, John.

Please could someone point me in the right direction as to how i would embed a web page in an access form. Thanks in advance.

I am using a continuous form on my database. does anyone know how to stop an empty new record listing at the end of the continuous form. Thanks in advance.

Cheers Aivars, it's one solution but it's not ideal for what i require. i really wanted it to insert a date after the user is prompted, before the form is updated rather than each seperate control. An example of what i was trying to do, though which didn't work (as The Dirty function doesn't...

I have a database where i want a date stamp recorded when certain fields are changed/altered. the 'Me.dirty' function is no good for me as it picks up changes on the whole form. is there a way for a record to be date stamped automatically when only certain fields have been altered/are 'dirty'...

Teh only way you can zero an auto number is to delete the field from the table and adding it again. give it exactly the same name again, give it a primaray key again if needed and re link the relationship if necessary. you may have to delete the relationship before you can delete this field.