Search:

Hello everyone,

I need your help, I have a multiline textbox and I need to save the contents to an Access database table (in a list format and not in a text format).
I'm using an ADO recordset...

Hi Sam,
thanks for your reply,

I looked at post #15, what you show is how to populate a flexgrid, then add, edit and delete an entry in the flexgrid then how to update the database, Any items...

Hi all,
thanks for all of your help, the code below gets the result that I want,
I get a List of parts from an Access database table (only one field in the table named 'Parts', each item within...

Hi Sam

I had a quick look at #15,
i'll go back and have an in depth look at it, sounds like it could be very useful to me.

Thanks, i'll give your code a go without the array and let you know

This now gives me a "rowset does not support fetching backward" error on the rs.MoveLast line

Hi OptionBase1

Yes the value is -1

Hi all,

I altered my database table earlier so it had all 3 fields, ID, parts and vehicle so the table matched the code, every time i have run this code i have got the runtime error.
All i need...

Hi all,
Hi Sam,

I used the code from #13 above but when it gets to the line "ReDim PartsArray(rs.RecordCount, 3) As Variant" it returns a runtime error 9, subscript out of range.

Cant work out...

Hi,
Let me explain, the parts list is part of a program for vehicle repair assessors, when a new record is created for a new vehicle repair, they select the parts needed for the repair from a...

Hi all,
Sorry it’s took so long to get back to you,
Ok then, Gaps, I need to be able to leave a few of the lines blank to act as a sort of separator between groups of car parts,
Why a Textbox, at...

Hi,

Textbox list problem explained,

I have an access database with a field called PARTS, in the PARTS field are records containing Part names, see example below.



Parts
FRONTAL

Hello to all of you and best wishes for Christmas and the New Year,

Right, now for my problem,

I need to load a list of 'Car Parts' from an Access database to a Textbox so that it displays as a...

Hi all,

I've got a Word doc which is loaded from a resource file within my VB6 program, bookmarks in the Word doc are populated from textboxes on VB forms, on the one form is a listbox with a list...

Hi,

38 views but no replies, am I asking the impossible.
Can a standard Common Dialog be modified in such a way.

If it’s not possible would someone at least say so.

Thanks,
Steve.

Hi all,
Been a while since I posted a question so here goes.

I've got a bit of code that when run displays a listbox and an Add button which then opens a Dialog Box, from this Dialog Box you can...

I’m marking this post as Resolved as the original problem of ambiguous name error was resolved in post #12, I merged the two modules into one which solved the problem, I’ve still got the problem of...

Thanks to both of you for your replies
If I select a single photo and Debug.Print I get

C:\SKM Software\SKM Images\Ref 2000\P1200010.JPG

If I select 3 photos and Debug.Print I get

...

Thanks for every ones help, got the dialog boxes working ok by combining the two Modules into one. I can't mark it as Resolved yet as I am having a problem saving the images.
When selecting a photo...

Thanks DataMiser

Got a question,

Can you have one procedure in a module which is used from multiple forms in a project.

Thanks for the replies

Fafalone suggests making a module for OFNHookProc, I haven’t got the code with me at present but I’m sure I’ve already got an OFNHookProc module that I use for another...

Sorry for leaving the reply so long, I think its nearly sorted.

As suggested i've moved the 2nd module code onto the 2nd form and changed the Publics to Private.
That's got rid of the Ambiguous...

Got a problem with an ambiguous name error in a project using custom Common Dialog boxes.
As well as other forms and modules I’ve got 2 modules and 2 forms relating to the Common Dialog boxes, the...

Using VB6 I need to copy photos from a folder on C drive to an open word doc, cant figure out how to do it.

Any help would be much appreciated.

Thanks.

I'm using Word 2002 and populating the Word doc using VB6 code


Thanks
SKM.

Thats it, I give up,

been trying to work it out for hours and just can't figure it out,

I'm going off to watch the telly.

SKM :mad:

Can't get it to work, comes up with the error "The Specified value is out of range" and the folowing code is highlighted

With ActiveDocument.Shapes.AddTextbox( _
...

Thanks anhn

i'll give it a try and get back to you

Thanks
SKM

No suggestions,

Someone must have some idea how to do it.

SKM

Hello,

The code below shows how Text is inserted into a Word doc Bookmark called "engsign"

.ActiveDocument.Bookmarks("engsign").Select
.Selection.Text = "ENGINEER : " &...

All sorted,

I use this code to save the selected image to a temp file,

SavePicture frmReportPg1.ImageList1.ListImages(frmReportPg1.cboEngSign.SelectedItem.Image).Picture,...

This is the full code line I use to save the selected Image to a Temp file

SavePicture frmReportPg1!cboEngSign.SelectedItem.Image, "C:\SKM Temp\TempSign.gif"
I use the same code elsewhere to save...

Hello,

I use an ImageList to populate an ImageCombo, This works ok.

When an item is selected in the ImageCombo at runtime, I need the selected image to be saved to a Temp file but I cant work...

Thanks,

Tried both examples and they work great.

Hack,

Heres an entry from the Listbox

R BONNET HINGES

The first charactor is a single letter (this I want in the 1st column of Listview) then the next is a Description, which may be a...

Hi.

I need to copy the entire contents of a Listbox (List1) to a Listview (LvP).

The Listbox has a single column and the Listview has 2 columns.

Each entry in the Listbox is made up of two...

Hello

I can create a Word doc and create a table in that Word doc using VB6 code but what I can't work out is how to copy the contents of a ListBox from VB to the Word Table.

Any ideas.

SK.

Thanks RhinoBull for the code, works fine now.

Thanks
SKM

Hi

Below is the code (obtained from this forum but I cant remember from who) that I use to move lines in a listbox up or down by dragging and dropping them.

Option Explicit

Dim sCurItem As...

Thanks to both of you

I tried the code and it works with XP
will it also work with Vista?

Steve.