Answer Questions

• drinkwater Access 2003 Long Binary Data

  In Access 2003, I have a table that contains a field of OLEObject. If I open the table, of course I see Long binary data displayed. I am trying to write some code that would allow me to take the entire table and fields and place them into an excel worksheet or in a form within Access and display the contents of the fieilds (recordset), but I do not know how to convert the long binary data to a readable source, loop through the records and then have them written to another source (preferably an access form or report). Any help would be appreciated ...Show All

• thatonedude Business Scorecard Manager / Firefox

  We just setup Business Scorecard Manager with Sharepoint and are going to be deploying those scorecards to a diverse user pool who will be using all kinds of browsers, IE and Firefox being the main two that are supported. The problem is, the HTML (and I imagine CSS) that BSM generates is almost undecipherable when rendered (the numbers are all over the scorecard instead of in the columns where they need to be). Is there any way to cleanup the HTML BSM generates or is there some kind of fix for this. BSM is a very handy tool but I'm not sure we can adopt it in the long run if it doesn't support more than IE (IE is my browser of choice but as a developer I have to be cognizant of all our users, most of which we can't control the browser t ...Show All

• jcsam MS Access User Defined Permissions

  Hi there - im building a contact management system and require some help with coding. I have a table (tblusers) for users that contains their information e.g. user name , password and tick boxes that will hopefully allow them to edit certain levels within the hierarchy of the system e.g 'allowcompanyedit' tick box will allow users with that box ticked to create and edit company information, 'allowcontactedit' tickbox will allow users with that bx ticked to create and edit contact information etc etc. I have created a user login screen and added code to a command button that checks their credentials against what is held in the users table to see if they should be allowed to log in or not. I would like to add additional code that will also ...Show All

• esharpcoder Running a macro if new mail if from a specific address

  Hello, I'm currently trying to write a macro that is run when new mail is received in Outlook 2002 (possibly XP not sure though) I would like the macro to check if the new email is from a specific address (in this case sales@falcontrunking.co.uk ), delete the email, and display a message saying "There is a new message in the Sales Inbox". I know how to run a macro when a new message is received and I know how to show a message box saying "There is a new message in the Sales Inbox" but I don't know how to check if the new message has been received from a specific address. Can anyone help me Sorry. I'm running Outlook 2003 here, and I shouldn't have assumed that the NewMailE ...Show All

• Randude Data from multiple listbox(s) to one array

  Hello looking for a quick way to loop through multiple listboxes contained on one userform and take all the data from each and add it to an array. Dim cCont As Control For Each cCont In Me.Controls If TypeName(cCont) = "ListBox" Then ' how do I loop through each list box and dump the data End If Next cCont I am new to this... Thanks Hi, Yip you should be able to do something like this... For Each cCont In Me.Controls If TypeName(cCont) = "ListBox" Then Dim lstBox as ListBox Set lstBox = cCont Dim iCount As Integer For iCount = 0 To Me.lstBox.ListCount - 1 MsgBox Me.lstBox.List(iCount, 0) Next End If Next cCont Tha ...Show All

• prawin Scorecard & Sharepoint

  Can anyone help!!!! After deploying scorecards to sharepoint, most users when trying to view the scorecard webpart get the following error: Web Part Error: A Web Part or Web Form Control on this Web Part Page cannot be displayed or imported because it is not registered on this site as safe. In fact the only users to be able to view the scorecards are the two accounts used in the creation of the scorecard - almost everyone else gets the above message. To make this problem even more confusing some of the users can view the scorecard. After reviewing two users with the same domain & sharepoint rights one of which can view them the other can't - absolutely no consistancy - so making this a dam hard issue to figure out. I ha ...Show All

• LittleSettler CRM 3.0 doesn’t save my settings

  Hi, I’m having another problem in CRM 3.0. When I change any setting in the CRM system, everytime that I clicked in the OK button it should save my new settings and that’s not happening. How can I solve this Thanks, Can you be more specific where you found the solution Per our support engineer: Would you please tell us where you changed the settings that were not saved There are lots of settings in CRM 3.0. So we need to know where is the problem. J Please provide the steps to reproduce this issue and I'll make sure that it gets back to the engineer. -brenda (ISV Buddy Team) Hi, The application pool is running with the account of the domain\administrator, because i had some pr ...Show All

• stallion_alpa Runtime Error: Supplied buffer doesn’t contain a valid OIID

  Hello VB developers, I am stuck at a Runtime Error in a module of VBA code :- This below code is basically connecting to source of data - Content Engine [object store] :- '\\ making a CE connection and pulling items whose CaseIDs match Set objRS = CreateObject("ADODB.Recordset") objRS.CursorLocation = adUseClient 'Case ID is 1 in the main select query { StrSQL } StrQuery = "SELECT [OIID],[Id] FROM [CustomObject] WHERE ([CaseID] = '" & Trim(adoRec(1).Value) & "')" objRS.Open StrQuery, objCN, adOpenStatic, adLockReadOnly '\\ Now, that we have Matched Case IDs - obtaining relevant info For intctr = 1 To adoRec.RecordCount Set objCust ...Show All

• MaggieChan Run Time Error 1004 On Long Running Stored Procedure

  I am encountering a "Run Time Error 1004" when I attempt to execute a stored procedure from within Excel VBA. The stored procedure takes about a minute to return results. I have tested with shorter running procedures successfully, so it must have something to do with the amount of time it takes to return results. The For loop is never executed because no results return. The error occurs on the last command where I attempt to set the column names in the spreadsheet equal to the column names from the recordset. Obviously errors because no recordset exists. As you can see I have set the timeout for the command to indefinite. I have also unsuccessfully tried a DoEvents after the command has been executed. Suggestions If ...Show All

• hte Updating a pivot table

  Hello, My name's Richie. I am trying to set up a macro which will update a pivot table automatically with given values. I have a pivot table containing several fields of information about our customers. Logically, one of the fields is Customer. On another tab, Customer list, I have a list of 5 customers. This list is not static i.e. the names change regularly. I want to run a macro that produces a report on these 5 customers. I need this macro to return the Customer name as per the names that are in the Customer list tab. In other words, the pivot table field Customer, is updated with the first customer name from this Customer list tab, the relevant values are returned & copied to a new sheet, then the pivot table is updated for ...Show All

• Ingenious MS Office document and image writer print driver

  Besides removing this feature from Office during setup, is there a process to remove this virtual printer from 300 users with roaming profiles on an active directory network We are having an issue with this printer assuming the "default printer" selection for our users. As a work around we have changed their default printer, but after they reboot or log off / on it has defaulted back to the MS Ofc doc and image writer printer. Hi to all! At me a problem with installation Microsoft Office Document Image Writer under Windows 64-edition SP1 with Office 2003 Pro full instalation. On a step 3 at me in the list is not present Document image printer writer port. Somebody faced a similar problem ...Show All

• michot Trying to write a VERY VERY simple routine BUT GOT STUCK !! ::) = Brain Ache !!

  Hi, I'm affraid I bit off more than I can chew and It's a while since I programmed. 1/ The routine is set in an open Excel worksheet which has 5 fields/columns per row 2/ The routine reads 1 row at a time, splits 1 field, does some ifs and appends 6 new fields per row 3/ I'm stuck with the Loop 4/ I'm stuck with the IFs especially bracketing 5/ I'm stuck with the output writes I'd really appreciate if you could just wiiiizzz through it and ellimate the mistakes. For you 5 mins for me 5 days. Here it is .... Sub TeamPerformance01() ' TeamPerformance01 ' Name Fields in open worksheet ActiveWorkbook.Names.Add Name:="Date", RefersToR1C1:="=Sheet1!C1" Columns("A:A").Select ActiveWorkbook.Names.Add Name:="T ...Show All

