Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

obtaining report using form

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Obtaining a Report using a Form to extract details from a table

Obtaining a Report using a Form to extract details from a table

ResolvedVersion 2003

Manjeet has attended:
Access VBA course

Obtaining a Report using a Form to extract details from a table

I am trying to create a form based on a query. My database table is linked to another table, everytime i try to create a combo box based on the query to look at the records allocated to me, if the log is closed, the priortiy level etc.

i am not getting a drop down list of the people available in the tables list, instead i am getting all the records allocated to everyone in the combo box.

Please could someone advise urgently, as i have nearly finished building the databse and its only the reports that are left to complete.

If you need to take a look at my database please let me know and i can send this on to you. However you may need to go into the database and link the tables again.

Many thanks in advance for your assistance in this matter.

Thank you,

Manjeet

RE: Obtaining a Report using a Form to extract details from a ta

Hi Manjeet

Thanks for your question.

Sorry for the delay in responding. I have been onsite training for the last week, and am only back in the office today.

Please feel free to email the database to me at SW@stl-training.co.uk, and i will investigate to see if this can be solved in the forum.

Regards

Stephen

RE: Obtaining a Report using a Form to extract details from a ta

Hi Manjeet


We haven't heard back from you in a while so hope the question you had has been resolved. If however, you require further assistance, please reply to this post otherwise it will be marked as resolved in five days.


Kind Regards,


Nafeesa

Microsoft Office Specialist Trainer

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

 

Training courses

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Access tip:

How To Find All Overdue Accounts?

To find overdue accounts create a filter that compares today's date with the Invoice Date in the table. To do this:

1. Open the Query in Design View
2. Select the field for the filter and in the criteria row enter:

<Date()

This filter returns records where the Invoice Date is before today's date.

This filter can be manipulated if, for instance, Invoices are due 15 days after the Invoice Date. For this the filter would be:

<Date()-15

This filter returns records where the Invoice Date is 15 days before today's date.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.