Search results

Well, I'm confused. I diddnt know there was any kind of chart apart from a form which has its default appearance set as chart (which was what was in the example). But I found what you were talking about, and I can't seem to get thet to get what I want either - it keeps trying to put East, West...

Any ideas?

Bump. I've attached an example to show what I mean.

Ok, I'm trying to create a line graph, with date along the bottom axis, and balance along the left axis. However, when I do this, it shows the dates properly, but all values are at zero. I'm not sure why it's doing this. I've tried diffrent combinatons, but I cannot seem to get it to do what I...

It works flawlessly. Thank you very much!! You have no idea how crazy this was driving me, and, of course, the solution was painfully simple :p. I really appreciate the help you, and GumbyD gave me. Thanks!

Ok, I've had ago with that, and it doesnt quite work properly. When I tried it with account 1, I got this: £0.00 £30.00 £20.00 £10.00 When I should have got this: £10.00 £30.00 £20.00 £30.00 and I'm not sure how you got that result:).

Thanks, but I'm not sure how you are trying to do this. I have attached a cut-down version of my database, with a few queries that I've tried: qryTrans: The code I posted earlier. It works, but it carries out the balance for all users. qryTrans2A&B: This does exactly what I need it to do, but is...

I have a banking system, and I need to be able to show the balance as each transaction is made. This is what I have so far: SELECT tblTransactions.lngTransactionID, tblTransactions.lngAccountID, tblTransactions.datDate, tblTransactions.txtType, tblTransactions.curAmount, (SELECT...

Thanks! The first one was what I wanted; the date of this week's monday.

How can I find out the date for whichever the date is of this monday. So, if today is 23/03/2006, then it would give 20/03/2006, which was the date of this monday. Thanks for any advice.

Thanks for your help.

How can I refrencence any value within a combobox (not the one selected)? I want to try and acheve something like this: cboSomething.Value(3) Although that doesn't work. Is this possible?

If have this SQL statement: SELECT (SELECT tblTransactions.lngTransactionID, tblTransactions.lngAccountID, tblTransactions.datDate, tblTransactions.txtType, tblTransactions.curAmount FROM tblTransactions WHERE tblTransactions.lngAccountID=[AccID?]) AS tblTransactionsB, (SELECT...

Anyone? The problem (I think) is that the calculated field is run before the where condtion removes the records that I dont want to be included. Thanks for any help.

Wow, I diddn't expect such a speedy responce. I sorted out the quotes, and now it works fine. Thanks, guys! You really helped me out.

I am trying to set a recordset, and I keep getting this data type mismatch error, but I cannot see what the problem is. Here's my code: Set rstAccounts = dtbCurrent.CreateQueryDef("", "SELECT [Account ID], [Balance] FROM tblAccounts WHERE [Account ID]='" & txtAccountID.Value &...

Please? I'm really not sure where to go from here.

Although this then only shows the the transactions carried out by that used, the calculation for the balance is still carried out on all transaction records, so the amount in transaction 4 is added to the totals from transactions 1 - 3, although transaction 4 was carred out by a diffrent Account...

Any ideas would be greatly appreciated...

Anybody? Please, I need this.