Answer Questions

• CsharpDotnetDeveloper Accessing Tables in Access 2000 that are linked from an SQL Server using VB code

  Hello, I am not sure if I am posting to the correct forum, but here it goes: I am trying to create an Access 2000 application to pull data from a table that is linked to a SQL Server Database using VB code. However, I cannot seem to get it to work, as I keep getting type mismatches and object not defined errors. I would post my code, but I have made a complete mess of it. Would anyone be able to show me simple code to accomplish setting u ...Show All

• Russ Harding Help On Error GoTo

  Hi Everyone, I`m creating a Workbook that protect and unprotect the sheets... The part of protect and unprotect is ok! But, the part of tratament of errors I don't get to do... I want that when the workbook show the error, it go to Erro: Guys, This is a strange one as Thiago's code worked fine when I tried it. Perhaps error handling was previously turned off prior to calling the method, has the OnError Goto Next statement ...Show All

• OKCMAN Windows media files have changes to Nero

  Hi just wondering how I change my music files back to windows media player, they changed to nero flies last week after burning a CD. Hate the nero player, but love windows media player. Hope someone can help me Thanks Shihad P.S check out Shihad single    ALIVE   Thanks a million for explaining how to knock this on the head. What a relief! After installing Nero it pretty much hi-jacked my computer. I've h ...Show All

• asisurfer converting from VB 6 to VB.net

  Started by sal at 03-19-2005 9:27 PM. Topic has 1 replies. sal Joined on 03-18-2005 Posts 1 converting from VB 6 to VB.net I was wondering if i could get answer on what is the easiest and quickest way to convert the vb6 code to vb.net. I would like to keep using the forms, the grid and the structure for the time being. since i do not want to check the accuracy of my application at present ...Show All

• Dmitry Shevchenko help on list box (Access)

  Hi can anybody help me with my list box. I created a form in design mode in access I added a list which gives me a set of data I addes a second list which has to give me a set of data depending on the result of the first list. But there seems something wrong with the link thx Can you post some sample code that we can take a look at -brenda (ISV Buddy Team) I resolved th ...Show All

• chessmaster vba access updating a record

  Hi all Currently i have a form that using the following press button event it displays details from my DB: Private Sub cmd3_Click() Me.RecordSource = "qCountUserDir3" Me.Requery DoEvents mylbl.Caption = "Selected: " & cmd3.Caption lblSelected.Caption = "Selected: " & cmd3.Caption End Sub This works well the only thing though is that i want to be able to update 1 field when i double click o ...Show All

• MobilTech Programatically Changing Excel Default Delimiter in VB.NET

  Hi, Is there a way you change change the default delimiter used by Excel when saving the spreadsheet as csv file format in VB.net I change the default delimiter from "," to "|" in: >Custom Control > Regional and Language Option > Customize button > Numbers tab > List separator It only works if I save it manually. However, when I attempt to save the spreadsheet into CSV in vb.net, it revert ...Show All

• elf_sander extract office file's title into excel

  hi guys! I have a folder which included many office excel and word files. these files have a file properties as "QMS-DOCUMENT-NO", which is created by myself when I create the file. New file will be add into this folder frequently. two questions: 1. I want to creat a excel file consolides what i have in this folder. it shall shows the file "name", "Title", and "QMS-DOCUMENT-NO". is there an automa ...Show All

• yunjian 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. ...Show All

• njg Program code fro sorting coloumns in a listbox VB Excel

  Hi I have in my UserForm a listbox, where I capture the A2:G10 in Spreadsheet1 And my problem is that I want to manage to click on the column header (in the listbox of the userform) to sort the coloumns. I hope that someone pls can help me sort this out! tullaolsen;)   Hi Derek and Wassim, Thank you for your help! I have now managed to get a sorting code for the commando button. Thank you both! The ...Show All

• Johannes Hansen Applying one cell's formatting to another cell

  I'm looking for a way to apply the formatting from one cell (i.e. range object) to another cell without using: sourceRange .Copy targetRange .PasteSpecial < options > Application.CutCopyMode = False The implicit selection of the targetRange is slowing down my macro, and making the sheet scroll unnecessarily. Note: I've already included the hack Application.ScreenUpdating = False, but this seems less than elegant, IMHO ...Show All

• saleem145 Diasbling Security settings in Microsoft Excel

  Hi all My friend uses Visual Basic Application code embedded in a Excel Worksheet for his application. When the machine has the EXcel MAcro Security as 'High' (Tools--> Macro --> Security) the macro fails to get executed. How to turn off the security (make it Low) from Visual Basic / C# code. Thanks Shasur The right way to go about this would be to digitally sign the VB code. If it's an application that is going to be r ...Show All

• chiefmsb printing .doc, .xls, and .pdf files from a list of filenames using an excel vba macro

  Hello all! I'm Jim from Western NY. Forgive me if I have posted in the wrong forum. If I have, just let me know and I'll comply. Here's my question: I am wanting to develop a macro for excel which will read (from a worksheet) a list of hyperlinks to pdf, .doc, and .xls files and print them using the appropriate application ( acrobat, word, excel). Theoretically, I know I would have to use some kind of for-next and/or case s ...Show All

• Hatanet Please Help with Access 2003 and ActiveX Controls

  Hello everyone, I am having a major problem and I can not find a resonable answer any where, so I hope some one here can help me out. I have been working with Access 2000 for a long time and have always been able to Insert the ActiveX control "Microsoft Common Dialog control, version 6.0". I now have made the jump into Office 2003 and Access 2003 which when I try to Insert the ActiveX control "Microsoft COmmon Dialog control ...Show All

• BornToEnjoy Left Joins with Multiple Conditions in VBA

  Hello, I am trying to run a query in Excel VBA. The query has a left join with a two conditions -- every time I run it excel crashes. If I remove the brackets enclosing the two conditions, the query fails. The query itself is correct because if I run it directly in Oracle it works. Also I can run it thru excel via Date->Import External Data but not thru VBA. Also if I restrict myself to one condition instead of two it works thru VBA. Any one ...Show All