Type: Posts; User: wilder1926
Search took 0.02 seconds.
December 22nd, 2012, 04:45 PM
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...
August 18th, 2012, 07:37 AM
I just tried and same error
August 17th, 2012, 06:16 PM
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...
February 23rd, 2012, 07:31 AM
This is perfect.
Thanks again for your help. Now it work.
Have a great day
February 23rd, 2012, 04:39 AM
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)))
January 9th, 2012, 02:21 PM
You now what, i undrestand what you are saying and i will work on that, to name them properly.
Thanks for telling me this. :)
January 9th, 2012, 01:37 PM
I have found another way to do it. Maybe not the perfect solution but it works.
For each DTPicker, when i select, il put's the sate date in a normal textbox.
That way, if i...
January 9th, 2012, 12:18 PM
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]", "'" &...
January 9th, 2012, 12:01 PM
ok, i will test it in access also
I think i did not do the test right the first time.
I forgot to test that part of the code:
IIf(etape2.Text <> "",...
January 9th, 2012, 10:47 AM
This is what i have has a result:
INSERT INTO DBase_vignoble_personnalise ([Date_of_day], [Client], [Adresse], [Ville], [Province], [Code_Postal], [Telephone], [Cellulaire],...
January 9th, 2012, 10:06 AM
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...
January 6th, 2012, 07:13 PM
Hello firoz.raj. Let me try this and i will let you know the result
December 28th, 2011, 06:33 AM
Thanks again for your help, i will now use a LIVE.COM account.
December 23rd, 2011, 11:47 AM
ah! ok let me try something here.
December 23rd, 2011, 11:30 AM
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...
December 22nd, 2011, 08:01 PM
I will take a look about that: You could SYNC it with a LIVE.COM account.
I dont know much about LIVE,COM
December 22nd, 2011, 05:36 PM
OK, so with Microsoft Outlook, it would not work. Right?
December 22nd, 2011, 05:25 PM
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...
December 22nd, 2011, 05:06 PM
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...
December 19th, 2011, 05:52 PM
I'm trying to modify this part of the code:
'Set OLRecipient = OLNameSpace.CreateRecipient("firstname.lastname@example.org")
Instead of putting the email in the code, i would like to use a...
December 5th, 2011, 04:38 AM
Oh OK, i will search for it.
I was kind of struggling
December 3rd, 2011, 05:02 PM
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.
December 3rd, 2011, 03:29 PM
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
December 3rd, 2011, 01:38 PM
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....
December 3rd, 2011, 12:01 PM
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...
Click Here to Expand Forum to Full Width