Recent content by thunderbolt1164

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...

Thanks any suggestions? Know of List Fields but figure the would cause similar problems.

Thanks for the advise and link. Can you suggest another way to do it? I know of List Fields but figure that they would cause similar problems and my Product List is pretty big.(over 100 Items) Have been thinking of doing a VB database but am still learning.

There is Only One(1) AutoNumber per Table They are: tblTransactions *TransactionID: AutoNumber TransactionDate: Date/Time TransactionType: Text tblDropOffs *DropOffID: AutoNumber *TransactionID: Number Employee: LookUp Supplier: LookUp tblDropOffsDetails *DropOffDetailID: AutoNumber...

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

That did not work either. I entered some data in DropOffs but when I went into PickUps it was listed there too. I have a different DB that seems to almost work except that it does not have a summary page that works. What I would like is some way to pull data from 5 different Queries (that...

Thanks, That is what I thought so I have started over I now have 1 Transaction Table 1 Transaction Details Table and have use Query to make up the 4 different Forms I require, but now when I build a Query for SubTotal and insert it in the Form..It comes up a Blank Form. Could it...

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...

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

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...

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...

Thanks for yo help..I got that working

yeah...i think so

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...

RuralGuy: Just thought i would let you know the database seems to be working...still finding little errors here and there but have been able to figure them out. I would like to thank you for all the help you gave me, without your help I was just about to give up on it. Once I know that it is...