Search results

I am trying to update a field in a table with the word "No" via an update query. I am not sure of the correct procedure with a string.. The code below, writes a "0" when run.. strSQLstatement = "UPDATE [Tblstock_item] SET [Tblstock_item].[Available] = No " & " WHERE...

Hi All, I hope I can explain what I am trying to achieve.. I have a "Top 1" query (Qry_Avail_StockItem), which selects the next available record in a table. I have a main form (Frm_MasterStock) with a command button "Add Record". If the user clicks the "Add Record" button, I need the form to go...

Hi All, I am not sure if this is an easy one or not.. I have a field in a table named Stock_Alias. This field was originally set as a Number field. I have a combo box on a form, which contains the Stock_Alias numbers. When a number is selected, the remaining fields are shown in text boxes. I...

Hi All, What is the easist way to select a column's value in a subform. After the record is selected I would like to write a value ("0") into this column by way of a button click.. Thanks in advance..

Hi, I am trying to copy the contents of a table with 11 fields into a new table which is the same except for an additional two fields at the end. Any advice would be appreciated.. Thanks..

Hi All, I am relatively new to Access and trying to construct a simple Stock Inventory Databse. I have two main tables for stock - TblPlu, which holds all the child items (product items ie. Pint Guinness etc..) TblMasterStock - which holds all the parent items (keg guinness etc.. ). End Result...

Hi All, I am trying to perform a query on two tables, with the result being a Dept Name & Dept Number. One table consists of an Index Number & Dept Name, the other table has Dept Number. The index Numbers & Names 14 thru 37 in first table correspond to Dept Numbers 1 thru 24 in second table...