473,327 Members | 2,016 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

EMR project : Creating a form that works like Word

Hello guys.

Good to be a part of this community. I am a medico who is developing an access database for keeping the medical record in electronic form. We currently use the word to type our case records.
I was able to do most of the job like storing patients data and assigning it to corresponding doctors. But i am not able to create a table / form where we can type patients case sheet like the format we currently use. Memo does not allow typing like in word. It makes me type in a straight line.
I have enclosed a format of our case record.

Also i want to know if its possible to assign a patient ID as autonumber + month+year [ for eg. if autonumber is 10, Date is 21/04/2013, ID should be 10413.] this should appear after patients details were saved.

Any help is much appreciated.
Attached Files
File Type: docx Sample Case Record.docx (34.9 KB, 355 views)
File Type: xlsx EMR.xlsx (9.9 KB, 450 views)
Apr 21 '13 #1
1 1682
TheSmileyCoder
2,322 Expert Mod 2GB
In an access form, the textbox must have a predefined size. To allow a textbox to scroll over multiple lines, you draq it in design view so that it is larger (taller). I am guessing you are currently using a textbox that is only 1 line high, which is why access is only typing on 1 line.

Drag the textbox to a size that will fit multiple lines.
This should allow you to type in a more word like manner, however if you type more text than can fit in the textbox, a scrollbar will appear, within the textbox, but the textbox will NOT autosize to fit the now larger text. Note that reports CAN autosize text to fit.

I would recommend keeping the autonumber as 1 field, the date in another field, and the "calculated" ID in a 3rd field. During the beforeUpdate event of the record, you can use code to update the 3rd field.
Apr 21 '13 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: m3ckon | last post by:
Hi there, I can succesfully create a word doc from my asp.net page, but I have 2 issues I need to resolve in order to use it in my app: 1) Creating a table: I seem unable to create a table,...
1
by: Samuel | last post by:
Why my Crystal Report form works on the machine I installed VB.NET, not works on the machine without VB.NET? Thanks.
0
by: goof1972 | last post by:
Hello All, I have a VB.NET web application (1.1 framework) that creates a new Word document through interop.word.dll. I have a Windows Server 2003 with Office XP Professional installed. I've...
5
by: darnnews | last post by:
Hi, I have been creating a database to keep track of press clippings, but I have hit a couple stumbling blocks. Any help is much appreciate. 1) Seeing if my query is done I have the...
1
by: john saul | last post by:
Hello All, I am not extremely new to Access but need help to hopefully a simple question. I am creating a project quote form that will ask customers questions and retreive pricing due to the...
1
by: sajina | last post by:
Hi all , I'm trying to do a project , File Management System. For that I want to create a form and write it to word format , after that convert it into PDF . Please can anybody help me? Please...
0
by: Mark Sandfox | last post by:
I have a simply email form using smtpmail.send. This form works on 99% of computers but does not work on my customers computer. He gets the generic runtime error. Again when tested on every...
5
by: Gun Slinger | last post by:
Hi i just have a quick question. I ran a search but i was not sure really how to word it correctly and couldnt find anything. I would like to know how I can create a form object like a textbox,...
4
by: =?Utf-8?B?QXJ0?= | last post by:
Hello, I saw this posting and it is the closest place to ask this question. I am simply trying to create a Word document from a VB application I am wrting with Visual Studio 2005. I cut a...
1
by: mwh2385 | last post by:
I just cannot see clearly now...or I am just stupid, but I need a little help to getting the file ready in Access for the form that awaits it in Word. Now I think the correct procedure is that I...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.