Answer Questions

• Val Savvateev Userform Controls

  I have created a data request form for the company in Excel. The form has quite a lot going on (e.g. frames, option buttons, tick boxes etc). I've created all the necessary code and event handlers so that the form behaves as it should. In an attempt to record the user's input, I've then gone on and written a bit of code, which executes when the user clicks OK after completing the form. This bit of code loops through each control on the form and, depending on the control type, writes its caption or value to a blank spreadsheet. The issue I'm having is the order in which it loops through the controls. The tab order for the whole form, including that within frames, is spot on, yet this bit of code loops through some of the controls in ...Show All

• Speedy2171 Adding a date from a specific cell into the DateAdd function

  Hi Been trying to implement this piece of code into my program and can't seem to get the following bit to work: Range(eeDispatchDate) = DateAdd("yyyy", 5, " ") & Range(SenorityDate).Value I basically want the date as from the senority date cell to be input to the function so i can add 5 years to it. I haven't changed the rest yet but will once i get this working. here is the full code below: Sub cmdEMP_email_Dispatch_date_Click() Dim AwardDue, eeDispatchDate, SenorityDate As String Dim x, z As Integer For x = 2 To Module1.GlobalCount AwardDue = "G" & x 'where G is Award due i.e. 5 yrs SenorityDate = "J" & x 'where J is Senority Date eeDispatchDate = "L&qu ...Show All

• Cassiopeiaxy [Access SQL]: Have a function similar Oracle SQL function Minus use in MS Access SQL?

  Caption the subject Many Thanks ...Show All

• steveareno VBA resources

  Hi All, As promised, I've compiled the " The “Everything We Could Find on Microsoft VBA” List ", which you can find among other VBA information on http://msdn.com/isv/technology/vba . -brenda (ISV Buddy Team) thanks man;) What a great resource! Thanks for sharing... ...Show All

• cbowman Select query returns non-existing data

  Hello everybody, I'm trying to match entries in a table up against each other based on a number of criteria (Quantity, Date). Three types of entries exist: Those from source 1, 2, and 3. I'm trying to match data from source 1 with data from source 2 and 3. Some is identical, some is not. In a VBA Script I first select every entry from source 1 (indicated by the field "Datasource"). I then run a While loop. For each entry I run a second select query on the fields I want to match (Quantity, Date). It works OK, ie. as expected, in some cases. In other cases, the quantity is completely off - it's as if Access just invents some random quantity instead of using the one from select query one (the one with source 1 data). What on Earth is w ...Show All

• rschalken Displaying Chinese Characters

  hi all... i'm trying to display chinese strings using the MsgBox...Instead only " " appear on the message box...can anyone help me regarding this issue... Thanks Manu Try the Chinese version Or generate a picture file for the Chinese characters and use it as the background lunaa ...Show All

• Avner Kashtan AutoExec will not execute properly

  Hello there I have an .dot file in the Word 2003 start-folder. When opening word, the file is read. The autoexec-macro should make a new entry with a number of commands and subcommands in the standard menubar. On about 300 PC's this works fine. On a few ones only part of the commands appear. All PC's run W2000 and Office 2003. Any idea regards Jurgen I order to help, i would need to see a bit more of the code you are using to create the menubar in question. (^_^; ) Hi the series of macros must run in Word, Excel and Powerpoint. Therefore individual start modules exist for the three applications calling then the common Sub initialise_program here is ...Show All

