Dynamic pass through query MS Access
- or -
Post a project like this$$
- Posted:
- Proposals: 6
- Remote
- #1829296
- Expired
SQL Server and MS Access Database Developer / Administrator / Commercial Analyst
Chelmsford
Excel | VBA | Macro | MS Access | MS Word | PowerPoint Program | .Net | C# | VB.Net
Bangalore
6422087822963451144943317007521889454
Description
Experience Level: Intermediate
Program: Microsoft Access – Data on Informix Server
• SQL Search
A split form with 4 textboxes. These textboxes will filter the below SQL code.
o Two textboxes for informix.whs_order.pick_date will be for the date between ranges
o One textbox for informix.whs_order_pick.pick_item_nbr
o One textbox for informix.whs_order.store_nbr
o Once these boxes are filled in I would like a search button to execute the modified code showing the results within the splitform.
The two date options must have a value before launching the code. The other two can run with blanks and with search as * so choosing all values in those fields.
• I would also like a button to export the results to a new empty spreadsheet in excel.
With my very limited knowledge I would assume a connection string may be required if done though vba which will be provided if needed.
• SQL Search
A split form with 4 textboxes. These textboxes will filter the below SQL code.
o Two textboxes for informix.whs_order.pick_date will be for the date between ranges
o One textbox for informix.whs_order_pick.pick_item_nbr
o One textbox for informix.whs_order.store_nbr
o Once these boxes are filled in I would like a search button to execute the modified code showing the results within the splitform.
The two date options must have a value before launching the code. The other two can run with blanks and with search as * so choosing all values in those fields.
• I would also like a button to export the results to a new empty spreadsheet in excel.
With my very limited knowledge I would assume a connection string may be required if done though vba which will be provided if needed.
Chris H.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
50%
Last project
28 Mar 2017
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies