Recent content by Alvin85

When i download https://www.access-programmers.co.uk/forums/showthread.php?t=293579 and try to access, I have compile error: The code in this project must be updated for use on 64-bits systems. Please review and update Declare statements and then Mark them with the PtrSafe attribute. May i...

Hi Markk, I tried cancel = true. But I am no longer able to close the form and go to the next form. May i know where did I did wrong and anyway to go about it? And may i ask what do u mean by having a hidden form open at all times? Do you have a sample?

Hi ridders, Thanks. Is there a way to disable the x button for the access application too?

Hi, I want the user to click on the button - btnClose to close the application instead of the user closing the forms or application via the X button. Is there any ways to disable the close button on the top right hand of the forms and on the top right hand of the access application?

Hi, I am trying to insert a new row of data into the table UserTable if the UserLogin is not found in the table. When i run the coding, an error appear. Compile error: Expected Expression. May i ask how do i solve this problem? Following is my coding: If isnull ( select [UserLogin] from...

Hi arnelgp, May i know what is what is .BOF and .EOF from your coding? Private Sub Form_BeforeUpdate(Cancel As Integer) Dim thisPrice As Double If Me.NewRecord Then thisPrice = Me.PriceOfToy With Me.RecordsetClone If Not (.BOF And .EOF) Then .FindFirst "[DateOfPurchase] = #" &...

No i not. I m just curious if there is. Thank you:)

Thank you :) on the same note, is there a way to do it without having the need of the overview page to be open?

I have 2 forms namely PrecedencePage and OverviewPage. I have 1 textbox named txt_fine and 1 button named btn_view in PrecedencePage. I have a textbox name txtView in OverviewPage. The idea is for the txtview in OverviewPage to see what user had key in previously in PrecedencePage's txt_fine.*...

Thank you for the idea. :)

Hi, I have 2 forms namely form1,form2. I have an label named lblerror, a textbox named txtsearch and a button named btn_next in form1. lblerror default visible is false I have 2 textbox name txt1 and txt2. and a button named btn return. Both txt1 and txt2 default visible is false. If user...

I have a if else statement in miscrosoft access. My user keyed in txtB with the input YES but the statement return an alert box no input instead of the value YES. Below is my if else statement. Please help me find out where is the mistake. Please If me.txtA.value <>"" and me.txtB.value ="" then...

Hi Mr pat, As the value of the toy might change, i will only need to add the newly keyed price by the user with the existing price stored in the database. :)

I have a table namely tempDB. The table have col namely [PriceOfToy],[dateOfPurchase]. User will key in the price of toy and date of purchase. How do I retrieve the all datas from tempDB and check if there is a same dateOfPurchase. If there is a same dateOfPurchase, then the PriceOfToy will be...

I have a textbox by the name txt_date. The user will key in the date. The program is supposed to count the total number of days in the month which the user had key in. May i know what is the coding to do the counting? Example 1: user keyed in 5/2/2020. The program supposed to display day in...