Search results for query: *

Private Sub TransactionDescription_AfterUpdate() If DLookup("[Description]", "tblDescription", "[Description] =" _& Forms![transactions]!cmbDescription) Then the error message I get is compile error, syntax error. Don't know whats wrong.

Still doesn't work any other ideas? Thanks.

Hello, It highlights the "&" and the whole first line of the code? Thanks

I don't know code very well, Im getting a compile error message with that code you gave me?? Thanks It is getting close to working.

Still need some help. The table that contains my transactions is called "transactions". I created the "tbldescriptions" table per your instructions. Do I put the combo box in the description feild in "transactions" or "tbldescription". Aslo, step 4 and on and a little confusing I cannot find...

Hello, I have a table called transactions in my accounting d-base. There is column heading called date, description, account, amount, and control. I post tansactions in there feilds by filling the required feilds. Sometimes I have the same transactions every month (recurring) and was wandering...

Hello I hope that there is a simple solution to what I want my website to do. I want to have a form on my homepage that lets the visitor select different choices ie through drop downs, check boxes ect and display the results on a different page. can anyone help me? thanks!

Hello Why do I get a #error message in the text bax with the following formula in my form? formula =sum([AMOUNT]) where AMOUNT is the field in my table called transactions the field contains both negative and positive values. That exact formula works with my report. Why is it like that for my...

Hello, Is it possible to copy certain records from one table to another? Thanks.

Hello, I really having a problem, I want to create and accounting balance sheet using the report function in access. I have set up a list of accounts that have a bunch of transactions posted to them. What I want to do is total the transactions for each account and put them in a specific...

Still didn't work?? what I want to do is total the values in the accounts with the same name. Any other ideas? thanks.

Can someone tell me why this formula doesn't work? =Sum(IIf([AccountName],"CURRENT PORTION - INV LEASES",[DepositAmount])) Thanks

I think that this can be a rounding issue. How do I roundto the nearest decimal?

Hello, I want to add to "general number" (in a box called total) text boxes together in a report.When I run the report the total box is off by one digit. eg 12+13=24 where it should be 25. Any suggestions?

Hello, I was wandering if there is a way to protect information in a table. I have a customer form that holds all of the information on a particular customer is there a way to lock the information making someone unable to change the info until they click the edit button? Thanks!

Hello, I have several reports with sub reports that all use the same query. I want to open them all at once with the same set of criteria. I created a macro to do it except when I run the macro I have to enter the same parameter value 6 times to open the different reports at the same time...

Thanks Randy, Unfortunatley that didn't work any other ideas? that I can try??

Hello, I have several reports with sub reports that all use the same query. I want to open them all at once with the same set of criteria. I created a macro to do it except when I run the macro I have to enter the same parameter value 6 times to open the different reports at the same time...

I was wandering if the "If" function can be used in reports. I want to display some text if the value in one field in the report is true. Can anyone help me thanks. This site is awesome!!

HELLO, I WAS WANDERING IF SOMEONE CAN HELP WITH MY REPORT. I WANT TO MAKE A CUSTOM REPORT THAT ABOUT 8 PAGES LONG. THE PROBLEM I'M HAVING IS THAT IN THE DESIGN VIEW UNDER THE DETAIL BAND, I RAN OUT OF ROOM IT ONLY WENT TO 22". HOW DO I MAKE ANOTHER PAGE OR MAKE THE SPACE UNDER THE DETAIL BAND...