Hola, tengo una duda.
tengo una base de datos de facturacion, y en el formulario de facturas, al
meter el importe en euros, tengo que teclear 135,50 es decir 6 pulsaciones.
Lo que me gustaria es ahorrarme la "," y escribir 13550 y que el
automaticamente me pusiera la coma entre los dos 5.
Alguno sabe como hacerlo...
Gracias.. 2 2012
Jorge,
Para que Access sepa cual es la parte entera y cual la decimal tienes
que entrar la coma.
Lo que puedes hacer (para que el Usuario lo vea bien) es dividir el
importe introducido por 100 en el evento "Al Salir" y así se verá con
la coma.
Pero, en previsión de que "algún" usuario le guste entrar la coma
tendrás que comprobar, primero, si la coma ya existe para no dividir.
Saludos.
Angel.
"Jorge Gallardo" <jo***********@ eb4enn.com> wrote in message news:<c1******* ***@nsnmrro2-gest.nuria.tele fonica-data.net>... Hola, tengo una duda. tengo una base de datos de facturacion, y en el formulario de facturas, al meter el importe en euros, tengo que teclear 135,50 es decir 6 pulsaciones.
Lo que me gustaria es ahorrarme la "," y escribir 13550 y que el automaticamente me pusiera la coma entre los dos 5.
Alguno sabe como hacerlo...
Gracias..
Muchas gracias..
Lo hare asi..
"Angel Mazo" <an********@vod afone.es> escribió en el mensaje
news:e2******** *************** ***@posting.goo gle.com... Jorge,
Para que Access sepa cual es la parte entera y cual la decimal tienes que entrar la coma.
Lo que puedes hacer (para que el Usuario lo vea bien) es dividir el importe introducido por 100 en el evento "Al Salir" y así se verá con la coma.
Pero, en previsión de que "algún" usuario le guste entrar la coma tendrás que comprobar, primero, si la coma ya existe para no dividir.
Saludos.
Angel.
"Jorge Gallardo" <jo***********@ eb4enn.com> wrote in message
news:<c1******* ***@nsnmrro2-gest.nuria.tele fonica-data.net>... Hola, tengo una duda. tengo una base de datos de facturacion, y en el formulario de facturas,
al meter el importe en euros, tengo que teclear 135,50 es decir 6
pulsaciones. Lo que me gustaria es ahorrarme la "," y escribir 13550 y que el automaticamente me pusiera la coma entre los dos 5.
Alguno sabe como hacerlo...
Gracias.. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: El |
last post by:
with CDRoms, books, licence, .....
Where ? : south of BELGIUM
elcrac@yahoo.com
|
by: Davide |
last post by:
Perche' non riesco ad inserire immagini opiu' grandi di 1Mb in un campo
LONGBLOB? Ha forse il limite di 1Mb il campo LONGBLOB?
Se si, posso modificare tale limite?
Per le immagini inferiori a 1Mb e' tutto ok funziona perfettamente.
Grazie a tutti, ciao.
|
by: Gema |
last post by:
Hola a todos,
Tengo un problema, no se me ocurre como solucionarlo. Utilizo SQL
Server 2000.
Tengo una tabla (tblRespu) en la que quiero insertar tres valores: el
primero procede de una variable @CodPregunta, el segundo tiene
guardada en texto la información de la columna de otra tabla
(tblPlana) de la que quiero recoger el dato y el tercero es un campo
de esta tabla (tblPlana). No se me ocurre forma de asignarlo, he
probado a crear...
|
by: mick.smith1964 |
last post by:
I have a report which is sometimes exported into Excel using the following
code:
DoCmd.RunCommand acCmdOutputToExcel
This works fine if the default "Currency" format is used in the text boxes,
in this case it is UK pounds sterling.
If I change the format to "Euros" or format the text box for US Dollars
these columns are then exported as text. The correct currency symbol is
displayed but any calculated cells remain at 0.
|
by: g.magliozzi |
last post by:
Ciao a tutti,
dopo aver copiato dei record tramite una query di accodamento su una
tabello ho la necessità di modificare un campo (che risulta vuoto) su
tutti i records spostati.
Come posso fare?
GRAZIE 1000000
| |
by: Neolo |
last post by:
Hola, necesito ayuda.
Tengo un formulario en access 2003 y necesito hacer que al elegir en
un combo la provincia me salga la lista de los municipios de esa
provincia, los cuales tengo almacenados en una tabla.
Consigo que lo haga si elijo la provincia, cierro el formulario y
despues lo vuelvo a abrir, pero necesito que lo haga automaticamente
sin tener que cerrar el formulario, y eso no lo consigo, he pensado en
ejecutar alguna macro...
|
by: Marta López |
last post by:
50 EUROS DE REGALO PARA TI!!!
http://www.laruleta.com/user/f8f5eaa2/
INGRESA A MI SITIO, REGISTRATE Y GANA 50 EUROS EN 5 MINUTOS!!!
ES UNA GRAN OPORTUNIDAD, Y TU ERES DE LOS PRIMEROS EN ENTERARSE
INGRESA AQUI Y REGISTRATE
|
by: hicksmcb |
last post by:
I've got a txtbox that returns a pounds(sterling) value for number of nights * price per night. How do i convert it from pounds to euros
If txtNights.TextLength > 0 And txtPrice.TextLength > 0 Then
txtTotal.Text = CDbl(txtPrice.Text) * CDbl(txtNights.Text)
Else
MsgBox("Invalid Function")
Thanks
|
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: 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: 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.
| |