Solved

Adding a box for Remarks

Posted on 2014-12-16
8
108 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
  • 4
  • 4
8 Comments
 
LVL 18

Accepted Solution

by:
Simon earned 500 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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Suggested Solutions

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

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