Search results

  1. R

    Combo Box Updating queries

    Good morning All, I have create a form from scratch in which I included a combo box linked to a table (customers table) next, I created a query that outputs all the order made by a specific Client based on the selection of the above combo box. so far all works perfectly well. Next I dragged...
  2. R

    Images on Forms

    Hello All, Below is a Macro I wrote assigning a picture to an image box on a form. it worked properly then stopped for no reason. it is now generating runtime-error 2220 ============================================ Private Sub Combo45_Change() 'This is the By Part Reference ComboBox Dim...
  3. R

    Combo Box empty rows filtering

    Good Morning, Just Created a Form with a Combo Box. The combo box lists all the companies in the table. nonetheless, not all record contain a company name. is there a way to get rid of the empty spaces? Thanks in advance Roland
  4. R

    Nz() issue in expression Builder

    Good afternoon, I am trying to use the Nz expression as part of my Expression Builder Formula, however when I click OK the following message appears: The Expression Nz([Old Stock]) + Nz([New Stock]) cannot be used in a calculated column. Can anyone help? Thanks.
  5. R

    Roland

    Good morning, I am currently working on a stock management database, where all my stock is stored in a table "Table_Stock" This table was created and included the original stock quantities when I first created my database. Today we are placing an order for new stock. Should the existing...
  6. R

    Publishing Database

    Good morning, Can anyone refer me t a good tutorial on how to make my database accessible (read only) on other pcs? Thanks in advance Roland
  7. R

    Queries

    Good morning, While viewing the query in design view, I am unable to see the relationship tables at the top. Can someone help? Thanks Roland
  8. R

    Stock Management

    Greetings. I have created a simple stock management database using 3 basic tables: 1- Stock Table 2- Client Table 3- Transaction Table. I also established the 1 to many relationships: Stock to Transaction & Clients to Transaction I also created a query that allows me to list all the items that...
Top Bottom