Answer Questions

• Petru66 Open a new blank form from an existing populated form

  i know this sounds like a really easy thing to do but for some reason i cant do it - in a new system i am building i have a form where users enter their daily activities and they will need to be able to enter several days at a time. once they have filled in a days activity on the form i want them to be able to click on the 'new' command button and this will save the existing activity record to the database and then let them enter a new one. I dont care how this is done as long as it is transparent to the user - the only way i have been able to get it to work is to save the existing record, close the form and then open it up again as a new record but the user obviously sees this happen, which i dont want (see code below). DoCmd.RunComman ...Show All

• pratyusha kothi Exporting variables

  Hi. I need to use a result from a variable of another sub (sometimes from an another module).  I tried using an analogy of userforms method i.e. On userform2: MyVariable= userform1.textbox1.value (That's OK) but on sub2 (where MyFirstVariable exists and it have been already calculated): MySecondVariable=sub1.MyFirstVariable (Wrong!) this doesn't work on sub's so How can I use variable result from sub 1 on sub 2 (without linking result with a worksheet cell). Thx! Hi If I understand your question correctly you want to use a variable from one sub routine in another. The best approach would be to pass the variable as a parameter. Eg the below takes a variable from Sub1, and Sub2 prints it to the immediate w ...Show All

• fdc2005 String parsing in Express VB

  New to VB. Simply trying to parse the zip code out of a string and placing the zip code into a new string. Looking at the Split method, but unable to get code working w/o errors. Sample string I am trying to parse is: 'Bakersfield,A CAA 93309 Any suggestions on the code snippet to remove the zip out of this string Thanks in advance. CT Thank you for the quick response. I just figured out that I am actually inside the VBA 6.3 IDE launched from Excel. It seems the variable declaration is not as advanced in VBA as VB Express edition. Would you know how to do this string extraction inside VBA 6.3 using a module This way I am already 'inside' my Excel worksheet. Thanks CT ...Show All

• kampak1111 subscript out of range

  I am getting an error when running the script Do While (Not (Workbooks(bookmonth).Worksheets("by associate").Cells(4, i) = "dsl") Or Not (Workbooks(bookmonth).Worksheets("by associate").Cells(4, i) = "hsi")) I am uncertain why this is coming up. i is currently set to 1, so it should be starting to search in cell a1. Is the type mismatch on that same line of code thank you, there was an error in my code and it was not populating bookmonth correctly, however, I am now getting a type mismatch. How do I correct for this I can not see anything wrong with the code that would produce a type mismatch on that line. Any value contained in the cell A4 would be compared to the two st ...Show All

• Mark064 opc

  I am trying to develop an opc - da client using .net technology. Have gone through the documents on opc and opc client and all, but am still not sure how to implement it, can someone give me a direction on how to start with it Hi Eric, Sounds like you know what you're talking about ... Can I also butter you up and find out if you know anything about using an OPC interface in VB.NET that was designed for VB6. The problem is the RSiOPCAuto.dll that Rockwell use to interface to their OPC server (RSlinx). It only accepts Arrays with lower bounds of 1 which is not possible in VB.NET. (see refs below) 1) http://www.control.com/1026218609/index_html 2) http://www.control.com/1026222355/index_html I ...Show All

• SonAsylum Help with Excel VBA Code

  I am trying to format different spreadsheets. I need the data to be in the same cells for each worksheet. This data is in column A. I need to check to see if DBCS# ( ) is above Tour, and if so insert rows until Tour is in row 175, column A. The problem is that the number after DBCS# is never the same. How can I use an IF statement to make sure that the cell above Tour says DBCS# (whatever the number is) This is the If statement that I tried. If I put DBCS#46 in my IF statement, it will not work because the number after # isn't always 46. If (Range("A174:A174") = "DBCS#") And (Range("A175:A175") = "TOUR") Then GoTo label_177: Else: Do While (Range("A174:A174") <> "DBCS#") And (Range("A175:A175") <> "TOUR") Select ...Show All

• Little_Dice On Error not catching problem with a web query

  Why does "On Error" not seem to work in this case Once every few hundred iterations, there will be a failure, timeout, or resource not available error on the last line which invokes .Refresh BackgroundQuery:=False. Any insights would be much appreciated. Regards, Brian code excerpt........................... On Error GoTo query3error With ActiveSheet.QueryTables.Add(Connection:= _ "URL;http://finance.yahoo.com/q s=" & ticker, Destination:=Range("A1")) .Name = "q s=" & ticker .FieldNames = True .RowNumbers = False .FillAdjacentFormulas = False .PreserveFormatting = True .RefreshOnFileOpen = False .BackgroundQuery = False ' ...Show All

• udayan Configuration Failed

  Configuration Failed One or more configuration settings failed. Completed configuration settings will not be rolled back. Resolve the problem and run this configuration wizard again. The following contains detailed information about the failure: Failed to initialize SharePoint Products and Technologies upgrade. An exception of type System.Collections.Generic.KeyNotFoundException was thrown.Additional Information The given key was not present in the dictionary Plz Help One or more configuration settings failed. Completed configuration settings will not be rolled back. Resolve the problem and run this configuration wizard again. The following contains detailed information about the failure: Failed to initialize SharePo ...Show All

• Henry Ong Highlighting cells within a worksheet

  Several of us in our office have a fantasy golf league and we administrate it off-line using an excel spreadsheet (we haven't found a free website that lets us tailor the rules to the way we like it.) Anyway, it is a salary cap format, meaning that only one golfer can be on one team at a time. To keep track of this, one of our worksheets has a list of all the golfers. That same worksheet also has every team's roster. For all golfers that are on someone's roster, I manually highlight that same name in the master list of golfers so it is easy to see who is taken and who is available. What I'd like to be able to do is have it automatically highlight that golfer's name in the master list when it appears in the individual team roster's page (an ...Show All

• John Paul Cook How do I...

  select the next row down at the end of my macro. I tried to do this recording a macro using the down arrow and it did not work. Any help is greatly appreciated. Thanks, I added the activecell.select and it works fine now. This will save me a LOT of time. Hello Sleeks, The selection.offset(1,0) needs to to have a bigger offset (ie the number of rows that are selected already) use the following lines: nbrRows = Selection.Rows.Count ' store the number of selected rows ActiveCell.Select ' select the first cell of the range Selection.Offset(nbrRows, 0).Select ' come down by that many rows Cheers Chas ...Show All

• kart Global Variable not Persisting

  Hi there, i seem to have hit a BIG problem! Im building a new system for users at work and the functionality of the system so far is good. However a lot of the functionality is based on permissions applied to the user after they have logged in - there is a global variable that stores every users login name 'loginname'. However at some point, (although not always) if the user is doing a lot of work in the system by entering activity, creating companies, contacts etc then they will receive a message stating 'Error 94: Invalid use of null' and when I go to debug it will highlight a line of code that inevitably depends on the 'loginname' global variable. I have a little text box that holds the loginname after the user has logged in and it will ...Show All

• FHJJr Referencing unregistered DLL

  Hi all, I've had kind help with part 1 of my problem somewhere else on the forum, but I think part 2 should be posed here. What I am trying to do is create a .dll-file (TestDLL) that contains a function (StartMe) initiating a form (frmMain) and then call that form from both an EXE-file and an Excel add-in. The DLL-file I created with VB 2005 could not be registered with Windows, so I could not call the function StartMe from within the EXE. As it turns out, I could simply include a reference to TestDLL in the EXE-file, telling it where to look for the function StartMe. Logical deduction would therefore tell me I should also include a reference to TestDLL in the VBA-code, telling that where to find StartMe. Is it possible to do ...Show All

• AndrewBadera Ideas for creating a subset of the string 'pathname' ?

  Hi all, I am working on a VB-Script that uses the pathname of a given set of files and extracts a subset of that pathname string only. This is the string I have: "H:\Images\2006\ 04_02 CanyonLands \converted\IMG12034.tif" And this is what I want (a subset of the string above: pathname) " 04_02 CanyonLands " I am a Photographer working with lots of pictures. My images are sorted by Year/Date/Event. The idea now is to copy a subset of the pathname to a specifc field called EVENT of my images database (iView Media Pro v3.1.). But this may not be so important as I have no problem putting the whole string of the pathname into the field EVENT. The problem is to extract the subset . Not only that, the pathna ...Show All

• N G Smith Missing values

  How do you handle missing values in excel vba e.g. i have a macro that creats a chart but sometimes values are missing inside the data series. how do you handle this is there any way of setting a general way of handling this in excel e.g. skip all missing values, set missing value = 0 thanks! You may have better luck getting an answer to this question in the Excel Programming Newsgroup ...Show All

• robinjam Once copied, can we export as a GIF file?

  How to convert MS Excel to jpg or gif and paste/insert to MS Word thank you very much     I had no idea we could copy a range and paste as a graphic... I do the chart gif thing all the time for userforms (load the .GIF in to an image frame or the background of multipage, etc.). Copying a range as graphic and saving is as GIF and then using the image would reduce so, so much code writing. I see many great uses for this!!! So --- once we copy the range, can we: 1) export as a graphic file and save to the hard drive (like we can with GIF export for the charts) 2) control the file fomat (aka - .GIF, .JPEG, etc) I did follow the link the gentleman's website and all his code sh ...Show All