Search results

Thanks once again. I will follow the lead by ghudson and let everyone know.

Thanks everyone. To clarify, i do not need only my computer's name. I will try searching the net as suggested by ghudson. By the way if u come across something please let me know.

How do i get the names of the computers (the ones u see on entering network neighbourhood/ My network places) currently on the LAN using VBA code ? Thanks in advance.

How can i set a particular form's printing orientation to landscape / portrait if needed thru VBA code ? The scenario is like this. My client often selects the columns to print from a datasheet using Unhide Columns... and i can calculate the total columnwidth of the visible columns. Based on...

The scenario is like this :- I have 4 databases A.mdb,B.mdb,C.mdb and another one commonforms.mdb. A,B and C have 10 forms in common and they are contained in commonforms.mdb (and in A,B and C too as of now). What i want is that i keep those 10 forms only in commonforms.mdb and create "links"...

Thanks. To clarify what i want further and my purpose, lets say i have a saved query in Access select ..... from .... where .... group by ..... having ..... Can i know, which tables will have all their records read for this query's execution ? :confused:

Is it possible to see the execution path taken by a query and if so , how ?

Thanks for replying. But, I am looking for other options than the one u mentioned. Does anyone know of a good free query editor for Access available as an add-in ?

Consider the foll. query SELECT pinvtrn.*, LASTSALESBILL, SALESPCS, SALESMTS, LASTSALESBILL, LASTSALESDATE, SALESPARCELS, SALESRATE, SALESADAT, BILLS.DATE FROM ((BILLS INNER JOIN PINVTRN ON (BILLS.CNO=PINVTRN.CNO) AND (BILLS.TYPE=PINVTRN.TYPE) AND (BILLS.VNO=PINVTRN.VNO)) INNER JOIN COMPMST ON...

The purpose is to allow a particular view (form/datasheet) of the subform based on the particular user's preference.

Thanks. Any tricks to get around this ?

I want to be able to change a subform to form-view / datasheet view when the main form is open in form view (not in design view) using VBA code preferably using the open event procedure of the main form. How can it be done?

Thanks a lot, ghudson :cool: .Followed the thread and will check it out. I did use the search yesterday but somehow missed the referenced thread. :(

Is it possible to display some part of the msgbox message in bold and rest in normal font weight (as is done by some Access messages) without using a separate customised form?

Well, if anyone else has a clear and precise reply alongwith technical facts related to the original question, i would be grateful. For the time being the water is till a bit muddy.;)

There's a piece of advice to u too. Maybe it's the Australian way of being polite, but u can be certain that to my understanding, ur tone/manner is not, plus its better to stick to the technical part of discussion (which i and probably other members are more interested in) as much as possible...

Thanks Chris for replying. I understand from ur reply, that w.r.t. VBA as a prog. lang. atleast theoretically it is not compulsory to use the statement Set mrst=Nothing. However, In practice that does not always happen. Can i have a concrete example w.r.t. VBA for this particular query of...

It's a very straight question. Consider the foll. code Public function sample() as integer Dim mrst as DAO.Recordset Set mrst=Currentdb.Openrecordset(..... . . . sample=1 End Function Is it compulsory to put the statementset mrst=Nothing before End Function to release resources used up by the...

I wish to set my toolbar font thru VBA code. I am not getting the method/ API call inspite of numerous tries. Please help me out.

Thanks a lot Pat, for the info. I understand ur point and it is valid.