Search results for query: *

If a form is looking at a query result, and you use the form to change the data (Which will change the query result), how do you refresh the query result without exiting the form and going back in. The form is datasheet view, and therefore I can't create a refresh button. Thank you for your help.

I am looking for the keyboard shortcut, not the formula. Thank you!

Thank you in advance for your help. I want to create a dateadd field in a query to display when a patient's next appointment is due. I need to find the most recent appointment date and add 6 months to it. I know how to use dateadd, but how do you tell the system to use only the most recent...

Thank you in advance for your help. I have a query that displays positive or negative in a field based on a calculation. There are four fields that display positive or negative. They are all attached to the same record number. example: record Value 123 Positive 123 Negative 123...

Thank you in advance for your help. I have a table that consist of 200 codes and their definitions. In another table I need to choose up to 5 of these codes to define a given task. I want the definition to automatically appear when I choose the code. I know I need to build a query to pull...

Thank you for your time. I have a form that looks at a query, which of course looks at a table. In the table I have a field that is set to the text datatype with a default set to 2004/2005. It looks fine in the table, but in the query and form the default shows .999501495513. Same situation...

When I run a report the page breaks and widths look great, but the last page on the report is always blank. What am I doing wrong? Thank you.

Thank you for reading. On a report I have created text boxes to show sums for Deposits, withdrawals, and balances. When the balance is a negative balance, it shows as a positive number. I'm using: =Sum([depositamount]) =Sum([Withdrawalamount]) =Sum([Depositamount]-[Withdrawalamount]) The...

Thank you for reading. When you create a parameter in a query, and run the query, it will not pull up a record if the field that has the parameter set to it is blank? I do not want to make all the parameter fields required fields. Is there anyway to work around this so that I can leave...

Thank you for reading. Everytime I open my database a message appears saying: "There may be a macro.....that may harm your computer, do you want to open anyway". Should I be worried about this? How can I remove it so that it doesn't appear? Thank you.

Thank you for reading. I would like to crate a button that refreshes the subform data only. The command button for "Refresh data" refreshes the entire form . Is there a code that will refresh the subform data only? Thank you

Thank you for reading! I have a form that calcualtes running totals. The subform looks at a query (qryinvoicesandbalances) with a parameter searching for FundID. I am using the following code on the main form for running totals...

On a form, I have a subform which looks at a query and shows the following field: Withdrawalamount depositamount In the footer I created three text boxes and used the following codes to get total withdrawals, total depostis and balances: =Forms!Transactions![Transactions Subform].Form![Total...

Thank you for reading. This is the basic checking ledger. I want access to read a beginning balance, subtract or add a given value, and return a new balance. I don't know where to store the beginning balance, and I do not know how to get access to return a new balance based on the previous...

Good morning. I am trying to put the company budget on access. I have set up a table that looks just like a checkbook ledger. How do I incorporate a beginning balance? I need each item to subtract or add from the balance and give a new balance? I am assuming you put the beginning balance in...