Replies

>. I guess all you can do is create a history sheet

Duh!

Thank you for pointing out my stupidity.

Sadly, turning off recalculation didn’t help, and although this data does belong in Access, the spreadsheet began life as a simple sample tracking sheet and has grown. I started in Excel because everyone is comfortable with it and it’s difficult enough anyway to get people to bother logging things. Getting an Access db to the same level of useability requires a fair amount of work. I also don’t need the data to be shared as such, but I need to know who changed what from what and when. I could do this in Access, of course, but it would require setting up a workgroup information file and more coding.

There may be another way round this. Actually what I want to do is recover from the annoying Excel “feature” of deciding that all 65000 rows on a work sheet are active, rather than just the rows that contain data. I’ve never understood why this happens, but it’s a real pain if you’ve got a few hundred rows. Usually it’s easy to deal with, but I can’t find any way of sorting it out in a shared workbook.

Physical. But disaster didn’t strike until I’d accumulated a few of these episodes – usually increasing in frequency and/or number.

It was quite a long time ago (a 520MB hard drive I seem to recall), so maybe I’m worrying you over nothing.

Just back up more frequently from now on – the time this happened to me it was the prelude of major hard disc disasters.

This is not the only culprit, as I always have active desktop turned off but still see this behaviour occasionally, especially, but not exclusively, when windows (not the computer, just windows) restarts after being prompted to (eg following a system settigns change or refreshing my MSP proxy client). It happens on my Win98SE machine too.

Thanks, I think I’ll go for B: only got 6GB HD in laptop, and won’t split db until devpt finished, when it’s not so much of an issue.

Never have been good at the simple answer. Thanks

Duh! Why didn’t I think of that. My slice of the server pie at work is mapped to a drive at logon, so why not map the My Documents folder on the laptop to the same drive letter, and solve many problems whilst not interfering with the simplicity of my synchronisation programme.

Thanks Bubs.

BTW, how much “overhead” is involved in this (eg mapping My Documents to T:)?

Sorry, I must have been mistaken.

I will, of course, try the access boards now, but I remember coming across this problem before (of not being able to find a list of these variables), and always like to try for the global solution first .

Thanks Mark, but when I do this I don’t see some of the variables I think I know exist, such as %user%.

I don’t have a problem with writing simple code, but mainly VBA rather than dealing with anything more OS. My main problem is in working on developing an Access db with linked tables on both the laptop and at work, where the My Documents path is different, but everything is the same below that.

It sounds so simple…..which probably means it’s impossible .

This thread may help set you on the right track:

http://www.wopr.com/cgi-bin/w3t/showflat.p…ew=&sb=&o=&vc=1%5B/url%5D

Sorry, must be being really stupid here. Charlotte, I can’t find solutions9.mdb on either of my office cd’s, and can’t find anything in the rptsmp to help either, although did find a useful example of creating an index, which I shall have to look at more carefully (BTW, how would I have found out that the answer might have lain in either of these places – I’d obviously tried online help and newsgroup and KB searches before I posted here, with no hits).

Francois, I don’t think I can have explained properly what I need to do.

I have a PAGE header, repeating on every page, then Group2 header, repeating on everypage (group2 usually spans about 50-70 pages), then Group1header, detail and group1footer, all kept together and usually spanning about a third of a page, then the Group2footer, which starts on a new page and spans 10 pages.

What I would like to do is change the PAGE header for the first page on which the Group2footer is being printed. Any format event associated with the group doesn’t seem to fire at the right time to prevent the first page of the group footer containing the unmodified page header.

If it helps to put this in context, the report is a list of families in a region. Group1 is the family group, with Group1footer containing a number of rows with UID’s and families filled in for handwritten additions to each family, and each group2 is a subregion (one field team), with group2header being column headings for all pages, and group2footer being 10 pages each with 10 new slots for family members for completely new families to that subregion. The page header contains the name of the region, the subregion, a page count, and the first and last households on that page. This last feature didn’t work properly for the group footer, so I want to hide it with a box in the page headers of every page the group footer is printed on (or actually replace it with a box saying New Family X). As I’ve said, I can get this to work for pages 2-10 of each group footer, but not page 1.

Clear as mud, I know. Hope someone can understand.

At this rate, with only 45 subregions, I’ll be reaching for the Tippex soon.

Ooops. Looks like my post was made a little redundant by the much more erudite simultaneous post from Wendell!

I still got the same results, but that was helpful too.

Thanks for the instructions on using the find duplicates wizard. I have to say I found the running instructions unhelpful in helping me decide what I would actually get, the online help totally useless, and trying to play around with the SQL statements (with Access’s usual lack of help on SQL) also frustrating.

I’m sure your suggestion did get to what I want (looking at the SQL statement as well), just there’s something wrong (or at least unexpected) in my data.

So yes, you did help! Thanks

Sorry, I don’t understand why you don’t just have your subform as text boxes (you could set all the data validation on a the default text box and then drop them all onto the form), and then, if you want to rapidly go a particular answer, have a combo or list box to direct you.

Have I missed your aim?

PS – Dealing with medical records. Good luck to you mate.

Thanks Francois,

That works to keep the controls together, but, as expected, as soon as I jump into the subreport I can no longer access Max([Household Number]) – all expressions involving this, however explicitly referenced, resulting in an error. I could try and link the subreport to a series of calculated values for Max([Household Number])+1, +2 etc, but it’s not clear to me that this would work either, as it would be a many to many relationship. Even if it did work, there would be a large overhead involved, as the villages have between 60 and 300 households. That’s a big table for a dummy!

Ah! Maybe I have it. Seems to work with using a label for household number, your tabledef for familyID and putting

lblHousehold.Caption=Str(rptVillage!txtMaxHouseholdValueHolder+FamilyID)

in the on format event of the subreport’s source report.

Now lets see if this continues to work.

Thanks