Search results

In the form properties go to the "Other" tab and set "Pop Up" to Yes.

Has anyone had any experience with watermarking images? If so what software are you using? Any tips?

If the flag is effective across all data within the database, then why not just store it in it's own table, which you can then update as needs be?

Strange; no problems on my lap top which is set up "essentially" the same, so there must be something just a little different :confused:

Hi John Yes I can see that it appears to work fine for you. I'm using FireFox as my default browser, but Access is stubbornly spawning an IE browser when ever I click on a hyperlink, whether it is your DB or my own. Perhaps there is a setting somewhere in the depths of windows that I have not...

I down loaded the sample DB, as I had just been having a play with Hyperlinks in a DB I'm working on. The problem I had noticed was that, in my DB, when the link is clicked it opened in MS Explorer (not my default browser). So when I opened the sample DB and saw on the bottom of...

I'd just use an If...Then

When you place your tab control on the form you need to drag it out to cover the area of the form that will be changed as you click through the tabs.

How about as part of the save button you run an append query (prior to closing the first form) that appends the refrence number into the other table. Then open the second form, and use OpenArg to get the from to open at the last record.

Do the two forms read from the same table or different tables?

You might want to put a dialog box in the code, to confirm that your user has selected the value he intended, prior to locking up the Combo Box.

If I've understood your question correctly; all You need to do, is put a logical test (based on the value of the Combo Box) in the after update event for the Combo Box. Then assign a value to the text box or unlock it to allow data entry depending on the result.

Take a look at this thread Forms based on Queries with no result I think you might find an answer there.

:eek: TMI!

Thanks John thats fantastic.

Thanks guys works a treat :D

What is the syntax to check if a combo box populated by a query contains data?

Yes I know I'm thick but could someone pleaser put me out of my misery.

Try this use acFormatRTF if you want your report in Rich text format. Just make sure that the query that builds the report picks up [EmailAdd], [CCEmailAdd], [BCCEmailAdd] ,[SEmailSub],& [EmailMess] If you have multiple email recipients you will need to concatinate them first.

OK I've disovered how to refer to the subform, but there is still something wrong with the code, which looks like this; I'm now getting an "Object doesn't support this property or method" Arrrrrgh Help.