Search results

  1. L

    store concatenated values in one filed

    hi guys, i have a form that contains two controls, one is a combo box which contains dailing code list and the other one contains phone number. both controls are unbound. i want to store the values from the two controls in one filed on my table. the reason i wanna do so is because the dailing...
  2. L

    Subform dirty

    hi guys, i'm working on an access DB however my knoledge in VBA is very poor, here is my question: i have a main form called client_orders which include subform called client_order_details. i created a close button on the main form, when user trying to close the form it will popup a save...
  3. L

    Designing stock DB

    hi everyone, I'm building a database for stock management, all the incoming supply that I get from every supplier goes into one table, and of course the sales I make goes to other table. Say I'm selling a products package that includes some products, so for that I create a table which includes...
  4. L

    sub form listbox based on auto number field from main form

    Hello, i have a form based on a table, in the table i have a field called ID which is an Autonumber . for every record, the form lists a new Autonumber in the ID field. the same form also includes a sub form in which i'm trying to create a list box that lists the values of the ID field from...
  5. L

    Popup message based on a field value

    Hello, very new to vba, i have a data base that contains CLIENT ORDERS TABLE and a CLIENT ORDERS FORM that feeds this table, in this table i have a YES/NO field for payment status, yes = paid order. i also created a CLIENT DEBTS QUERY that shows qlients that have a debt based on the YES/NO...
  6. L

    Calculation with query or report

    Hi everybody, i'm buliding a database to manage a small business stock, i have three tables: one which contain the PRODUCTS INFORMATION and includes two fields product ID field and product name field. the second table contains information about PRODUCTS IN STOCK, and feeds according to...
  7. L

    create dropdown list in a form with one to many relation

    Hi all, i'm sure it's simple question but i'm new to access. i have two tables, one contain Suppliers information and the other one includes information on orders i made from this suppliers. i would like to create a form that feeds data to the orders table. i'm trying to create the form so i can...
  8. L

    field related to combobox

    hi everyone, access amateur, i've created a form with a combo box and i want other fields in the form to be related to the option chosen in the combo box, for example, if a user want to enter data on a new computer part through a form the first step will be choosing the type of hardware in...
Back
Top Bottom