Search results

Thanks a lot Pat. So, i do not need to change my method. By the way, some digging up on my own has revealed that insertion from another table may cause the gaps to be filled in if u desire. But, as u said keeping a separate untouched field with newvalues to increment is a safe method which is...

Thanks for replying. :) My reply to ur question is that i had just thought of using a simple method to achieve my objective. I can and probably will use recordsets for the same purpose henceforth but i would still like to know.

I have very little experience using autonumber field. I have come to know that autonumber field may not follow the order of insertion. Is it possible? To illustrate consider a table (auto-id(autonumber),name) When the first record is added it contains 1,Arvind 2,Jay 3,Rahul. So, for m & n...

Thanks, i have visited the site and downloaded the article. Seems that my problem is solved.

How can i change the font,fontweight,fontsize of toolbars of my application using VBA code ? Right now i do it interactively using Control Panel -> Display -> Appearance tab In Item combo-box i select "Menu" and set the desired fontname, fontweight,fontsize below.

How do i create a shortcut (.lnk) to a given file using VBA code ?

As i said before, there are some inexplicable things that Microsoft does. One of them is making datasheet "a gorgeous cripple" :rolleyes: . The click events will not be available to u for datasheet column headers whatever u do.:D I have one more suggestion for u. If it is crucial to ur...

An attached label is a label that has its parent property set to some other control, just as a subform has its parent property set to the main form. U will understand practically when u open a new form in design view, and drag a field from the field list to the form. When u select the text-box...

Try it out practically. See that the labels are attached labels. There's no question of it not working. I use it for my applications.

I just wonder why Microsoft couldn't merge the functionality of a continuous form and datasheet to devise a "perfectsheet". Another one of Microsoft's idiosyncrasies. Coming to the point, if u are using a form then change the captions of the attached labels with each text-box/combo-box. If u...

Thanks Nero but there is a misunderstanding. I mentioned very explicitly that allowfullmenus is for a different purpose and does not help achieve full dropdown menus. If u are using A2K2 please try it out practically In View menu -> Toolbars option -> Customize option -> Options tab -> check...

Is there a way to always show full menus thru code? View -> Toolbars -> Customize -> Options tab Always show full menus is to made true thru VBA. (I searched all docmd.runcommand options but was unable to spot it) Allowfullmenus property of currentdb or the Allow full Menus in startup dialog...

Fine that teaches me to create a toolbar. As i pleaded in my previous post if u try out practically what i wish to achieve (it takes a second) then perhaps u can understand what i wish to do otherwise we will keep beating around the bush.

Thanks a lot Pat. That solved my query.

Well i am genuinely sorry i messed up UNION and UNION ALL. Thanks for bothering to correct me. Can we do away with the UNION part altogether coz as i said i already had a slightly different solution that used UNION. As far as i know select * from t1 full outer join t2 on t1.id=t2.id (with...

Thanks for replying Rich. No that's not what i was looking for. Please try it practically. (It only takes 5 seconds). In the menu-bar, View -> Toolbars -> Customize -> Options -> Always show full menus Remove the check-mark from the check-box (make it false) and each dropdown menu will appear...

It is very obvious that it will do so. Apart from that the point is i wish to get rid of unions as they will be clumbersome to work with and slow if full outer join of more than two tables is reqd.

If u think carefully this will fetch duplicates of records present in inner-join. Also, if u observe as i said in the original post that i am currently using SELECT * FROM t1 LEFT JOIN t2 ON t1.ID = t2.ID UNION SELECT * FROM t1 RIGHT JOIN t2 ON t1.ID = t2.ID where t1.id is null which is the...

Thanks for replying. If u don't mind please elaborate your solution a little more and please try it out practically because as i mentioned i have gone thru all the docmd.runcommand options possible in a macro.

Thanks once again.Have seen the site and downloaded the web page. Will let u know the results.