Search results for query: *

I have a table called Orders with 3 Day fields called: 1)Day1 2)Day2 3)Day3. I now need to create a append query to copy these days into one field in a new table, but I now need it to ask which days need to be copied into the new combined field called combined. How will I do this?

Thanks Guys. What I have done is added a ID(AutoNumber) in the table, I then said: If ID = "1" Then Area = "WC" Else If ID = "2" Then Area = "GAU" End If End If Thanks for making it a lot more clear to me!

This is what my table looks like: Product Qty Area 0001 50 GAU 0002 10 0003 5 0004 70 0005 80 0002 30 WC 0009 5 0010...

It is the 3000th Record! A product can belong to all 3 regions. All I am trying to achieve is to determine the qty of products that was sold to area 1)GAU 2)WC 3)Nat? And for that I need the area next to each record in my table! Hope this is more clear

I have a form with these fields: 1)Product 2)Qty 3)Area In the area field there is 3 options: 1)GAU 2)WC 3)NAT The problem i am sitting with is that say in record 1 i will have GAU in the area field and in record 3000 I will have WC in the area field. I now need to update all the...

Thanks Ken Reay And Danvlas This is my code that I have been using, it works to some degree there is only one problem and it it that on the form I have 10 Records with sub regions before we get to say the GAU region. Now I need all the other Records between the two regions to belong to the 1st...

Thanks it it working up to a point! It is putting "WC" in Area but as soon as it gets to the next RH field it continues to put "WC" in the field instead of going over to "Gau"! I am maybe doing something wrong!!!

I have a form with a Field called RDRH and a field called area. I want to add a value like "WC" in the area field till the value in the RDRH field = "RH" Then I want the area field to change to "Gau" is it possible to do it in the got focus option? And how will I go about doing this with code...

I have a table with a Anonymous field and a region field In the Anonymous field I have three values = "10" "30" "60".That only apears once in the table/Form. I need a query that will write a value = "WC" into the region field till it gets to the the "30" value. Is it possible in any way to do...

I have a text file with RH(Row Header) and RD(Row Detail) fields. Is there away of importing the file into access?

How do you change the view of a form in Vb from Single Record to Datasheet?

Hi I am very new at VB only started last week! I want to know is there a way of adding a sub-form to a form like in access? I have looked everywher and cant seem to find it!

Is there a way of creating a delete query that delete all the entries in a table except the last record?

I have a form called FrmGrn that is based on a table called tblGrn!I also have a table called TblGrnTemp. If I add a record to my form then I want it to add the record to both my tables and not just the one! In the tblGrnTemp I only Want one record at a time for stock purposes! Is it possible...

I have form with a command button and a text box! I want to add the value yes in the text box when I click on the command button! How will I be able to do that? Please help

I have a dbase in access97! In the dbase I have a form Qc and a form GRN! I then have 2 check boxes one for qc and one for grn! I want the computer to tick(activate) the box after completion of the form, when I close the form! Is there any way of doing that?

It is a Continuous Form! And the stoc on hand is a text box!

Please help! I have a stock dbase with stock levels! The fields I am working with is 1) Product 2) Stock On Hand.I want the dbase to mark a negative stock count in red(Stock on Hand) and a positive stock count in black! Is there anyway of achieving that???

I have a table with the following fields: 1)Supplier 2) Product 3)No of Lugs! I want to print labels, say the number of lugs is 5 then I need it to print 5 labels with the labels numbered 1 - 5! How will I go about doing this! Is there some code that I can add in the ReportOpen field?

I have a stock receiving Dbase! I have created a append qry that copies the record to the stock table, but it is adding a new record everytime instead of just adding the quantity of a specific product to the table! how can I get it to identify a product name and just adding the incoming stock...