Search results

Hi, The title gives away the problem I am experiencing! I have memo fields that have more than 32,767 characters so when I try to export this to Excel I encounter problems. How can I check the length of the memo field and split the data so that it will show in an additional column on export to...

Hi all, I have a pie chart on a form that where the rowsource is determined by a selection in a frame control (a SQL string determines the rowsource in the AfterUpdate event of the frame control). That works just fine, however, I have data labels with percentage values showing on the pie...

Hi, I am having a problem with the attached code. I have a database with 2 main tables that are joined on a 1:Many relationship. The master table contains faults raised and the other table contains notes. There may be multiple notes per fault. What I want to do is be able to run a query that...

Hello folks I am developing a basic Fault Logging system so I have a main form that allows ref to be input, date fault raised, priority, etc... I also have a sub form running that allows notes to be input. There is no set limit on the number of notes that can be added as this needs to be...

Hello folks, There must be an easy answer to this! I have searched the forums but have not found what I need to make this work the way I want it to. I have a three part reference field. The records in the form are supposed to be sorted into ascending order Field1 first, then Field2 and finally...

Is it possible to delay the Form_Current event? I use the code below to duplicate records, ask for a change in teh reference number and then resort the database according to the reference numbers. This works fine until I introduce some code into a Form_Current procedure. Now whenever I activate...

The following code governs whether two fields are enabled/disableddependent on a selection made in a frame with 4 radio buttons. All are bound controls. The first time that you select an option it's fine and the fields disable correctly, however, when I close the form and then go back into it...