Search results

Thanks for your help. The error 2046 was occurring when one of the fields that was being copied was blank. I have now changed the process a little so that that field only gets copied when it contains data. The whole process now works well.

Thanks for your help. I agree that the code supplied would replicate the data in the new control, however, I need to be able to amend the text in the new control and leave the original text as is. I am using this to store Form letters which can be selected and then modified resulting in a...

You should be able to use Conditional Formatting in the Format menu to disable the control which will also dim the label.

The following code has been used to simply copy the contents of two fields[memo] and [footer] to two other fields [memosent] and [footersent]. The code works up to the point where it reaches the "accmdcopy" for the second field. At this point I get a Run-time error 2046-the command or action...

Still working with this one without much luck. Has anyone any idea of how I can maintain a table of standard correspondence that can be selected but then have the contents edited for the current client and saved as a correspondence sent record but not alter the underlying table. I can do it by...

Hi Neil Thanks for your reply. I had looked at that but was attempting to keep it all within Access. I suppose if I can't work this out I will end up going that way. Your help is appreciated. Peter

Hi I have a customer contact db (A2K).I need to regularly send out letters to clients based on a standard set of form letters. The letters are held in a table with a memo field being used to store the contents. A report is used to create the letter from the contents of the letters table and the...

I have a subform embedded in a mainform which contains loan payment details over a number of months. The record starts with the payment period number ie 1,2,3 etc. The problem is that every now and again the subform changes the display order of the records so that I get 4,5,6,1,2,3. When I look...

I have a form called "Customers" with a subform called "Investments", the investments subform is based on the "Investments Query". I have 2 fields on the subform for incomes for Client 1 & Client 2. I wish to use conditional formatting to disable the client 2 field based on a relationship of...

Thankyou That did the trick. Thanks for the input.

I have a combo box based on a table. The table is sorted by the Customer surname field using the Order By property. My Problem is the combo box will still display data in the unsorted order ie in Primary Key order. Any suggestions on how I can make the Combo Box display dat in ascending order...

A Further problem with this one As usual one problem conquered another presents itself. I can now create a duplicate of the customer record and the append query duplicates the sub form details which is what I want to happen. However, when I attempt to amend the new subform record I am...

Answer found Found my own answer to this one. The procedure RecordsetCloneshould actually be written as Recordset.Clone. I discovered this while viewing some automatically generated code, tried it and it worked. Why is it that all the MS help etc. refers to it as RecordsetClone? Trying to keep...

I have set up the following code to duplicate a record in a table called "customers" along with data in a sub form called "Residences". This will be used to create a new record which will become a new scenario for the client in some financial modelling we will be doing. The code runs without any...

Found the answer in Microsoft knowledge base. Basically it requires a bit of code on the form containing the tabbed forms which makes the sub tabbed form visible only on the tab that you require it. Works great except that the sub form appears on all tabbed pages when in edit mode. Which can...

I would like to be able to add a tabbed control to one of the pages of a tab control. I have made several attempts and it hasn't worked. There is no reference to it in MS help. I have seen many databases with this facility (not necessarily MS Access). Can anybody offer a suggestion please. Peter

Terrific. Thanks for the advice. Regards Peter

Hi I have a query result which I am exporting to Excel. The query contains some fields which are from related tables. They appear OK in the query but when exported they revert to their ID number from their original table. Any suggestions please on how I can make the exported result show the...

I have a client using an access DB that I have built. It was built using Access 2000 and he is running it on Access 2003. The problem is that when he opens one of the forms which is tabbed and he moves to the second page when he moves the mouse pointer over some hyperlink buttons the background...

Hope someone can help your cos I'm having the same problem and I'm tearing my hair for days trying to find a way around it. Good Luck. :confused: