Recent content by giedrius

Found the solution here: http://www.mvps.org/access/queries/qry0015.htm It really turns to be a problem. giedrius

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

Yes, it helps. 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...

Thanks Dana, it works. Great!

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

Metad is probably talking about using Conditional Formatting on the whole row based on the value of one field of that row. giedrius

There is also good description how to handle dates at http://www.mvps.org/access/datetime/date0005.htm .

Thanks folks for quick responses. Everything works just fine. That was great help. thanks, giedrius

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

Its OK now, I figured it out. You can control which record is last seen with the help of me!subform.form.selTop=11.

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

You simply add button on your main form and write a procedure for OnClick event to add record (say your subform has recordsource called Products, which can be a query or a table): Set mydb = CurrentDb Set myset = mydb.OpenRecordset("Products") myset.AddNew myset![field1] = 123...

After some experimenting I found out that you can concatenate in a separate invisible field all the fields to be tested with the "+" rather than with "&". This gives you null value result even if a single field is null. You then test for null value in that invisible field. giedrius