Recent content by Only1Abhi

problem solved by turning Long Integer into Single. Thanx anyways ppl! (double will also work)!

Hi. I have a with lots of fields, but 2 in particular. In Table Design View, I have set these 2 fields to Long Integer field size, General Number format, 2 decimal places, default value 0, NOT indexed, NOT required. But when I type a value in the table in these 2 fields (or in the form I made...

thanks Ken someone else in another forum suggested the same. It worked. Many thanks. Bye!

lol... then again people... I was thinking... Is it possible for the "Dates" field (updated name of the field "Date") to have TODAY's date automatically stored everytime? When I make a transaction, it will be automated to TODAY's date. But when I make a transaction...

yeh thanks! It did work actually! The regional settings on CONTROL PANEL had language set to English (US) and not English (UK) That solved the problem. Many thanks! Best Regards, Abhi

Magic... Magic... It works! Thanks millions, billions and gazillions. Kenray is the Don! ;o) Thank You Very Much. Kind Regards, Abhi

But the problem is still there! :(

this is what I done. Still not working though! :( Private Sub Form_BeforeUpdate(Cancel As Integer) Me.txtTotal = Me.txtCalc DoCmd.RunCommand acCmdSaveRecord End Sub

yes! All that is set to UK default!

Hi People! I posted this problem years ago! I searched for the thread but couldn't find it! So... I'm posting it again! Hoping access professionals can help out! ---------------------------------------------SCENARIO------------------------- I have a table called tblTransaction. In...

Basically, when I choose the Data Type for my field "Date" as Date/Time, all dates are in: month/day/year format. I need day/month/year format! How is this possible? Many thanks!

thanks! But I solved this problem! I just deleted fields CustomerForename and CustomerSurname from tblTransaction. That solved it! Many thanks anyways! Kind Regards, Abhi

thanks guys... But I solved it using another way. When I click the button, another form loads with Yes & No button. That solved the problem. Thanks anyway! Kind Regards, Abhi!

Hi People. What's wrong with this code? When I press the button to exit the program, I want a message box to appear, which confirms this action. Private Sub cmdExit_Click() MsgBox("Are you sure you want to exit?", vbYesNo, "Exit The Program") End Sub

Hi. I have a problem that I tried to solve. It's very hard for me but maybe people with good access knowledge can help! -------------------------------------SCENARIO--------------------------- I have a table called "tblCustomer", with fields: CustomerID (Autonumber) Forename...