Search results

  1. D

    Internet(Think)

    How do I go about if I have a program on a computer inside that I have built and I want to be able to access it from a laptop outside so that when I enter a record on the Laptop its updated on the one inside.
  2. D

    Fields

    I have a Table Called Stock which has Stock Name and Stock Quantites so when you add to your stock you put in how many are in stock and also it allows you to update so you can do stock takes, what im wondering is it possible to add a price field to the stock and when I bring up Stock in...
  3. D

    Formating

    I Have some fields to enter percentages which are text boxes and then other fileds (text) to enter fuel ammounts for example 3,405.00 (litres)*69.44 % = 236443.2 and it should be something like 2364.43 another is 882*65.00% and it gives me back 57330 and it should be 573.30 what am I doing...
  4. D

    Table

    I have a form with a sub form which is Tabular so when I enter a record it creates another set of feilds automaticaly, I have a field Invoice number which is put in manualy.....is there any way that when you put it in once it automatically goes onto the next one after a record is enterd so I...
  5. D

    Dates

    Can anyone please tell me or show me how to put be prompted to put in two dates so you can see records between to alocated dates, Im only doing this in Access not visual basic. Regards Dave.
  6. D

    Union Query

    I have managed to get this Union query to help in some calculations for a stock take but have no Sum of Quantity in it so I done another Query via the wizard and done a Sum of Query in that for quantity......its nearly perfect but it some times doesnt recognize a new stock ammount entred, any...
  7. D

    Calulations 2

    Sorry about he previous data base I attatched that had no data making it hard to see the problem, have now entred a item so you can see the problem to edit the item (update) obviously click on edit stock item then choose the a catergory and click on the item that will then allow you to update...
  8. D

    Stuck on a calculation

    Im still having problems with this query that is doing a stock take for me, in the tables the numbers are all as they are meant to be but when I run the query (Stcok Take) the numbers are all doubled, has anyone got any ideas.....please. Have attatched it for anyone who is interested or can...
  9. D

    calculations

    I have two tables..stock added and stock sold so when a particular stock item is invoiced out it takes it of the stock on hand but when I go to edit the stock item as to add another delivery of that item i.e say another 20 drums all the calculations in the stock added etc double up throwing the...
  10. D

    Building new Data Base

    Is there anyone that could build me a simple data base, basically I need it to be able to enter stock names so when new stock arrives I can pick it from a drop down menu and add a quanitity and clients details so I can invoice stock out to clients. Then the big one.....be able to do a stock...
  11. D

    Rows/Columns

    Is there any way in a querie that I can have the data from one product displayed across the screen so that I can do a Sum off that one particular product. Just think it would be a way of solving the problem I have with doing Stock Takes and updating stock numbers of produce coming in. Im only...
  12. D

    Stock Take HELP?

    Can anyone help please , Im only a basic user of Access and Im trying to develop a program for my small busness so that I can keep a track of stock in and out of the shop and im having trouble with stock coming in, have a form with a sub form...main form is for the company at the time bringing...
  13. D

    Stock Take HELP?

    Can anyone help please , Im only a basic user of Access and Im trying to develop a program for my small busness so that I can keep a track of stock in and out of the shop and im having trouble with stock coming in, have a form with a sub form...main form is for the company at the time bringing...
  14. D

    Stock Take ...HELP?

    Can anyone help please , Im only a basic user of Access and Im trying to develop a program for my small busness so that I can keep a track of stock in and out of the shop and im having trouble with stock coming in, have a form with a sub form...main form is for the company at the time bringing...
  15. D

    Stock Taking...HOW?

    Can anyone help please , Im only a basic user of Access and Im trying to develop a program for my small busness so that I can keep a track of stock in and out of the shop and im having trouble with stock coming in, have a form with a sub form...main form is for the company at the time bringing...
  16. D

    Stock Taking/Invoice

    Can anyone please help me, Im only a basic user of Access and Im trying to develop a program for my small busness so that I can keep a track of stock in and out of the shop and im having trouble with stock coming in, have a form with a sub form...main form is for the company at the time bringing...
Back
Top Bottom