Search results for query: *

Here's how it unraveled, in case someone else has this problem. The system file was corrupted, probably by my hung import. Replaced it with a backup and all was well with the old dbase copies. Rejoining original workgroup (saved as per excellent instructions) and revoking permissions from...

I hope someone can help me find the end piece to start untangling this mess. Today I began moving over my multi-group secured, replicated dbase to a new platform in an attempt to leave behind some corruption. We're using all the built-in tools for these two procedures. No server, using...

Dwayne, I did run into some difficult with that code. Figured out where I think it goes, believe I've substituted the proper field name in the proper way. Here's what I get: IN YELLOW TYPE: Private Sub PageFooter_Format(Cancel As Integer, FormatCount As Integer) END YELLOW TYPE Dim i As...

Thanks, Duane. I have a follow-up question for you. I'm not a programmer, and am unsure where to place this code and how to get there. Sometimes I will carefully drop a piece of borrowed code into VB if I have clear instructions. (Thank goodness for long-ago Basic and Paschal classes so I'm...

I'm working on a transcript format that will be run for an entire class all at once. The query-based report contains: 1. A Page Header with school contact info 2. A detail record with the student's personal info and a subform that contains the class information 3. A page footer that contains...

I forgot to say that we repair and compact about once a month. After this latest episode we're on an every-other-week schedule. We shall see if it helps. Prognosis? S

I'm running a large, replicated, permission-secured system that serves three programs, and is based on PCs. No server in-house, we're a small nonprofit and try to keep it simple. We occasionally note that data has been "lost." For example, a user puts in a set of birthdates for new staff...

I have successfully imported the deleted record from a backup copy. You'll need to import it to a dummy table first, then append into your live table. Worked fine for even a non-programmer using the visual approach. My sympathies, I've been there in the days shortly before we created our...

Have you tried a pivot table? You can organize by months that way as a built-in function. Good luck! Susan

Glad this thread is up, I've been considering doing this for a while now and have a similar learning curve ahead of me. Can any of you who have a front-back setup please tell me how much of a pain it is to replace those front ends when you make changes to objects? I have about 15 users in two...

Gemonom, I get enough of that stuff at home from my almost Phinished theoretical physicist DH. Not here, too! I bet you've also watched Star Wars and calculated that the mass of the Death Star isn't great enough for it to generate its own gravity. I've grown accustomed to that kind of thing...

The strangest thing of all has happened. I went to recreate the missing field using the same name, and was told that I could not redefine that field. ("help" was no help, suggested I'd maxed out 32 indexed fields, not the case.) Then after I created a different field name to temporarily hold...

What you want to do is click the cursor in the client number field and then hit the search spyglass icon to search for that number. (Or ctrl-F for Find) Simply entering the number into the form is creating a new record, as suggested above. If it's an autonumber field, it won't let you do...

That is a good idea, Hakala. I don't have a copy of the current creature here at home, but tested this on an old copy. Hiding the field didn't remove it from the field list in the design, nor did it create a warning tag on the field in the form. My poor missing field is both absent from the...

All tables are internal, and all current replicas are missing the field or it would have been blessedly easy to snag it from there. I'll be darned if I know where the data that appears on the form is "living!" Are you suggesting that there is a hidden copy somewhere? Intriguing. Please tell...

A field in our main table has suddenly disappeared. It no longer shows in the design list, or in any other field list in queries, etc. But strangely, the correct data does show when viewing the field in a form. Design view/properties claims that the control is invalid, yet ghosts of my data...

Hi, I'm waiting for my authorization to make my own post- may I piggyback here with another replication question? When I try to view conflicts with the Replication Conflict Viewer, the button won't bring anything up. I see from the FAQ that all sorts of wonderful things are supposed to happen...