• Range of one cell backcolor in excell 2003

    Dear Sir Madame I am doing a function in Excel 2003 that takes three cells as range data-type. the function all it does is to see if two of the cells equal to the third one. if yes I want to color the background as green Can anyone reply to my request? Thanks in advance p.s. I am using the RTD...

    JonsIL45 pointsBadges:
  • commit in vba

    I am new to VBA (within access 2000) and have the following problem I have used a docmd to import a txt file into a table. I then want to use the table data within the same procedure/process using a movefirst command - the problem is that I do not think the data imported has been commited if thats...

    Gordo15 pointsBadges:
  • Visual Basic IF statement…

    I am trying to write an IF statement that will show a message box if the postcode of the customer begins with one of about 20 area codes. I can get it working for one code, but as soon as I add ' Or "HS*" ' (minus the apostrophes) it comes up with Type Mismatch. What am I missing / doing wrong? If...

    Mandi195350 pointsBadges:
  • Automate download from ALV grid to excel using VBA

    I have recently started extracting data into Access using RFC_READ_TABLE. I now need to know how to get results from a standard report via an ALV grid into excel / access. I am using VBA. Thanks

    VB Monkey5 pointsBadges:
  • Header in Word Document using VBA

    How to have different stlye within the same header,i.e. if a header consists of 3 rows the 1st header is bold and the second 2 are not. This way a single page should have a header consisting of 3 lines and each line has different format

    Idks5 pointsBadges:
  • Accountant

    What software proficiency, would enhance my career. There are so many MS Certificates.

    05120 pointsBadges:
  • dynamic visual basic form based on access database table

    I am useing an access database table to populate some lists. I want to dynamicly add picture boxes that I use to seperate the list box as if lined based on how many records I have in the database. Basicly, I just need to know how to add a control by code. I don't want to have to place 100 picture...

    YitoGraft0 pointsBadges:
  • Visual Studio.Net 2003

    I have a user who when she tries to run a project, recieves the following: "Error while trying to run project:Unable to start debugging. No such interface supported" Similar message appears when selcting Tools, Debug Processes. Software has been reinstalled, as well .Net Framework 1.1. Any advice...

    Ajwhit000 pointsBadges:
  • how to send sms through GSM modem in VB 6?

    hello alll, I am working on a school management s/w. Plz if anybody knows anything about sending sms through GSM modem in vb 6, then reply me. thank you all.

    Poojadoshi0 pointsBadges:
  • Coping and Renaming multiple files using VB6 Code

    Hi Everyone I would like to know how can we copy multiple files from one location to another location, and having the files automatically renamed. I want to copy Images from C:Original to C:Main but i would like VB to automatically rename the files. Naming must start from 000001 to the last image...

    Yugeshang0 pointsBadges:
  • Memory (helpfield) usage in Microsoft Access with VBA

    Microsoft Access software is running on the desktop of every user, but the database is installed centrally on a server. More users can start and run on the same database simultaneously. In VBA I have various helpfields defined. What I want to know is: if more users are in the same part of the VBA...

    Gerhemmes0 pointsBadges:
  • MS Access to SQL Server Image

    I have a Sql Server 2000 database. We don't have Web resources available, so I must write a User Interface in MS Access 2003. What I want to do is have the user supply a path and name for a document. Then I want to load the document into the Image field of the SQL Server DB. I have found some code...

    DonMonroe0 pointsBadges:
  • Cannot get the current year using vbDate or vbLongDate

    I have tried to get the current year (2005), with the following statements: helpfield = DatePart("yyyy", vbLongDate) helpfield = DatePart("yyyy", vbDate) The first statement gives me the year 1899; in debugging I can see that vbLongDate = 1. The second statement gives me the year 1900; in debugging...

    Gerhemmes0 pointsBadges:
  • VB Error

    when i try to make my project as .exe format, i get a message that says there is no BINARY COMPATIBILITY FILE SET. i tried to enable that option from the project properties but it was disabled for the users to change it. thanks for your time...

    Sswar1110 pointsBadges:
  • Windows or Web App for Data Update?

    I need to create an app that will give the user a list of items that they can then check off to denote that they are copleted. I would prefer a scrollable grid where they can make multiple selections. I would prefer to create a Windows app, but don't know which control to use. Can you give me some...

    Mrclark0 pointsBadges:
  • Library management system

    i need a free library management system running on window or linux that can keep track of who has what cd/books any one help plse

    Eduado0 pointsBadges:
  • Convert Excel file to AS400

    I have 'n' number of excel files . i need to convert them into AS400 and validate data . My problem is that all these files are in different formats (e.g. Excel 1 has Age, Name ,Salary fields; excel 2 has name , salary , company fields) to validate data I need these excel files to be converted into...

    SKapoor0 pointsBadges:
  • MS Access payment book

    Hello, This is my first time using this board, so bear with me if I am not using it correctly. I am trying to create a report that will print out 3 payment coupons per page. I have created a basic query that gives me the borrowers payment info (The amount owed) The problem that I am having is the...

    Novell2NT0 pointsBadges:
  • Help with VBA Code for retrieving data from a table in an MS Access Database

    Hi, I'm new around here. I'm a student in the programming field. I have a question for those of you with experience with VBA, VB, or SQL coding languages. Basicly what I'm looking to do with my database is have it fill in the remaining related fields in a form when the Primary key field is selected...

    Suprababe0 pointsBadges:
  • Microsoft Access. Passing an ID/value to a subform. or between forms

    Hello Everyone. I am using MS Access 2000 I have a form (frm_cboclient)that has a combobox on it that I populate by querying a client table for clientID and client name. What I would like to do then is have a subform that will display all my order infomration from my order table, where the clientID...

    Gryphon0 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