Hi

would anyone steer me in the right direction please. I do not have access,
only Microsoft exel 2003

I have followed the threats on how to create a form, but will require it
modified slightly. (g).

Not enough information here to hazard a guess.

Please provide a few details on what type of form and slight modifications
required.

Maybe even a message ID of the threads you followed?


Gord Dibben MS Excel MVP

On Tue, 24 Nov 2009 14:50:54 GMT, "BNT1 via OfficeKB.com" <u19326@uwe
wrote:

Hi

would anyone steer me in the right direction please. I do not have access,
only Microsoft exel 2003

I have followed the threats on how to create a form, but will require it
modified slightly. (g).

Hi Gord, thanks for the response

Headings on sheet

A1 - Number
B1 - Despatch date
c1 - into comp date
d1 - Carrier
e1 - Quantity

I have so far created the form following the link below. (without the coding).
Not sure "What type of form" this is.
regards

http://contextures.com/xlUserForm01.html#Finish

Gord Dibben wrote:
Not enough information here to hazard a guess.

Please provide a few details on what type of form and slight modifications
required.

Maybe even a message ID of the threads you followed?

Gord Dibben MS Excel MVP

Hi

[quoted text clipped - 3 lines]
I have followed the threats on how to create a form, but will require it
modified slightly. (g).

--
Message posted via http://www.officekb.com

What you found at that site is instructions for creating and using a
UserForm.

I could never aspire to providing more help than Debra has given at that
site.

Did you download either of the the sample workbooks?

Modifications will be made depending upon your requirements for different
labels and linked cells.

You may be better off simply using the built-in Data Form Excel provides.

See Debra's site for instructions and a link to John Walkenbach's Enhanced
Data Form.

http://www.contextures.on.ca/xlDataEntry01.html#List


Gord

On Tue, 24 Nov 2009 19:11:44 GMT, "BNT1 via OfficeKB.com" <u19326@uwe
wrote:

Hi Gord, thanks for the response

Headings on sheet

A1 - Number
B1 - Despatch date
c1 - into comp date
d1 - Carrier
e1 - Quantity

I have so far created the form following the link below. (without the coding).
Not sure "What type of form" this is.
regards

http://contextures.com/xlUserForm01.html#Finish

Gord Dibben wrote:
Not enough information here to hazard a guess.

Please provide a few details on what type of form and slight modifications
required.

Maybe even a message ID of the threads you followed?

Gord Dibben MS Excel MVP

Hi

[quoted text clipped - 3 lines]
I have followed the threats on how to create a form, but will require it
modified slightly. (g).

Thanks Gord

I did download the file PartLocDB ,. It was almost what I wanted, with the
exception, that it obviously did not pick up any data already in the data
base and created a new record - thats the tweek I would be looking for. (not
that i am saying it is an easy tweek!)

Thanks again

Brian

Gord Dibben wrote:
What you found at that site is instructions for creating and using a
UserForm.

I could never aspire to providing more help than Debra has given at that
site.

Did you download either of the the sample workbooks?

Modifications will be made depending upon your requirements for different
labels and linked cells.

You may be better off simply using the built-in Data Form Excel provides.

See Debra's site for instructions and a link to John Walkenbach's Enhanced
Data Form.

http://www.contextures.on.ca/xlDataEntry01.html#List

Gord

Hi Gord, thanks for the response

[quoted text clipped - 26 lines]
I have followed the threats on how to create a form, but will require it
modified slightly. (g).

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200911/1

That's all the userform in PartLocDB does.

Appends new records to an existing database sheet or starts a new
database............in that sample workbook the PartsData sheet is hidden
and would contain your existing records.

If you want to be able have a form that allows new entries and is searchable
the built-in Data Form is what you need.

Or John W's enhanced form.


Gord


On Thu, 26 Nov 2009 14:15:45 GMT, "BNT1 via OfficeKB.com" <u19326@uwe
wrote:

Thanks Gord

I did download the file PartLocDB ,. It was almost what I wanted, with the
exception, that it obviously did not pick up any data already in the data
base and created a new record - thats the tweek I would be looking for. (not
that i am saying it is an easy tweek!)

Thanks again

Brian

Gord Dibben wrote:
What you found at that site is instructions for creating and using a
UserForm.

I could never aspire to providing more help than Debra has given at that
site.

Did you download either of the the sample workbooks?

Modifications will be made depending upon your requirements for different
labels and linked cells.

You may be better off simply using the built-in Data Form Excel provides.

See Debra's site for instructions and a link to John Walkenbach's Enhanced
Data Form.

http://www.contextures.on.ca/xlDataEntry01.html#List

Gord

Hi Gord, thanks for the response

[quoted text clipped - 26 lines]
I have followed the threats on how to create a form, but will require it
modified slightly. (g).