In my database I have a form that you go to enter project status for week ending. In that form I have a subform so that when you pick a project that it brings in the status entered for last week because so you can see what you put for last week before you put in this weeks. The status is set up as a memo field. For this one project it is cutting the data off. However when I go to print the report all the data is there. It's just when I am trying to review what was entered last week it doesn't show everything. It pulls up last weeks status with a query. Could the query be causing the cut in data. If so how do I fix that?
Thanks
5 6748 MMcCarthy 14,534
Recognized Expert Moderator MVP
In my database I have a form that you go to enter project status for week ending. In that form I have a subform so that when you pick a project that it brings in the status entered for last week because so you can see what you put for last week before you put in this weeks. The status is set up as a memo field. For this one project it is cutting the data off. However when I go to print the report all the data is there. It's just when I am trying to review what was entered last week it doesn't show everything. It pulls up last weeks status with a query. Could the query be causing the cut in data. If so how do I fix that?
Thanks
querying memo fields is a nightmare. It cuts off a 255 characters invariably. As a work around don't have the status field returned by the query. Instead put a dlookup in the textbox.
Mary
I'm a little confused never working with DLookup before.
Here is what I have:
When you go in it auto populates this Friday's date, then you pull down a project from a drop down, then when you pick that project. The status, milestone, and next step (3 seperate memo fields) populate with last weeks project status and its pulling from a query based on the max date and the project you picked from the drop down.
Where would I put the DLookup? In the query, form, code? I would have to put it for all 3 unless I would make a MakeTableQuery and have it read from there. I am not sure what I should do.
Can you please help?
querying memo fields is a nightmare. It cuts off a 255 characters invariably. As a work around don't have the status field returned by the query. Instead put a dlookup in the textbox.
Mary
MMcCarthy 14,534
Recognized Expert Moderator MVP
I'm a little confused never working with DLookup before.
Here is what I have:
When you go in it auto populates this Friday's date, then you pull down a project from a drop down, then when you pick that project. The status, milestone, and next step (3 seperate memo fields) populate with last weeks project status and its pulling from a query based on the max date and the project you picked from the drop down.
Where would I put the DLookup? In the query, form, code? I would have to put it for all 3 unless I would make a MakeTableQuery and have it read from there. I am not sure what I should do.
Can you please help?
Just stick a textbox (txtDesc) on the form and in the after update event of the combobox put the DLookup. - Me!txtDesc = DLookup( ...
Try setting the field in the query to First instead of Group By.
@binner
Thanks for that - that's got my problem sorted .... cheers
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Shyguy |
last post by:
I want to create two buttons on a form. One would allow the user to
Copy the contents of the current records memo field, the other would
allow them to print. I set up a report based on the memo field, and
it works. But, it seems wrong since I had to create a huge text box to
accommodate memo fields with a lot of text.
Thanks for any help,
ShyGuy
|
by: PMB |
last post by:
Thank you in advance for any and all assistance.
I'm trying to take 4 fields and space them evenly on a receipt printer. My
problem is there are many variables, i.e.
Qty may be one or two digits; 01-99
Description may be UPTO: 25 characters, but some are less than that; Would
and either or statement for each length do the trick?
Price Per; $ .25 to $99.99
Then the subtotal is Qty * Price Per
|
by: Mal |
last post by:
I have an ACC 2000 database that has a strange behaviour
I have a small table, with just a few fields...
My report has very simple grouping and sorting, no code bar a NODATA
event.
I have a memo field
When CAN GROW is set to NO everything works just fine.
When CAN GROW is set to YES - watch out.... One record causes BIG
|
by: kotowskil |
last post by:
A report has a subform. The subform is set to datasheet view and its
RecordSource is a select query that includes a memo field from the
source table. The memo field's Can Grow property is Yes, and the
subform Detail section's Can Grow property is Yes. The report Detail
section's Can Grow property is also Yes.
When run, the select query's memo field has all the data. However,
when I run the report, the subform does not show all the...
|
by: RMC |
last post by:
Hello,
I'm looking for a way to parse/format a memo field within a report.
The Access 2000 database (application) has an equipment table that
holds a memo field. Within the report, the memo field is printed within
the detailed area. The problem is, the apllication is not setup
properly, thus the users are entering data within the memo field as:
location1 1/1/2005 1/1/2006
| |
by: Teresa L |
last post by:
I am using Access 2003. I have a memo field that I have put into a
report. My problem is that the report will only show a specific
amount of characters in the report. It does not display the entire
field. I have checked the properties and they are set to memo so what
is happening here? I think it is happening in more than one field but
I have only been able to identify or replicate the problem in one
field.
Thanks
|
by: sara |
last post by:
I have a Memo field in a table to hold notes from a conversation a
social worker has had with a client (this is for a non-profit).
If the user needs to update the memo field, I need to find the
original record (which I am doing fine - getting the correct key)
and
I need to update the "notes" with the new value from the form, which I
store in a String Variable.
(I've tried storing in a Variant variable; didn't work for me)
|
by: Roger |
last post by:
I've got two tables in sql2005 which have an 'ntext' field
when I linked the first table in access97 last week using an odbc data
source the access-field type was 'memo'
when I link the 2nd table today, it is linked as a text(255) field,
ditto for the first table if I link it today
if I link the 2nd table using access2003 (and the same odbc data
source) it is linked as a memo field
|
by: revogs |
last post by:
I've got some troubles with VBA and Excel.
I wanna show the content of a Memo field from VPF data (DBF) into an Excel's cell but it shows nothing after de procedure.
After the conection with ADO everything goes right, i can print every data but Memo's data
Is there anyway to do it ?
I've tried every method: trim, replace, left cuts, right cuts but they don't work.
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |