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...
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
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
...I want the Total field's value to be automated. It should depend on the Amount and Qty fields like this:
Total = Amount * Qty
I want this value to be stored in the table tblTransaction and NOT JUST viewed on my form frmTransaction.
-----------------------------------------------PROBLEM...
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...
Hi.
I want to learn PHP. But I have found no tutorials online or books in my local library.
Does anyone know any links to websites for PHP (or ASP) for beginners please?
Or would anyone be able to assist me in any way please?
Many thanks!
Kind Regards,
Abhi
(Palbano) ok m8 I understand...
Thanks for ya help anyway!
Thanks for the advice minifiredragon... I already have SAMS Teach Yourself Visual C++ in 21 Days.
Regards,
Abhi
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.