Search:

Hello all

I have 3 grids that i would like to extract in 1 single excel sheet but each MSHflexgrid will be paste in different sheets.

I would also like to name the sheet by the MSHFlexgrid...

Hi HanneSThEGreaT

I just tried and same error


Conn.Open


Full code

Hello all

I used to use this code bellow for accessing an access 2007 dbase but it looks like 2010 is not the same.
I'm also on windows 7 64

I have this error:
"Run time error 3706 Provider...

This is perfect.

Thanks again for your help. Now it work.

Have a great day

Hello all

I have this code where i'm validating 2 MSHFlexgrid column to find if there is a same value:



Text1 = UCase(Trim(Form61.MSHFlexGrid1.TextMatrix(r1, 5)))
Text2 =...

You now what, i undrestand what you are saying and i will work on that, to name them properly.

Thanks for telling me this. :)

Hello all

I have found another way to do it. Maybe not the perfect solution but it works.

Ex:

For each DTPicker, when i select, il put's the sate date in a normal textbox.

That way, if i...

ok, i just did the test also in Access and here is the issue in the picture in the attachment.

In that field, it is a date format. but i did says that IIf(etape2.Text <> "", "[Etape2_date]", "'" &...

Hello again,
ok, i will test it in access also

I think i did not do the test right the first time.

Really sorry.

I forgot to test that part of the code:

IIf(etape2.Text <> "",...

Hello WoF

This is what i have has a result:

INSERT INTO DBase_vignoble_personnalise ([Date_of_day], [Client], [Adresse], [Ville], [Province], [Code_Postal], [Telephone], [Cellulaire],...

Hello all

I'm trying to build this code so that it transfer all information into my Microsoft Access dBase.

The problem is with this part of the code where i want to says these:

1) If there...

Hello firoz.raj. Let me try this and i will let you know the result

Thanks

Hello dglienna

Thanks again for your help, i will now use a LIVE.COM account.

ah! ok let me try something here.

Hello all,

I have a macro vb6 where i go in 1 folder in Microsoft outlook and then, extract some information for all of them in an excel sheet.

Ex: msg.To / msg.Subject / msg.ReceivedTime...

I will take a look about that: You could SYNC it with a LIVE.COM account.

I dont know much about LIVE,COM

OK, so with Microsoft Outlook, it would not work. Right?

Hello all

I'm having a code that creates an appointment in microsoft outlook. See code bellow.

But now, what i want to do, is to be able to also send that calendar appointment to another email...

Hello dglienna
This is perfect. Now it working perfectly


Dim OLApp As Outlook.Application
Dim OLNameSpace As Outlook.Namespace
Dim OLRecipient As Outlook.Recipient
Dim OLAppt As...

Hello all

I'm trying to modify this part of the code:


'Set OLRecipient = OLNameSpace.CreateRecipient("test@hotmail.ca")


Instead of putting the email in the code, i would like to use a...

Oh OK, i will search for it.

I was kind of struggling

ok, this is based on multiple data base in access.

Let me see what i can do here since i need to filter the grid by date and ACCESS_ID to get the last effective of each.

Ok

So to populate my grid normally, i would use this:



Dim sSQL2 As String
Dim oRST2 As ADODB.Recordset
Set oRST2 = New ADODB.Recordset
Dim oConnect2 As ADODB.Connection

Hello all

Hummm sorry for the double post, i did not even no it.

Sorry for that

Code is now fixed also.

Now why excel, because it is a dbase extract from another department where i work....

Hello all

I need you help on this code please.

What i need to do is to be able to filter my grid based on 2 criteria.

In column 4 of every rows, i have ID for stores(Ex: 00167D)
In column 5...