• VBA-question

    How do I transfer 30 text files at a time into my access DB? I was able to get the files, but it did not transfer into the database. Thanks.

    Bonjour15 pointsBadges:
  • Error 2501

    While navigating my database I have a button that will take you to a different form using parameters. It works when you either simply click ok or type in a parameter, but when you click cancel it returns an error 2501. What code should i put in to VBA to make it simply close the parameter box and...

    Newguy20085 pointsBadges:
  • programming

    Tag# 301-22-AB02-103, I want this Tag format in this formate XXX-XX-NNXX-XXX, it means in place of Numbers i want 'X' and in Place of alphabet i want 'N', do you know how can you we do that in Excel? i wana to change numeric values in 'X' and alphabet in 'N' form, and my friend did already, through...

    0717855 pointsBadges:
  • Change Font Style of Menu Item Through VB6

    My program is in varnacular language, i. e. input and output are in Gujarati (Indian) language, by changing the font to "Gopika.ttf". So, during the execution of my program I want to show menus also in Gujarati. Normally, we change this from desktop --> properties --> appearnce -->...

    Mayuri155 pointsBadges:
  • Copy past in excel using VB

    i want to cut data in a colunm H and copy it in column B. i tried to record macro and run it. but i am not getting the values in column B. i am using excel macro and vb code to do this. i understand that the data in colum is cut and the data is not retrived while it paste in column B. Can Any one...

    Krishsrikanth5 pointsBadges:
  • Changing Color in a Cell

    I am updating a spreadsheet each month which is automated. I have written a macro to update this spread. Each month I append four columns to the end of the spread sheet and update the data in the spreadsheet. The problem that I am having is trying to figure out how to update the heading color for...

    Kioh4650 pointsBadges:
  • Executing a Stored procedure using Excel Macro

    I am an amateur in SQL programming. Could you please tell me how to execute a Stored procedure using Excel Macro (VBA Programming) and then save the record set into different Excel sheets?

    SQL Server Ask the Experts2,585 pointsBadges:
  • jim development funds management

    i would like someone to tell me how to develop an application in visual basic 6 that can be used to ; maitain a list of - development areas, details of proposals , awarded projects and maintain funds recieved, given; jim is an organisation that receives funds for development from sourses such as ;...

    Analysis and design5 pointsBadges:
  • use vba to draw graphics in ms word

    can vba create drawing "free hand" or by joining forms and circles together (putting one near another is good enough)

    Elad Karako255 pointsBadges:
  • Separation of data

    I want to copy a part of a table from Adobe to Excel, but all the data are getting copied to one cell. How can I use VBA to separate this set of data each one into different cell? Thank you beforehand.

    Lyu5 pointsBadges:
  • easy way to automate uploading data from a word document to a spreadsheet?

    I have a spreadsheet to verify datafields for. This needs to test for example state all the valid entries. I do not want to save off a spreadsheet form of the template i am testing one for each data value I need to test. Is there an easy way to create many spreadsheets off of a data file I create...

    Juls45 pointsBadges:
  • How Can i restrict the user to insert next record

    Hai all, I have a requirement that , i have to display the data from a table in the subform in a datasheet view mode. I should validate the fileds in such a way that i can restrict the user to insert a next record when the one of the fields in the previous record is null. And also i should pop up a...

    VBAccess5 pointsBadges:
  • Overwrite previous record with VBA code

    I am doing a training exercise. All works OK as per the notes with a new record being added when the OK button is clicked. Now I want a script that overwrites the previous record and not to add a new record / row on pressing OK. Pls help with code

    Battler5 pointsBadges:
  • Open Import window via code in MS Access

    Within a MS Access application, I would like to have the window that is opened when you select: File | Get External Data | Import via code.

    Rjwilcox45 pointsBadges:
  • Save Access 2007 format as 2000 format with VBA

    how can i save the curent database as a 2000 format with vba

    Dave b10 pointsBadges:
  • Saving form calculations to tables

    I have a simple calculation on the input form a-b. It is calculated on the form but I cannot figure how to save it to the table

    Rv49495 pointsBadges:
  • How to save a document as current date ?

    I'm using VBA in excel 2000 to create a macro that saves out a spreadsheet with today's current date. I cannot figure out the code that will achieve this function. Help Please

    Data Mgt5 pointsBadges:
  • Combo box and VBA

    The two possible selections in an Excel combobox: Debt & Common Stock. Let's say that the combobox resides in cell B3. If Debt is selected from the box- I want the following fields to show up two rows below the combobox, all in the same column: Issue Date, Maturity Date, Interest, Seniority, Use of...

    Nkd5 pointsBadges:
  • microsoft access 2007 & Outlook 2007

    Hello, I am running office package 2007. I was wondering if anyone has found a way that i could set reminders in access 2007 and i would get a reminder email when the time comes closer. I was also wondering if access could auto pull from a date catagory and set it to have outlook send a message...

    Itguy1509220 pointsBadges:
  • VBA Auto Protect

    How can I make the worksheets in Excel automaticaly protected on date

    Georgesal00110 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