Oops!

Hi All,

I'm a complete novice when it comes to ASP, so please bear with me.

I have a GridView bound to an Access Table that has no sorting on it (which is as it should be) and a Combo Box bound...

Hi,

Try using dr = Nothing instead of dr.Close()

You're getting the error because you have cmd set to the "New" keyword and not dr (so cmd is an Object whereas dr is a Variable).

HTH,
...

Placing the intCounter in the header as a Private variable makes it available to all the subs and functions in the form (or module for that matter).

Crucially, it's independent of the Timer event...

OK, so I've just spotted another mistake. Where I have Set fldrs = fso.GetFolder("C:\Program Files") it should be Set fldrs = fso.GetFolder(YOUR PARENT FOLDER PATH HERE)

It's been a long day..!

Oops! That should be string length = (string length -1)

I was right about the FSO Property though - it's GetParentFolderName - so no need to mess with strings at all!

Chris.

Ok, from your post it looks like the Application Folder is in the same folder as the DB Folder.

You can use string manipulation to get the parent folder of your App.Path (use a Do.. ..While Loop...

Oops!

Ok:

Declaration in Form Header (after Option Explicit):

Private intCounter As Integer

then -

Sadly the App has to be compiled in VB6 but knowing how to do it in .Net would be good for future reference.

If you can post the method I'd really appreciate it.

Thanks,

Chris.

Ah.

This appears to be an installation issue.

I had 2005 Express for a while, got fed up with the installer, bought the full version.

Where is the DB being installed to? Is it as a...

Hi All.

Does anyone know how to get the ShareName of a Local Drive? Or even if the Local Drive is shared?

I know you can get the ShareName using FileSystemObject, but this only works for...

Hi,

Try moving the Image location bit to the timer:

Private Sub Timer4_Timer()
Image1.Left = Image1Left + 200
Image1.Top = Image1.Top - 50
Timer4.Enabled = False
End Sub

Hi Mr Wobbles (good name!)

For VB6 use: App.Path to return the application dir (eg: Open App.Path & "\MyFile.txt" For Input as #1)

For VB2005 use My.Application.Info.DirectoryPath

HTH,
...

Hi,

Adding an image to an Access DB is fairly simple -

Add a field to the employee table with a type of 'OLE' (call it picture or something like that).

Open the table, right-click on the...

Ok, so it seems it's important to type out (and not Copy/Paste as I did).

I've just rewritten the function in the new project (word for word - it's identical) and now it works - go figure.
...

Hi All,
Does anyone know why I'm getting a 'Null Reference' error when I try to use a FolderBrowser?

I have the following code (called from a Toolstrip Menu Item):

<code>
Dim fldBrowser As...

Hi Webbsta,

It depends on how you've linked to the .dlls. I know practically nothing about linking to such files but I do know you can find the installation location of your app (and point to it...

Hi, sorry for the late reply.

I'm using VB Express, which I suspect is part of the problem. I saw the Project Installation doodad on the MSDN website whilst looking for solutions but it doesn't...

Yup, exactly the same problem... Installed to the User Account under a folder that's almost impossible to navigate to! (Try adding your App to Scheduled Tasks and you'll see what I mean.)

I...

Update #2

The installer doesn't install to Program Files in XP either - it wants to install the App in the User's profile just like in Vista.

I've looked several times now and there just...

Update:

Ok, I've solved the problem of adding the additional pngs to the installation process by adding them to an ImageList and calling them from there.

I'm still having a headache with where...

Hi All.

Does any one know how to add extra files (in my case .png's) to a VB 2005 installation?

This used to be really simple in VB6, you just browsed for the extra stuff you wanted and that...

Are you sure they are in the right order?

According to your last post PRIMARYSSN a Field in OtherAdults and SSN is a Field in FormInformation.

If there are no spaces in the Field Names (and...

Hmn...

About all I can see wrong is (assusming you have pasted your code from Access VBA) you have a typo in the 'Set' event for rstMain (should be: "Set rstMain = dbs.OpenRecordset(sql)" - not...

Like all the best solutions - simple when you know how. It's the knowing how beforehand...

Thank you waynespangler!

Okay, I think I can't scratch this one - it just doesn't seem possible...

Thanks for looking,

Chris.

Hi,

So long as you have a Reference to the DAO Object Library you can do the following:

Dim dbs as DAO.Database, rstMain as DAO.RecordSet, rstLookUp as DAO.Recordset
Dim sql as String
Set...

Hi All,

Does anyone know how to interrupt a Do While Loop?

I have a very simple bit of code that Loops though the items in a ListBox so long as a boolean (blnPaused) = False. There is a...

No worries, glad I could help.:)

Oops, not sure what happened to the formatting in my post - sorry. (Ignore the <...> bits.)
Chris.

Hi, I haven't implemented this but it should work:



While Reader.Read()
Try<LI class=li1> For Columns = 0 To Reader.FieldCount - 1
<LI class=li2> ...

Hi,

I did something like this myself. Use two variables (ie: Dim dblVal1 As Double, dblVal2 As Double).

Pass the 1st test entry to dblVal1, clear the text box (when the user presses a...

Hi, thanks for the reply.

If I use a timer how will it reflect the progress of files/folders copied? Do I turn the timer on and off from the Do.. ..While Loop?

Apologies if I sound daft but...

Hi All.

I've got a small App (VB.Net) that adds Files and Folders to a List and then uses a Do.. ..While Loop to copy each item in the list to a new Directory (not unlike a backup program).

I...

Hi.

Sorry for delay in reply - at home now after work.

Line 90 was a call to Debug.Print the Response to the SOAP message so I could see what was coming back (I can't remember the exact code...

Hi All,

I'm trying to connect to a Web Service from VB 2005 and keep getting the same error:

System.IO.FileNotFoundException occurred
Message="The download of the specified resource has...

Hi All,

I'm completely new to XML & SOAP so please bear with me if I sound stupid.

I regularly write code in VBA and VB6 and have been asked to create a function that will link to a...