| |
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: MLH |
last post by:
Is an apostrophe a character of special significance to MySQL in a way
that would cause "Bob's dog" to become translated into a 12-character
string when typed into a MySQL memo field? If I type Bob's dog into an
Access memo field, I get a string that is 9-characters long.
When I read "Bob's dog" from a memo field in a MySQL table attacted
to MS Access via MyODBC driver, it displays as "Bob's dog" - a
twelve character string. the '...
|
by: Martin Heal |
last post by:
I am having problems trying to assign the contents of a Memo table
field to a String variable in VB using the following code:
Private Function udfBuildSQL(SQLID As Integer) As Variant
Dim rs As Recordset
Dim db As Database
Dim rSQL As String
Dim strSQL As String
Dim fld As Field
|
by: jacoballen |
last post by:
I have a query that combines the results of three related tables. The
memo fields are truncated to 255 characters, but I need all the
information in them. I'm aware that removing code such as DISTINCT and
GROUPBY will fix this problem (as discussed in other threads in this
group), but I need to limit the query results to unique values, which
is what DISTINCT does for me. Any suggestions?
Thanks,
Jacob
|
by: DBQueen |
last post by:
How can I limit the size of a Memo field? I don't want the user to be able
to enter more than 500 characters.
Thanks!
Andi
|
| |
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: pv1 |
last post by:
Hello,
I am somewhat new to Access and vba, but am trying to complete a request that has been made of me. Access version 2002 WindowsXP.
At this point these text boxes are bound to the table memo field. I have located Stephen Lebans code to limit enter of text field based on characters entered and code to limit text based upon width of a text box (this seems to be most applicable for single line text box). I am have trouble putting...
|
by: TechyGal |
last post by:
Hi there,
I really hope someone can help as I have been trying for two days now and to no avail.
I am trying to add a validation rule to a memo type field in MS Access 2007. I need to limit the amount of text that can be entered into this field to about 1000 characters. I have tried using the following validation command but it is not working! Any ideas would be very greatfully recieved! :)
Validation Rule =Len("Specification")<1000
...
|
by: steph |
last post by:
I have a table with 250 fields. Of course you are wondering why 250
fields... what could I possibly be storing in so many fields?
I am using this table as a general import table for files that vary
based on user selections. The input files are CSVs and can number from
2 to 175 columns. Each field is usually able to fit into a Text field
(< 255 characters) but every now and then a longer field creeps in.
since I don't know in which column...
|
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: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
