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
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
13 freelanceri licitează în medie 22€ pentru acest proiect
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
Bonasera seniorina bonaseraas as Chelentano sings ! Send me your Access 2007 DB and I'll fix it. Regards Zurab
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
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
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
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....
Hello Sir/Mam, i would like to do your project. can you share some more details about this project.
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.
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
i am sure my 30 yeas experience will make you satisfy with the solution i will provide.................................
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