Search results

  1. T

    Quantity Control

    Hello Have been working on a DB for awhile now and am now stuck at Quantity control. I have 5 different types of Transactions which are picked by which Button you click. Drop-Offs =Addition Pick-Ups =Addition TearDowns =Subtraction Sales...
  2. T

    AutoNumbering

    My Question is: Can you put Two(2) AutoNumber Fields on One(1) Form? When I Coded my "New Transaction" Button with: DoCmd.GoToRecord,,acNewRec I get an Application or Object-Defined Error
  3. T

    Changing ID in multiple Tables

    I have been building a DB for a while and have broken the tables down to 4 different tables using 4 differnt ID's: DropOffs ----- DropOffID PickUps ----- PickUpID Sales ----- SaleID Repairs ----- RepairID Is it possible to change each ID to 1 common ID like: TransactionID ? Now that I think...
  4. T

    Button Cotrol help

    Is there a way to setup a button command code so that it opens up the form (which iam able to to do :) ),but have it also auto fill a text box with different thing, depending on which button you click? TY in Advance
  5. T

    Forms show negative

    I am building a db and on it forms I have: Subtotal Labour GST Total Payment(Button) Amount Owing They all seem to work until I click Payment and enter the Total amount, then I get Amount Owing -0.01 or -0.02 Is there way to fix this (I think it has to do with the GST), Maybe by using an IF...
  6. T

    BookKeeping Report Help Needed

    Hi Everybody; Have been building this db for awhile and think that i am stuck at the end (at least i hope it is the end) :D The db I am builing is for my Computer Recycling & Elictronic Waste (E-Waste) Business and has differernt forms which some are: Drop-Offs Income Pick-UPs...
  7. T

    New record botton control

    Hi I am working on a database for my new business and need some help. For each section I have 4 forms: Tansactions Form (MainForm) Transaction SubForm (Listing All Transactions) DropOffs (for entering Supplier Information) DropOffs Subform (for entering quantity and Items) Now what I want...
  8. T

    Report Date Range showing all dates

    I have been trying to build a database for my business for the last 4 months off and on. I am down to doing up the reports and am stuck again. I have set up DATE FORM and added a text box to the report. When I click on the Report it brings up the Date Form, but when i click OK it still lists all...
Back
Top Bottom