thanks a lot for your response. I found the answer. First I did calculation by query then run update query to update record in table. thanks again for your reply
I am stuck here for last 5 days. Here is my database. I need to calculate and add due amount for each time payment is made but can not understand how i can do that. I have added my payment table in the database. I am using Ms Access 2007. Please help me if you can. Any help will be appreciated...
Here is my problem. Trying to solve from last week. I am working with case files. In my main form i have a combo box named cboCaseType and in my sub form i have another combo box names cboCaseStage. I want to filter sub form combo box (cboCaseStage) by main form combo box (cboCaseType). I...
I am working with case management system. my table structure is like this:
tblCaseBasic
CaseNo - PK
DateFiled
CaseType
tblCaseUpdate
RecordNo - PK
CaseNo
LastDate
NextDate
CaseStage
tblCaseStage
StageID - PK
CaseStage
CaseType
Now my problem is, I want to filter the Combobox field CaseStage...
Greetings.
Here is my problem. I attached the sample file. I want to input data by the form frmCBasic with 3 sub forms. I want to set tab order after input data in main form "frmCBasic" then set focus to "frmPetitionerSubform" and input data, then set focus to "frmDefenderSubform" and input...
Hi all,
Natale, can u post ur existing data in the format currently is. Then we can see and advice u to develop ur own database setup..
Thanks everybody...
Is it possible to design drop down menu is Microsoft Access form?
If so, how can I design a drop down menu in my form?
Thanks and best regards.
Arif Masum
I am working on attendance database. I need to change program run date ( usually 1 or 2 days before current day).
I need to change the date from form and assign that date to every employee. Then I will run update query to update employee attendance informaitons. But I am stuck here. I don't...
Is it possible to add date sequence each time I run a macro?
Suppose I have a date table contains date 20/05/08 and dateID 1, I need to run macro to insert dateID as 2 and date as 21/05/08, I need this because I will run more macros in that specific macro...
Any advice will be...