Search results for query: *

Someone in the office just gave me this: Application.SysCmd(acSysCmdAccessDir) & "MSACCESS.EXE" and it works :o) Regards Chris Bezant

Hi Guys Does anyone know if it is possible to find out the path of Access itself from within VBA? I am writing some code to automatically compact the back end and it creates a BAT file that runs Access but it needs the full path of Access. Different versions will be in different named folders...

They have to be separate programs - too complicated to explain but I have found a solution. After a trawl on the net last night I saw a keyword that triggered instantly in my brain. In another lifetime I used to program on OS/2 and when I saw this item it all came flooding back - well in...

Thanks for the response. I thought about this technique but I wondered if it would be fast enough if the there were ten calls per second. At the moment I am nowhere near that frequency but I am envisaging having maybe 5 programs all needing to serialise through this connection. That is why I...

Hello I have 2 vb.net programs that use a common DLL and I need to serialise its use. Is there a way that 2 programs could access a common resource to see if the resource is free? Specifically, I am using the Betfair interface which must be restricted to a certain number of calls per minute so...

Thanks MajP I will give that a try. In the meantime I came up with this solution: In the subform I created the following code: ' This is called from the main screen to reflect the status of each race Public Sub ChangeBackgroundColour(Colour As Long) Me.FormHeader.BackColor = Colour...

Thanks for responding, Jimmy. The event is on the main form but you have given me an idea. If I create a public sub in the subform that resets the colour I could call it from the main form. Regards Chris Bezant

Hi Guys I have a form with a subform and I want to change the background colour of the subform to indicate various statuses during a process. I thought I could just say: Me.SubFormName.Backcolor = SomeColour but it doesn't work. I'm using Access 2003. Any ideas, please? Regards Chris Bezant

I have built an Access database that interogates web pages in a webbrowser control. For plain pages it's great but I need to read a Betfair page and some data appears to be in frames. Is it possible to find data in frames? If so can somebody guide me, please? Thanks Chris Regards Chris Bezant

I'll try that, Skip. The reason I didn't is that it isn't really an Access question; I just happen to be using a webbrowser control on an Access form :o) Regards Chris Bezant

I have built an Access database that interogates web pages in a webbrowser control. For plain pages it's great but I need to read a Betfair page and some data appears to be in frames. Is it possible to find data in frames? If so can somebody guide me, please? Thanks Chris Regards Chris Bezant

Hello I have an Excel addin that needs to write to the root of the C drive but Vista gives me an access error even though I am an administrator. Does anyone know if I can get round this, please? Regards Chris Bezant

Hello I just bought a new laptop and it came with Vista installed. I ran a new program from a source that I trust and it said I needed admin rights to be able to run it. I checked my account and it IS an admin account. Anyone have any ideas what's going on here, please? Regards Chris Bezant

I have a need to do this kind of thing too and using a listbox/textbox combination the listbox only updates when I click out of the textbox. Even then I could only get it to work using the AfterUpdate event. The OnChange event seemed to give the textbox content before the keypress. I used...

I have an Access database where I display a form showing postcodes. The requirement is to be able to type a partial postcode and see a list of postcodes beginning with those characters. The form is driven by a query that gets its parameter from a text box on the form. At the moment I enter the...

Thanks, Skip, that's perfect - exactly what I had in mind :o) Regards Chris Bezant

I have searched my books and the net to find out if there is a formulae collection in Excel. I feel there must be but cannot find any info. I have some code that performs a Selection.SpecialCells(xlCellTypeFormulas, 23).Select but if there are no formulae an error occurs. I have put an on error...

I have a spreadsheet that contains a sheet called MailMergeData that has a line of headings and one row of data. I have a hyperlink on the sheet that opens a mailmerge word document that picks up the row of data from the MailMergeData page. This all works perfectly BUT Word issues a warning that...

Hi Guys Thanks for all your input and your time. I omitted to say that I am using Excel 2003. I tried to get combo’s solution to work but failed. I had already read up on the suggested items but still failed to understand how to do it. I finally took Skip’s idea of establishing the range...

Hello Combo That's exactly the sort of thing I expected to be able to do but unfortunately I cannot get it to work. I have taken an image of my pivot table but I cannot paste it here. Would it be possible to email it to you so that you can see exactly what I am trying to do? I must be really...