?
Solved

Adding a box for Remarks

Posted on 2014-12-16
8
Medium Priority
?
112 Views
Last Modified: 2014-12-17
I need to add a text box?? to my form for the user comments--which means it sounds like a memo field.  But when I did my query I didn't include that has a field.  How do I put this into my form and tir to back to a table??
0
Comment
Question by:Jass Saini
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 18

Accepted Solution

by:
Simon earned 2000 total points
ID: 40503706
1. add the memo field to your table or a new related table
2. add the field to your  query
3. drop the field onto your form and give it appropriate properties (scroll bar?)
0
 

Author Closing Comment

by:Jass Saini
ID: 40503824
Thanks..since its tied into my query it's not updating
0
 
LVL 18

Expert Comment

by:Simon
ID: 40503897
Hi, are you having a problem saving data from the memo field or from all fields on your form?
0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 

Author Comment

by:Jass Saini
ID: 40504879
Yes...I have some fields that are tied back to the form and others are not...
0
 
LVL 18

Expert Comment

by:Simon
ID: 40505272
Check the query that you use to populate your form.
Did you first add the memo field to your table and then update the query to include the new field? Check that you haven't made a typo and just included a static item in your query instead of a column from the table.
0
 

Author Comment

by:Jass Saini
ID: 40505342
Sorry what do you mean by that "static item in your query "...I have that memo field in my table already..as I included into my subform..but now my boss wants it a part of my main form and my main form is based off the query.
0
 
LVL 18

Expert Comment

by:Simon
ID: 40505424
The subform and main form would usually be based on different queries and just linked together by the master/child relationship (common key fields) that you choose when you add the subform to the main form. If both are based on the same query I suspect that's the cause of your problem.
0
 

Author Comment

by:Jass Saini
ID: 40505656
Sorry again..I am new at this and this is the way I was taught.  The main form is based off the query and subform is from the table.  If I based it off the query then I am unable to enter data...this was my orginal problem when I found this website.  There are so many different ways of doing stuff...
0

Featured Post

New benefit for Premium Members - Upgrade now!

Ready to get started with anonymous questions today? It's easy! Learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question