473,396 Members | 1,766 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Ajudem-me por favor ! Duvida no access e vba !

Ola!
Sou um novato que esta a fazer um programa de gestao de estoque no
access xp e tenho uma duvida que é: tenho uma tabela e formulario com
o nome produtos que tem dentro os campos (referencia,descriçao,preço)e
outra com factura que tem
(referencia,descriçao,preço,quantidade,total).
O que eu quero é fazer o seguinte: no formulario produtos intruduzo
referencia,descriçao e preço livremente e quando estou no formulario
factura queria que funciona-se assim:intruduzia a referencia e
aparecia automaticamente a descriçao e o preço so precisando de
escrever a quantidade.
Sei que isto se faz atravez do vba do access so que daquilo nao
percebo mesmo nada.
Ajudem-me se puderem!
Se tiverem algum exemplo ou ficheiro mdb com isso ja feito podem-me
enviar para re***@clix.pt
Obrigado pela ajuda!
Sergio Santos
Nov 12 '05 #1
1 3205
o que tens que fazer é agarrar o tal valor da referencia, fazeres uma query
ao produto e apresentares o resultado nos campos que referiste!

Espero que isto ajude.

Rui Patinha

PS: Se fizeres a pergunta em inglês pode ser que tenhas mais respostas!!! :P

"Sergio" <re***@clix.pt> escreveu na mensagem
news:d2**************************@posting.google.c om...
Ola!
Sou um novato que esta a fazer um programa de gestao de estoque no
access xp e tenho uma duvida que é: tenho uma tabela e formulario com
o nome produtos que tem dentro os campos (referencia,descriçao,preço)e
outra com factura que tem
(referencia,descriçao,preço,quantidade,total).
O que eu quero é fazer o seguinte: no formulario produtos intruduzo
referencia,descriçao e preço livremente e quando estou no formulario
factura queria que funciona-se assim:intruduzia a referencia e
aparecia automaticamente a descriçao e o preço so precisando de
escrever a quantidade.
Sei que isto se faz atravez do vba do access so que daquilo nao
percebo mesmo nada.
Ajudem-me se puderem!
Se tiverem algum exemplo ou ficheiro mdb com isso ja feito podem-me
enviar para re***@clix.pt
Obrigado pela ajuda!
Sergio Santos

Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

63
by: Jerome | last post by:
Hi, I'm a bit confused ... when would I rather write an database application using MS Access and Visual Basic and when (and why) would I rather write it using Visual Studio .Net? Is it as easy...
4
by: Cham | last post by:
Hi I have a complex Ms Access application with lots of forms and queries that needs to be moved on to the web. Is there an easy way to do this without re coding in ASP?
49
by: Yannick Turgeon | last post by:
Hello, We are in the process of examining our current main application. We have to do some major changes and, in the process, are questionning/validating the use of MS Access as front-end. The...
20
by: Olav.NET | last post by:
I am a .NET/C++ developer who is supposed to do some work with Access. I do not know much about it except for the DB part. Questions: *1* I am looking for INTENSIVE books to get quickly up to...
55
by: AnandaSim | last post by:
I just had a google through this NG but have not seen mention of Erik Rucker's blog entry and the new Jet: http://blogs.msdn.com/access/archive/2005/10/05/477549.aspx mentioned by Mike...
5
by: Benny Raymond | last post by:
I'm nearly done writing the first version of my tracking app and I'm starting to re-think the way I store my database. Currently I have my database setup as an xml dataset. Before I started the...
6
by: Woody Splawn | last post by:
It is real important to choose the right tool for a given problem and it is not clear to me just what the advantage of VS.net is over Access, for example, when writing a non-web applicaiton. I see...
38
by: Oldie | last post by:
I have built an MS Access Application under MS Office XP (but I also own MS Office 2000). I have split the application in the pure database tables and all the queries, forms, reports and macro's. ...
16
by: JoeW | last post by:
I'm utilizing a database that I created within MS Access within a program I've created in VB.NET. I am using the VB front end to navigate the information, but want to be able to print a report,...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
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...
0
jinu1996
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...
0
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...
0
tracyyun
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...
0
agi2029
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,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.