i want get a code for value in cell(sheet1) for example :
code    value
fghf    451
Nm8j    13.2

I have this VB6 Code.  Is there a way of altering it so that it works in
VBA?
Thanks
DS

I have raised this before and wrongly thought I had solved it.
I have a database on a peer to peer network with command buttons to open
mail merge documents. The first button works OK, but the other ones are
extremely slow, even though the only difference is that they are opening

In simple terms...
I've done the newsgroup thing, even visited
mvps.org\backslash\backslash\0007.html amd seen Dev's example.   But yet I
cannot get it to work.   Let's see if lateral thinking newsgroup can figure

From a MS Access 97 subform, I would like to refer to a text control of its
parent form?  Is it possible? If so, how do I refer it from code?

I am trying to get the number of rows in a subform programmatically. The Form.
Count should be returning 0, but for some reason is coming up 8. Why, I
cannot understand, as when I try it manually, it comes up 0!
Is there some better way for me to get the row count of a subform

I have a form which checks whether a field has been inputted before closing.
I have a message box that works ok with the check but i have the evnt on the
ONCLOSE of the form
With this in mind, if the field in question hits the check and fails i want

Quite sure I am just experiencing an ID-10-T error when trying to figure out
how to do this.
Have combobox with Row Source of SELECT [Participant].[Name] FROM
Participant;

This query works in the query window.  If you name it in control source it
works.  If you write the code into the control source of a form, it gives a
syntax error in the from clause.....  Why?  and can someone help me fix it?
SELECT TBLFUNDINGTOPOS.PosNo, TBLFUNDING.Funding, ...

We have a form-based application running all right.  But once upgraded
from 97 to 2003.  One of the functions no longer work, for instance,
one function that queries all sellers and populates them, upon a
selection (of a seller), the next box populates all the products from

In a form, I want to calculate the age of customers as of July 1st - I want
to be able to look at the age at any point in time during the current year
and know the customer's age of July 1st. So if a customer's birthday is July
1 and was born in 1962 the age would read 43 but if ...

I have these three forms. Form A, B and form C. Form C is a pop-up which ties
back to Form B's table. Form B is set to Continuous Forms with a button to
call form C. However,when I call form C, I want to plug into the target
foriegn field's key textbox on form C the primery key ...

I have a form that is returning a bizarre message and I can't figure out why.
The form's record source is the following SQL statement:
SELECT c.*, i.[Advertiser Name]
FROM [CMR Client Numbers] c LEFT OUTER JOIN [Imported CMR Client Numbers]  i

Well, the question is all in the header, is there ?
I have a bound form that jumps around the recordset if the user uses
the mousewheel. Worse, if the user accidentally hits the wheel while
moving to another tab or subform or control (not everybody knows how to

I have several forms that utilize a combination of text fields, check boxes,
combo boxes, etc., and I am trying to streamline the data entry process to
help save time.  Specifically, I am trying to make it to where every time a
combo box is updated, the focus is set to the next ...