Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 341
  • Last Modified:

Buttons to query database to display specific record numbers; Go to to last record, and Fwd / Reverse buttons by record.

I would like to add some functionality to an access database that allows me to display records based on a field called "WorkOrderNumber"  and I would also like to add a button for "go to last work order entered"  and buttons to move forward and backward by work orders.  Can someone help me with how to create the buttons and fields to make the queries etc?  Thanks!
0
jckuhne
Asked:
jckuhne
3 Solutions
 
tonydemarcoCommented:
Is the data in one table?
Have you created a form?
Is the form based on a query?
0
 
incrediblejohnCommented:
Turn on your ToolBox Wizard, add a combo box to your bound form, click on the option "to look up values on a form" and set the field in the wizard.

Then, in the AfterUpdate code in your combobox do a DoCmd.GoToRecord acLast
Then in your form, make sure in the properties window that you set the "Navigation Buttons" to yes or true or on or whatever choice it gives you.

0
 
Jeffrey CoachmanCommented:
jckuhne,

Quite simple,

However this is a very broad question, as tonydemarco is eluding to.
Do you need help designing *ALL* the Tables/Queries,Forms?

1. If you already have you "WorkOrder" table, you would simply use the Form wizard to make a form out of it.
The Form will automatically have "Navigation buttons" to move through the records (First, Next, Previous, Last, and New)

(There is a wizard to help you create your own Navigations buttons, but why bother if they are built in.)

The only thing you might need is a search box, to select a specific WorkOrder.
There is a wizard to help you do this also.

Here is a sample:
https://filedb.experts-exchange.com/incoming/ee-stuff/5840-Access--EE_-Q22982722WorkOrders.zip

This is a simplistic example. In reality you would probably need the following other tables:
Employees
Customers
Parts
...ect

And they must all be related.
You would need Lookup fields as well.
But these "Design" questions should really be addressed in a separate Question.

Examine the sample carefully, and play around with it. If you have any issues post back here.

JeffCoachman
0
 
jckuhneAuthor Commented:
It is hard to have comprehensive solution for what started as a vague question on my part.  I had to send this issue to a more qualified individual inside the company.  I was hoping to be able to learn some quick tricks, but don't have the extra bandwidth to fill in all the existing gaps in my knowledge.  I won't add this to the KB because there are more quality questions and dialogues that deserve KB status.  I did learn, however, that I should pick up a MS Access book.   Points divied amongst all the kind people who responded.   Thank you!!!   <:-|  
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now