Search results

you're welcome :)

All you need to do is to go the the form design view, go to it's properties and change the Record Source property to the table you wish to use. However, make sure that you take the advice suggested by the previous posters, as i'm afraid your data is not normalized.

I don't think it is possible. What you can try to do is instead of using the enabled property use the Locked property and set it to yes, change the background to grey to make it resemble a disabled field and disable also the tabstop. Maybe someone else can come up with a better solution.

you're welcome, glad we could help :)

you should base your report on a query and then use the combo box selection as a criteria for your query. i.e. in the criteria field of your query put [Forms]![FormName]![ComboSelectionName]

:D testtesttest

In the Form Properties set the DataEntry property to "Yes"

You can use the "Record Lock" property in the form properties window to lock the records

To send a PM click on the UserCp and from the left hand side menu click on Send New Message. I would also suggest you deleting this thread in the meantime from the Thread Tools drop down, so that it won't serve as an ad that you have company data uploaded.

Congratulations RuralGuy. Thanks for your support.

you may try something like the following: SELECT table1.field1, table2.field1 FROM table1 INNER JOIN table2 ON table1.field1 = table2.field1 GROUP BY table1.field1, table2.field1 HAVING (((table1.field1) Like "*" & [Enter Number] & "*") AND ((table2.field1) Like "*" & [Enter Number] & "*"))...

try to "compact and repair" your database which you may access from Tools -> Database Utilities. Alternatively you may create a new database and import all of your objects (i.e. tables, queries, forms etc) to the new database and see if issue persists.

On the OnDoubleClick event put Application.FollowHyperlink "Your Image path goes here"

Hi, Search this forum for Application.FollowHyperlink and you should solve your problem.

Happy Birthday!

Hi Try renaming your form because according to this link "property" is a reserved word, so it might be conflicting.

Hi, try omitting the .Text part because unless the field has the focus it will return that error message you are receiving.

do you mean an access form? Unfortunately you cannot, although if you need to distribute your database on a pc without Ms Access you can search this forum for the "runtime" version of access.

Hi, in your query you need to use an outer join instead of an inner join.

Hi, Since it is a calculated field it is not recommended that you store its value in a table. What is the reasoning that you wish to store this value ? ... if you need to use elsewhere i.e. other forms, reports etc, then consider creating your calculated field in a query and base your form on...