Search results

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 :)

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...

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...

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...

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...

Hi, I have an Access application (client) connected with another Access database (server). I would like to make a new version with the same client but with a Postgresql database as server. My client application has forms with checkboxes objects. The controlsource of the checkboxes are boolean...

Hi, It should be simple … may be too simple but … I have a warehouse application which can manage several warehouses. Each user may however manage only one warehouse. When the application starts, it reads the warehouseid in a parameter table and stores it into a VBA public variable...

Hi, I would like to transmit several parameters from my main form to the subform when I open it. Parameters could be used in the subform by onload event, for eample, to define form caption, hide or show buttons, enable or disable edit boxes, give them a color, ... It could also allow to use...

Hello, I have a form "article" with a button "place an order". Click on the button opens another form ("order") where I should fill the order for the current article. The problem : how can I tell to "order" form that I want to order the article I was on in my "article" form, and not another...

Hello, I'm working on VBA to fill a Word document with Access data. I need to kow the current character (cursor) position in my Word document to define a range (from the current position to current position + n characters) where I want to insert my data dynamically. Since Range parameters are...

Hello, I woul like to programatically (with VBA code) hide and unhide the database window. In Access 97, this can be done with Tools > Startup > Display database window box (check/uncheck). But I would like my program does that himself : when the user launches the application, the database...

Hello, I would like to get the current character (cursor) position in a Word document. Could you tell me which VBA code I could use to get it ? The current position should be an integer. I want to use it to define a range from the current position until (current position + x characters) Thanks

Hi, I would like to create an application with a left side tree menu. Each leaf of the tree should open a form or launch a procedure. The branches could expand or collapse. Nodes could have pics. There must be a couple of VAB examples. Would you recommend me some of the best ones ? Thanks

Hi, I want to fill a Word document with data comming from 2 Access tables. The context : There are two tables linked with ont-to-many relation : one table for the orders (master table) and one table for order lines (detail table). I have one Word document with tags (xxx...xxx) saved as...

Hello, I have a table on which i must work at row level, one by one. I put the table into a recordset and i scroll the table row by row from the top until the bottom. The work process - a test - is executed for each row and returns an integer. I would like to put the process into a function and...

Hi I have a dropdown list in an Excel Worksheet and I would like to use it to select and retreive data comming directly from an Access table or query. I believe it is possible and I would spare a lot of time if someone could you put me directly on the best way to do it. Thanks.

I have a SQL query in a string of a VBA procedure (e.g. MyQuery = "select sum(Amount) from Investment") and I want the result to be shown in a TextBox of my form Me. I know several ways to run the query and to send the result into the TextBox (e.g. with QueryDef and RecordSet). However I guess...

Lets say an employee form withs the name, the position, the birthdate, ... and a picture of the person. There are several ways to store pictures in a database, each having pros and cons. Experienced developpers in dealing with pictures would be kind to tell me the way they recommend to store...