Finalizat

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

Aptitudini: Microsoft Access, SQL, Visual Basic, Programare baze de date

Vezi mai multe: 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

Despre angajator:
( 0 recenzii ) Milan, Italy

ID Proiect: #22743390

Acordat lui:

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 Mai multe

%selectedBids___i_sum_sub_7%%project_currencyDetails_sign_sub_8% EUR în 3 zile
(2 Recenzii)
2.5

13 freelanceri licitează în medie 22€ pentru acest proiect

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 Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR în 1 zi
(177 recenzii)
6.7
zu02

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

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% EUR în 2 zile
(53 recenzii)
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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% EUR în 7 zile
(25 recenzii)
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 Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR în 1 zi
(6 recenzii)
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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% EUR în 7 zile
(1 părere)
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....

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% EUR în 2 zile
(1 părere)
0.6
pragatiraj

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

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% EUR în 3 zile
(0 recenzii)
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.

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR în 1 zi
(0 recenzii)
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] Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR în 1 zi
(0 recenzii)
0.0
vw7967040vw

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

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% EUR în 3 zile
(0 recenzii)
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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% EUR în 4 zile
(0 recenzii)
0.0
(0 recenzii)
0.0