Search results for query: *

Is it safe to have a script that will run every week to truncate my temporary tables? ======================================== I kept my Job because of TEK-TIPS Thanks a lot to all who keeps on helping others.

Good day! I have this post under SQL thread183-1560051 that is already working. But since the we need to create a folder at MYserver as a dump location for our excel files for the OPENROWSET to work like D:\ExcelFiles\, I need my program to check first if the folder and files really exists...

I'm already doing this code below Public Sub testloop() Dim x For x = 1 To 10 Select Case loopr Case 1, 3, 7 To 10 Debug.Print loopr End Select Next End Sub But is there a way for the loop to look like this? Ofcouse the sample below is not...

I need to loop to lots of excel file so i need to pass the file name. But using SET @FileName = 'C:\MyExcelFile.xls' and pass it on the code below is not working. FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=C:\MyExcelFile.xls;HDR=YES', 'SELECT * FROM [Sheet1$]') My Code SET...

Is it possible to get the actual website of this url below, which is "http://www.starr-al.com/"...

I have a project that when I run, the application run as is. But when the time to close the application it crash. But when I open the project and compile it first before running, it never crash. What is the reason behind this? ======================================== I kept my Job because of...

Good day, The given code below is working. But my problem is when i open the text file and go to the last line, there was additional row instead of showing only the "SetFooter". It was like I hit the enter key. How can I avoid that last line. ======= SAMPLE ONLY (MY PROBLEM) ========...

I would really appreciate if some can help on my problem. And please bear with my explanation. I have an array that holds 2 data (actually 3, but Level is for tracking only), one is the Manager and the other is the Agent. But that agent can also be under the Manager have agents under it. Its...

Is there anyone that can give me guide on how to add Open Office Calc in my VB Reference. I really can't find it in my Available References. And is there a simple code that I can start to transfer my data to Calc. This is really my first time using Open Office...

Order by newid() I got this from thread183-1208594 and it really works. Thanks a lot. But just one question. I have 300 to 400 users and we have atleast 20,000 to 30,000 records. What is the possibility that these users will get the same record? ======================================== I...

Good Day! We are having some problems here updating our workstations. Actually by the help of Tektips people I already created an application that will automatically update the workstations (about 150 to 200). But the problem is that some of the workstations are real SLOW (and its not easy...

Sorry, but I already search and only find threads that wants to bypass excell with password. But for security purpose, we will be sending Credit card information thru email that was created by VB and exported to Excel, and the company want to protect our client information, so we need to...

Hello there! Is there a way that I can get all components/reference that was used by an application particularly an exe file. What I'm trying to do is to have an application that will automatically copy (from server) and register a dll/ocx to a workstation that do not have a dll/ocx that was...

declare @cCustNo as varchar(20), @nType as numeric declare @vTelNo as numeric DECLARE RS_cursor CURSOR FOR SELECT cCustomerNo, nType FROM Customer_Contact OPEN RS_cursor FETCH NEXT FROM RS_cursor INTO @cCustNo, @nType set @vTelNo = 0 while @@FETCH_STATUS = 0 begin set @vTelNo =...

Hi there Just want to know if there is a way that i can list all items in my menu that was already created using the menu editor. I need to know this coz I need to create an "access this menu maintenance". It's getting complicated here since i have lots of menus. Right now, I have a level of...

Here's the scenario: Last saturday everything is running okay, the user can open all the reports (crystal). But this Monday, an error Invalid Filename was encountered. The last thing that we know last saturday is that we install Yahoo Messenger and Winzip. So, we uninstall these two...

Is there a way that I can set the row height of a listview during runtime. If the data/text is too long it will automatically change the row height to fit the data. thanks in advance for any suggestions Please pardon the grammar. Not good in english.

is there a way that i can set my mdichild to be at the center of the mdiform? hope you can help me on this. coz, i have some small mdichild, and it really looks bad not showing it at the center. Please pardon the grammar. Not good in english.

In VB i can use this function to get the value of the clipboard. But how can I get the value of the clipboard using VBA? Any one?? Please pardon the grammar. Not good in english.

Hey guys!!! Is it possible in VB that I can declare an infinite array??? Please pardon the grammar. Not good in english.