Recent content by vaiamo

No, it is not a split database and none of the literature I read before doing it mentioned that though that they may have thought it was common sense. Though thinking about it, if you have it split and are not synching the frontend then how do you pass on any changes that need to be made to...

Hi - First some background. A few months ago I replicated an Access 2003 database so that folks in various locations could all enter data. There is one master and 3 copies. One of these copies was operating on a computer with Access 2000 and it also happened to be the copy of the database...

Quote by Pat Hartman >>>BTW, one somewhat undesirable thing happens when you go with replication. Access changes ALL your autonumbers to random instead of sequential. That means that from that time on, all new autonumbers will be assigned randomly to minimize the problem of conflicts between...

Hello All- There may be a very simple fix for this but I'm very new to the code world and don't completely understand what's going wrong. I have a data entry form in a survey-like database. One subform is used to enter in responses for each of 12 criteria (equivalent to "questions"). The 12...

Yes I see how its not really puzzling at all that this problem is occurring. I guess it goes back to my design but I have gone over it and over it a million times and even posted questions regarding it on this forum and this design seems like the only way to work it. Basically the MainForm...

Hello- I'm puzzled. I'm trying to have a data entry form with a simple form and subform layout. The table that the main form is based on has one field, an autonumber field (call it animalid) (it serves as a cataloging table- assigning a unique id and is related to several tables) and its...

That worked like a charm in putting zeros in the blanks but I'm still missing region 1 under the agriculture category completely. How do I get it to show up in the queries with 0's in each of the 4 quarters. It looks wierd to have Region 1-5 in one category and only 2-5 in the other.

Hi! I have searched the forum and can't find anything that totally matches my issue. I've downloaded some code to try but it seems like it should be a simpler problem/fix.... I am creating 2 queries on which to base a report on. First a select query which I then use to create a crosstab...

Thank you Thank you Thank you! Lots to digest. You all are fabulous. Stephanie

Thanks for the reply and willingness to help! I've attached a slightly better image but its a .snp (snapshot) format which I'm not sure if that's a universal format or not. Hopefully its better--Is there a way to attch things bigger than 100kb on this forum? Anyhow: 1. Thats the hunter...

Hi! I have a problem with tracking unique ids through several tables in a database. This a DB that I am modifying which all ready had existing data. These unique ids are unique animals that can have several things (4 in 2 general categories) happen to them. 1. The first 2 in order to have...