Search results

Hi Pat Sorry, but I disagree with you

Have now found the solution which I have shown in the code below. The objective of the code was to find a new Logo image which I save as an attachment on my company record. I also wanted to ensure that only one image is stored in my Logo attachment field. I have changed it from a Function to a...

Hi thanks for your help. I tried your code, but it gave me the error Invalid or unqualified reference on the line: With .Fields("Logo").Value I have now found the solution which I will post in my reply.

Hi Pat Thanks for your response, but what I want to know is how to manage attachment fields Kind Regards Melvyn

Hi I am trying to check if an attachment exists on a recordset2 record and if it does remove the field contents and then add a new attachment to the same record so I Only have the one attachment entry on the record. My code is giving me two problems: 1. The If statement If .Fields("Logo").Type =...

If the Me.filterOn = true you cannot edit any of the filtered records. I solved my problem by creating an edit button to call another form that allows me to edit the desired customer record and then return back to the filtered records when I close this new form.

Thanks ,I did have DISTINCT in my filter query, I removed this, but it had no effect. I also noticed that once I apply a filter, then clear it I can no longer edit any of my customer records without closing and re-opening the form.

I have a Single form showing a customer record with a subform showing orders for that customer. When I go through the customer records one at a time, I can edit the customer record etc. But when I apply a filter to reduce the number of customer records available to me on this form, I cannot edit...

Sorry I am not only new to using forums, but I am a real beginner when it comes to using vba Code: Dim CheckDisplayName as Boolean Private Sub btnDisplayPayee_Click() If CheckDisplayName = True Then DisplayPayee = Nz(PayeeName, "") CheckDisplayName = False Else...

I am using a subform to display transactions belong to an account specified on the main form. This works OK. The problem I have is the amount of data to be displayed is to much for the size of the subform, so I thought I would resolve this using an unbound field (DisplayName) in which I want to...

Repairing the database has resolved my problem. Thanks to all who took time to help me.:)

Hi I tried your solution, but I still get the same error. Thanks for your help.

Hi In the example given all I am trying to do is display a message box using the on click vba event. The error I am getting happens on all vba procures that I create and I don't know why. I have tried to use a simple event example to see if I can get that to work and I have failed. I am...

Hi This problem is driving me crazy. I have a simple tabular form showing two records, it is setup so you can only input data into one field for each record. I have created a simple on Click Event: Option Compare Database Option Explicit...

Hi I have worked in the IT industry since August 1974. I have been an IT Manager since March 1989. Since August 2006 I have been retired due to ill health, this has effected my memory and I find it difficult to remember many things that I use to do without thinking. I still enjoy using my...