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!

Register Log in
  • Congratulations Chriss Miller 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: *

  1. djeeten

    Shift - enter. Please help!

    Hi, I know this question has been asked before, and I have read the faq about this, but I don't know what to do with it. I have this application in access, called supply management. The application starts with the form frmLogon. But when a user opens the application with shift+enter, the...
  2. djeeten

    vbKeyReturn

    Hi, I have this logon form where a user has to give in his name and password. There are also 2 buttons on the form: Submit and Cancel. Now, I want to make sure that pressing the return button does the same as when pressing the button Submit. So it should do this: Private Sub...
  3. djeeten

    Speed problem with Form_Load()

    Hi, Skipping the code in Form_Load() does not make the form load faster. However, I started reading the additional tips and found something that was slowing it down a little bit. As a user logs on correctly, the visible property of the logon form is set to false. That way I can retrieve the...
  4. djeeten

    Speed problem with Form_Load()

    Hi, I have a serious speed problem when this form frmChangeOrders is loaded. Using this form, users can change the orders they have already made. This is the relation between the tables: tblCustomer tblOrders tblOrderlines tblProducts ----------- --------- -------------...
  5. djeeten

    Turn of the year

    Hi, I still don't know how to solve my problem. In the table tblOrderlines there will be inserted about 20.000 records a year (in the table tblOrders about 2.000 a year). Will this give serious speed & performance problems after a few years??? Thanks in advance, dj.
  6. djeeten

    Form allowing edits problem!

    In the code of the button on form one put this: DoCmd.OpenForm "name of form two", acNormal, , , acFormReadOnly
  7. djeeten

    Help with form: Couldent update, currently locked

    I get the same error sometimes, and all I need to do then is close the database, remove the lockfile (this file is always created when you open the database) and try again. I hope that does it for you as well ;-)
  8. djeeten

    Help with form: Couldent update, currently locked

    It probably means that your database is opened. Otherwise try again after removing the lockfile.
  9. djeeten

    Save selected record on form A into a different table

    Hi, I'm a bit confused about your tables and how they relate. (misschien zou het makkelijker zijn in het Nederlands ;-) ) Let me just give you an example of how to insert records into a table by pressing a command button. ---------------------------------------------------- Private Sub...
  10. djeeten

    Save selected record on form A into a different table

    Oops, well in that case, I would like to help you out a little, but then I need more information: what's the exact name of the table, the name of the field with the value you want to insert into the table, how you select an offer (is it by pressing a button or ...),... dj.
  11. djeeten

    Save selected record on form A into a different table

    Hi, I guess you just need to Insert the offer into this table "confirmed orders" using vba... What does your code look like? dj.
  12. djeeten

    Turn of the year

    Hi, Thanks WildHare for your answer. You're right, budgets can change from year to year. I'm still not so sure about what I should do though... You see, the table tblOrders (together with the table tblOrderlines) will be huge after one year. So I think it will be better to create a new table...
  13. djeeten

    2 lisboxes

    Thanks danvlas. Silly me... GHolden, it's not a good idea to change the recordsource when choosing a product from the second list, as the user should be able to choose every supplier at all times. I am changing the recordsource for the products list when the user chooses a certain supplier from...
  14. djeeten

    2 lisboxes

    Hi, probably a stupid question but: I have 2 lisboxes on this form. One is based on the table tblSuppliers and has 2 columns: SupplierId and SupplierName. Only SupplierName is visible. The second lisbox is based on the table tblProducts and has 4 columns: ProductId, ProductName, SupplierId...
  15. djeeten

    Turn of the year

    Hi, I have created this database, allowing users to make orders etc. There are several tables in the database, such as tblCustomers, tblProducts, tblOrders,... Every user (from the table tblCustomers) is allowed to place orders for certain product groups. So a certain user may not be allowed...
  16. djeeten

    Listboxes

    Hi fneily, I don't want the analytical code and description to appear in the same list, as the user should be able to search the analytical code by its code or its description. That's why there should be 2 listboxes, you see? I'm still kind of stuck here though, I tried to put this in the...
  17. djeeten

    Response....

    patience?
  18. djeeten

    Listboxes

    Hi, this probably is a stupid question, but I cannot work it out myself. I have this table tblAnalyticalCodes with 3 fields in it: -Analytical code -Description -Groupcode (this is the code of a main group) there are 3 tables involved here like this: tblProducts n--1 tblAnalyticalCodes n--1...
  19. djeeten

    Search in table

    Hi Nath, thanks for trying to help me. To answer your question: No, Product and analytical codes are textfields. I just figured out what went wrong though. I need to use square brackets in order to make it work correctly (as Analytical code is not one word and Productcode(Supplier) has...
  20. djeeten

    Search in table

    Hi, I have this form frmSearchProducts with several textboxes where the user can fill in a value. My code works perfectly for all the fields on the form, except for the fields where the Productcode and Analytical code have to be filled in. So, when the user enters for example the letter 'p'...

Part and Inventory Search

Back
Top