Tek-tips.com how to use, tutorial

How to create a DLL in VFP

Details: Join Tek-Tips ® Today!. Join your peers on the Internet's largest technical computer professional community. It's easy to join and it's free.. Here's Why Members Love Tek-Tips Forums:

› Verified 2 days ago

› Url: https://www.tek-tips.com/faqs.cfm?fid=3381 Go Now

› Get more:  How To UseGo Now

How to generate an XML document from within VBA

Details: This FAQ contains code to use MSXML6 to generate a template XML document. To be of much use, it will need to be expanded to include your own content, and adapted for your own node name and namespace, and saved to your own preferred location, or adapted to store it in a database for example.

› Verified 2 days ago

› Url: https://www.tek-tips.com/faqs.cfm?fid=7736 Go Now

› Get more:  How To UseGo Now

How to use FindComponent

Details: I tested Awarnica's method, and it worked for me too. That'll teach me to guess instead of test. So if they both work when Michael and I test, maybe there is some other factor preventing it …

› Verified Just Now

› Url: https://www.tek-tips.com/viewthread.cfm?qid=487129 Go Now

› Get more:  How To UseGo Now

Access to Excel export with proper formatting

Details: Access will / can not format the export information. It is possible to write Excel VBA code to format the cells in the target spreasheet. It is possible to write code in Ms. Access VBA to write the Excel VBA code to format the cells and to have the code exported tot he spreasheet.

› Verified 1 days ago

› Url: https://www.tek-tips.com/viewthread.cfm?qid=1201057 Go Now

› Get more:  How To UseGo Now

How to kill an Informix session

Details: Hi, First identify a problematic session by using: onstat -g ses onstat -g sql onstat -u make not of session id and use onmode to kill the session:

› Verified Just Now

› Url: https://www.tek-tips.com/viewthread.cfm?qid=728199 Go Now

› Get more:  How To UseGo Now

Using Sum() in formula

Details: Try a running total. This will sum according to a formula, which can be quite a compelex set of tests. Right-click on a field and choose Insert to get a choice of Running Total or Summary.Or else use the Field Explorer, the icon that is a grid-like box, to add running totals. Running totals allow you to do clever things with grouping and formulas. They also accumulate for each line, hence the

› Verified 1 days ago

› Url: https://www.tek-tips.com/viewthread.cfm?qid=1094731 Go Now

› Get more:  How To UseGo Now

MiVB 9 software installation

Details: I have a 1 gig ram on a new 3300 that I managed to migrate to MiVB9 with no challenges. It is the same 1 gig ram that I have tested with on the 33300 that is failing to boot up either MiVB 8 or 9.

› Verified 1 days ago

› Url: https://www.tek-tips.com/viewthread.cfm?qid=1790349 Go Now

› Get more:  How To UseGo Now

Using "Contains" in a Formula

Details: Dear harriet, You have several options: 1. Use In function to check. If 'Captial' in {Table.Field} then 1 else 0 2. Use Instr (Instring) function:

› Verified 1 days ago

› Url: https://www.tek-tips.com/viewthread.cfm?qid=1234541 Go Now

› Get more:  How To UseGo Now

set_item_instance_property

Details: As lewisp said, put only one button then try to call this function in your post_query. This is the one I daily use for this job: PROCEDURE HIDE_AN_ITEM …

› Verified Just Now

› Url: https://www.tek-tips.com/viewthread.cfm?qid=547139 Go Now

› Get more:  How To UseGo Now

How to remove commas from a number

Details: Thanks this is great! I just realized that the original format is: XXX,XXX,XXXX.00 How do I use the 'replace' function to get rid of commas as well as the decimal point and trailing zeros in …

› Verified Just Now

› Url: https://www.tek-tips.com/viewthread.cfm?qid=606632 Go Now

› Get more:  How To UseGo Now

Control multiple monitor display using VBA

Details: I agree - how about Comic Sans!! After I'd finished they said, some of the users have dual monitors. Aaarrrggghhh! So I need to disable monitor 2 programmatically whilst the program is in use.

› Verified 1 days ago

› Url: https://www.tek-tips.com/viewthread.cfm?qid=1779630 Go Now

› Get more:  How To UseGo Now

