Search results

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...

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...

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...

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...