Search results

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

OK, thanks. But what if I need to check on a number of fields? I tried using another hidden field which holds a concatenated value of say other 3 fields which values should be tested, but is there a possibility to test the result of my very control for #Error and then take an action? giedrius

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

Yes, you are right. I made simple things complicated. Thanks. giedrius

I presume stored queries are only possible while working with SQL Server. I have a simple peer-to-peer configuration and I use DAO. giedrius

Yes, I take your point that is is more convenient for coding. But is it faster in execution? I have no clue how many lines of low level code A2K adds for a simple INSERT INTO sql statement. If it is hundreds of lines, than probably it is more efficient to have INSERT once in a subroutine and...