Replies

kgudgel

It does seem that John has set this up the easiest way.

Have you tried it? You can still input the customer number into the combo box. The combo box will find it the listing, and the rest happens from there.

I also have been using Find and Replace for years. It has saved me a lot of work. But as with anything that can save you work can also cause a lot of midnight candle burning.

Always remember and never forget, be careful, as a carpenter should measure twice and cut once. Check your settings before to press go.

DHawver

I may be able to help.

When you say R:Base 5.5 file, are you meaning data base?

If your file is a data base. You can export each Table as .csv files. You can then open these .csv files in Excel, and clean then up. You will have to clean up as R:Base has an Indexing system to be recond with.

After your clean up, you can then import to Access Tables.

John

Just wanted to let you and others know, the addition did in fact work.

When I was making the cut down version on the database I had to make some adjustments to make the process work. When I ran a test it worked perfect.

Thank you much for your time, and the hard nudge to the head.

Hello John

The test did not work. All were exported to Excel sheets.

The macro runs all listings from a combo box through a Query (qryMapPointExportSpecial).

The listings are Delivery Route codes.

I’ve not dealt much with macros. Nor have I dealt much with Excel.

Apologizes, was on one those iPhone thingies.

=Count(IIf([YourControl]=”TopBox”))

=Count(IIf([YourControl]=”MiddleBox”))

=Count(IIf([YourControl]=”BottomBox”))

I hope somebody out there can
– in the “QoSBoxes” cell on the report I want to count the number of times it Says “TopBox” – The cell will onloy say “TopBox”, “MiddleBox”,”BottomBox”

on the report or form

=Count(IIf[YourControl]=”TopBox”)

=Count(IIf[YourControl]=”MiddleBox”)

=Count(IIf[YourControl]=”BottomBox”)

Working now!!

After talking to a tech at MS home base, would seem that my Multi licence MS Office 2007 was faulty. After downloading a few patches and then downloading the whole suite (with disc in the mail) all is working.

Oddly the tech said a number of times that I needed to upgrade. And me trying to explain that I did upgrade.

But is working now, main part.

Thanks much

Hello John

I’m not sure of any difference. I just started doing this in 1998. I had a data base that I was working on go corrupt on me. With a lot of work I was able to extract the components and get it working again, really done want to go through that again.

Just one of my safety measures.

I do the same with web site.

To most it’s foolish, and nothing but added work. For me it has become habit.

oops OS is Vista.

When I build a data base, I start with a working on model. I use this to build, change and fine tune data base.

The second is the the actual data base that the end user will receive. And this is also the master copy.

All changes to the end users copy are done via internet or intranet. All databases are split into Front end and Back end some times with an added back end for temporary tables.

I try to make my data bases as idiot resistant as possible.

I’m told that you can use Google Earth as well. I have not tried it yet.

Yes sir I did and it is an Add-In. There is a version for XP, 2003 and 2007. Worked well with XP, then I upgraded to Access 2007.

One use that I found is that if working on a data base from my working on model that I can Export all components (queries, forms and such) in one fell swoop to the actual data base. As opposed to one at a time.

It is pretty handy. When it works.

Apologies John you are correct.

I’ve built an Access data base (still fine tuning, as the end users are not sure of what that want or do not want). The data base is to be used for the delivery of Subscriber publications.

With the use of MS Map Point and an Add-In called Route Writer I am able to setup delivery routes with turn-by-turn directions. At present the route and turn-by-turn are on seporate sheets. Through some coding I plan to combine the two into one route sheet with delivery addresses and turn-by-turn direction.

I am also able to send the turn-by-turn directions to the carriers GPS or cellphone from Map Point. If need be a map can also be sent.

So far all is working well, everyone seems to be happy.

Deliveries are being made with a less then 1 percent recovery.

I’ve talked with others that are using Map Point, they have their system working. sadly they wont share their code. Oh well.

Using Access 2007, Excel 2007 and Map Point 2010 with GPS. The above will also work earlier versions.

Have you tried WinMerge? Works well for me.

Winmerge.org

One of them is

Ezy Exporter Primium for Access2007

This little gem Exports All or Some of your Tables, Queries, Forms, Reports, Macros and Modules.