Search results

Hi folks I have a report as attached. My totals all work but my final totals at the bottom dont sum up. I wonder if somebody could help. Thank you.

Hi there are you still using access ? I have come across your code to move a record from 1 table to another and struggling to get it to work. Do i make the new table with the same fields as existing one? Also is it just the new table I change in your code? Thanks very much for any help.

Oh I see what you mean a list of accounts in a dropdown so it would need the record number. I think I need to study it a bit more. Thanks again for your help.

Ok here is file. Not used lookups either.

Upload database to forum.?

Created a new box with same code but blank box. Strange.

Double checked and all spelling is OK. Checked field types and renamed text box. Now blank box.

One of the criteria items I missed an e

I have a blank box with cursor.

I had 1 spelling mistake so now I have a blank box.

Spelling looks OK. I just made a form called trial balance and inserted a text box and used this code. Ledger is table Account field and Amount is money. Running Costs are categories.

Wonder if someone could help. Im using Office 2010 and trying to get this to work but so far no joy. I,m using it in a text box. Thanks for any help. Keep getting...

Ok vba. Will check YouTube etc. I thought access was fading out but it seems not so will persevere. 😀

Just out of interest what languages are best to learn for msaccess? Is it jet sql and vb ?

Ok thanks will look into that. Never used sub forms etc but keen to learn. Thankyou.

Could I make a field for each total and maybe get some sort of query to group them and make the field the total.

Ok..I have about 10 totals to do. Haven’t used dsum before will have a look. It’s a pity excel does it with a formula.

Hi I am doing a basic cash ledger in a data sheet. I wondered how I can create a trial balance eg. Total all records that field equals subscriptions and vehicles and so on. Something like sumif. Thank you for any help.

Hi never took you to answer. Only takes a simple wrong forum or whatever to answer. There must be thousands of people on this for Even a moderator. Anyway thanks for replying.

Thanks very much for the nil comments really reassuring. Got help on other forum.