Access 2010

Good day

i'm building an database in access and i have a problem. i would like to know if some one can help me figure out how to build a Next button in access so that i can click on it and g to the next record.

i some one know please reply my message

It should be part of the default first/back/next/last button set. I'm guessing you're not using the provided templates?

The RunCommand method in Access 2010 provides most of the common built-in Access functionality. The parameter list is pretty intuitive. Just type RunCommand in the VBA editor and a space after it to see the available parameters. 

The following is I believe what you were looking for:

RunCommand acCmdRecordsGoToNext

@Shamir: right clcik on mouse -> clcik build event-> on right  side of u will see "Action catolog" ->"select Database Object" and clcik "Got to Record " in that u can select for next previous ,new ,last

MDSIDDIQALI.

Hi Friends,

              I have a problem in getting  value of a field from other table,I created the table 1   with fields of  product name,cost,In Table  2  i  created  product name which is a look up from table one and cost and  quantity,My task is when i select product i should get cost automatically.

 MD.SIDDIQALI

6 hours ago, mdsiddiqali wrote

Hi Friends,

              I have a problem in getting  value of a field from other table,I created the table 1   with fields of  product name,cost,In Table  2  i  created  product name which is a look up from table one and cost and  quantity,My task is when i select product i should get cost automatically.

 MD.SIDDIQALI

Products( ID, ProductName, Cost )

Table2( ID, ProductName, Quantity )

SELECT Products.ID, Products.ProductName, Products.Cost, Table2.Quantity FROM Table2 INNER JOIN Products ON Table2.ProductName = Products.ProductName

Note that this is bad normalisation because you're defining a relationship based on a textual value, rather than an integer ID.

This sounds suspiciously like undergraduate databases homework...

Thanks W3bbo,

 Here is my task that i mention clearly, I need  Retrieving Data from 2 tables based on a conditions .

Example: In Table 1 have 2 fields Product and cost ,In Table 2 Product ,cost and quantity are the fields in table 2 product is a look-up field from table 1.I have created forms based on the Tables ,In the 1st form when i enter the

product and cost in 2nd form when i select a product i need to get the the cost of a product from 1st Table automatically.


Please suggest me the way's how can i implement

Mdsiddiqali.

Unfortunately Mdsiddiqali I cannot understand the English to your problem well enough to be able to help.

Perhaps you should head over to StackOverflow.com where you are likely to get more of a response.

Good luck!
CaRDiaK

I suspect you might be looking at a design flaw.  Why are you storing the costs?  Conceptually you could easily calculate the value for display purposes and never store it.

Now if your project requires storage of the value then you have the problem of how to calculate the value and store the value.  This might be the purpose of your assignment (assuming it is an assignment).

If this is the case, you will need to step beyond the wizards and write some code.  Conceptually  you would need to add events to the "Product" and "Quantity" fields on your form to detect value changes.  On update of either of these fields you would then wish to update the value of the cost field by performing a lookup of table #1 using the current value of the "Product" lookup.  How and when you update the database would then also be a choice  you need to make.  Again, these are design considerations made in programming.