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

And....... to show you what i mean from my last post- i made an arc measure years ago by manipulating the angle command in DIESEL and adding the length in the place of the angle text. Here is my code: ^C^C_lengthen;\;_dimangular;@;t;$M=$(rtos,$(getvar,PERIMETER),2, $(getvar,dimdec)); Years...

Hi Tony, im guessing then that the shop you have in reading is a print shop hrnce the 3D printer in the window? I ve always liked the idea of a 3D printer as you can make mock ups of what you need instead of waiting days from your supplier to make it for you which is where i am at....... i...

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

Why do you have a 3D printer? We were looking at one for our concept model building using sketchup but decided against it in the end :) N 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