Hello, Is there any way of returning an array from a funciton under VBA (Office 97)? Do I need to use a global array for this? I'm trying to minimize global...
for a simple and fast , you can direct edit from properties. ... Start your day with Yahoo! - make it your home page [Non-text portions of this message have...
private sub command1_click() ''''assume forecolor me.forecolor=vbGrey 'if u want to change the forecolor of form to grey command1.forecolor=vbCyan '' if u...
hi vinod put the command me.refresh after your command. good luck Mehran VB master;) ... ____________________________________________________ Start your day...
hi all i am having fso open to aexcel file and i want to delete it ... what is the command to free the conection , when i execute kill("c:\filename.xls") can...
Access is not designed to be a multi-user database backend...You might investigate getting some form of SQL Server (SQL = "S"tructured "Q"uery "L"anguage)....
Hi Chad, You can use Variant to return an array. For example, Private Function ReturnArray(ByVal Source As Long) As Variant Dim Result(2) As Long For i = 0 To...
Hello, Yes it helped. Thanks. Variants did solve the problem. I got so used with VB 6 and VBA in Office 2002 that I'm having trouble working with VBA in Office...
u r wrong Mr.Richard. u can use MS Access as multiuser database backend. i m using it as a multi user environment. ofcourse not for large WAN, but for small...
hi every one i am not expert in VB nor an intermediate. but i can work on VB.i am learning VB from a book without any others help the name of the book is "VB...
Hello Kumar, Could you please tell me more about MS Access as multi user database backend? I have tried to search in Google but need more information of it....
You don't have to do anything fancy with the database. Just put it on the
server, or somewhere everybody has access to it. Connection strings can be found at...
This is a good tutorial on how to handle files and folders. It goes into
binary, random, and other types of files. Rick Rose ... From: Sameen Khan Date:...
Does anyone know how to make combo boxes rotate 90 degrees (i.e. align with a 90 degree line)? In my program a piece of land is given -- the piece of land is ...
__________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ...
hi, i have database & i succefully conected but, when i add or delete records in table, all the records in report is not getting update. plz help me thanks ......
hi, i have database & i succefully conected but, when i add or delete records in table, all the records in report is not getting update. plz help me thanks ......
after delete or update data u have to refresh the report what report did you use?? __________________________________________________ Do You Yahoo!? Tired of...
Dear All, I am having company master which iam having filed like companyid,companyname,add1,add2,etc.. i need to view all the data in flexgrid once i click the...
Hi all, I have a modem attached to one of my USB ports and I was wondering whether it is possible to poll my USB ports to detect whether there are any devices...
You can't change the font color of a command button, unless you use API, you could use a checkbox to simulate a command button and then you can cahnge the font...
Hi i work with VB 6.0 SP 3 and SQL Server 2000 (SQL Standard Edition 8.00.534 (SP2)). The driver on the local PC's are mdac 2.8 with SP1. Now I have the ...
dear all, i am using VB 6 and data reports of VB. i have table of sales order,in that fields are sal_ord_no,sl.no,description(items),rate,units,quantity,...
hai, In a VB program I have used direcrory list box, drive list box, file list box. Here if i click the directory list box with the mouse, corresponding files...
You should use a Hierarchy Flexgrid. When they click on the id, run a query
of your database using ADODB. Set the flexgrid's recordset property to your
ADODB...
hi, Thanks for reply. I use data report. plz help me to solve this problem thanks Asral Sukma <alsukma@...> wrote: after delete or update data u have to...
Change the Style of the command button to Graphical and you can adjust the properties withot doing API calls. Dan Opiela ... From: Nuno Fernando Afonso...
I've made a VB program to do some printing to a local printer. I need to be able to launch that program somehow from the web. Can someone suggest how to do...