MS Access Macro


I have a small job, I need a Macro placed in a report item that opens a form to the corresponding product ID.

I’ve already made the form and the report, but I can’t seem to construct the Macro to open the form to the correct record, it just opens to record #1.

I’ve attached the Access database for you to look at.

The Report is titled Reorder Watch and it links to the Form titled Inventory Details & Order, both can be found in the Inventory section.

The link on the Report that should open the Form is item / SKU.

Note: There is a Form named Inventory Stock Levels in the Inventory section which does exactly what I need the above task to accomplish if you need a reference, the reason I don’t use it is because I need to add a query field to it, but can’t get the extra field items in the Add Additional Fields dialog in design view.

My maximum budget is $40 USD

Thank you for your interest!

Evner: Microsoft Access

Se mere: named query, microsoft access job, job ms access, design access database, what is ms access, microsoft macro, microsoft links, ms access job, sku inventory, report design access, access inventory design, microsoft access query design, access form record, macro report, stock inventory access database, access budget database, product stock database access, database access inventory, budget access, budget database access, product inventory access, inventory microsoft access, need access database design, microsoft access stock, stock inventory microsoft access

Om arbejdsgiveren:
( 25 bedømmelser ) Mission Viejo, United States

Projekt ID: #5984079

Tildelt til:


Hi, My name is Nebjsa and i am experienced Ms Access developer. If you can, open macro for the onClick event on the Item/SKU field on the Reorder Watch report. Then replace where condition with next code: [Item / Flere

$30 USD på 1 dag
(12 bedømmelser)

6 freelancere byder i gennemsnit $132 på dette job


Hi, I have gone through your project details and feel comfortable in doing the job. I have done several MS Access projects earlier of various complexities and can take your work to provide a solution. Waiting fo Flere

$40 USD på 1 dag
(22 bedømmelser)

Sir/Madam, Greetings. This is an IT person , experienced MS Access database developer.I have read the given description . It's less than 1 hour work. Let's start the work now . Previously , I have developed uni Flere

$35 USD in 0 dage
(1 bedømmelse)

i have 8+ years of experience. Can we discuss the project. Please initiate a chat with me so that we can discuss the project at a broader level. Why you should hire me- 1. I have a very good communication skills Flere

$257 USD in 10 dage
(0 bedømmelser)

I have already done such kind of projects in MS Access. I am doing Masters in computer Application and have already handled such project. Your Task will be done as per your requirement and desire. You can explain me th Flere

$155 USD in 5 dage
(0 bedømmelser)

I have total 13 years of experience in IT which include both software development and web development. I have great experience in managing projects with USA/UK based clients and I manage my work shift timing as per cli Flere

$277 USD in 5 dage
(0 bedømmelser)