• Benin Count the number of records that show up in a Access form

  I need to count the number of records that show up in a Microsoft access form. The forms record source is defined dynamically in vb using a select query. I need to know how to count the number of records that show up in a form. Open the results of your select query as a recordset. Then move to the last record in the recordset, and get the RecordSet.RecordCount property. Does this work How do I do that ...Show All

• Zubair Masoodi FORMAT OF A VARIABLE USED IN VBA MACRO PROBLEM

  The value in C1 below is a date, e.g. 12/1/06. The date changes monthly. The cell C1 is formatted as Dec - 06 whcih is what I want. However, I need the Dec - 06 to be used in the name of the file noted here as "date1". The problem - date1 needs to be in the "Dec - 06" format but is in "12/1/06" format. How do I get the value of date1 to be exactly what I see in the cell of the spreadsheet Dim strDate1 As String date1 = Range("C1").Select date1 = ActiveCell Range("A1:E60").Select Selection.Copy Range("A1").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Application.CutCopyMode = False Range(" ...Show All

• Thibaud Copying formulas From a Range of cells

  Using VBA i have to copy formula to a cell from another worksheet. The worksheet will have columns containg values like CONCATENATE("OA"," + ID + ",LEFT(RC4,4))where ID is a variable following is the code i am using. Dim Str1 as String str1 = "=" + Sheets("Sheet1").Cells(1, 5).value Sheets("Sheet2") .Cells(1,5).FormulaR1C1 = str1 The value of ID is not substituted with actual variable value, but if i hardcode the formula like Sheets("Sheet2") .Cells(1,5).FormulaR1C1 = "=CONCATENATE(""OA""," + ID + ",LEFT(RC4,4))" things work. Is there any way where i can store the formula in a variable and still get proper results. ...Show All