This is my DLO0KUP Query
Me.BalanceA = DLookup("Balance", "CardDetails", "CardNo='" & Me.Combo60 & "'")
When I add this to Combo Box It work and show the result in the form field. But When I Add this to my Submit button it doesn't Work?
Why is it?
I was created a Query to Update A table Field Value. Icreated a form and add button to run the query. The query is only update the field value of a table. So How can i show inmy form next to query submit button Result of the query (After run the Query Updated Field Value) .
Please Help Me...
I have two tables
2.Add Product (RefeNo,PID,Amount)
I created Form to Add Product Table. Also Create query to update QTY_Balance by in relevant product after add products by forms. Query Also Working No Issue.
Now I want to Pop up Message "Your Balance is...
I created Access Database with Forums. And I created Login Form Also. When I Open My Access File First automatically it ask to Login. It's Ok.
Now I want to do it when i am Input correct user name and password I want to open automatically Onther Form. How to do it? Here is the Code in Login...
How can i change Primary Key Dublication message in My Form. when I Duplicate Primary key in form it show " The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields...
I created a Query when i Run it it it work perfectly.
Then I Add Query to New Button It also Worked.
When I add Query to Add Record but using marco add query it run but dont update rows. But when I run it in new button it update Records.
What is the Issue
I was already created Form for CardTopUp by using CardTopUp Table. It has These fields.
There is another table CardDetails It has these fields.
In this field there is a amount .
What i want to do it when iTop up my card using CardTopUp form, when click submit...
I have two tables.
Fields : CardNo
I created a form using CardTopUp Table. What i Want to do is when i click submit button
1. Insert the record to Cardtopup table
I am Very Very New Student For MS Access.I have a Problem in my Access Data base
I have Tables
It has these fields.
In this table Have these fields
As a example i entered fare for between two bus top. as...