I am building another data base for invoices. I have two tables on is for the invoices, one is for the parts.
The invoice table contains several fields. for the customer info and for the orders to be stored in.
The Part table consists of fields
part #
Serial #
description
Price
The form that I created for the invoice, i want to have conditional formatiing for the part info for example:
When part # 001 is selected from the drop down box that is connected to the part table then it automatically fills in the serial description and price into the appropriate fields on the form. I then want the price field multiplied multiplied by the quanity field to bring a total. into the total field. Then a sub total at the bottom.
If anyone can help me with how to do this it would be greatly appreciate. Oh yeah I am running with MS ACCESS 2000. If any further info is needed let me know.
Thanks a lot
16 2011 Rabbit 12,516
Recognized Expert Moderator MVP
You could just set the control source of the textboxes to DLookup the appropriate fields.
You could just set the control source of the textboxes to DLookup the appropriate fields.
But would it automatically look up the info. They are different fields?
Rabbit 12,516
Recognized Expert Moderator MVP
But would it automatically look up the info. They are different fields?
It would automatically lookup whenever your combobox changes because the control source would be tied to the value of the combobox.
It would automatically lookup whenever your combobox changes because the control source would be tied to the value of the combobox.
I'm sorry but I dont think that I am understanding. The first field on the form is a combo box which is the part #, the next field would be a text box which is serial number, the next is a text/ description and the next is text box/ price.
Do I do the dlookup on the combo box or the text box... and what exactly do I put in for the appropriate field.
Again Sorry I am fairly new to this.
Rabbit 12,516
Recognized Expert Moderator MVP
I'm sorry but I dont think that I am understanding. The first field on the form is a combo box which is the part #, the next field would be a text box which is serial number, the next is a text/ description and the next is text box/ price.
Do I do the dlookup on the combo box or the text box... and what exactly do I put in for the appropriate field.
Again Sorry I am fairly new to this.
You'd put it in the control source property of the textbox. You'll want to look up the DLookup function in the help files as that'll provide you an explanation of all the intricacies and examples.
You'd put it in the control source property of the textbox. You'll want to look up the DLookup function in the help files as that'll provide you an explanation of all the intricacies and examples.
But the control source needs to point to where I want the data stored. I am more looking for an After Update type thing. Just dont know what to put.
But the control source needs to point to where I want the data stored. I am more looking for an After Update type thing. Just dont know what to put.
in the after update event of your combo box
me.mytextfield = me.mycombo.colu mn(x)
where x is the appropriate field you're trying to populate.
J
MMcCarthy 14,534
Recognized Expert Moderator MVP
Set the Row Source of the combo box to ... -
SELECT [part #], [Serial #], description, Price FROM Part
You can hide the extra columns by setting their column width to 0.
Then in the After Update event of the combo box put the following: - Private Sub ComboboxName_AfterUpdate()
-
Me![Serial #] = Me!ComboboxName.Column(1)
-
Me!description = Me!ComboboxName.Column(2)
-
Me!Price = Me!ComboboxName.Column(3)
-
End Sub
Mary
MMcCarthy 14,534
Recognized Expert Moderator MVP
in the after update event of your combo box
me.mytextfield = me.mycombo.colu mn(x)
where x is the appropriate field you're trying to populate.
J
Congratulations on the new status J.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Jouke Langhout |
last post by:
Hello all!
For quite some time now, I've got the following problem:
Access won't close properly when a user closes the application. An
ACCESS process stays active and that process can only be terminated by
pressing ++ and then terminate the process.
I searched the entire internet and found out that there could be two
things wrong (both of them are mentioned in the bug list on the access
|
by: Allan Koch |
last post by:
Dear NG,
I would like to format a record in a subform, dependent on a value in one
field.
If one field in the record I show in a subform (datasheet view) is true I
like to view that particular row in green, all other rows just as they are
normal. Is that possible ?
regards
Allan
|
by: Dimitri Furman |
last post by:
Given:
Access 2002/2003
A subform in datasheet or continuous view, placed on a tab page (this last
may or may not matter)
Conditional formatting applied to some controls on the subform -
format expressions are the same for all controls
Under some undetermined circumstances, when such subform is displayed, the
controls on the subform start to visibly flicker, the cursor in the subform
stops blinking, and CPU utilization goes to 100%....
|
by: John Baker |
last post by:
Hi:
I have a field that i wish to use the conditional format capability on, and for some
reason it wont work.
The field is a a text box:
=-
I would like to make it red when negative, and have been working with the conditional
|
by: Paul T. Rong |
last post by:
I don't know why that I lost track of the post. I found it from the
newsgroup and paste last two posts.
Pieter Linden said:
"To do this - use conditional formatting..."
I didn' work it out. Seems to complicated. Can anyone help with this
conditional formatting?
Thanks
Paul
| |
by: Sara |
last post by:
The problem:
Conditional formatting bold, red when field Value < date() sets the
field
background to white - always - whether condition is met or not. I
want the field unfilled and just red/bold when the date has passed.
Background:
I have 2 related fields that are only rarely active, so I manage them
in the
query for the subform: ShowBlanket: IIf(,"Blanket","") and
|
by: Marc Jennings |
last post by:
Hi there,
I am trying to get some conditional functionality into some of my
apps. I can use the format :
private void doStuff()
{
//do something
}
|
by: Smiley |
last post by:
Hi,
I know how to do confitional formating in Excel by clicking the wizard. Is
this possible in MS Access ? If so, please directly where to look. I found
example but nothing as to how to do it. I am very green in this. Please
help.
|
by: afromanam |
last post by:
Regards,
Please help
What I'm trying to do is this: (and I can't use reports since I must export to Excel)
I export some queries to different tabs in an excel workbook
I then loop through each tab and apply autowidth to columns and apply autofilter to the first row of every tab in the workbook. I've this down
|
by: riaane |
last post by:
Please help: I have Conditional Formatting on a Report Field that fills the background Red if the criteria is met. This displays correctly in Report View, however, when I "OutputTo" this report to "Rich Text Format (*.rtf)", the colour is lost on the resultant RTF document when I open it up in Word 2007.
I would obviously like to retain the colours dictated by my Conditional Formatting criteria results when I output this report to RTF format....
|
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: 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: 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: 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: 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
| |