Search results

I would not have thought you would map a grandfather to grandson relationship. All you need is a child (son) to father relationship. You don't need separate tables for these relations. All you need is a single table of all people, and to map the relationships of child to father (and child to...

Well it was a curious request. It sounded like "show me the look and feel of a sample access database". If the requirement is just to demonstrate that an access app can look ok, then the suggestion to look at northwind might well be sensible.

If you want a data entry form, where you have clerks entering batches of new records, with no need to see records that have already been entered, then you want a data entry form.. If you are entering stock taking records it may be convenient to use data entry mode. If you want to review all...

It probably fails to work as you would like because of the behaviour of a data entry firm. A Data entry form just allows you to enter new records in this session, and not see pre existing records, so I expect showallrecords just shows the new ones in the current session. .

With a module you call a procedure inside the module, so the module just can't be named the same as one of its procedures. With a class module, the whole thing is a complete unit, and you instantiate an object of that type. The procedures and functions within the class module are methods of...

@Capitala You really don't want to do that you know. Why do you think you need this solution?

Is there an ordering thing? Does the findasyoutypecombo unit/module need to be sorted/declared above the current unit/module

Did that work? It's useful on a laptop, where the ribbon just takes up so much screen real estate.

Ctrl+F1 maybe to show/hide the ribbon. :D

I would have thought it relatively easy to produce JSON file from first principles, but you do need to understand the syntax you want to achieve, and I think that's what @isladogs was suggesting. The file example produced may not satisfy the requirements. By first principles, I mean Open text...

I think it's probably unreasonable to expect manufacturers to still supply deprecated products which simply because they are old may well contain insecurities that have been dealt with in later issues. Maybe users need to retain their original installation material and installation information...

I think the last points you make are on point. I think a bigger problem is being aware than an access database is easy to copy, and your data may not be as private as you would like it to be. That may be a real issue as databases will most likely hold sensitive information.

That's a really interesting screen shot, which makes it quite clear to me that I don't need a tool of this sort. Out of interest can the usage column show value instead of items, or do you just click on a blue number to expand the contents? A simple monthly spreadsheet is adequate for my own...

You could tell the users to only use forms to enter data, and not to use tables directly. In my experience, users won't try to interfere with data, especially if they know how important it is. You can restrict access to the tables in ways explained by others in the thread. Using an accdr is...

By default a use can see tables and queries, and edit them. They can't edit forms reports or modules though. Sometimes it's useful. If you want to prevent access, you need to hide the database window.

Personally, I would classify accounts as either Balance Sheet or Profit and Loss, the difference being that P&L accounts clear to zero at the end of each year. Expense/income is a poor category type, I would have said. You might need an account number strategy to group income accounts into a...

This is really describing a double entry system, I think. For a payment you credit your bank account and you debit the expense account. By doing both, the double entry is maintained and the total debits correspond to the total credits. It's not so much that the two parts of the transaction...

I am not really familiar with quicken. I thought you were talking about a commercial type accounting system For my own personal finances I just use spreadsheets. I suppose it might be occasionally useful to analyse my expenditure by the supplier, so I can see how much I've spent at different...

How much of quicken are you writing..which ledgers are you doing. I wrote a great NL in a couple of days, and a SL in a little longer. The SL was actually harder, which I didn't expect. You can have the NL if you want it. Accounting is straight forward. I've used the NL for my own accounts for...

You could have two combo boxes, and hide/display the one you want to use etc. Or, once you select the display option you want, simply change the text in the cbo title, set the query to the one you want, and requery the cbo box.