Thanks Mary, I have it working now!
Nicola...
Imicola
Last Activity: Sep 4 '07, 09:38 AM
Joined: Feb 27 '07
Location: Edinburgh and Southampton
-
Back up access db to external hard drive without replicating
Hi,
I recently got an external hard drive to backup all my files. The easiest way it seems to synchronise between my desktop computer and the backup files on the external hard drive is to use Microsoft briefcase, but this then makes a replica of the database - which is not what I want.
All I want is a copy of the most recent version of the database as I develop it, but to do the sychronisation manually seems a bit time... -
Command buttons to add related records
Hi,
I have seen very similar questions which have not really helped me, so thought I'd better ask for some more help.
I have a form called fsubAnimalDetai ls(which holds data on animals sampled, with the PK anmAnimalID)
What I am trying to do is put a command button on fsubAnimalDetai ls, which then opens another form frmAnimalSample s, and then details all the different samples taken from a specific animal... -
Ok thanks.
I wasn't going to use text in my IDs to begin with, but then discussed my database with a colleague who suggested it might make it easier for people analysing the data at a later point as they will be able to see easily which table the data is coming from.
I think that I will just stick to a normal autonumber, as by adding text to it seems to just confuse matters!
I have worked with databases...Leave a comment:
-
Using Autonumber Primary Keys with text prefixes
Hi,
I want to use primary key IDs in my tables which are autonumbers, with a text prefix. I.e. for table tblVillage, the ID's will by V1, V2, V3... and for table tblHumanCases, the ID's will be H1, H2, H3...
I have a few questions:
1. I have heard its not good to do this. Is this true and if so why?
2. I am also having problems creating the relationships to related tables due to the field... -
Thankyou so much, it is working now!
NicolaLeave a comment:
-
Hi, thanks for this.
I'm still struggling with the code though as I have never ever used code before!
What I have is, for example,
tlkpCountry which has the country information
CountryID
CountryName
tlkpRegion which has the region information
RegionID
RegionName
CountryID
The code I am trying, which could be totally wrong is:
...Code:Private Sub Country_AfterUpdate()
Leave a comment:
-
Dependent listboxes on access forms
Hi,
I've recently been tasked with developing a database to store data which has been collected by a lot of different people. I have quite alot of access experience, but not that much on database development, so I'm learning quite a lot as I go along.
My problem is that I need to keep information about locations. All the data we have has been collected in different villages. Each village belongs to a Parish, each...
No activity results to display
Leave a comment: