Recent content by coyote

i have come to realise the problem is not the barcode scanner. After scanning the product i want the user to see all the other details like productcode(sku), price and all that. The only problem is that the barcode is not the primary key as some products sold don't have codes. so am using...

Hi, I have an inventory system designed in access 2007 that tracks products This thing was working well until i introduced barcode scanning. The forms have the required fields. When registering a product a barcode is entered in a barcode textfield and saved to the table. When selling the product...

Hi, I have a main form with a subform. I want to manage branch stocks. I have a table called tblProducts. All i want is once i enter the branch in the main form, then the subform is populated with the products from tblproducts, because all the branches sell the same products and entering the...

Works fine except there is an overflow error when for example 40,000 payable in 6 months starting november. Thanks a lot

Tried but am getting an error can't go to the specified record. CBrighton can you attach the code in the sample dbase you sent me.

Thanks Checking the new update. Question though Assume a loan of 12,000 is given in November 2011 and is payable in 6 months how do i make the year jump to 2012 after the December payment. Thanks

Works so nicely thanks a lot. One thing if i put an amount like 5600 and payable in 3 months i get decimals. Is there a way to calculate the amount in even numbers and the last balance is inputed in the last month. But the db works for me . Thanks a lot

Hi guys, I have a loan issue form with a subform. In the main loan issue form i have LoanIssueID (assume 1) LoanIssueDate (assume date now) EmployeeID (assume John Doe) LoanAmount ( assume 1000) Then I have unbound textboxes txtPayTimes (assume 2) txtAmount (500) txtBalance The subform...

Well i have cracked it since i was updating records in the same table and the relationship was using the AccountID in both queries, i changed the relationship to AccountAdd in the second query and it works. Thanks

As a part of an Inventory/Accounting system I have a table called tblAccounts with fields AccountID, AccountName and CurrentBalance. The accounts are AccountID AccountName CurrentBalance 1 Accounts Receivable 10,000.00 2 Cash at hand I also have a...

download the ribbon creator and the help, install the creator and follow the help file and i assure you, your application will be totally different.

http://www.ribboncreator.de/en/index.php?Download use the ribbon creator to customize your ribbon. put only the useful buttons and it makes the application professional and easy to use.

This is the database guys please help

Guys help me with this. Can anyone help me recover the data in the attached database. Its very urgent. Its a backend to an inventory database. In the front end i have a function that backs up the back end but I now have all the copies of the back end with this error. Please any help guys

Sorry I was not clear, In the first scenario I want the tab to appear but the user should not be able to to anything when they right click it. Second scenario, the form is for editing records so it should open with the related records in the subform but they keep on disappearing but once you...