Search results

I am not disputing that. I am just surprised that you see a bank rec module as the first priority. How many transactions do you have per account in an average month?

Maybe someone is opening the problem database in a mode that secured sole access.

But don't you have to change the external functions in each case, for longptr, or whatever it is. You can't build the same code, can you?

Good points about the search by field. So you get your query by simply adding "searchby = " & currentuser , slightly modified depending whether you have a string or a number for the currentuser. Why do you need to add all the record IDs manually ? It's just another row (or) in the access query...

I think you could have a table field called "selected", but if you have a million records you would have to update all of the records to false, then update the current records to be saved to true. Also you might then have problems if multiple users were doing the same thing simultaneously. Do...

Doesn't it make a difference if all users have current version, but some 32bit and others 64bit?

if you issue a accdh, then you can include conditional code with compiler directives that says something like #iff 64bit then call 64 bit code statements #else call 32 bit code statements #end if it tests the environment first, and works properly in both environments. however you...

@KitaYama I've not read the whole thread, but It's "undesirable/ugly" because it's dealing with records in a non-relational way, and creating special cases. So what if instead, a user can "save" a record, and the record settings for the current record save into a table with the date, user...

"A bank rec is the last thing I would bother about" was purely in terms of adding it as database functionality. Manual records. I would go further. Too often, I have seen a lack of control with figures recorded in a database, or a proprietary accounting system such as Sage. Users think a...

I think it's the conceptual issue that I am struggling with. Are you trying to digitise a finished song to show a time graph with all the instrumentation and voices separately - so that the PC could actually play the song if it had the instrument capability. What's the atomic level for this...

If you want a bank rec module, you would need a table with all the items from the bank statement, and another table with all the items in your cash book. You then cross reference all the items on the bank statement to the cash book, inserting any items on the bank statement into the cash book...

I think I've seen that exporting an excel file fails in some cases if an existing excel file has a different format. It. Not sure if that's sometimes or every time..in such a case you could delete the old file first, and then create a new one.

We think you may not be able to automate Outlook with the new Outlook. Currently outlook may include the code that integrated access apps, but we think new outlook will eventually remove that code, and then you won't be able to use your code. We aren't sure how MS intends to fix that? Are you...

Sorry, I've been ought for a few hours. I'm not saying don't do a bank rec, just I can't understand why you would need a module to do that in an access database. I do a few very small club type things and I keep the records on a spreadsheet, rather than manually, but I don't cross reference...

In your second example you are using a subfolder called GCD. In the first example there's no subfolder. Are you are you have the file/ folder name correct. Can you not include a file browser to select the file you need?

Out of interest why would you want a bank rec program. How many transactions do you have? To me, a bank rec program is a solution looking for a problem. A bank rec is the last thing I would bother about. Depending on the nature of the charity, I would think you need a decent nominal ledger. I...

Well. The hard bit is working with other people's data. If you can't get your suppliers to change to a standard system, you will have to convert each suppliers data into a useable format. What happens if the Acme Corporation changes their layout, adds a few more columns for instance. Then you...

To me, get, put, post, delete Sounds like a variant of read, edit, write, delete. Just being different for the sake of it. Crud is the same. Which came first? Does anyone know? What do the French say when they work on leur ordinateurs?

Bitness is a problem. MS used to recommend 32,but, but now recommend 64bit, and install 64bit by default. I think you are right to develop a accdb, but build it as an accde to distribute. However your code can't work in both 32bit and 64bit access. Therefore you have to select one, and make...

It's hard to know what you mean. If you view a record on screen, you should be able to edit the record to make changes. How would you expect a new record to automatically describe itself? If you are saying that some of your fields are actually dependent on other fields, then that probably...