How To: Add a blank value to ComboBox item collection

Details: In VB6 you could set the initial value held in ComboBox control to -1 so that it is blank to begin with. But in .NET if when the DataSource property is set for a ComboBox, you cannot modify the item collection.You cannot set ComboBox1.Text = "" or use Add method to add a new item to the list. So how would you add a blank value to the ComboBox item collection, when it is bound to a data source?

› Verified 2 days ago

› Url: https://www.tek-tips.com/faqs.cfm?fid=5281 Go Now

› Get more:  How To UseGo Now

How to convert decimal hours to HH:MM format in Crystal

Details: I have an application written in C#.net using VS 2008 and Crystal Reports. I have written reports that pull data from my access database and bind the data to the crystal report where the data is summarized and totaled in various ways.

› Verified 1 days ago

› Url: https://www.tek-tips.com/viewthread.cfm?qid=1685015 Go Now

› Get more:  How To UseGo Now

How To: Add a logon banner using GPO

Details: *Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

› Verified 2 days ago

› Url: https://www.tek-tips.com/faqs.cfm?fid=5073 Go Now

› Get more:  How To UseGo Now

How to convert Float to Integer

Details: coulad any body help me?! I want to use mod to find a remainder from a Float, however, it only works under integer!!! HELP ME PLEASE!!!!! I am a new user!!

› Verified Just Now

› Url: https://www.tek-tips.com/viewthread.cfm?qid=128128 Go Now

› Get more:  How To UseGo Now

Streaming a file to a local printer

Details: JScannel, your approach is not wrong, but you should explicitly P/Invoke at least seven different Windows subroutines in a specific nested order like XML: openprinter, opendoc, openpage, writebytes, closepage, closedoc, closeprinter. I speculate that your printer driver is waiting for your C# code to close all (implicitly?) opened sections.

› Verified 1 days ago

› Url: https://www.tek-tips.com/viewthread.cfm?qid=1784519 Go Now

› Get more:  How To UseGo Now

how to: get the total size (in bytes) of a folder

Details: In windows, one way to get the the directory size is by right-clicking on the dir then choose properties. In aix (ascii terminal), what is the equivalent comman

› Verified Just Now

› Url: https://www.tek-tips.com/viewthread.cfm?qid=564397 Go Now

› Get more:  How To UseGo Now

Running PC off a generatora Bad Idea

Details: Hello, I am a victim of Hurricane Ike, it will be several weeks before AC power is restored. In the meanwhile, I'm using a ~7,000-Watt generator to power a few devices like a 42" plasma, small wall A/C, and a few lights.

› Verified 1 days ago

› Url: https://www.tek-tips.com/viewthread.cfm?qid=1501851 Go Now

› Get more:  How To UseGo Now

Mitel 5320 locked & how to unlock

Details: Hi guys , We have 4-6 mitel 5320 phone which showed locked on display. Can get extension details by searching MAC of 5320 ip Phone. If yes what will be steps.

› Verified 1 days ago

› Url: https://www.tek-tips.com/viewthread.cfm?qid=1806201 Go Now

› Get more:  How To UseGo Now

How to Get Image from Shared Folder on Server

Details: I want to access an image that is in a shared folder on the server. The shared folder is NOT in the INETPUB folder and it cannot be moved. The directory structure of the shared folder is …

› Verified Just Now

› Url: https://www.tek-tips.com/viewthread.cfm?qid=935379 Go Now

› Get more:  How To UseGo Now

How to change location of RDP file

Details: The Default.rdp is only created if you don't save the connection to another location the first time you create it. What I do is open the RDP, customize it, and then [b[before I connect[/b] save it as a different name (I use the server or client name.rdp) to a location of your choice.

› Verified 1 days ago

› Url: https://www.tek-tips.com/viewthread.cfm?qid=1584077 Go Now

› Get more:  How To UseGo Now

R11.0 Upgrade to R11.1

Details: 1) He's got an IP500 V2, so the CentOS issue isn't an issue here. 2) Even if it was, the 11.0.4.4 to 11.1 SP1 process doesn't need another server setup for virtual server upgrades or doesn't need a manual data restore.

› Verified 1 days ago

