Recent content by djeeten

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

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

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

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

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.

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

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 ;-)

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

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

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.

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

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

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

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

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