Tek-tips.com list how to use

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

What Is PowerBuilder and How do I learn how to use it

Details: Congratulations on getting to work in a great environment! Powerbuilder (PB) is an Object Oriented, Event Driven, Graphical User Interface (GUI) environment primarily geared for client / server applications. PowerBuilder uses its own language, called PowerScript. Powerbuilder is considered a …

› Verified 2 days ago

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

› Get more:  How To UseGo Now

how to make exe file standalone in visual foxpro5 or 6 ver

Details: Rick. RE: how to make exe file standalone in visual foxpro5 or 6 ver. wsobers (IS/IT--Management) 6 Sep 01 11:06. You need your program.app or program.exe, vfp6.exe and vfp6enu.dll in the same directory to run your apps. You can just copy these into the directory unless you have active X controls, which you will need to register.

› Verified Just Now

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

› Get more:  How to makeGo Now

How do I add/remove controls at runtime

Details: First, create a control array. Let's say we're using a TextBox. A button will be pushed to add the control. Private Sub btnAdd_Click() Dim NextVal As Integer

› Verified 2 days ago

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

› Get more:  How To UseGo Now

Use SQL Reporting Services from VB.NET

Details: Basically there are 2 ways to work with Reporting Services. The first is by using your browsers address bar. This along with the report manager provides a very easy way to interact with reporting services. The second way is through the web service that is provided with reporting services. This allows access to the functions and methods that

› Verified 2 days ago

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

› Get more:  How To UseGo Now

How yo check if Serial Port ( COM 1) working

Details: RE: How yo check if Serial Port ( COM 1) working. edfair (TechnicalUser) 29 Jun 11 13:04. You basically short pins 2&3 on the serial port connection then pull up hyperterm, tell it to use the port and anything you type should show up on the screen. That covers the transmit and receive.

› Verified 1 days ago

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

› Get more:  How To UseGo Now

How to split a PDF into pages using VBA

Details: 25 Mar 09 10:12. hi all, Im stumped with a problem. I have a PDF file and I need to split this into individual pages I would normally do this manually but I have thousands per month and so I want to automate this process. I am an expert in excel vba but this has baffled me as i cant seem to find any activex dll's which have this

› Verified 1 days ago

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

› Get more:  How To UseGo Now

How to make robocopy maxage to check date Created not Date

Details: 12 Oct 04 03:42. I'm running an incremental file system backup using a Robocopy MAXAGE switch as a starting date for increment. I have bumped into a following problem: If a file was Modified say on the 1st of October, but copied to a directory that is being backed up on the 10th of October, Robocopy with MAXAGE:20041005 would skip the file, but

› Verified Just Now

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

› Get more:  How To UseGo Now

Password Character InputBox (hiding text in a vba inputbox

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=4617 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 remove commas from a number

Details: Phone numbers on my report (Crystal Reports 8.5) come out as: xxx,xxx,xxxx (number field) I want to change the format so they would be displayed as: (xxx) xxx-xxxx. I am using the Picture and ToText functions to create a new field with the right format in the field Editor. However, what I have not been able to figure out is how to first remove

› Verified Just Now

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

› Get more:  How To UseGo Now

How and where to enable JIT Debugging

Details: jitDebugging value set in the system.windows.forms section. The application must also be compiled with debugging. enabled. For example: <configuration>. <system.windows.forms jitDebugging="true" />. </configuration>. When JIT debugging is enabled, any unhandled exception.

› Verified 1 days ago

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

› Get more:  How To UseGo Now

How to code in VBA a HTML body of email, fonts, hyperlinks

Details: I am building emails in VBA and would like to define the overall font for the body of the email. I would also provide text that would actually be a hyperlink, such as: go to this our SharePoint site and it would go to that site, or People names that would be a <mailto> link. I currently have the text formatted in a .oft outlook html template but when it displays no formatting is maintained.

› Verified 1 days ago

› Url: https://www.tek-tips.com/viewthread.cfm?qid=1789919 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. Thanks again folks, Neil.

› Verified Just Now

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

› Get more:  How To UseGo Now

Simple "Where date less than today" query

Details: Simple "Where date less than today" query. JohnOB (TechnicalUser) (OP) 5 Sep 07 05:46. I want to write a simple query but am just a learner, and am struggling with what I think is the curdate function. I want to return values where a date field is less then todays date. I currently have.

› Verified 1 days ago

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

› Get more:  How To UseGo Now

How to create folder with VBA

Details: Bill, I didn't mean to step on your (or anybody's) toes. A preference is a just a preference, with its pros and cons. I have nothing against FSO and it does its job just fine when Windows Scripting Host is enabled. But some users disable it, because of virus threat, and the FSO is then just dead meat-CreateObject fails.

