Search results

Unfortunately, not a programmer either. :o) Although I have looked at using links with the FollowHyperlink method to link to external docs. The reason that the memo fields are so big is that they contain step by step test scripts, some of which are rather lengthy. Unfortunately I wasn't...

Thanks for the response. I'd be interested to hear more on how you think the design can be bettered using linked text fields as I have no experience in that area. Would you be able to provide some guidance or point me in teh right direction? Cheers

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...

Excel needs to be involved because... The entries have to be exported into a spreadsheet to be sent to an external company. The database part is an internal tracking tool that will log more than just faults. Therefore it is not viable to expose the database to any of the external companies. So...

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...

Staring me in the face! Answer was so simple that I completely overlooked it! Simply requeried the form. Code is: Form_frmData.requery Happy days!

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...

Thanks Thanks, worked like a charm!

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...