Recent content by antvon

Hi Rick Firstly my most humble apologies for not posting a reply sooner. I have regrettably assigned to a client for the last to weeks at their premises. Secondly, thanks for your reply. I am still looking into the two controls you mentioned. Thanks again. Anton

Hi all I would like to know if its possible to make a multiline textbox wrap to a set length on each line. I know that u can use the maxlength property to set the length for the entire control and that the wrap property can be use to wrap when the text gets to the control border. If I use...

Hi I proberbly shouldn't be posting this here, but I thought I'd give it a shot and see if there was anyone that knows eVB. I am basically trying to shell to a eVB application on a pocket pc. So far it seems as though the function can only shell to exe's. Unfortunately eVB makes a .vb file...

Hi I'll take a stab at this by suggesting that if you have a year and month field in your root table/query you can concatinate them into another field like so 200501 and then run the crosstab based on this. I have used this recently for 24 month report. Hope it helps Cheers

Hi Greg I have had the same problem on Acc 2000 with the Left Function. The references were correct in my case as well. The funny thing is that the app works fine on a win95 machine and winXP but gives the error on a win2k and win98 machines.(the combination may be swopped around i'm not sure...

Hi John Thanks for your reply. Unfortunately the table was fixed. I went with your first alternative suggestion and modified the defined query using a querydef object. This did give me the flexibility I was looking for. Thanks for your efforts again. regards Anton

Hi all I'm looking for a way to reference a table/query field name by using a variable. Lets say I have a table with the following fields: Customer Budget1 Budget2 Budget3 . . Budget12 Where Budget1 is the Budget target for financial period 1 What I would like to do is create a query that...

Hi Is it possible to a run a .vbp app on a rf handheld device that is synchronized to a pc when that app resides on the pc only? This may be a really stupid question but I don't know win ce at all. Thanks in advance

Yes & I have managed to register the MSDE database in EM. It does actually let you do everything you want within the EM on the local machine. Don't know if this is considered cheating or not but it does not let you create a local database only one on the networked pc. Oddly enough when I check...

Hi SQLBill Thanks for responding. I wholeheartedly agree with you and I would prefer doing it with a linked server. My problem stems from a budget issue. Our company is quite small - only 5 people. We service a erp system that sometimes requires us to have a copy of the client sql db on our...

Hi Is it possible to attach a mdf database file from a directory on another pc over a network. I have tried to attach the normal way but all I can see is my local C: drive. Thanks in advance

Thanks Duane I can setup some conversion function. I appreciate your response. Regards Anton

Hi Duane Thanks for your reply.I appreciate it. Quite right. On Format event is better and I have moved the code there. I have found that the original event works too, but that I had used a value that made little difference in the position Me.txt386.Left = 26 When I look in the properties of...

Hi all Is it possible for me to programmatically move controls on a report in any section before it loads or opens. As in : Private Sub Report_Open(Cancel As Integer) Me.txt386.Left = 26 End Sub Thanks

Thanks cheerio That will do the trick as well.