Search results

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.

I doubt whether converting some processes to 64 bit access is always as simple as "just" adding ptrsafe declarations. Those parameters used with settimer () may not work in 64 bit. That might be the issue.

Yes. Of course a batch ref is a good idea. if you still have the external data set, you could match the external data to the imported data as well.

You need to think carefully about your process and your data tables. You can append autonumbers from one table to just long numbers in another table, which may be sufficient. If you append the autonumbers to an autonumber field, you may get problems if you also create new autonumbers in other...

Your personal time of 3 will be treated as 3 days. If you want 3 hours then you need 3/24, as a real number. Note also that adding or subtracting time will often give a curious answer, as you will get the time value for a day plus time result. So 14:00 - 10:00 will give you 4:00 (as a real...

That was really just an observation. If you have an estimate table to store things like metadata for a "job", such as the estimate ID, the client, the project name and reference, the date started and so on, then that only gets you so far. If you have multiple items per estimate you need a...

Most theatre booking systems seem to have some curious logic. They won't let you leave a single seat in a row, for instance.. They also seem to allocate your seat then give you a limited time to complete your booking, or lose your allocation. Airplane systems do something different as they...

Seriously, users shouldn't be telling programmers how to do their job, at least not at the point of "requiring" an autonumber. An autonumber cannot guarantee an intact sequence. Even if you could, occasionally autonumbers "jump" to a new seedvalue. There must be some reason it happens, but it...

You should get a "do you want to save your changes?" type message. Maybe you have setwarnings set to off. That might cause your changes to be dropped. Also, if your code closes the form with the setting to not save changes, that might have the same effect also. (I think it's AcSaveChangesNo...

A time part of a day is actually a fraction. So 9:00am is actually 3/8 of a day or 0.375

Out of interest I think you would have had an issue with a SQL server back end, because I'm pretty sure you can't poke an autonumber of zero into a SQL server table, but you can do so with an access table.