Search results

Hi, im making a form which calculates the total of a till at the end of the day. Once this is saved i enter it in a database called 'tblEndofDayTotal'. What i want to do is: Ive got a button which links to this form. So when the button is pressed, I want it to check the tblEndofdayTotal...

Hello, Ive got an order table with a few fields one of them being 'Paid' and one being PaymentDate Paid is the amount someone has made a payment for PaymentDate is the date the payment was processed. Now what im trying to make is a End of Day Total page which will Sum up all the payments made...

Hello, I have a combo box on an order form which the user can purchase products. Now what i want to do is when the user chooses a product, and wants to buy more, when the drop down is clicked that same product they have bought should not appear in the drop down list. To do this, In my...

Hello, I have a form with bound textfields. These used to show the last record that was entered in it by using: Forms!frmProduct.Recordset.FindFirst "ProductID = " & DMax("ProductID", "tblProduct") that code used to work and it used to show the last product in the databse. What...

Hello, Im making an order system with a multi log in user page. The owner and staff can log on. Atm ive got it working so that if a staff logs on it goes to their main menu and if the owner logs on it goes to the owner menu. To do this ive used the following code: Public Sub...

Hello, Ive got a form where a customer can place an order. now at the bottom i want to put an execute statement which will look at the product ID that has been ordered and make sure that it dont allow that one to be entered again. This is the coding ive got atm to do that: db.Execute...

Hello, Ive got a Date of Birth txtbox which if the user clicks it, it should pop up with a calendar that the user can then choose a date for the DOB. Now ive seen a few people say that you change the 'Show date Picker' to "For Dates". Now ive done this and the pop up calendar still dont...

Hello, Ive got a form with bound txt boxes that displays the information in the database. Now ive put an edit button which when its clicked it allow the txt boxes and combo boxes to be edited. Ive got the edits and so forth to work. This is the coding for my Save Button Private Sub...

Hello, Ive got a product table with a ProductID which is an autonumber. As this increments itself - When a product is deleted that prodID disappears and it is not replaced so when a product is added it carries on with the autonumber. Example: Last ProductID used is 80. ProductID 80 is...

Hello, Ive got a form with bound txt boxes. these look into my 'Product' Table and show the last product entered. Now ive got a search button on the same page. When you clcik the search button a combo box appears which has in it a list of all the values in the Product table. What i want...

Ive got a bound form which displays the last record that has been entered in the database. this shows the details: ProductID, Desc, quantity, size, price etc.. i done it using: Forms!frmProduct.Recordset.FindFirst "ProductID = " & DMax("ProductID", "tblProduct") Now on another form what...

Hi, Ive got a bound form which has the following info. These are all in a table called 'tblProduct' ProductID Description Category Size Quantity Price Now when i use the bound form it shows the first record in the database. What i want to do is whenever the form is opened it goes to...

Hi, Im making a form which allows the user to add products to the database i have created. Now in my table (tblProduct) ive got a ProductID field which auto incrmements for every product added. What im trying to do it display the next ProductID on the form so that the user can see what number...