Search results

Thx for the attempt sneuberg. it was worth asking.

Hi, Is it possible to create a hyperlink within a part of a field formatted as long text? If so, how is this done? See attachment for a print screen. P.S. I know there is data type "Hyperlink" available but this is not an option.

Thx jdraw. That did the trick.

Hi, I have written a function which sets the checkbox for all records in tbl_Questions to true. Function frm_1_Passage_Q1_Ja() Dim strSQL As String strSQL = "UPDATE tbl_Questions " _ & "SET tbl_Questions.Answer = True" _ CurrentDb.Execute strSQL, dbFailOnError End Function I however only...

Hi, I have a form with a datasheet view. When I want to filter on a field I get a checklist of all the available values. When there is however already another field filtered there is no checklist visible. See the attached print screen for a visual overview. Any idea on why this is happening?

One step closer. When clicking the button a pop-up appears. Unfortunately it's empty where I would expect it to be populated with the validation text from the field causing the error.

Thanks CJ. I wasn't aware that you could convert macro to code with a simple push of a button. Unfortunately the code does not react similar to the macro. Private Sub NextRecordMacro_Click() On Error GoTo NextRecordMacro_Click_Err On Error Resume Next DoCmd.GoToRecord , "", acNext...

How can I translate the additional code in the macro to vba?

Hi CJ, If I have focus on the score field or not then the validation rule is triggered with the macro button. For the code button there is no difference. Neither way the validation pop-up appears. I've tried changing the required property to yes in the table but that does not have the desired...

Hi, I have a table with two fields. Both fields have a validation rule and text. As a result both fields need to be filled in the form before a next record can be added. When using a macro based button to go to the next record a pop-up appears with the validation text if a certain field is not...

Forms it is :) Thanks for your assistance.

That would solve my problem but create another one :) If making use of a text box within table the user can no longer select a quarter from the list.

Sample database is attached.

SELECT Data.Quarter, Data.Vendor, [EH&S]+[Adherence DD] AS [Sum] FROM Data WHERE (((Data.Vendor) Like "*" & [Geef de naam] & "*"));

It's not a form but a query.

Hi, I have a table (Quarter) which acts as a source for another table. When I create a query based on the latter in the Datasheet view the entries of the second column of table Quarter are shown. The PivotTable field however displays the primary key. Where do I need to make the change to only...

Looks like I have some reading to do. Thanks for pointing me in the right direction.

Hi Mailman, I'm afraid I don't understand. Could you please elaborate?

Hi, I've made two queries. One in PivotChart and one in Datasheet view. Then I added both to a form. When one query in the form is filtered the other should filter as well. Currently they are not "synchronized". How can I make this happen? Thanks in advance for your reply. I've added a...

MSAccessRookie, Thanks for your reply. I was unaware of the existence of an IN-statement. This indeed reduces the complexity. As you pointed out however and which is backed up by boblarson perhaps it's better to make us of the table method. boblarson, That's exactly what I mean. I however...