Search results

@gemma-the-husky See attached my basic DB reviewed to reflect comments above. (not yet incorporated an audit yet) The transactions so far are taken from @CJ_London 's example (it does not include an account for Client A - although I would imagine this is also necessary). Please do indicate where...

Hi @gemma-the-husky Thank you for the very detailed response😀 Over the weekend I hope to review my design in light of your comments.

So the main purpose of the app is for logging the funds owed to each entity and aid the finance team in tracking down clients' debts (generate statements etc). To answer your query what the difference between client, company and units - yes all units are allocated to a company but since I am...

So I've drafted a basic table design following the above comments: Please advise if the above is correctly normalised. I am not 100% sure if the accounts table is correct - how to link any company/unit/client to an account? Would system details like who paid in a transaction be entered in the...

I know this is a pretty old thread but if anyone is still interested I can post my solution to this 👀

@CJ_London You have mapped out the process really clearly - thank you! Now can you help me with the next step - translating into the table design. Would it be necessary to have a table for each column or can it be in the same table? Also would both the credit and debit amount be required as data...

It seems your only option is run Windows Update.

You seem to have error 2425 occurring. A solution offered is to run SP1 for the Access Runtime. It can be found here: https://www.microsoft.com/en-ca/download/details.aspx?id=39643

Maybe this thread can help you: https://stackoverflow.com/questions/44430660/vba-application-ontime-works-overnight-but-not-over-weekend

This may help you: https://stackoverflow.com/questions/29469747/how-to-disable-access-security-notice-a-potential-security-concern-has-been-ide

Hi @patapotato Good to have you here! You'll find loads of support on database design and VBA here. Sure your experience in data science will come to good use as well.

I cannot remember the exact name of my colleague's account but I believe it was some variation of the name Mike and I think he joined between 2009-11. Some of his posts were related to recovering a password on a DB. I think there may have been queries about a school/student DB. If you have any...

Hi guys! Sorry I've been off work a couple of days and just catching up with the messages. Didn't realise this would be such a hot topic! So I believe this company does have an accounting system like quickbooks, as well as a standard payroll system in place. I've been commissioned to design a...

Hi there I am designing a complicated accounting database to manage transactions of various types in a company. The primary table is obviously tblTransaction. We have identified the fields involved in every transaction (payee, recipient, amount, date etc). My question is for payee, recipient...

Just wondering if it happens on this forum that old members are eventually deleted? I happen to know a colleague of mine who has posted here in the past (joined in 2011) - I think last in 2018/9 and now I cannot locate them. Would that be because they've deleted their account or would they be...

Thank you. I think I have resolved this by adding a unique date field using the advice here.

I understand however I would like to have this data as a query since it will be presented as such.

I am attempting to calculate a running total column on a union query of two tables - invoice and transactions so that I can design a statement which involves all this info. Because there are two tables involved I can't use the ID as the unique field in the DSum calculation, instead I tried...

For instance we designed a database for a door/window manufacture company which is modelled according to the process it goes through during production line. It accommodates for various types of clients (trade/retail etc) and many other nuances specific to this company. The process is so...

Sometimes the best option is to outsource the project instead of getting yourself tangled in knots. I could give you some excellent recommendations. (We have built a couple of systems similar to the one you have described - PM for more info as this discussion is not intended as marketing)