› Url: https://www.tek-tips.com/viewthread.cfm?qid=1806351 Go Now

› Get more:  How To UseGo Now

How to Suppress (or show empty ) the first record in

Details: Search for this file on th CD website. It is a help file for most, if not all of the functions available in version 8. cr8_formularef_english.chm

› Verified Just Now

› Url: https://www.tek-tips.com/viewthread.cfm?qid=569140 Go Now

› Get more:  How To UseGo Now

How to Initialize a ImageList

Details: Hi I am trying to create a TreeView using an ImageList control. I am creating the root node using Add method as: TreeView1.Nodes.Add , , Shelby , North Shelby ,

› Verified 9 days ago

› Url: https://www.tek-tips.com/viewthread.cfm?qid=26748 Go Now

› Get more:  How To UseGo Now

How to Force AfterUpdate

Details: I have a form with a combo box that has an elaborate routine for its AfterUpdate event. At certain times, I would like to open this form programatically and specify a value for the combo box.

› Verified Just Now

› Url: https://www.tek-tips.com/viewthread.cfm?qid=599816 Go Now

› Get more:  How To UseGo Now

How to: Clone Samsung OfficeServ 7200 SD card and/or

Details: @ IPGuru: Why would I need to speak to our end users first? Thanks for the rest of your advice. @ hostedphone: Thanks for the detailed reply. Speaking with Samsung in their Telecommunications and Networks department I'm told it's FAT16 and "They are specifically formatted for our systems by us.

› Verified 1 days ago

› Url: https://www.tek-tips.com/viewthread.cfm?qid=1738113 Go Now

› Get more:  How To UseGo Now

How to center a message box in a form

Details: How can I center a message box in my visual basic app? I want the message box to be the center of the form, I know how to do this with input boxes but that's ab

› Verified Just Now

› Url: https://www.tek-tips.com/viewthread.cfm?qid=417043 Go Now

› Get more:  How To UseGo Now

setting multiple "To" recipients using CDO.Message

Details: I am trying to send an email dynamically to multiple recipients with the recipients defined within a variable. The code below works if I set selectedEmailList = "[email protected]" (a single email address within quotes) but doesn't work if I set selectedEmailList = "[email protected],[email protected],[email protected]".

› Verified 1 days ago

› Url: https://www.tek-tips.com/viewthread.cfm?qid=1683399 Go Now

› Get more:  How To UseGo Now

How to schedule a mail send

Details: Hi, I use Lotus Notes Client 6.5 is possible to schedule an automatic mail send every day at a spefic time? Regards

› Verified 1 days ago

› Url: https://www.tek-tips.com/viewthread.cfm?qid=1275767 Go Now

› Get more:  How To UseGo Now

how to install aloha pos on server

Details: hi; I have been having so many problems with the aloha pos server, it crash few times a day and the edc stops working. And i need to rebuilt it, so i decided to just get a new server and now i need help to install the aloha software and to transfer the database to the new server.

› Verified 1 days ago

› Url: https://www.tek-tips.com/viewthread.cfm?qid=1292365 Go Now

› Get more:  How To UseGo Now

Query Prompt Wild Card

Details: Is it possible to use a 'wild card' in a query prompt? For example, rather than select a Name from the Values list and get data just for that Name, enter a wild card to retrieve data for all Names.

› Verified 1 days ago

› Url: https://www.tek-tips.com/viewthread.cfm?qid=1006869 Go Now

› Get more:  How To UseGo Now

How to read a Notepad file using VB6

Details: If you don't know then the simple conclusion is that you are not qualified to write programs for Windows. Microsoft has tried and tried to get programmers up to speed on how things have changed since the DOS days passed, then since the Win9x days passed, and now we're in the Vista era which protects even more of the filesystem and registry from casual tinkering.

› Verified 1 days ago

› Url: https://www.tek-tips.com/viewthread.cfm?qid=1739461 Go Now

› Get more:  How To UseGo Now

Avaya One X Agent Ringer not playing through PC Speaker

Details: Hi, Hoping someone can help. We're running Avaya One X Agent 2.5 on Win 7. We can't get the ringer to ring on the PC's external speaker. Instead, along with voi

› Verified 1 days ago

