Search results for query: *

Hi I have 2 separate broadband lines (Both with a fixed IP), coming into my LAN via 2 separate routers. Both routers forward Http ports 80 to my webserver. Yet only one of the external IP will show my default web page when I try and browse? Have I missed some configuration on the Server...

Thanks all Youve pointed me in the right direction Great forum

You guys work quick Just seen HarleyQuinn's post . Ill update you how I get on Thanks

Thanks All Ive tried a few of your solutions, but no success. Im using XL 2007 xlbo - CTRL+SHIFT+ENTER didnt do anything, Do I need to do it in a specific place? skipVought - VB editor is clear. No code anywhere combo - how do I go about 'What-if analysis'? Thanks again

I have inherited a formula on a .xlxs spread sheet and am trying to work out what it is doing. {=Table(,C4)} It is producing a value. The Function =Table is not listed in the Excel functions, I have also looked in VB to see if it is a custom function. If i click on the cell the characters...

Hi I dont know if anybody else has come accross this problem, but i cant update a forms recordsource in the form properties on Access 2007. I normally just use the build/query button on the forms porperties pop up. It works fine on Access 2003? Ive reinstalled 2007 2-3 times, downloaded all...

I’m a complete novice to configuring IIS. I’ve wrote a function that sets a Meta Tag dynamically. Using Visual Studio 2005, this works perfectly when I debug it on the built in development server. When I move it across to our web server (default directory) it doesn’t work at all. As a test...

Try the below Dim ImagePath as string ImagePath = "C:\PHOTO\124645.jpg" If Dir$(ImagePath) <> "" Then objWord.Selection.InlineShapes.AddPicture FileName:=ImagePath, LinkToFile:= _ False, SaveWithDocument:=True With .InlineShapes(1) ' Set to the size you require...

Do you mean a group policy (on server)? If so Ive not relly messed around with them, but ill look into this. Thanks

I have managed to stop users from activating fuctions that create orders that are older than todays date. The users (crafty they are) have been changing the date on the desktops so they can create the orders. Is it possible to get the date/time from our local server so I can cross check it...

You are probably better linking the image at runtime In the load event set the picture property as below with the path to your image. Me.Picture = "C:\IMAGE.bmp"

Im not sure if this is your problem but Ive found that if you use the: Format(Date,"mm") it returns the minute of the Date/Time. Try using Format(Date,"MM") the upper case forces it to the Month.

Ive never used the calander control before but had a quick look. I noticed on the poperties tab on the form designer it doesnt have a click event. You can create a click event handler in the visual basic window for your calander control. In the click event reset the record source for the...

Thanks, great tip

I have a order screen that lists completed orders ready to invoice. I have a command button that runs the below code to loop through the completed orders and print a copy of the invoice via a InvoiceOrder() sub. At the moment it uses the default printer. I would like the user to be able to...

Try putting the below is your sqlstring And (vw.DtmDateOfVisit between # " & format(Date1,'mm/dd/yy') & "# And # " & format(Date2,'mm/dd/yy') & "#)

It could be the date format. Ive found that when passing dates into recordsets you need to make sure the dates are formated "mm/dd/yy" for them to work. Try using format(Date,"mm/dd/yy") in your recordset. Hope this helps.

Thanks Guys

Im looking to create a client app that will use a web service to collect and store information locally. I know that you can create "Access" databases within VB.net to hold the information. My question is, if the client doesnt have the programme "Access" installed on the local machine will it be...

My English is as bad as my programming, Thanks anyway!