Recent content by carlton

I need to read a .RTF file, then convert to plain text for further processing. The .RTF and plan text versions are both stored in Long Text fields.

I opened a .RTF file, stored the contents into a Long Text field of my table. Using a text box with the format set to RichText I can display the fornatted data in it's rich text format. I need to convert the RichText formatted data to plain text for further processing, hence the use the the...

According to all I've seen across the web, to convert .RTF data to plain text data I should use the plaintext function. On reading in a .RTF file the Rich Text formatted text displays a perfect rendition. Attempting the plaintext conversion results in a display of jibberish. I'm using Access...

I'm trying to solve the same problem. I found the .Crosses and .CrosseAt properties but both give run time error '438'. Object doesn't support this property or method

I'm an engineer using Access databases for admin tasks and customer deliverables.

I've the same problem. I've a form with several tabs, each with a media player. Despite all using the same code and properties, two shrink and one functions normally. I've deleted the controls and recreated the with no effect. 🤬

Thanks, I'll test it out.

The database contains video attachments which must be written to the TEMP directory for displaying, this needs to be cleaned up.

Is there a function/macro I can write which will always be called when Access closes regardless of the method (except of course power failure/ windows crash). I need to perform some specific clean up operation when the database closes regardless of whether the user presses the handy EXIT APP...

I tried this, no change. it was all working correctly yesterday. The contents of the tabs have all moved to the far right of the tab. On moving them ack. I can't resize the width of the tab page.

The form I have has 5 tabs some for database interrogation, some for user information. When recently opening the form all the tab headings are no longer displayed. They are all present in Design view, and set to visible=true. Any ideas on the cause/solution?

Is there a method by which I can send the contents of a populated for directly to a .PDF document? (possibly via a print to PDF)

I have inherited a database which generates graphs on a form using an over complex series of queries I need to be able to export the graphs to a .PDF document. There are multiple graphs (31) which may be column or line graphs, each having different titles and axis labels. So far I have created a...

I have a database form design which has 85 labels for user option selection. Can I setup a single event subroutine that can be called every time a label is clicked (i.e. all the label.click events point to the same function) without having a routine for each one. I really don't want 85 separate...

Hi there, I've programmed in Access for a while, but still have lots to learn. I'm based in the UK and have the task of updating someone else's work. Carlton.