Recent content by inoxo

That's right. Sometimes however you need to read data on the tables directly (e.g. data analysis) and then unstick the display options could be useful. Thanks anyway Pat.

Hi, One you have opened a table, you can change the layout of the table : column width, roow height, color, ... and sorting or filtering the table. I wonder there is a short way to reset all the changes to the original layout of the table. How to do it ? Thanks :)

Here is the code attached to the search combo box (myCombo) : Private Sub myCombo_AfterUpdate() Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[idUser] = " & Str(Me![myCombo]) Me.Bookmark = rs.Bookmark End Sub When I select an idUser with the combo, the record is...

Thanks for your answer. This is not a solution however : the combobox is cleared indeed, but it doesn't display the value of the (new) current record when I move to the next one in the table.

Hello, I have a combobox on a form to search for a name in a table and do to the record. Classical. When I find the record and then I move to the next record (with <page down>), then combobox does not update to the current record. What sould I put in my code to force the combobox to always...

You're right. Yhanks for your help DJkarl.

Thanks DJkarl. But how do I create a new public VBA module ? Should I create a "Public sub" ... with only "Const" ... sentences ? I don't see how the code sould be.

Hi, I would like to put all my constants at the same place in my application. I put them before the first procedure of the first form which opens when I start my application, with "public" before. ex. public const ModelPath as string = "\xxx\" But VBA doesn't allow that (error message ...)...

Hi, I have an Access application whith manage pictures. The pictures come from different sources and the date/time is'n always correct. For example, I need to add one hour to every jpg where the file name contains the string "xyz". There are many untilities which can set the time attibute to...

So simple ... and it works ! Thanks Lagbolt

Hi, I made a SQL query which creates a new column and initialize it to 0.00 : SELECT ... , 0.00 as Amount, ... INTO ... ; This is within a procedure. Once running, the column is created in the table BUT with Long integer format. I would like to create the column with Double format so I can...

I shall add an INTO clause in my query to save the result in a temporary table and then display the data by opening that table. Thanks Adam.

Thanks Adam. Nice idea. But then I could store a query for once and use it with parameters. I wonder VBA cannot provide something to execute a SQL select and simply display the result on the screen, the same way as with QBE ...

Hi, I would like to display the result of a sql query into a simple table. My sql sentence is embedded in a VBA module. DoCmd.OpenTable "myTable" works well, but it displays the whole table myTable. However, I would like to get the result filtered and sorted. I have thought to DoCmd.OpenQuery...

Hi, I would like to write a vba procedure to query a table with passtrough. I need to use a passthrough query because the table I use is too wide to be queried normally in Access. It's a DB2 table which counts more than 256 column. Using Access query interface to query the table works fine...