Need Help With Sales Purchase Ledger Database

[Aamer]

Need Help With Sales Purchase Ledger Database



I have made a ledger DB, everything is working fine.... but am stuck with
the delivery challan form.

When I put the company name it does not pick up the details of the company
i.e company address, city and phone numbers.

Can someone please fix my DB

I can mail my Db for fixing.

PLEASE PLEASE Send reply to (e-mail address removed) so i can e-mail the DB.

Help needed urgently.

Regards
aamer sheikh

 

[Wayne-I-M]

Hi

It doesn't normally work like that - where you can e mail a database to
someone form to work on it for you.
On that point there "may" be someone who is prepared to do this so you never
know.

But. If you provide more details of the problem, then someone may be able
to offer some advice so you can fix it yourself.

As an example. You say you are "putting in" the company name.
Where are you "putting" this into
What is supposed to happen after this
If you are using a list or combo to put the name in - what is the bound column
eg
Say you have a form with a combo box on it call CmbSearch
you could use this as the AfterUpdate event of that combo

Private Sub CmbSearch_AfterUpdate()
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[CompanyName] = '" & Me![CmbSearch] & "'"
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub

This would search through all records on your form a fins one with a
matching company name.
This is not a good idea by the way as you may have companies with the same
name (eg The Ford Garage, The Old Oak Pub, High Street News, etc, etc) - so
you really should select them using the primary field. Up to you thought

Basically you need to supply more information to get a decent answer.

 

[John Wyman]

Aamer,
This is a possible answer to your question: If the company name has an
apostrophe in it (e.g. O'Rorke) the selection will fail. You need to make
sure you are using the ID field to select records.