• jag108 Unable to create FileSystemObject in Access VBA

  I have encountered an error when trying to create a FileSystemObject. This code has been running fine for about a year and a half, but now on one system my user is recieving: I have the same problem. But with what appears to be several hundred reference libraries to choose from which one should i attemp to activate First thought that occurs to me is that the Reference to the Scripting library may be broken on that machine (perhaps it's not even installed ) Open the VB editor, view the project, go to Tools/References and see if it's still activated. Dim fso as Scripting. FileSystemObject set fso = new Scripting. FileSystemObject Also reference the MS Scritpin ...Show All

• ONEWORKNGRL Design Strategy Problem

  Hi All, I am struggling with an idea I had whilst developing a solution for my client, basically its a distrubuted system with a number of client applications connecting to a windows service and in turn, that service publishes data to an internet based web service. (using Remoting and Fusion) The idea was to automatically update the clients that are active/connected when ever data changes on a server in a background process and update any user interface that may display the information that has been changed by another user. I have the idea working in draft, but would like to know what the community thinks on this idea before I finalize the design. Basically, the solution provides a 'live' data environment. It does present me wi ...Show All

• suranga_d Password protecting to a command button in Excel?

  Hi Trying to set a password for a button i have on my user form. I want a popbox asking for password to display when the user clicks the button. I did try to use an If statement and setting a variable as my password but didn't seem to have any luck Any ideas Hello Derek, Thanks for continuing with helping Scott. If there is anything else I can provide please let me know. Regards Chas The paragraph in my previous post should read: had two textboxes because I wanted to check the Employee number AND password. For the password textbox you will have to set the PasswordChar to "*" or one of your choice so that the password is not seen as it ...Show All

• Dan Rooney I have a fairly simple macro writing question (in Word).

  I have used a mail merge to create labels of products with relevent pictures attached to each label. However I have to select all and update to get the images to appear once the merge has run and then the sizes all change to a very small size. I have made a macro to resize the images one at a time to 9% of the original, but I cant find out how to resize all the images (about 300 this time). Ideally I would like to resize them based on how many records were merged, but i suppose it would work if i just did a loop for a static amount. any ideas thanks Here you go. This will resize every image in the current document to 9% of its original size. Does this help Public Sub Main() Dim img As Word.InlineSha ...Show All

• DevDiver SendKeys from Excel

  I'm trying to send information to another application using the SendKeys function but it isn't working. The primary code that I'm using is: ActiveWorkbook.FollowHyperlink Address:=" http://www.aasb.com.au/public_docs/aasb_standards_2005/compilations/AASB101_07-04_COMP_11-05.pdf ", _ NewWindow:=True AppActivate "Microsoft Internet Explorer" Application.SendKeys "^F34.~", True. Sometimes I get an error on the AppActivate statement and sometimes the SendKeys function works but not all the time. Does anyone have any suggestions about what I'm doing wrong for it to not work all the time Hi lofe, Try adding a pause between the activating the application and sending the keys. AppActivate "Mic ...Show All

• Aquariun25 String Functions

  Does anyone know if there's a string function that removes new lines from a string (where return has been hit to start a new paragraph) It's kind of like the Trim functions I'm looking for, but these only work with trailing spaces, not where a new line has been started. Cheers! Keith nae bother big yin. :) Hey man, Try the Replace() function. Just replace all the vbCrLf in the string with "" and that will remove them. myString.Replace(Environment.NewLine.ToCharArray(), String .Empty.ToCharArray()) Cheers for that. My final solution below. Basically, it's a text box where it is possible for the user to hit return and begin a new par ...Show All

• QWERTYtech What is the difference between Excel Dates and VBA Dates ?

  Dear all, In this piece of Excel VBA code: Sub a() Dim Datim As Date Dim Outr As Range     Set Outr = Range("b2")     Datim = "17/03/2006 12:00"     Do         Outr.Value = Datim retry:         If Abs(Datim - Outr) > 0.0000001 Then             Debug.Assert False             Outr = Datim + 1             GoTo retry         End If         Datim = Datim + CDate("00:05:00")   &n ...Show All

• mew4ever23 What language was Microsoft Word developed in?

  Just out of curiosity, does any one know what language Microsoft Word was developed in Thanks, msv6 Hi, I'd say it was written in Visual C++ (MFC) but that's a guess. I'm saying that because Visual C++ (MFC) is very much geared towards the document/view architecture ala the Word Document and the Print Layout view. Cool. Thanks a bunch! ...Show All