• Late Bound Listview in Access

    Not sure if this will make sense, but here goes: I have several forms built which include listview controls on them. I am currently using early binding to manipulate them, but one of my user's workstations is having an issue reading the ref lib. I'm assuming there is a program on that system that...

    McNitro255 pointsBadges:
  • VBA – Delete rows if they meet a certain criteria

    Hi, I am trying to write a code to delete rows that meet a certain criteria. I have a large amount of data in a spreasheet and all of the columns contain different metrics. I want the code to go through all of the rows and delete the rows that have a number in column H that is between - .3 and +...

    Sumcap5 pointsBadges:
  • Windows XP Word 2003 with macros takes a minute to open

    I have win xp. The problem with word 2003 usually starts occuring in couple of months of flowless operation. Then for whatever reason, word starts taking more then 1 minute to open. I know it has to do with macros, because if I remove word template files from c:Program FilesMicrosoft...

    Levinmik5 pointsBadges:
  • Passing a form to subroutine in Access 2003 (VBA)

    I have a function that recieves references to 2 forms and 2 controls. The sub looks like this Public Sub Not_In_List_Starting_Handler(vNewData as string,Not_in_list_form As Form, List_control As Control, Lookup_Form As Form, Lookup_Control As Control) when I try to call it from the form I get all...

    Nainey5 pointsBadges:
  • Order column in pivote table from vba

    I need help to make this, i try with PT4.PivotFields("Category").AutoSort xlDescending, "Ventas" but not sorting. Please helpme,          With ActiveSheet.PivotTables("PivotTable5").PivotFields("Ventas")        .Orientation = xlDataField        .Position = 1       ...

    Emoraleshn5 pointsBadges:
  • Download AS400 Physical File to Excel Using VBA

    I am in the process of developing an Access database with the intention of using it to control the download of AS/400 physical files into Excel. I am fine developing the Access / Excel side of the data, however I ahve no experience with the AS/400 side of things. The access database will contain...

    Martyjw5 pointsBadges:
  • VAB macro that iterates through all bookmarks in a word document with exception and allows user to change the value of the bookmark via input box

    A VBA macro that will work in MS Word 2003 and MS Word 2010 that will do the following:

    Astakeil35 pointsBadges:
  • VBA/VB code to edit hyperlinks in PDF files

    Hi, How do we read the content in a pdf file. I have some sample pdf where I have to edit already existing hyperlinks . Thanks in advance.

    Iamfromhyd20 pointsBadges:
  • VBA copying a range from Excel and pasting to a text file

    Do you know how to copy from excel and paste to a text file using VBA?

    TBone555 pointsBadges:
  • how to create autonumber

    while press enter on cell (b1) the cell (a1)= 1 while press enter on cell (b2) the cell (a2)= 2 and so on i tried functions : =row() and =OFFSET(A2,-1,0)+1 i don't think its an autonumber because i used manualy so, hlp pls

    Army125 pointsBadges:
  • Access 2007: VB code to make a button press link to a specific record in another form

    The database is for a set of components. One of my forms shows details about each component on a separate record (the property "Default View" is Single Form). The other form is a list of all components by component number displayed all together (the property "Default View" is Continuous Forms). The...

    VinDibo5 pointsBadges:
  • PDF save as TXT file (VBA)

    HI EXPERTS PLEASE SOLVE IT I WANT TO SAVE AS TXT FILE FROM PDF FILE THROUGH VBA (XLS) CODING; I WANT TO GET THE DATAs AS TEXT MODE FROM A SPECIFIC PDF FILE IN EXCEL SHEET PLEASE ANSWER IT ANANDA DEBNATH DELHI, INDIA

    AnandaDebnath280 pointsBadges:
  • Printer Orientation Control using VBA Code

    I want to print excel UserForms automatically using VBA proceedures.Some should print in Portrait and others in Landscape. How can I control the printer page orientation from VBA code?

    KingsITI50 pointsBadges:
  • “Automation Error Invalid Advise Tags” What is an advise tag?

    I have a visual basic module within Access that seems to compile fine; when I select the Debug function in the visual basic editor, I receive no errors or messages.  However, within my Access form, when I try to click the button associated with this module, I receive the error message, "Automation...

    Siggy5 pointsBadges:
  • DoCmd.OpenReport not working right with WHERE clause

    I have looked all over and seen hundreds of questions about this command, but no answers. It seems like the most basic thing you can do with combo boxes, so I'm baffled that it doesn't work. Here is my VBA Code: Option Compare Database Private Sub cboFundNumbers_AfterUpdate() Const strFormName As...

    Pubfin15 pointsBadges:
  • How do you change user password for a separate Access database than you are working in?

    I've built a database (Production) with user level security on it.  I also have built a smaller database (Login) so I don't have to use Access' login.  I'm trying to figure out if there is a way to change the user password in the Production database FROM the Login database.  I've been working...

    McNitro255 pointsBadges:
  • Dir() Function doesn’t find .pdf files in Access 2003

    I've used the Dir() function with VBA several times for different file formats, but for some reason it's not working on .pdf files. Am I missing something?

    McNitro255 pointsBadges:
  • Unlocking VBA project using VBA code

    Can i use vba code to unlock my x-cel vba project protected by password? I need to unprotect my project to add some code and then reprotect it.

    Yves69520 pointsBadges:
  • VBA to separate overlapping times

    I am stuck trying to seperate overlapping times. The situation is that I have 5 devices requiring x amount of material at the differing durations. What I need to do is seperate the durations and add the demands together for the new duration, but there can be as many as 5 overlapping demands; here...

    Jace75 pointsBadges:
  • VBA Excel 2003 Copy and Paste

    I would like to know how am i going to copy a certain range (A1:E500) in File A and paste it in a different file (File B). Then copy a new range in other sheet of File A then paste it in File B without overlapping the data I copied from the first range. Thank you so much in advance!

    Eron09135 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following