Recent content by OAKLEYS21

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!