Solved

Adding a box for Remarks

Posted on 2014-12-16
8
106 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
 

Author Comment

by:Jass Saini
ID: 40504879
Yes...I have some fields that are tied back to the form and others are not...
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
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

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)

Question has a verified solution.

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

Suggested Solutions

In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

863 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now