Displying progress?

[Gasman]

Hi all,

I have a form that I am trying to use to update the user on each macro step.

The form has one field txtProgress and I set that value in the macro prior to running the next query. However most times the form is still opening when the macroes are already running, so defeating the purpose of the progress update. I know I could use MSGBOX, but that would involve the user having to click each display.

How can I just have the field get updated in time with the macro that is next on the list to run.?

TIA

 

[Anakardian]

I have used the technique from here http://www.granite.ab.ca/access/progressbar.htm

It relies on vba but you can probably use it from a macro as well with some modifications.

 

[Gasman]

Re: Displaying progress?

Thanks for that. I'll take a look and see if I can modify it.

 

[namliam]

Anything that macro's can do, VBA can do better. Suggest you start making the transition sooner rather than later.

 

[Gasman]

I am more than happy to do so, however this is a small task allotted to me as I know a little bit about Access and is not my correct role in this place. If someone else needs to maintain it when I go, they will not know VBA, but will likely be able to build a macro of the steps.

 

[Frothingslosh]

If at some point you start working with vba, I built a class that uses the same principle in Anakardian's link but automates and expands upon the process a bit. It can be found in the Code Repository HERE. The single-meter bar is pretty easy to use; the dual-meter takes a little more effort.

 

[Gasman]

If at some point you start working with vba, I built a class that uses the same principle in Anakardian's link but automates and expands upon the process a bit. It can be found in the Code Repository HERE. The single-meter bar is pretty easy to use; the dual-meter takes a little more effort.

Great. Thank you for that.

 

[namliam]

If someone else needs to maintain it when I go, they will not know VBA, but will likely be able to build a macro of the steps.

You cant really limit your development on what another person may or may not know....

 

[Gasman]

You cant really limit your development on what another person may or may not know....

I agree, but this project as I mentioned is not my normal job, which is very boring. I only have a limited time to work on this. Already they do not want anything else, but I can see the potential of making my life and my colleagues a little easier.

I'll give you an example. The professionals created a database where the user has to copy fields to another Access database. My amateur version was going to copy the data it is required for that database to the clipboard so all the user had to do is paste. With the help of one the developers of that database I now send the data direct to that database and all the user has to do is press the button on the form. Life is so much better not having to click a checkbox to retain common data 90 times a day.

Most of my questions have been asked out of work hours. I've only just found out that they do not block access to this site in work (well not yet) so have managed to post the odd question from work.

I will admit that the macro process does allow for a quicker build if you are not an Access developer, and even the 2007 wizard now uses Embedded Macroes rather than a line of DoCmd.

I am enjoying learning new techniques as I ask questions and get answers here.

Thank you all.

 

[namliam]

My amateur version was going to copy the data it is required for that database to the clipboard so all the user had to do is paste.

If it is another (access) database, why not simply insert it into the required tables. Elliminate the chinese interface all together.

Ow, never mind

 

[Gasman]

Well I have no access (excuse the pun) to the other database directly, but am able to use their form to fill in the required fields. Best I could do with the restrictions set upon me, but it makes life so much easier for us now.

I'll give you another example. We have to search two Excell spreadsheets for a name. They are incapable of having all the data (same type of data) in one sheet.

I import both sheets each morning and with our little bit of data, create a table of unique names with the minimum payment limits (as they have duplicates with different limits ) to create what I call the Master **** table.

When processing our data, the form supplies the data from this table as well, warns if name is missing from that table and warns if limit is exceeded for that person.

Can we use it?. No, it requires a lengthy change control process, yet I have proved that every name in both sheets exists in the Master table (but only once).

We pretty much use human beings where computer systems should do the work. Typically we will copy data from one system and paste in to another, rather than export and import.

 

[namliam]

Naice! tell your boss i can save HIM 200k if he pays me 100k euro

 

[Gasman]

They do not look at it like that. LOL