Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / July 2007

Tip: Looking for answers? Try searching our database.

Form Help.....

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
amorrison2006@googlemail.com - 13 Jul 2007 14:14 GMT
Hi

I am hoping someone can help.

What I want to do is have my forms show up with a drop down box
showing my client names and then when I select my client the form
should show all my accounts for that client.

I do not know how to do this or whether this should be done from my
table.

I hope someone can help.

Thanks so much,

Andrea
SteveM - 13 Jul 2007 14:26 GMT
Can you supply a description of your tables and their field names?

Steve

> Hi
>
[quoted text clipped - 12 lines]
>
> Andrea
amorrison2006@googlemail.com - 13 Jul 2007 16:10 GMT
Hi Steve

I have one table which I plan to expand as my database become more
advanced.

The fields in my table are Client, Account, Date1, Date2, Date3,
Amount.

I want a form to filter down to show only the records relating to my
client.

I am also going to try and make the window refresh so it can update as
I will have multiple users accessing it.  I appreciate your help with
this,

I hope you can help with the drop down list so it only shows records
for one client say "Funky Doughnuts" and then all the accounts which
relate to "Funky Doughnuts".

I hope I make sense to you,

Thanks so much,

Andrea

> Can you supply a description of your tables and their field names?
>
[quoted text clipped - 19 lines]
>
> - Show quoted text -
Steve - 14 Jul 2007 01:26 GMT
Andrea,

Your table is incorrect! That's the root cause of your problem. You need
more tables in your database immediately. Please explain what all your
fields mean and I will give you a recommendation for the tables you need.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
resource@pcdatasheet.com

> Hi Steve
>
[quoted text clipped - 44 lines]
>>
>> - Show quoted text -
amorrison2006@googlemail.com - 14 Jul 2007 20:16 GMT
Hi Steve,

Thank you for coming back to me,

It's much appreciated,

I will tell you what I am doing with this database.

I have hundreds of clients for example.  Each client has a name.  I
was thinking of keeping them in a separate table...??

Each client then has multiple accounts.  Some could have one, other
could have 100's.

Within each account I want to track the dates of my letters sent to
them......

I would like the form to be in a tablular view to make it easy to see
for me and my staff.

I would prefer to have one form and then right at the top of the form
have a filter which allows me to filter down to my clients and show me
only that clients orders.

If I could also have an "All" filter to show me everything that would
be great.  I am so silly with these databases but I have seen them
help alot in the past.

I then want to add additional functionality to it for example sending
out emails when my clients havent responsed to me.......I think the
first thing is to get my database structure correct.

Can you help me???  Please.....

Perhaps you could send me an example file to my email......

I would be every so grateful.  I do everything manually at the moment
for my small business and I am starting to lose track of everything.

Thank you Steve,

Andrea

> Andrea,
>
[quoted text clipped - 61 lines]
>
> - Show quoted text -
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.