• Need Help With Multiple Conditions and Constraints for Access 2007 VBA Event

    Hi, I’m working with VBA for On Click Event procedures in Access 2007. My knowledge of Visual Basic is rudimentary and I've come against a business rule I can't even begin to figure out how to code. I work at a college and was asked to build a database for a student conference we're hosting. One...

    Dataempress115 pointsBadges:
  • How to convert VBA decimal DataTypes

    I need to figure out how (if possible) to remove decimals from numerical data, and add zeroes to the front/back end of data so that I can concatenate several cells into a single strain. Ex: Actual value = 14.37, needs to be converted to 14370 Actual Value = 4.3, needs to be converted to 04300...

    McNitro255 pointsBadges:
  • Excel 2003 VBA drop down list and discontinuous ranges

    I am attempting to populate a drop down list in excel using data validation and data contained in two discontinuous ranges. I have used the Union command in vba to create a named list which seems to correctly concatenate the two data ranges but when I validate the cell which is to contain the drop...

    TeradyneBenzene10 pointsBadges:
  • Microsoft Access AutoNumber

    Hi , I want to add a row of serial number for the existing records in MS access .Whenever I am trying to define a new row with type as "Auto Number" and save the same it automatically gets changed to Text type.Please suggest.Also, the requirement is modified and now the serial number has to be of 8...

    Ansh12320 pointsBadges:
  • How to update data using Microsoft Excel VBA?

    I HAVE A CELL "A1=NUMERIC VALUE" & "A2=NAME OF PARTY" WHICH IS UPDATED EVERY MONTH AND I WANT TO SAVE IT WITH "DATA" SHEET WITH EACH PARTY NAME(CELL A2) AND ITS MONTHWISE VALUE(CELL A2).HOW CREATE DATA SHEET WITH MONTHLY COLOUM NAME I.E : DATA SHEET: NAME OF PARTY APRIL08 MAY08 SURENDRA KUMAR...

    Sa2915340 pointsBadges:
  • File referencing in vba

    Hi All. I have a user form in Word that populates a doc, saves as a temp file, emails as attachment and then kills the temp file. I am worried that with momre than one user at any one time one person's code might kill another person's temp file before they have sent it. Any ideas as to how I might...

    BugBear5 pointsBadges:
  • Outlook 2003: trim leading spaces from email subject with VBA macro

    Hello, some email clients send emails with an extra leading space added to the subject. As a result message sorting on subject in outlook 2003 does not work correctly: these messages are considered to have a different subject and so the entire conversation is split in two seperate conversations,...

    Slay40 pointsBadges:
  • rolling average VBA code MS Access

    Hi All Anyone know how to create a VBA function and or SQL statement which will work in Access to find the rolling average as per example below + see excel file for working example in excel. Should work for a unknown amount of records. Not an easy one I think :-). If it can be done without using...

    Astakeil35 pointsBadges:
  • SpinButton linking to an occupied cell

    Can a spin button be linked to the cell that it is located in? I have about 100 spin buttons that I need in this sheet and don't want to individually link each one! Thanks!

    Sleibbra245 pointsBadges:
  • Visual Basic If Then Statement

    HELP! I normally don't write code or develop databases but I am trying to build a MS access database. I have one table (departments) with a list of departments and one table (112) with department, question text and question answer columns. I am trying to build a form where user selects department...

    Williams77710 pointsBadges:
  • Writing vertical data to a flat (unfortunately!) table

    I have an application that I need to update (written by someone else) that requires that I take data from a nice, vertical table and write them into a pre-exisiting flat table. Column 1 of the vertical table is the PK for the flat table, while there are up to 35 entries that must be written into...

    Kingle15 pointsBadges:
  • VBA to print to specific printer with print button

    In Access 2007 how do I use VBA code in my print button to print to a "specific printer" for my report.

    RPJ5 pointsBadges:
  • Microsoft Access 2007: Using an IF statement

    I want compare a field in one record to the same field but in the next record. For example I have this IIF statement: IIf(([MAILADDRESS]=[MAILADDRESS]),True,False) This will compare the MAILADDRESS in the same record but I want to compare that same field but in the following record. How do i do...

    Servent15 pointsBadges:
  • Microsoft Access menus

    How do you setup menus using MS Access?

    Danljonessr10 pointsBadges:
  • Perplexing Combo Box

    I have a set of combo boxes that I would like to have January through December added to as options. I need all of them to be exactly the same. Any suggestions other than With cmbMonth1 .AddItem "January" .AddItem "February" End With With cmbMonth2 .AddItem "January" .AddItem "February" End With...

    Label1cc25 pointsBadges:
  • new to macros – extracting data

    Hello, I'm just learning how to use macros and have this fairly large project to do. It concerns extracting data from a schedule (timetable) with the courses, course code, name of tutor on it. I have managed to extract from a cell and have the following information come up in a message box(course...

    Oistins2610 pointsBadges:
  • VBA Localization

    Is there a way that I can localize VBA macros into a second language without opening the macro in VBAIDE and laboriously going through each line of text and each control on every form. Some of the macros are very large and include a lot of forms and controls. Some of the macros are in VBA for...

    Tyke5 pointsBadges:
  • How to use Access object library in my Windows application

    dear friends , how to use docmd.opencurrentdatabse command to open an access application database please advise

    Ashabalu5 pointsBadges:
  • VB_Combo_Like_VBA

    Hi Experts in VB 6.0 Please Tell me how I code for combo just like Access form eg. In Access Form's Combo -- when we start type any letter then nearest matching data should be selected and auto also showing during typing in the combo box Question : Please give any idea for VB 6.0 Combo --- so when...

    AnandaDebnath280 pointsBadges:
  • How to paste data directly from Excel to PowerPoint graphic as data

    I've been trying to search for ways to copy data from a spreadsheet onto the datasheet of a graph in an open spreadsheet. I am unfamiliar with VBA code, but got it to copy and paste to the correct slide, but only as text. I have been unable to select the actual graph and paste the data in. Any help...

    Charm20 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