Search results

Hello, I have a problem with feeding UPDATE statement with values which are numbers but with comma as decimal point: CurrentDb.Execute "UPDATE Product " & _ "SET qtty=qtty+" & sqtty Update works fine if sqtty is a whole number. If it comes to updating with a value sqtty=24,5 it fails...

Hello, I was expecting that when you make an mde file you should not be able to view code, queries tables, etc. in it. However I figured out that only forms are compiled, but you can still view queries and linked tables. Is there a reliable way to hide those as well? Thanks/giedrius

Hello, I have a combo box, which drops down when it gets focus. It displays numbers from 1 to 100. The problem is that if I enter a single digit in the box I have to press the down-arrow key and then Enter to accept the value and move to the next field. For double digit number it is enough to...

Hello, I have a backend database and front end mdb file with forms. I established the necessary relationships in the back end, however when I open Relationships screen in the front end - it opens empty. Do I have to establish same relationships in the front end or can I leave it as it is and...

Hello, I have a form in A2K which is set to be displayed in datasheet view (both DefaultView, ViewsAllowed are set to Datasheet). When I open it straight away, it is displayed in datasheet view as required. However if I open it from the switchboard - it opens in single form view. What could I...

Hi, Has anybody tried this? I have a main form and a subform with 10 visible rows. The subform gets filled in line by line as user enters data in the main form. When it comes to enter 11th row, it does not appear in the subform unless you manually scroll it up. Is it possible to scroll by one...

Hello, I have an Iif formula in my control, which checks for certain value entered in another field and then makes some calculation. However before this another field is filled in my form displays "#Error" in the control. How do I get rid of this annoying #Error? Thank you for any advise. giedrius

Hello, I am using simple INSERT INTO query a lot of times in different forms. What would be more effective - to put INSERT INTO once in a procedure and call it every time it is needed or simply use INSERT INTO a number of times as needed? Thanks, giedrius

Hi, Does anybody know if it is possible at all to have a UNION SELECT statement within an INSERT INTO statement? thanks, giedrius

Hello, I was wondering is it possible to change individual cell format (for example background) in a row in datasheet view in A2K. I need to do it from code. Conditional formatting doesn't help as my condition is quite complicated. Thanks, giedrius

I have three controls (say A, B and C) on my form, which receive focus one after another sequentially. I need to track Enter or Tab key presses for the field B. However when I put code into On_Keypress event for control B, it fires when the user hits Enter in field A. In order to catch Enter key...

Hello, Is it really possible (and how) to get hold if a user clicked on a column title (selected the whole column) in Datasheet view on a form? I want to be able to reverse sort order of the marked column.

Hi all, I was wondering if you could point me to a good add-in which would enable to copy all the objects from one data base into another. Honestly, I got sick with all those bloating issues and after having read most of what is available on the net and some experimenting by myself I came to a...

Strange format in dropdown list of a combo box Hello, I have a combo box where I can choose a number from a drop-down list. Rather than displaying '1' or '2', it displays '1.00' or '2.00'. Format = Fixed, decimal places = 0. After I choose the number, the value in the combo is properly...

Hello, I have a question how can I retrieve the pointer to underlying form in a tabbed form. If I use the following code, Dim frm As Form Set frm = Screen.ActiveForm it returns pointer to the tabbed form itself. I need to get hold of the pointer to the form that is currently displayed in a...

Hello, I am using A2K and was wondering if there is a limit for the max number of characters for the RecordSource property if I want to set value for it in code? I have an SQL statement which is over 600 characters long and I am having problems in getting the right set of records in my code...

I am running synchronization from VB module and was wondering how can I check if sychronization is needed. I want to skip synchronization if there were no records updated neither in Design Master, nor in Replica. I presume this is possible since if I run synchronization through Microsoft...

Hello, I was wondering how can I suppress PgUp/PgDn keys in a form event. I want user not to allow to go to any other record except currently displayed in a bound form. Setting form property Cycle to Current Record does not prohibit user from browsing the records using PgUp/PgDn keys. Thanks...

Hello, I was wondering is it really possible to replicate an mde file? I am comparing replication versus front-end/back-end database implementation technology. I tried to replicate an mde file, but with no success. If this is not possible at all, how can I make sure, that my code is not...

Hello, When I create a form with a wizzard I can select from a few standard background styles. How can I set a background style (not just colour) for a ready made form? Can I do it from within a code? Thanks, giedrius