Recent content by hirenJ

baster, nothing has been done by Uni IT department to limit P2P traffic... its definately a config problem, everyone else on campus and within my compund can use P2P services... However,I do understand the lack of sympathy... make peace with yourself before you kick the computer...

Nope.... all my friends on the network are still using these services as normal... Ren. make peace with yourself before you kick the computer...

I access the internet using XP, through my university LAN... Up until last month, I could use most file sharing applications, at lightning speed, without any problems.. HOwever, all of a sudden, when using Kazaa, WinMX and ANY other file sharing programs, I can never connect to the file...

Is there a tag in HTML to justify text, i.e. not left/right/center alignment but the block text alignment? Thanks Ren :o) make peace with yourself before you kick the computer...

Does anybody know how to invoke the access 2000 import wizard from a form? maybe a doMenuItem or SendKeys command? thanks Hiren :o) make peace with yourself before you kick the computer...

Hi all, I have an access query that is querying a SQL server database. Every time the query is run, the SQL Server login box is invoked. Is there a way of invoking this SQL server login in code, without running the query? (i am working in Access 2K) ThANKS Hiren :o) make peace with yourself...

Yeh, thats great -- but then all my reports are in landscape view -- is there a way of assigning the orientation in code, so that you can dictate which reports are landscape, and which are portrait? thanks Hj :o) make peace with yourself before you kick the computer...

Hi all, is it possible to set up a report that loads in landscape view. I have some reports that are landscape, and some that are portrait .. However, at present, all reports load in portrait view as default ... is there a way around this? thanks Hj make peace with yourself before you kick...

hehe, nope -- it was right the first time (I think) -- I wanted to delete records from the master table -- where the ID's matched those in the delete table... unfortunately I havent been able to get this code to run yet-- I think its just owner rights issue..at least I hope... thanks everyone...

Hi all -- I have an updated table of data that I am trying to use to update a Master table. Both tables are in a common key therefore making the relationship is no problem. How can I write a query that will update all the Master table records with the new data from the update Table? Similarly...

Access will not allow you to insert a subform into a form that has its "Default View" property set to "continuous form." Therefore, what you are trying to do is not possible within the Jet framework. HOwever, instead of using a "continous form" -- you could use a...

Hi All, I have a small pop-up box that generates cost data for an Admin team. Unfortunately this has had to be done in acc 2000 instead of VB. Is there a way of resizing the access environment in code so that the access window is the same size as the pop-up form? (and the form resembles a...

Hi all -- I have a combo Box that is based on a value list --i.e. its static -- how can I add another row to this comboBox at run-time in code? NB: The comboBox contains two columns... is this possible at runtime? cheers Hiren :o)

Hi all, I have a form that contains a subform that is set to Datasheet view --- I have a boolean field called CONTROL in this datasheet. How do I reference this field in the datasheet so that when the user changes the value of CONTROL in the datasheet, a msgbox appears? any ideas? thanks...

thanks for all of your help!!! From what I can make out, the problem lies with using ADO in conjunction with the wildcard characters (i.e. * ) ... After re-coding the module using DAO...the code ran fine!! Is this a bug/flaw with the ADO 2.5 model? Hja