Search results for query: *

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.

Hi Does anyone know how to link a sql table in access without the linked name showing the owner prefix. ie dbo_tablename to just tablename. Is there perhapes a setting I can change (I now this is a long shot) Abviously I could just rename the link but sometimes theres quite a lot of tables...

Hi there Well, I certainly did'nt expect to see a thread on this question again, but its welcome non the less. Unfortunately my knowledge has not expanded since but I was able to use the MSDE engine with a bit of cheating. To answer your question Firstly I take it that you are upgrading to...

Hi Tom No both machines have been set to specific printer Thanks for the reply though but given up until monday Thanks again Cheers

Hi all I have a report preview error No.2157 in Access 2000 running Win98 printing to a oki dot matrix printer. Error Msg is as follows : "The sum of the top margin, the bottom margin, the height of the page header, and the height of the page footer is greater than the length of the page you...

Hi all I have place the ms web browser activex control onto a ms access 2000 form and pointed it to an xml file. The browser displays the contents correctly. Unfortunately I cannot find a way to size the control so that it can be larger than it current is. I have used the following to no avail...