Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ohmbru2
  • Content: Threads
  • Order by date
  1. ohmbru2

    Repeating Table - Spacing Between Records

    SharePoint 2010 w/ InfoPath I have created a repeating table which appears on my form. The records returned are correct. My issue is the format. There is a large gap between records in the list that appear on my form: Record 1 Record 2 Record 3 The desired result is: Record 1...
  2. ohmbru2

    Return to Home Page After Workflow

    I have a workflow that is triggered upon entry of a new list item. I want to jump to the home page after the item is added. Is coding required to accomplish this?
  3. ohmbru2

    Shared Documents Suddenly Misssing

    I set up several PDF and Excel documents in My Site. Suddenly the documents are gone. The shortcut was no longer recognized. Did the administrator move my data? Has anyone experienced this?
  4. ohmbru2

    Parallel Cable Adapter

    I'm going to purchase a new computer soon. I intend to keep my laser printer which uses a parallel cable. The new PC will not have a port for this so I need to get a cable adapter to USB. I've found these online but the reviews indicate that customers are not always sold the correct one (or...
  5. ohmbru2

    DVD Writer - Disks not initializing

    Win XP Home, SP2 I'm using Pinnacle Studio Ver 10 to burn DVDs on LG DVD Writer. I have had it for a couple of years and burned many DVDs. I burned 2 yesterday. Today the Pinnacle Studio will not recognize that there is a blank disk in the drive. Install disks spin up in the the LG and it...
  6. ohmbru2

    RAM Upgrade

    I have Gateway PC with Windows XP. I want to upgrade my RAM currently has a 256 in the first slot. The second slot is empty. If I purchase 1 GB RAM would I get better performance if I replace the 256 stick in the first slot or just add the new RAM in the second slot?
  7. ohmbru2

    PasteSpecial Macro

    I have a macro in Excel that creates a Word object, then creates and executes a macro in Word. The Word macro simply pastes the contents of the clipboard (that was copied as part of the Excel macro) as a wdPasteMetafilePicture. All is well until this is executed on laptops. It seems that...
  8. ohmbru2

    List Database, Tables, and Fields

    Is there a way to query the entire server to return a list like: Database1 Table1 Field1 Database1 Table1 Field2 Database1 Table1 Field3 Database1 Table2 Field1 Database1 Table2 Field2 Database2 Table1 Field1 Database2 Table1 Field2 ...
  9. ohmbru2

    Return Value from table

    I'm trying to retrieve a value from a table from an ActiveX Script Task. The code errors on the msgbox line. I'm not sure why. Any help is greatly appreciated. Dim strSQL Dim strResult Dim conn Dim dsn Set conn = CreateObject("ADODB.Connection") dsn = =...
  10. ohmbru2

    Run-time error 2113

    I made some changes to a form module. Since I was going to repeat the steps I wanted to put it into a regular module, then call it from the form(s). Part of the code sets values on another form: Me!Field1 = Forms!MyForm!Field1 Me!Field2 = Forms!MyForm!Field2 ... When I moved it to a...
  11. ohmbru2

    Add a record to Access Table from Word

    I'm trying to populate an access table from Word. I have a custom button in a Word document. It does some tasks, but I want to capture some info in an Access table as part of the process. I only need to add one record, then do the other tasks. I need help with code to open the DB, open the...
  12. ohmbru2

    Run MS Access in the background

    I have a script that executes some tasks in an Access database (.mdb). Can I run Access in the background with a script?
  13. ohmbru2

    Goto Control on subform

    I'm trying to set the focus to a control on a subform, which is on a tab control. Do I need to reference the tab control? The current focus is on another subform in the same tab control. I have tried this, but get an error: DoCmd.GoToControl "Forms![MainForm]![SubForm].Form![ControlName]"...
  14. ohmbru2

    Return Max of field in recordset

    I need help with this code: Set db = CurrentDb() query = "SELECT max(tblLicensingNotes.notesid) FROM tblLicensingNotes" Set rs = db.OpenRecordset(query) intNotesID = rs![NotesID].Value + 1 It errors on teh last line: Object variable or With block variable not set (Error 91)
  15. ohmbru2

    Find record on a form

    I've searched this forum (and the Access Forms forum) and found some help, but the code I came up with doesn't work. I'm trying to display a record on a form based on the value of a field on a different form. Sometimes this did take me to the correct record, but I haven't figured out why. For...
  16. ohmbru2

    Invalid Use of Null

    I get the "Invalid Use of Null" error, but I don't understand where the null is comming from. The BeginDate and Enddate evaluate to valid dates. Public Function Test(BeginDate As Date, EndDate As Date) Dim BusDays As Integer BusDays = DSum("[BusinessCalendar!BType]"...
  17. ohmbru2

    Get SQL result via ActiveX Script

    Can ActiveXScript return a value from a SQL select statment such as a records count? If so, how can I do this?
  18. ohmbru2

    Merge data and Time fields

    I have a DTS package where there is a Date and a Time (separate fields). I want to create 1 field out of them and continue to transform them separarely. I've tried to concatenate them, like this: DTSDestination("swdatetime") = DTSSource("Col002")) & DTSSource("Col003") That didn't work so I...
  19. ohmbru2

    Determine File Size

    I'm trying to determine the file size. Can anyone push me in the right direction? This is from a DTS Package. '********************************************************************** ' Visual Basic ActiveX Script '************************************************************************...
  20. ohmbru2

    DTSSource error

    Can anyone tell me what I'm missing here. I'm getting the error message, "Invalid procedure call or argument: 'DTSSource'" DTSDestination("PIEKey") = right(DTSSource("TransferDate"),1) + DTSSource("Policy2")

Part and Inventory Search

Back
Top