Search results

I suspected there was no easy solution. Thanks. Is there a way to check if the form is called from a tabbed form or a standalone form? Giedrius

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

Do you think this might be the autonumber field type problem? giedrius

Here's my sql: sql1 = "SELECT Pr.prekOpdata, Pr.prekKod, " & _ "Pr.charKod, Pv.pvPavadLT, " & _ "Char.CharaktLT, Pr.prekMatoV, " & _ "Pr.prekMatoV2, Pr.prekKiekis, " & _ "Pr.prekKaina, Partneriai.partnerPavad AS Vieta, " & _ "Partneriai_1.partnerPavad AS Partneris, Pr.id " & _ "FROM (((Prekes...

The problem is that when I pass the SQL string assignment statement while debugging and display the variable in debug window and then copy the displayed resulting SQL into new query design window - it works fine (i.e. displays the records expected). Have no clue what's going on!? Shall I paste...

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

Thank you very much for the solutions. giedrius

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

OK, thanks. Looks quite complicated. In the meantime I found a small VB code, which after some modification allows to print field names and attributes the way I like. giedrius

After some experimenting I came to the conclusion that mde files can not be replicated, however the following technology can be implemented: Make b/e as Design Master file and create a replica thereof. Then in f/e (which is mde file) make links either to the Design master or to the replica as...

I think you have misinterpreted my question - I may have been not precisely clear. I was asking about data base replication ( compilation or decompilation are actually different topics in this sense). I was wondering if it is possible to make a replica of a database file if it is compiled into...

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

How can I get to know what is the name of the standard form wizard style called, say, Expedition? giedrius

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

Hello, I deployed my database on the server and application mde files on each workstation. However on some workstations I keep receiving "Disk or network error" after few transactions. If I quit application and start it again - it runs for some time and then, again, the message pops up. I...

Thanks, it works with QueryDef. I am just wondering why is it so - both commands do perform same action (I used the same update query with QueryDef). On the other hand, I understand, with QueryDef we loose transaction roll-back functionality available with currentdb.execute method? giedrius

Hello, I have a simple update query like follows: currentdb.execute "update products set price=price*1.1 where prodCode=12345" X=currendb.recordsaffected However, although some records do change, X always stays =0. Is this an A2K bug? THanks, giedrius

So, do I understand it correctly, that mde file, prepared with Standard Access, can not physically run under Runtime? giedrius

Thanks for your good explanations. I am not sure if have all the patches for A2K. Is it so, that if I install the latest, it will include all the previous? giedrius