› Url: https://www.tek-tips.com/viewthread.cfm?qid=1744414 Go Now

› Get more:  How To UseGo Now

Excel VBA: Copy selected text from word, paste in excel at

Details: I do OK in Excel VBA but Word VBA seems completely foreign. As the title says I want to select text in an open Word doc then with an Excel macro have it …

› Verified 1 days ago

› Url: https://www.tek-tips.com/viewthread.cfm?qid=1794887 Go Now

› Get more:  How To UseGo Now

How to implement the "OnFirstRecord"

Details: OnFirstRecord is a function that is "True" on the first record of the report. It is great for conditional page breaks. If you want each detail record on a seperate page then

› Verified Just Now

› Url: https://www.tek-tips.com/viewthread.cfm?qid=373229 Go Now

› Get more:  How To UseGo Now

J139 series phones, trouble enabling web server

Details: I'm trying to enable the web server through the phone admin menu as per the instructions in Installing and Administering Avaya J100 Series IP Phones October 201

› Verified 1 days ago

› Url: https://www.tek-tips.com/viewthread.cfm?qid=1798052 Go Now

› Get more:  InstructionGo Now

How To Maximize IE Window via VBA

Details: I use the following function to open Internet Explorer via VBA from Excel. [code] Function GetWeb(URL As String) As String Dim IEApp As Object Set IEApp = Creat

› Verified Just Now

› Url: https://www.tek-tips.com/viewthread.cfm?qid=905088 Go Now

› Get more:  How To UseGo Now

How to populate a Combobox in Word

Details: Thank you for the response. I really am not familiar with VBA code and need a little more help. I'm using ActiveX combobox which I have found out how to populate by using DAO but have yet to figure out how to write any new data from the combobox into the database.

› Verified Just Now

› Url: https://www.tek-tips.com/viewthread.cfm?qid=963710 Go Now

› Get more:  How To UseGo Now

How to setup a global array

Details: Another quick question please guys. I need to make an array global so that other sub and functions can access it - how do I do this? I would be using the Sub uto_Open to get it to intially read some data from a file into an array and then instead of having to query the file it just queries the array.

› Verified Just Now

› Url: https://www.tek-tips.com/viewthread.cfm?qid=534419 Go Now

› Get more:  How To UseGo Now

How to check which version of MS JET

Details: Go to: Control Panel, Administrative Tools, Data Sources (ODBC), then the Drivers tab. Scroll down to find Microsoft Access Database and look in the version column. Just because a PC has a certain version of Access on it doesn't necessarily mean the correct Jet library is there.

› Verified 1 days ago

› Url: https://www.tek-tips.com/viewthread.cfm?qid=1155711 Go Now

› Get more:  How To UseGo Now

Convert ResultSet into List/ArrayList/

Details: I am at a bit of a loss on this. How the heck do you write a generic class/function/whatever that will convert a ResultSet with an arbitratry number of Rows an

› Verified 1 days ago

› Url: https://www.tek-tips.com/viewthread.cfm?qid=1181382 Go Now

› Get more:  How To UseGo Now

How to exclude particular group summary from crystal

Details: Hi, Can any one help me to find a solution for the follwing: i don't want to show a selected group summary - how to do this? Ex: Group names are: A, B, C, D all

› Verified 1 days ago

› Url: https://www.tek-tips.com/viewthread.cfm?qid=1644515 Go Now

› Get more:  How To UseGo Now

how to convert dat file for editing in premiere

Details: Yeah, should work very simply. When the VCD is in the drive, look at it in a file explorer. It should contain a few directories. In the one labeled 'MPEGAV' (or at least it is on vcd's I've created with nero) there is a list of .DAT files.

› Verified Just Now

› Url: https://www.tek-tips.com/viewthread.cfm?qid=460216 Go Now

› Get more:  How To UseGo Now

How to interrupt a module processing upon an event

Details: The only way I can think of doing it is to declare a public (global) variable (i.e. Public gbolEventFired as Boolean) and when the event fires, set the Public variable to True.

› Verified Just Now

› Url: https://www.tek-tips.com/viewthread.cfm?qid=649719 Go Now

› Get more:  How To UseGo Now

Related topics