Terminé

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

Compétences : Microsoft Access, SQL, Visual Basic, Programmation de bases de données

en voir plus : 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

Concernant l'employeur :
( 0 commentaires ) Milan, Italy

Nº du projet : #22743390

Décerné à:

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 Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% EUR en 3 jours
(2 Commentaires)
2.5

13 freelance font une offre moyenne de €22 pour ce travail

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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(177 Commentaires)
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 en 2 jours
(53 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 7 jours
(25 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(6 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 7 jours
(1 Évaluation)
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 en 2 jours
(1 Évaluation)
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 en 3 jours
(0 Commentaires)
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 en 1 jour
(0 Commentaires)
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] Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(0 Commentaires)
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 en 3 jours
(0 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 4 jours
(0 Commentaires)
0.0
(0 Commentaires)
0.0