I gang

MS Access Macro

Hello,

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!

Færdigheder: Microsoft Access

Se mere: named query, microsoft access job, design access database, microsoft macro, microsoft links, 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, stock macro, access query design, access order inventory

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

Projekt-ID: #5984079

Tildelt til:

nlukovic

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 / Mere

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

6 freelancere byder i gennemsnit $132 for dette job

mail2vimalarora

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 Mere

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

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 Mere

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

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 Mere

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

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 Mere

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

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 Mere

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