I can answer most questions on database design using Access. I can help with VBA too. I can integrate engineering and business needs in the database design.
I have more than 15 years of MS Access database design experience.
College degree in engineering. Graduate degrees in engineering and management. Current PHD student - concentration Industrial Engineering.
|Stuart||07/21/14||10||10||10||Thank you for your expedient and concise .....|
|Charles||07/06/13||10||10||10||Very prompt in answer to a simple .....|
|Thiruthuva Rajan||02/23/13||10||10||10||Thanks alot mark. Though you do not .....|
|Thiruthuva Rajan||02/15/13||10||10||10||Thanks alot mark|
Hi, The best practice is to create a form with dropdown boxes where you can select the report and click a button to print the selected report. You can create a table with the names of the reports,
Hi Stuart, Sorry for getting back late. Well, it can be done and this is how usually it is done: 1. Create a table (tblMinInvLvl) with minimum inventory levels for the items. Fields: Item, MinInvLvl
Open the table in Datasheet view. You will see the new field for the hyperlink. They should have been blank initially. If you have anything, you will need to delete them. I guess you have the same website
Hi Megan, Open the table in design view. Add a field. Select "Hyperlink" for Data Type. Save the table. Close the table in Datasheet view. Enter website addresses in the new hyperlink field.
Hi Charles, You can create a query to do get the earliest date first. Save this query as "qryEarliestDate" and use it as the RecordSource for the form. On the form use design view and VBA icon to get
Answers by Expert: