Recent content by Aqif

Hi, To my understanding the scroll bar should move automatically. Anyway try putting MyFirstControl.SetFocus on LostFocus event of the last text box. Cheers! ÙÇãá It's important to learn the rules so that you know how to break them.

Simplest is create a split database with backend/frontend interface. You can create multiple copies of same frontend by slightly changing the names. So you can have Frontend_1.mdb, Frontend_2.mdb and Frontend_3.mdb all opened at the same time and linked with the same backend data file...

Dear Jim I can't agree more with you saying "I wish there were an 'Access-like' tool for Oracle or SQL-Server, one that combined everything into one package." I felt the same many times when I work on Oracle database, using Developer 2000. Mind you, Developer 2000 is also an excelllent tool and...

Can't say anything without actually looking at the form. I am sure that there would be some tiny error somewhere but connot tell without lookig @ database. Cheers! ÙÇãá It's important to learn the rules so that you know how to break them.

Dear HTH With your method I need to program click-even on all the labels that I want to use. I want to avoid that. Thats why I asked for a method by wich it automatically picks up the caption of current label. Cheers! ÙÇãá It's important to learn the rules so that you know how to break them.

Hi, I have created few of hyperlink type labels on my form. Is it possible that when I click on a label it gives me the caption by using something like ActiveLabel.Caption? Cheers! ÙÇãá It's important to learn the rules so that you know how to break them.

Hi, Try checking few things 1. Form might be attached to a query which cannot be updatable. 2. Try decompiling database by opening MS Access with decmpile switch and then run compact and repair database. Cheers! ÙÇãá It's important to learn the rules so that you know how to break them.

Hi, Have a look at this post http://www.tek-tips.com/viewthread.cfm?qid=560286 Cheers! ÙÇãá It's important to learn the rules so that you know how to break them.

Hi, Its a bit gray area between choosing mde or mdb as deployment choice. I guess many of us work in maintaining/developing in-house databases where we don't care about source code being readable and sometimes we do need to fix a tiny bug at users machine while user is bit impatient :) and then...

I work in Maintaining almost a dozen database and I release updates all the times. What I have done is 1. Create a seperate database (like a switchboard) with table containing fields for Database name, Current Version, Date Changed, Location of front-end file. 2. Created a temporary table in...

Hi, Any one of you in our tek-tips community who works with clinical databases are welcomed to give their suggestion about what are the characteristics of a good clinical databases. So far I have come up with this 1. True relational database 2. Secure access to data 3. High quality of clinical...

Thanks a bunch lupins. I will install and test it soon. Cheers! ÙÇãá It's important to learn the rules so that you know how to break them.

I will agree with earthandfire :) Mde gives you better stability as the code is compiled and encrypted. There is less chance of corruption plus the mde files doesn't bloat as much as the mdb file. But you definitely need Access (full or runtime) to run any kind of Access database Cheers! ÙÇãá...

Dear Johnny That solution only applied to mdb files. If you have mde file than I am afraid there's no way. Cheers! ÙÇãá It's important to learn the rules so that you know how to break them.

Humm... Try this Format([MyDateField],"dd/mm/yyyy") Between Format(Forms!frm_myForm!Date1,"dd/mm/yyyy") And Format(Forms!frm_myForm!Date2,"dd/mm/yyyy") Dates are sometimes tricky to get as they are effected by the way regional settings are set on ur pc. Good luck Cheers! ÙÇãá It's...