Hello,
I have written a macro in access 2000. Where the macro transfer the excel data to access. I wanted to run that macro through vb6.0 program. Can any body tell how to call the macro or run the macro.
rockford333
Last Activity: Nov 3 '07, 11:25 AM
Joined: Sep 29 '06
Location: India
-
Running a access Macros in vb6.0
-
Try this
label1=format$( now"DD-MM-YY")
label2=format$( now"HH:MM:SS")
this wat u want... -
Hi,
Mr.Killer42 wat i have given the suggestion is correct r wrong....Leave a comment:
-
hi,
This the way u have to write the code for this.
first open the connection and recordset then,
here u use the column no of database to search for example if its first columnCode:rs.movefirst while rs.eof<>true
...Code:then rs(0) if rs(0)<>dtpicker then pad.text=rs.fields(2) rs.close exit sub else rs.movenext
Leave a comment:
-
hi,
Write u r msgbox programme like this it will work
MsgBox"Error in saving OEM Configuration", "FCS", vbcritical
Let me know whethere u r problem solved r not....Leave a comment:
-
Hi,
Just use the tab order it will select the text automaticaaly. If u face problem in that u can use this type also u can use in the textbox which u want to select u can write in the gotfocus event if u r using text1 then text1.setfocus. Tell me if u have any problem are if u succed also....Leave a comment:
-
Hi,
This is very easy to create the setup file. Just follow the instruction below u will do it.
1. Open vb tools
2. Open package and depolyment
3.Select u r project
4.Select Package
From there follow the instruction u can do it.
Let me know if any problem are there are not. IF u achieve also u tell me....Leave a comment:
-
First add the dataenvoronment , and right click on it goto properties and select the engines. For example if u r using the access database the select microsoft database engine 4.0 and then lick next and locate the database. If u want to give password u can give are leave it. It prefrable if u wont give the password. Then add command and right click and select properties and select the table are query for which u want to design the report. Then add...Leave a comment:
-
Hello To All,
Plz help me in the matter of transfering the data from excel to acess. As i am facing the lots of problem in doing this programe. I have got example programme which need conversion.dll, that i dont have with me. I try to download but I didnt got it. So plz help me providing either conversion.dll or give some other programme....Leave a comment:
-
here is my code
i am writing this code in timer.Code:Public Declare Function Inp Lib "inpout32.dll" Alias "Inp32" (ByVal PortAddress As Integer) As Integer Public Declare Sub Out Lib "inpout32.dll" Alias "Out32" (ByVal PortAddress As Integer, ByVal Value As Integer)
Text4 = Inp(&H379)
Out &H378, 3...Leave a comment:
-
Keep the exe file inside the same folder where u have kept the database. Create shortcut from there to desktop. If it doesn't work mail on my email id rockford333@gma il.com with subject as Database exe....Leave a comment:
-
Parallel port programme
I have written a programm for fetching data from parallel port but data is not coming. -
Have u solve the problem, if not u send me the email to my address to rockford333@gma il.com, with subject con problem....Leave a comment:
-
Hi Shashi,
Thanx for u r response. Actually i was seeing u r vb Tips mail only. I have not started the code to transfer data. I am not getting how to do it. Do u have the ready code for transfering data excel to access....Leave a comment:
-
Excel Data To Ms Access
Hello,
This is Sayeed. I am writing a program in vb6.0. I want the code to transfer the excel data to ms access. Plz help me it urgent.
No activity results to display
Leave a comment: