Activity Stream

SQLite is a database very commonly used in Android device applications. Python works well with SQLite. There are ODBC drivers to connect an SQLite...

Yes, going through and doing it to all combos to be consistent (and proper).

That is just a matter of preference and standardisation? The bound column is always the value in the combo. Make sure you have done it to all...

Taking the advice and switching the combo box around so the first column is the Primary key and the bound column and simply hide it to show just the...

Pretty sure you can if you wrap the reference in Eval(). Not that I disagree on which column should be bound.

Do not have objects with spaces in the names. Then you have to surround them with . You used them pretty much everywhere except where needed for...

GSLevelandStepF has to be a field in GSPayT; is it? I'd try to include the field in the combo's row source and do this: ...

Yep, I always had the bound column as the first and hidden. Often more columns were hidden where I could retrieve associated data from them.

I think you really need a web based interface/app that can talk to your data. That allows pretty much any device to be used. We moved a clients data...

It's far more common ( I would dare to say normal/good practice?) to bind the combo to the first column (Normally a primary key) than the second or...

I am not aware of anything android that reads an Access DB. I know of an app that reads an actual table, but that is it. For transfer to and from...

Forgot to mention this can be seen when using the 3rd option in the menu list labeled with "Datasheet". Hoping I am just missing something simple...

Feels like it is but doesn't do it for all records.. This is in the Datasheet form entry mode so it seems like if it were going to reverse fields...

Or the bound column property of the combos has been altered? Check that the bound column is correct.

Something is changing the RowSource property of comboboxes? If you want to provide db for analysis, we might be able to figure out what. Why is...

Bit like a Banana being called an Apple. :)

Please post code within code tags if more than a few lines and where indentation would help see the logic.

Thanks for your answer, I just found the error, cboComment was still in a module with a reference, this caused the error. In any case, thanks for...

What has db being on a secured network got to do with sharing code?

why are you starting a new thread when you have already asked the question here? https://www.accessforums.net/showthread.php?t=90342

CODE tags use not <>. is not in query 1. Query 1 aggregates and assigns alias name to expressions. Why not put filter criteria in query 1? ...

And you don't in Excel?

I have to assume your variable CurrCountry somehow is retrieved from the questionable combobox cboCommentaar. Perhaps it's not working as you expect...

Still think using a stock table would simplify a lot. After all it is the standard solution for a reason. I think it is rather strange you use a...

To which you have now gone to another site and said :confused: