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?

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...

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?

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...

I have a form called ToolBookOut, in the form there is a few fields, 1)Current Stock 2)Quantity 3)New Stock Level How this form works is when you add a value in quantity it deducts the value from current stock and put it in the new stock level! I now need to get the form to carry the value...

Hi There I have 2 forms: 1)FrmTools 2)FrmToolBookOut On Both forms there is a field called quantity! If I Book out a tool on the FrmToolBookOut Form I need it to deduct it from FrmTools! Please does anyone have the code to help me here?

Is there a way of making the drop down arrow wider and bigger? We are using a touch screen and it is almost impossible to use the normal size drop down arrow on the combo box! I have made the actual combo box bigger but the arrow stays the same size!!!

I have a table with several staff members, from that table I need to get the efficiency of each employee. At the moment I am getting it but only one per page in my report I need the whole section on one page. Fields in table: Name | Date | Product | Efficiency | Name Expr1 Expr2 STD Kg Expr3...

Is it possible to draw graphs from the information in a query without physically entering the values? Please help!!!!

I have a dbase where we get our recipes from, I now created a query to get the weighted averages but I want to group the ingredients when I run the report. Here ia an example of the table: Date |Ingredient|OrderQty|Weight|Qty/Lug|Waste|Exp1|Expr2| 01/08| Onions | 10 | 0.20 | 6 | 80 |...