Search results

So how would the syntax look for a reference to say wshom.ocx instead of the early binding method? thanks N Sent from my OMNIA7 using Board Express

Could you give an example of late binding a reference? I have references but use code to check they still exist and repair the reference if it is broken. I never really considered late binding the reference as I always got side tracked and it ended up being a case of 'i will do it eventually'...

Hi You wouldn't really need the 'on Error GoTo 0' because you are already set up to go to ErrorHandler. By going to 0, you are actually skipping the ErrorHandler set. You would need the 'Exit Sub' before the error handling to bypass as mentioned already :) Nigel Sent from my OMNIA7 using...

Hi, I delayed the form code by 1/2 second. The form opens then 1/2 second later, populated the grid perfectly. Instead of closing the form, i made it invisible to prevent this every time the form opens. Here is a video of it :) http://www.youtube.com/watch?v=sjoMQspE4ag Thanks Nigel

Hi i am struggling with a slight form delay. When it opens on the OnOpen event, i am populating a grid. This takes about 3 to 5 seconds but, the it also takes the form the same time to open. What i need to do is get the form to open then populate the grid. Can i make the form open first then...

Dont everyone panic and rush to my aid lol......... Here is my custom font box with lovely displayed fonts :) Cheers

Customers can also be suppliers and vice versa so it makes sense to have them in one table otherwise there would be duplicate data. I have both who are both at work... Nigel Sent from my OMNIA7 using Board Express

The local mining village football team, "Quarry united" won yesterday 2-1 on aggregate!

A woman walks into an opticians. "hi, I think these glasses are broken" she says to lady. "me too" said the lady. "I don't work here, and this is the bakers"! Sent from my OMNIA7 using Board Express

I wouldn't have thought this applies seeing as there is an option in the settings to change the icon unless I have misunderstood :S Cheers Sent from my OMNIA7 using Board Express

Why try and hide the icon labels? You should only focus on your app. I don't hide the labels and I get both my icon and title. Would the hiding of the label be a user option rather than an application feature? I wouldn't be happy with an application changing my environment. Cheers Sent...

Hi In the immediate window in the VBA screen, what result do you get jf you type ?apptitle Cheers Sent from my OMNIA7 using Board Express

Hi Pat I rarely where my excel hat these days and always think Access. What I'm actually doing is creating a visual font dialog with option buttons and each option button label holds the style of the font so it can be visually seen. Can do this at load time in Excel on a form and Not in...

Hi, in Excel, i can dynamically add option controls to a frame on a form using the Control.Add method. Is there an Access Equivalent? I can only find Count & Item as Control. items. It might have something to do with design view i guess. vv frustating Cheers Nigel

Hi guys is there a way of displaying the font dialog like this- without the colour, strike through etc or, can i display the font styles in a combo box? I already have the fonts listed in a combo box but all in a single font style. Alternatively, is there a simple font dialog that doesnt...

Hi, im at my PC and found a sample db i made ages ago. You can modify how ever you like. There is a public module that has the settings in etc and i added this to let you demo what you could do- Sub AddAppointment() Call AddAppClosedOutlk("20/08/2012", "Demo App Subject") End Sub Sub...

No idea mate. I'll have a look tomorrow :) Sent from my OMNIA7 using Board Express

I'm not on my pc so I can't post code but, look up my name and I posted code for this a while ago. It can post to outlook without it being open. Thanks Nigel Sent from my OMNIA7 using Board Express

The Irish Olympic fencing team got all confused..... The arrived with 50 posts, 300 metres of ship lap timber and 2 tins of creosote! The Chinese badminton team were finally disqualified.... Chi ting fook and nei to hi are said to be annoyed. The annual camping and caravaning convention got a...

Hi The wshom.ocx is fixed now. Instead of trying to add during the install, it is now checked for existence first when the app runs and if it doesn't exist, the file will be copied to system32, registered and referenced. I will upload it again if I can get some testers. There will be a AWF...