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
13 freelanceria on tarjonnut keskimäärin 22€ tähän työhön
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....
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.