Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: malbreht
  • Content: Threads
  • Order by date
  1. malbreht

    Problems with designing the database

    Hi! I've been using tek-tips for a while and you guys have helped me so much already. But now I got really stuck, have no idea how to move forward and have therefore prepared a problem description at http://shrani.si/files/problemdesrvs2.pdf . The 2 basic problems are: Problem no. 1: How to...
  2. malbreht

    Error by duplicating form/subform record

    Hi! I've followed the instructions at http://support.microsoft.com/kb/208824/en-us , adapted the names to my DB, however when pushing the button "Duplicate", I get the error: Item not found in this collection. And nothing happens - not even in VB there's no row highlighted! Any ideas what...
  3. malbreht

    TAB index

    Hi, My combo is a FindAsYouType combo and obviously its code overrides the tab index in the properties of the combo. Tab index is only 4, but the form always opens with this combo highlighted. Is there any code to say, this field in this form is to be first? Thanks, mare [thumbsup2] P.S...
  4. malbreht

    DLOOKUP error

    Hi! I want to do a lookup on tblProduct before entering the price of the product in tblPurchaseProduct. tblPurchaseProduct (PurhaseProduct_ID, Purchase_ID, Product_ID, Price, Quantity, Cancel) tblProduct (Product_ID, Name, Price) The names in my form are the same - Product_ID and Price. I...
  5. malbreht

    Form / subform problems

    Hi! I created a subform, so that I will be able to asign not just one item to an employee at a time. (description and tables at the very bottom of http://www.tek-tips.com/viewthread.cfm?qid=1320545&page=1) My main form is frmPurchase (Purchase_ID, Date, Year, Bill_No, Employee_ID, Name...
  6. malbreht

    Cancellation of an event called purchase

    Hi! I'm building a simple DB for tracking little products or items, that employees get from our company, for example an iPod for the director and a cell phone for his secretary:) I've already built almost everything, with the help of tek-tips of course, but now I got some new instructions...
  7. malbreht

    Find As Your Type Combobox

    Hi! I'm stuck at using the faq http://www.tek-tips.com/faqs.cfm?fid=6304 . These two lines are red Private WithEvents mCombo As Access.ComboBox Private WithEvents mForm As Access.Form and I'm not sure what to do with it... These are supposed to be instructions: Option Compare Database Option...
  8. malbreht

    Aplying the code to my DB

    Hi, I need my DB to store history data and have already found what it seems to me as a perfect solution at http://allenbrowne.com/AppAudit.html. The code itself is at http://allenbrowne.com/AppAuditCode.html. I've followed the instructions carefully, but since I'm not a programmer, I got...
  9. malbreht

    Choosing a record in a combo

    Hi! I've got a combo-box in a form (gets data from a query), where the user has to select one employee. When testing it with 10 employees, everything works just fine. However, the user will actually have to choose between 100 or even more employees. That's why I want to give him/her the...
  10. malbreht

    Inserting only one record from a table into report

    Hi, I want to sell the DB to not just one company, but want to have the name and the adress in every report head customized. That's why I've got a form where the company will enter their data into a table tblCompany (Name, Adress,...) However, if I insert the fields from that table into a...
  11. malbreht

    Auto-selecting the last entry in a combo-box

    Hi, I've got a form frmSell where you enter data for a receipt...among other data you have to select the customer from a combo-box. If the customer doesn't exist, you double-click on a combo-box to open the form frmCustomer for entering a new customer. However, when you enter the new customer...
  12. malbreht

    Unable to enter data in a form

    Hi, I've built a multiple tables form but can't enter any data (tried also with creating a query first and than a form from that query, didn't work as well). Also the little buttons to navigate between records are disabled. Here's some aditional info about my tables (simplified): tblCustomer...

Part and Inventory Search

Back
Top