Search results

Hi Paul, The file u sent me in that http://dl.dropbox.com/u/60558749/Urgent%20Help_%20Appending%20%2C%20Deleting%20data%20in%20access%20database%20using%20excel%20-%20Upload%20Data%20to%20Access%20Table%20%28for%20paulrh%20at%20chandoo.org%29.zip is the same file i sent u

a) only the following tables CHP, HVAC, Lighting, MPAN, Others, Refrig, SD OD List, Temperature are to be updated with fresh weekly data and correspondingly last week's data should be deleted from these tables before uploading new data. In my HVAC_Query query if you see HVAC table has the Store...

Hi SirJB7, I have reuploaded only that file. http://www.mediafire.com/download.php?o876dc75san4e4o In the Upload Data to Access Table.xls file all my requirements are met only one main thing which I wanted in that sheet is, the user can have the option to select the desired access...

Hi SirJB7, I have detailed the entire report making process stepwise in the excel file uktg description.xls, which I have zipped and also I have zipped the files in one folder for your viewing . Step 8 and Step 9 is the place I would require help in creating this application...

Im comfortable with ms access queries but im not so good in excel vba and sql so im bit stuck with this development. In fact if i could get any readymade projects available on the internet i could modify it for my development

Hi SirJB7, Im on skype.if your available would you want me to show you exactly my project what im working on

Hi SirJB7, 1. every week we get a sd list and we update the store master which is a hidden sheet in the UKTG_macro.xls 2. every week get the temperature details also which is daily wise which is updated in the UKTG_macro.xls 3. the data for lighting , hvac , refirg, others and mpan is...

Hi SirJB7, Where do I upload the sample files, which I would want to show you.

Hi SirJB7, This is a weekly report circulated to the management through out the year. in our company a week starts from Monday to Sunday. so on 9th April 12(Monday) when i am goin to do this report i must download 2 weeks data i.e: from 26th March 12(Monday) till 8th April 2012(Sunday).Now...

Hi I have a ms access database with 6 access tables.the 6 tables are: 1.Lighting consumption 2. Refrigeration consumption 3. HVAC consumption 4. Bakery consumption. 5.BioGas consumption 6. Main Meter consumption. Each table has the following fields 1.Store Number 2. Meter Reading Date and 3...