› Verified Just Now

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

› Get more:  How To UseGo Now

How to get COM+ Appliacation DLLHOST PID

Details: I'm having the same problem. I'm trying to get the process ID for a COM+ Application. The ApplicationInstances opbject is only available with COM+ 1.5, which means only Windows XP or Server 2003, but Component Services in Win2K somehow gets the process ID anyway.

› Verified Just Now

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

› Get more:  How To UseGo Now

Using "Contains" in a Formula

Details: So yes, there are several ways, now post the intent. If you only want rows returned to the report that match the text, use Report->Selection Formulas->Record: {table.field} like "your text". btw, all of these work with either version. -k. RE: Using "Contains" in …

› Verified 1 days ago

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

› Get more:  How To UseGo Now

How to get the IP address using VBA

Details: Does anyone know how to get the IP address of a computer using VBA ? I made log table, I have the back-end database on a server, and a few front-end files in the office, and i want to log all the users who access the back-end. I used the Environ function, it provides me the computer name / user name and anything else i need, but it doesn't show

› Verified Just Now

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

› Get more:  How To UseGo Now

How to fix the size of the form

Details: hi , i was wondering if some one could help me in fixing the size of the form. what i want to do is that when the form is opened it should be of the desired size and people should not be able to change the size of the form. thanks. Replies continue below.

› Verified Just Now

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

› Get more:  How To UseGo Now

How to display general field on form

Details: RE: How to display general field on form. keepingbusy (Programmer) 24 Jun 12 18:06. And to overcome the issue where a path to an image or the image itself has spaces betweens the words for example: c:\my folder\my images\test image 3.jpg. If it helps anyone, here is the code I placed in a command button on my form:

› Verified 1 days ago

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

› Get more:  How To UseGo Now

How to Export Date Field to CSV without TIME Being

