Automatic removes data - Microsoft Access / VBA

Jacky11

I want to have a query that removes all dashes for a field
named "item name"
But I don't want to delete the dashes from the table.
What do I have to write in the query?
Thanks

Nov 12 '05 #1

Subscribe Reply

1714

Fredg

Since you haven't mentioned which version of Access you're using, I'll
assume the latest.

NoHyphens:Repla ce([ItemName],"-","")

--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.
"Jacky11" <my*****@hotmai l.com> wrote in message
news:46******** *************** ***@posting.goo gle.com...

I want to have a query that removes all dashes for a field
named "item name"
But I don't want to delete the dashes from the table.
What do I have to write in the query?
Thanks

Nov 12 '05 #2

Jacky11

Thanks for your response
I have Access 2000
The only thing I want to remove is the –
The above code didn't work for me.

"Fredg" <fg******@att.n et> wrote in message news:<p%******* *************** *@bgtnsc04-news.ops.worldn et.att.net>...

Since you haven't mentioned which version of Access you're using, I'll
assume the latest.

NoHyphens:Repla ce([ItemName],"-","")

--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.

Nov 12 '05 #3

Fredg

Jacky,
This will work in all versions of Access.

Copy and Paste the following function into a Module.

Function RemoveChar(Fiel dIn As String) As String

Dim intX As Integer
Dim intY As Integer
intY = 1
Dim NewString As String

intX = InStr(1, FieldIn, "-")
Do While intX <> 0
NewString = NewString & Mid(FieldIn, intY, intX - intY)
intY = intX + 1
intX = InStr(intY, FieldIn, "-")
Loop
NewString = NewString & Mid(FieldIn, intY, Len(FieldIn) - intY + 1)
RemoveChar = NewString

End Function
======

You can call it from a query:
NoHyphens:Remov eChar([ItemName])

--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.
"Jacky11" <my*****@hotmai l.com> wrote in message
news:46******** *************** ***@posting.goo gle.com...

Thanks for your response
I have Access 2000
The only thing I want to remove is the -
The above code didn't work for me.

"Fredg" <fg******@att.n et> wrote in message

news:<p%******* *************** *@bgtnsc04-news.ops.worldn et.att.net>...

Since you haven't mentioned which version of Access you're using, I'll
assume the latest.

NoHyphens:Repla ce([ItemName],"-","")

--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.

Nov 12 '05 #4

Similar topics

2440

Automatic Code Generation

by: Rasmus Fogh | last post by:

Someone raised the question of automatic code generation a few weeks back. And yes, we (CCPN) are using automatic Python code generation in a major way. Basically we are making data models in UML, and using automatic code generation to make Python APIs, XML I/O etc. (more below). We can be found at http://www.ccpn.ac.uk/index.html As a general point, automtic code generation would seem like a good idea in special cases where:

Python

1482

automatic delegation

by: Hallvard B Furuseth | last post by:

Is it possible to write a metaclass or something so that with a class definition not much larger than this: class foo: def __init__(self, val): self.val = val operations on a foo instance f will be applied to f.val? E.g. str(f) -> f.__str__() -> f.val.__str__(). --

Python

2080

Python 2.4 removes None data type?

by: gaudetteje | last post by:

I just read in the 'What's New in Python 2.4' document that the None data type was converted to a constant: http://python.org/doc/2.4/whatsnew/node15.html """ # None is now a constant; code that binds a new value to the name "None" is now a syntax error. """ So, what's the implications of this? I find the lack of explanation a

Python

3341

What good is this automatic garbage collector?

by: joe | last post by:

I have a simple .NET application with two or three listViews which are filled with icons and when the user click on the proper item, they display the related images. I use "image = null ; " for all images that have been used and are going to be closed. This is how ever no way to reduce the memory consumption. I have noticed , using the task manager, that garbage collector doesn't actually do any collections unless the computer becomes low...

.NET Framework

2881

automatic indent and clean up of js code?

by: ivanhoe | last post by:

I need something like html tidy, but for javascript...to fix code indentation, converts tab/spaces, removes white space, etc...maybe even fast check sintax and warn on compatibility issues, but I guess it's too much to ask (?!) if you have positive expirience with some application(or perl/php script) that knows how to properly do this (and is customizible and maybe also free or at least cheap?), please speak up, since all progs I tried...

Javascript

2102

Automatic removal of unnecessary namespace

by: Oscar Thornell | last post by:

Hi, I am looking for a feature/functionality in VS.NET 2005 that removes using directives/includes of unnecessary namespaces. IDEs like Eclipse and JBuilder have had stuff like that for years and my guess is that VS.NET 2005 has it to...but where? Regards /Oscar

C# / C Sharp

1460

Automatic Memory Management Question

by: gwainguard | last post by:

Hello I am studying the ECMA specs and was doing wonderfully until just now. They have just broached the topic of AMM and given some example code which seems to be demanding a greater understanding from the reader than the previous examples. I include the code following, would someone please be kind enough to comment it as thouroughly as possible so I can understand exactly how it is operating and what it is doing. I have used...

C# / C Sharp

4650

When to use automatic variables and when to use malloc

by: Jorge Peixoto de Morais Neto | last post by:

I was reading the code of FFmpeg and it seems that they use malloc just too much. The problems and dangers of malloc are widely known. Malloc also has some overhead (although I don't know what is the overhead of automatic variable sized arrays, I suspect it is smaller than that of malloc), although I'm not too worried about it. I was thinking that, with C99's variable length arrays, malloc shouldn't be needed most of the time. But I'm...

C / C++

2647

where do the automatic variables go ?

by: sidd | last post by:

In the following code: int i = 5; ---it goes to .data segment int j; ---it goes to bss segment int main() { int c; int i = 5; ---stack

C / C++

8400

Changing the language in Windows 10

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,...

Windows Server

8602

The easy way to turn off automatic updates for Windows 10/11

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,...

Windows Server

7441

AI Job Threat for Devs

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...

Career Advice

6234

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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...

Microsoft Access / VBA

5702

Couldn’t get equations in html when convert word .docx file to html file in C#.

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();...

C# / C Sharp

4227

Trying to create a lan-to-lan vpn between two differents networks

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...

Networking - Hardware / Configuration

2817

transfer the data from one system to another through ip address

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

C# / C Sharp

2058

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

1814

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General