Search results for query: *

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

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

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

Hi, I have these 2 forms frmProducts & frmSearchProducts. By clicking a button on frmProducts, frmSearchProducts is opened. On the form frmProducts the user can navigate through all the records of the table tblProducts(all the fields are on the form). On the form frmSearchProducts, there is a...

I keep getting this error & don't know how to handle it this is my code: ---------------------------------------------- Private Sub cmdDelete_Click() Dim con As Object Dim stSql1 As String Dim stSql2 As String Dim stSql3 As String Dim stSql4 As String stSql1 =...

Hi, In my program, I have this form where a customer can suggest a new product. --------------------------- Name: ..... Definition:..... Maximumprice:..... Note:..... -------------------------- But now, I would like the information on this form to be emailed. Does anyone know how I could do...

Hi, on this particular form, certain fields have to be filled in: -------------- CustomerName ... Group Password -------------- The form is based on the table tblCustomer and Required is set to True for those 3 fields. For those 3 fields I also set the validation rule to: 'Is Not Null' (both...

Hi, I have this form and subform. For each record on the subform, a value has to be filled in (amount). If you fill in a value in a textfield in the subform and then hit the tab key, or place the cursor to another field on the subform/main form, the records in the tables are updated...

Hi, I'm creating this program that allows users to make orders. To make sure everything works easy for the user of the program I created this table tblCustomerOnline where I store the name of the client as long as he is online. My problem now is that I have just been told that several...

Hi, I'm having this little problem. I'm creating this program that allows customers to place an order. First he has to choose on a small form which kind of products (productgroup) he wishes to order. Once the customer has confirmed that, frmOrders is loaded, where the customer can only...

Hi, I have this field 'Amount' on a subform 'sfrmOrders'. Every time a product is choosen (from a listbox on the main form) it is inserted in the subform and the 'Amount' is set to 1. Now, whenever the 'Amount' of a certain product is changed on the subform, the total cost of the order...

Hi, I have this main form frmOrders and subform sfrmOrders. On the main form you can choose products from a listbox. If you click on a button next to the listbox, this product is added to a table called tblOrderlines. The products that have been choosen are seen in the subform. I get an error...

Hi, I have this main form frmOrders where you have a lisbox from which you can choose products. Once you have choosen a product you need to click on a button (also on main form) to confirm this and it should be displayed directly in the subform. All you need to do then is fill in an amount (of...

Hi, I have these 3 related tables: tblProductMainGroup, tblProductSubGroup and tblProduct. I would like to create a form where you can choose a ProductMainGroup from a list, after which you van choose the ProductSubGroups that belong to the main group. And finally you will be able to view all...

Hi, I have this (sub)form with a listbox containing the different products a user can choose from to order. Now, once a user has choosen a product, it needs to be out of the list, or the user should not be able to choose it(giving a message when choosen for example). A user can of course also...

Hi, A brief description of what I'm doing: I'm creating this little program that enables people to place an order using a main form frmOrder(containing OrderId, CustomerId,...) and a subform sfrmOrder(where the customer can choose several products he wants to order and give the amount). The...