Search results

I'm using a field type of "memo" with a rich text setting. I know there's limitations to the rich text implemented in MS Access. Users copy text from MS Word and want to retain the same format and layout. They would like to manipulate the text in MS Access as well. In the attachment entitled...

Thanks, the user needs to be able to create/edit within a form, and the output is produced in a report. Any suggestions? I also don't want to loose the exsting content that is already stored.

Have a database that produces documents for public distribution, and the use of memo fields are extensively used. Most of the time we can get buy using the standard rich text that is provided with MS Access, but I'm trying to find a solution to include a table that is produced in MS Word and...

Thanks everyone, I ended up using a solution I found at http://www.utteraccess.com/forum/Logon-form-Custom-Securi-t1917534.html (caution, read through the list and get the latest zip file, I learned the hard way :)

I've encountered this problem myself, and I found the root cause was something in the original copy and paste from a word document. If I cleared the field, and then pasted the text as "paste special - text", it worked fine. Never did figure out a better solution, but it solved the problem.

Currently creating an MS Access database that will reside on a shared drive, and looking for a simple solution that will control access to 2 different forms based on the userid. I could use the user's windows login or create a unique userid and password that is managed by the database. I'm...

Thanks Paul, we decided to go with html, the user will have to be trained on how to take their text and put into html. What a joy!

Well just experimented and certainly the desired results will work with the html formatting, however, there's 2 fields that are memo/text based, that I'd like to extract as is, so the user has control over the format. The only problem appears to be, that because it's recognizing that it's...

Thanks very much Paul! Greatly appreciated! I think the HTML formatting will probably work best. Have to work on the looping aspect for part 3. You relieved a great deal of frustration!

Thanks for your reply, it's greatly appreciated. Basically a new record in table tbl_contact, and then the ID field that's created in tbl_contact would then create a new record in tbl_particpants with the linked field. Does that clarify? Any help would be greatly assisted. Thought of a pop-up...

This forum is incredibly useful! Particularly for individuals who are not experts in MS Access or programming. Any assistance would be GREATLY appreciated! Have another problem with a training scheduling database, with the auto generation of emails to participants. They use MS Office 2003...

Have developed a database for our training team to manage their training schedules. The one course schedule form (see attached), enables the user to add a course schedule, and then the associated participants. The main form is linked to a table called "tbl_schedule" and the sub-form is...

Have a database built in MS Access 2000/2003, and utilized Lebans RTF2 Active Control (http://www.lebans.com/richtext.htm) which I found reference to in dozens of sites, which enables doing rich text and graphics within a memo field. It works wonderfully, and solves a great deal of problems. Two...

Thanks everyone, I ended up creating a function, was just hoping that there was an easier way. We're unique in Canada I guess, we have 2 official languages.

Thanks, I know I can use the format() function, but how do you make it format into a french version (i.e. long date in English would be "January 8, 2009" and in French it would be Janvier 8, 2009". That's the tricky part. I know it's based on your system language default, but I only want this to...

We have a need to display a date field which is stored in English, to be displayed in long date format but in French. It's only necessary for the report, so I don't want to make a global change, only temporary for when the user produces the report. I have done some research, but all I can find...

Thanks very much for the advice, I finally got it to work and it was related to issues with Office 2000.

Thanks for the advice, unfortunately they want each button to generate the email automatically - hence multiple buttons, because they pull up different info and different content. There's a total of 6 email buttons. I did take your advice and put the entire code as part of the button as opposed...

The commands all work from home where I use MS Office XP and Outlook resides on my desktop. At work, we use MS Access 2000 but with MS Outlook 2003. Bit puzzled and perplexed on how to get this working.

Have found some code that originated from this forum, and have modified it to suit my needs. There's one form with all the information, that has multiple buttons and subsequently multiple functions to generate emails, with each button/email to generate a different format and content. The first...