Search results

Hi All, I know this Thread is quiet old but did anybody came up with a solutionother than buying the $300 repair package ? I use DAO to access the backend database. When I update a column (CodeTableB) in one of my tables (tableA) and then query: select * from tableA where CodeTableB =...

Hi All, I know this Thread is quiet old but did anybody came up with a solutionother than buying the $300 repair package ? I use DAO to access the backend database. When I update a column (CodeTableB) in one of my tables (tableA) and then query: select * from tableA where CodeTableB =...

Hi All, I have a piece of code that adds items to a multicolumn combo box. I understand that the column separator is ";". So I coded like this: 'this adds 1 row with 2 columns OK myCombo.addItem "1;Village" This works fine until I get ";" character in the value of one of the columns. 'this...

I believe this will only set the value property of the list with the value of the bound column of the first row. Quiet far from what I need.

Hi All, I'm using Access 2003 I know there are a lot of problems related to the ListIndex property of a Combobox but could not find a post related to this one. I attached a small DB that reproduces the problem: I have a form with 2 textbox, 1 combobox. - On the AfterUpdate event of textbox1...

Hi All, I have forms with fields such as date and telephone number. I want to use Input Masks and formats to help the user type the data and to control the display. This works great with normal text boxes but I could not figure out how to get control over the message that is displayed when the...

You're absolutly right ChrisO, I should have posted the whole code. Here it is: 1) Module FormFieldHelper: 'Sets a form field in error by setting its back color to red and showing its 'error message label Public Sub setFieldError(Form As Object, field As Object, _ text...

Thanks for your help. I was trying to call the module directly but I settled for the solution of calling a method on the startup form which then calls the module method. Cheers, Jerome

If I do it this way, I have to code the keydown event for every single field of my application. I'm trying to use a generic module to handle all that, therefore assigning the onkeydown dynamicaly

Yes, it's a custom module that I want to call on the onkeydown event. The module is there and declared correctly. If I call it from the form module class it works fine.

Hi all, I'd like to create a custom toolbar where each button would call the same generic module function, passing it a parameter. I see how to create the toolbar, but I can't figure out how to call my function and how to pass it parameters. Also, I can't find any explaination on what this...

Hi all, I need some help with VBA code to assign generic event to a form field at runtime. I have a module which handles field errors (sets the field color to red to notify the user of a problem). This module has 2 methods: setFieldError(field) and resetFieldError(field). When the user clicks...

Hello, I would like to have your opinion on the best possible database design for the following problem: I need to build a small database where the main table will contain about 20.000 records. The application needs to be multilangual (2 languages at the moment but maybe more later). The data...