Đã hoàn thành

MICROSOFT ACCESS

Morning everyone. I'm Holguer a MSc student from the Americas. I hope you are well :)

I got monthly data from a measuremt device and it was exported to Excel. After I used a Microsoft Access to change the shape of showing this data. I got this part creating a new table. Then, I created a visual and sql programm in order to get the information every day, I mean intead of having one monthly excel file, I got 30 excel files (each file represents a specific day). Here, my problem start. Once I run the visual script (called module), a window comes up asking me to insert a parameter (because like this was done in sql). For example, while the visual with sql are creating the 1st document called day 1, I must insert the parameter 1 (means 1st day) to match the excel file called day1 with the info from the day1. But, the problem is, if I make a mistake and I insert 2 instead of 1, the information will [login to view URL], my desire is Once I run the visual, access creates the 30 excel files with its respective day information witout inserting any parameter (automatically)

I was thinking, export the value of a variable created in the visual script (exactly the for counter) to the sql script, but I don't know what is the exactly instuction in visual nor sql.

I hope anyone can help me.

PD: I created the visual and sql script, I have the desired table. In adition, I'm using Access 2007

I can deal with spanish, english or italian helpers

Thank you

Best

Holguer

Kĩ năng: Microsoft Access, SQL, Visual Basic, Lập trình cơ sở dữ liệu

Xem nhiều hơn: microsoft access open locked, microsoft access telco database, microsoft access search function code, microsoft access executable, system time microsoft access, access microsoft exchange java, microsoft access email harvester, inventory programs using vb6 microsoft access, sending microsoft access reports email, conversion microsoft access sharepoint, translate microsoft reader italian english, access control system gate controller phone access, how to call a module in vba access, crm access has been revoked from lead access manager, why will your access database example be more useful than using workbooks in excel

Về Bên Thuê:
( 0 nhận xét ) Milan, Italy

ID dự án: #22743390

Được trao cho:

AndresF9

I am a systems analyst with more than 7 years of experience in the management of Excel and Access databases in a multi-national company. Advanced level competence in data analisys for decision making and advanced knowl Thêm

€19 EUR trong 3 ngày
(2 Đánh Giá)
2.5

13 freelancer đang chào giá trung bình €22 cho công việc này

VladimirLilenko

Hello dear sir! I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality! You can read reviews about my work at: https://www.freelancer.com/u/VladimirL Thêm

€30 EUR trong 1 ngày
(177 Nhận xét)
6.7
zu02

Bonasera seniorina bonaseraas as Chelentano sings ! Send me your Access 2007 DB and I'll fix it. Regards Zurab

€30 EUR trong 2 ngày
(53 Nhận xét)
6.2
fanninson45

I had done a similar Access projects before with 5* ratings: • https://www.freelancer.com/projects/database-programming/legal-finances-database-improvements/ • https://www.freelancer.com/projects/php/build-ACCESS-Data Thêm

€25 EUR trong 7 ngày
(25 Nhận xét)
6.0
alokes

HI, I AM A SOFTWARE PROFESSIONAL DEVELOPING SOFTWARE IN MS ACCESS WITH VBA FOR LAST 22 YEARS. I WOULD LIKE TO DEVELOP THE DATABASE IN MS ACCESS AS PER YOUR REQUIREMENT AND INPUT PROVIDED BY [login to view URL] TASK WILL BE COMPLET Thêm

€25 EUR trong 1 ngày
(6 Nhận xét)
3.6
sahumk2000

Hi Greetings of the Day, I am interested in this task, I have extensive exp in macro writing. I am full time freelancer carrying 15 yrs of experience in VBA, Web and Windows development and Mobile development using AS Thêm

€19 EUR trong 7 ngày
(1 Nhận xét)
1.8
virtualcheater

I am working with ms access for last 10 years. In my understanding, you are having the issue to put the variable value from ms access module to the ms access query. Its so simple... please award me the work....

€19 EUR trong 2 ngày
(1 Nhận xét)
0.6
pragatiraj

Hello Sir/Mam, i would like to do your project. can you share some more details about this project.

€25 EUR trong 3 ngày
(0 Nhận xét)
0.0
jlmeseguer

Hi, I'm interested in your project. I find it very interesting and I can do a good job for you. I would like to contact you to keep a meeting about your project.

€8 EUR trong 1 ngày
(0 Nhận xét)
0.0
durgeshc4802

I can write a code to pass the parameters automatically and it will solve your problem. Basically it will mean passing the SQL with a value corresponding to parameter. I have worked on SAP B1, ACCESS, EXCEL, SQL, [login to view URL] Thêm

€34 EUR trong 1 ngày
(0 Nhận xét)
0.0
vw7967040vw

i am sure my 30 yeas experience will make you satisfy with the solution i will provide.................................

€8 EUR trong 3 ngày
(0 Nhận xét)
0.0
ckfeher

Hello, I offer my services for the task at hand. + 20 years programming with Access. Can you please send me the Excel and Access files you are using, so I can take a look at your code and bid accordingly. I also speak Thêm

€25 EUR trong 4 ngày
(0 Nhận xét)
0.0
(0 Nhận xét)
0.0