Details: Hi I have a table with a date field that defaults to DATE() for each new record. When I export this file to CSV format, the date becomes [b]5/9/2006 00:00:00[/b

› Verified 1 days ago

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

› Get more:  How To UseGo Now

how to set time on Option 11C

Details: To set the time: STAD dd mm yyyy HH MM SS. Then to print out the time to make sure it worked: TTAD. David. RE: how to set time on Option 11C. johnpoole (Programmer) 8 Sep 04 14:57. look at load 2 in the software i/o guide book one of three, not only are the prompts for setting time their, so is a command for adjusting the clock x number of min

› Verified Just Now

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

› Get more:  GuideGo Now

Excel: How to Access closed workbook Cell Value(s)

Details: I need some help on how to create an Excel function that will allow me to check for the value of a Dynamically determined NameRange (Day1, Day2.. etc) on a CLOSED workbook/worksheet.

› Verified Just Now

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

› Get more:  How To UseGo Now

Printing "Snake" Columns in Excel

Details: Zathras This macro makes 3 columns but the sorting is off. There are 1053 items. When the macro runs, the first column contains items 1-40, 121-160, 241-280, etc., the second column contains items 41-80, 161-200, 281-320, etc.

› Verified 1 days ago

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

› Get more:  How To UseGo Now

Whatsapp automation with VFP

Details: Dear All, Here is an attempt to send text messages,images,contents to whatsapp. No need of any third party dll etc. I have tested all method before uploading. A

› Verified 1 days ago

› Url: https://www.tek-tips.com/viewthread.cfm?qid=1807354 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 get Sequence names from the DB2 database.

Details: Hi, How to retrieve the sequence names from the db2 database. It is retrieved by use of tables like USER_SEQUENCE and ALL_SEQUENCES in case of oracle. How it is

› Verified Just Now

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

› Get more:  How To UseGo Now

Reset Password (IPECS LG-Ericsson Telephony System

Details: Version: iPECS-MG / GS55M-1.7Cd OCT / 11. I have tried the following procedure to reset the maintenance password: I connect via serial port to the telephone system using Putty Software with 115200 bauds, 8 data bits, no parity, no flow control. The Screen Output is: iPECS-MG MPB100 System. Version iPECS-MG / GS55M-1.7Cd OCT / 11.

› Verified 1 days ago

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

› Get more:  How To UseGo Now

How to get value from combo box in Excel

Details: Hi - hopefully this should be a quick one: I have one Combo box (chosen from the Form toolbox) in my excel spreadsheet - all I want to be able to do is get the value chosen from the combo box by using the formula/Function area (not having to use the likes of Index, Offset etc) something like:

› Verified 1 days ago

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

› Get more:  How To UseGo Now

How to convert Float to Integer

Details: MVPs. How to convert Float to Integer?! How to convert Float to Integer?! yili (Programmer) (OP) 29 Aug 01 15:15. coulad any body help me?! I want to use "mod" to find a remainder from a Float, however, it only works under integer!!!

› Verified Just Now

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

› Get more:  How To UseGo Now

I need to subtract one day from current date in DB2

Details: I need to subtract one day from current date in DB2. jorame (Programmer) (OP) 22 Mar 12 17:09. Hello, I have this query in DB2. SELECT * FROM DTINBS WHERE DTDCR = DAYS (CURRENT_DATE) - 1. The format for the where clause should be in YYYYMMDD for it work properly. If I change this query this.

› Verified 1 days ago

› Url: https://www.tek-tips.com/viewthread.cfm?qid=1678619 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 find duplicates in two arrays

Details: The quickest way is to use two "for" loops. Another approach would be to concatentate the two arrays, sort the new array, then delete all items that have duplicates. There are a couple other ways to go at this problem, but Dan's would probably be what I tried first, though it will be slow if the arrays are real large.

› Verified 1 days ago

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

› Get more:  How To UseGo Now

How to use FindComponent

Details: Awarnica says this: Obj := FindComponent (temp.Name); E := TEdit (Obj); I would still think that once you make temp a TObject, you lose the text property, and the value that it holds. I would be suprised if it retained the text value after you had cast it as TObject. I tested this, and it seems to work: E := (FindComponent (temp.Name) as TEdit);

› Verified Just Now

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

› Get more:  How To UseGo Now

Visual FoxPro 9 in Windows 10

Details: In the Windows 10 computer, VFP 9 is installed in the folder C:\Program files (x86)\Microsoft Visual FoxPro 9. In my projects all referenced to classes, icons, etc are to folder C:\Microsoft Visual FoxPro 9, so, in the Windows 10 computer I have to inform the new location, as VPF asks when I open an existing project.

› Verified 1 days ago

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

› Get more:  How To UseGo Now

Convert ResultSet into List/ArrayList/

Details: From the way the errors read it is a result of the aggregation going on in the DB to create the tabbed format. RE: Convert ResultSet into List/ArrayList/? sedj (Programmer) 30 Jan 06 13:51. The Sun JdbcOdbcDriver is not very good, and even Sun says it …

› Verified 1 days ago

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

› Get more:  How To UseGo Now

FILL BLANK FIELDS WITH "0"

Details: The blank fields already exist. I'm just trying to input a zero in a blank field. I tried the following: IIf (IsNull ( [HRSENTER]! [MONTH_1]),0, [HRSENTER]! [MONTH_1]) But this should have worked but it doesn't. Is there a way to tell it to go to each empty cell or field and input a zero in each empty cell or field.

› Verified Just Now

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

› Get more:  How To UseGo Now

How to shift entire schedule

Details: Display the Analysis toolbar; click on "Adjust Dates" button; enter the new start date for the project. The function will maintain existing Constraints and adjust them appropriatel and it will obey any special workdays/nonworkdays that you have put into your project calendar. RE: How to shift entire schedule. whitsend (MIS) (OP) 11 Aug 08 09:15.

› Verified 1 days ago

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

› Get more:  How To UseGo Now

How to convert a char* to a LPSTR

Details: rhpingwoo (Programmer) (OP) 11 Mar 03 19:32. Hello, Does anybody know how to convert a varaiable with type char*. to a type "LPSTR"??? Thanks, raph. Replies continue below.

› Verified Just Now

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

› Get more:  How To UseGo Now

Read contents of CSV file and use in VBS

Details: Read contents of CSV file and use in VBS. TheLad (TechnicalUser) (OP) 16 May 06 11:20. Guys. I am trying to automate the creation of local users on local servers (they are workgroup 2003 servers, not in AD) and I have written a script to create the user and do all of the necessary tasks as far as that is concerned.

› Verified 1 days ago

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

› Get more:  How To UseGo Now

VBS script to open any file in a folder.

Details: The script works great but I want to be able to open any file that is in the folder without having to give the exact name of the file. Here is the script: Const ForReading = 1. Const ForWriting = 2. Set objFSO = CreateObject ("Scripting.FileSystemObject") Set objFile = objFSO.OpenTextFile ("C:\temp\test.txt", ForReading) strText = objFil.ReadAll.

› Verified 1 days ago

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

› Get more:  How To UseGo Now

Convert string to datetime in crystal reports

Details: Hi all, I am working on a report that retrieve information from a database. In that database, the datetime is stored as a string. Is there any possible way I …

› Verified 1 days ago

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

› Get more:  How To UseGo Now

Related topics