• Creation of array for input of data

    Hi, I am using access 07. I have created an input form (forms.Base) with an input field of source_code. Below this there are options for other fields to be updated in a record set. There would be multiple entries in the source_code field, seperated by ';'. There would be a maximum number of 10...

    Rponsford15 pointsBadges:
  • format cell based on contents using VB

    i need to change the color of a cell in a specified column based on the value e,g if A1 value is between 1 and 10 then the colo will be red, if the value is between 11-20 then the color will be green etc. i used conditional formats but they only allow for 3 variables i need a script or other that...

    Voicetec15 pointsBadges:
  • VBA Copying rows where a range has the same value as another

    I have a problem where there is a large list of names in excel and a large number of other columns with data about them. One of the columns contains the section name they come under. There are 60+ different section names and these names change name a lot. I have been tasked with writing a piece of...

    Johnthepirate15 pointsBadges:
  • VBA – Mail Merge Automation via Access

    Hi, I'm not sure why my code is not working.. I have code in vba in Access 03 which opens a word document which runs a mail merge process. When the code runs, it asks me what the Header Delimiters are.  I specified those in the export file as a comma for a field delimiter and <enter> as the...

    JK012450 pointsBadges:
  • Need loop to cut rows that meet criteria and paste to another sheet.

    I want a loop that will look at the first four words in column A and if they match then the entire row should be cut and pasted to another sheet.

    Mdsc25 pointsBadges:
  • String Comparison VBA

    I have two columns of string values in excel. They are part numbers so they are typically 6 - 10 characters and a mix of letters and numbers. The columns contain many like strings. That is, the part number is listed in both columns. I need a quick way to compare each string in one column with every...

    RoyAdler5 pointsBadges:
  • Can any one correct this Microsoft Excel VBA code?

    ANY ONE CORRECT THIS Sub fill_series() Dim myrange As Range Set myrange = ActiveCell.Offset(0, 5) Range("N9").FormulaR1C1 = "Apr-2008" Range("N9").Select Selection.AutoFill Destination:=myrange, Type:=xlFillDefault End Sub

    Sa2915340 pointsBadges:
  • vba loop help

    i am trying to run a simple loop, paste code. i am new to excel vba and am trying to teach myself. here is what i want to do, take the numbers one through ten and paste them one at a time into x. it looks like this. 1       x 2 3 4 5 6 7 8 9 0 once i can do that then all of the other math is...

    Opie9715 pointsBadges:
  • Initiate Lotus Notes agent from VB/VBA

    We have a Lotus Notes database with a button to create a new document. The button runs some LotusScript and sets fields in the document. I would like to be able to "press the button" from VB/VBA

    Pprajapati5 pointsBadges:
  • Accessing an Access DB from Outlook via VBA

    Hi The situation: In Outlook I get a message from a server. The content of the message needs to be put into an Access db. But, there may not exist another message with the same date. So, I need to look into a db if there is already a message with the same date and time. If there exists one, then it...

    Camastanta50 pointsBadges:
  • Calculating OD from weight and/or metres in VBA

    Hi there, Have a problem trying to convert weight and/or metres to OD, I work in the flexible packaging industry coordinating all the trials for the UK & Europe. I can calculate from an exsisting OD to weight & Metres using the following VBA statement; RNEW = (PI * ((((NEWI(1) / 1000) / 2) ^ 2) -...

    Fugazi5 pointsBadges:
  • Issue with a sub procedure and its arguments.

    I'm trying to build a sub procedure to create a list for a combobox.  Basically, the db has sererate fields in the client table for first and last names and I want to create a combobox that lists each in one line. The real point of the question is whether or not I can build a sub procedure so I...

    McNitro255 pointsBadges:
  • VBA Looping In Access

    I have a report in Access which pulls from one table in an Access databse.  In the table there is one record for each "Region" and when I run my Access report it then creates one big pdf file containing a one page report for each region.  How can I write a peice of VBA code that will loop the...

    Keithman5 pointsBadges:
  • Trouble with Unload statement in VBA

    What am I missing? I have written code with an Unload Userform statement that doesn't seem to wipe out the Userform from memory. For Ex: (Default: CheckBox1.Value = False) MyForm.Show CheckBox1.Value = True Unload MyForm MyForm.Show So, the form is shown to the user, and they mark CheckBox1 so the...

    McNitro255 pointsBadges:
  • Issue viewing “additional controls” for toolbox in VBE

    I am unable to view the dialogue box when I select the "additional controls" option from the VBE menu bar, or when right clicking on the toolbox itself.  The project I created on one computer includes several forms, one of which includes a few DTPicker(s).  Some internal office issues have forced...

    McNitro255 pointsBadges:
  • Storing a ComboBox selection as a variable

    I have written a reporting procedure with various company code variables representing full company names. Different reports will be generated according to the company code that is plugged into the procedure. I am trying to create a ComboBox that allows the user to select the company code, which...

    McNitro255 pointsBadges:
  • Working with Login Userforms

    I've been doing research on Login Userforms and have come up with a code variation similar to coding trend. However, I am having an issue clearing the previous information, allowing the user to reenter their password before the loop continues. (i.e. the user inputs "password", receives an invalid...

    McNitro255 pointsBadges:
  • Looping to create new workbooks using a set “transaction” number

    I'm playing around a bit and can't figure out why the following code does not save a total of 5 files in My Documents(default) The files should be named in a sequence of 1 - 5 (In my Excel spreadsheet (A1)=1 and (A4)=5) The code works once through, but when ".SaveAs Filename:=Start" comes back...

    McNitro255 pointsBadges:
  • Vlookup Worksheet Function

    I develop and maintain pricing models that involve a lot of looping through cells and applying assumptions. For some reason I never seem to be able to get the vlookup worksheet function to work when looping through cells. It either says 'application-defined or object-defined error' or more...

    Hunter115 pointsBadges:
  • Meeting Invitation not updated in Calendar

    I have created a COM Program in MS Access using VBA code which will send meeting invitation. Invitees are getting my invitation and after accepting it is not updating their calender. How to do this. I attached a sample tag for the same. If you want complete code I can post the same. Thanks for any...

    Subbu2k990 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