Tabular Data Design

[pbaldy]

Happy to help Ram!

[Ramsi2001]

Hi Paul,
I have a different issue this time.

I am retrieving some data from an Oracle db table to access. I am able to do this.

But i have a requirement wherein the process of retrieving should be done automatically at every regular time intervals, e.g. every week.

is there anyway to schedule the process in access?

Please help!!!

[pbaldy]

You could use the timer event of a form, but I wouldn't for something like this. I'd create an mdb that performed your process when it opened (autoexec macro starting a function), then closes itself. Then call that mdb from Windows Scheduled Tasks.

[Ramsi2001]

Hi Paul,
Thanks a lot for the reply!!

So, what i understand is , you want me to create another mdb file seperate from my current MDB and write a macro to run the fucntionality.

But i could not understand the concept of autoexec macro.

As i told that i am a bit new to access, can you help me in explaining this part?

if possible, can you give an example of this kind?


Thanks,
Ram

[pbaldy]

I wouldn't say that I wanted you to create one, just saying that's what I would do. I'd create a new mdb, and put your import process into a macro or VBA code. The concept behind an autoexec macro is that any macro named "autoexec" will run automatically when the database opens (unless you hold down the shift key). So you can use that to either run your VBA code or it can have the macro actions in it if you decide to use macro actions. The last step in your VBA code or macro is Quit, which means that the database will automatically run your process when it opens, then quit.

[Ramsi2001]

Thanks Paul!!

As always, you have been very helpful!!

[Ramsi2001]

Hi Paul,
I have a samll question.

I have a continuous form where i am dispalying the budgets for different projects.

Can i show total of all the budget amounts just below the budget amount column within the same form?


Thaks in advance,
Ram

[pbaldy]

Probably, depending on your structure. One method would be a DSum() function.

[Ramsi2001]

Hi Paul,
I know i am bothering you too much; But i need your assistance on this.

The only problem i am facing with this is, i am unable to place the total value just under the column list.

When i try to place it in Form Footer, and when i see it in Form View, it is displaying at the very bottom of the form.

When i try to place it in the Detail section, it is being repeated every row.

Is there a way to place the summation field just below the column list?

Thanks,
Ram

[pbaldy]

Can you post the db, or a representative sample?

[Ramsi2001]

Hi Paul,
Sorry for replying bit late.

I am attaching the screenshots with this mail.

I have attached the form, table and the query linked to the form.

Please let me know if you need more info.

Thanks,
Ramarao

[pbaldy]

Are you saying that you want the total as the last line of data? If so, you can a UNION query. It would make the data read-only, but with that SQL it already is. My friend A.D. has a demo here:

http://www.rogersaccesslibrary.com/f...-ae2231ez.html

[Ramsi2001]

Thanks again!!!

It works wonderful!!!

[pbaldy]

Excellent! Happy to help.

[Ramsi2001]

Hi Paul,
How are you? I have a small question for you.

I have a form and a subform. When i try to open my form to enter a new record, I am using the following copde in my main form_load event:

DoCmd.GoToRecord , , acNewRec

This enables me to open the form with no old values in it.

But my subform shows old values in it. The subform is in Datasheet view.

How to show my subform without any old values in it?

Please help..


Thanks,
Ram