G
Guest
Ok, here's one for you guys that should cause a few heads to be rubbed.
I just got this database dumped on me by my boss that a previous employee
created. While I am pretty good at databases, I am not good at VB codes.
This database deals with tracking advertising campaigns. On a daily basis,
there is a form that has data entered as follows:
Advertiser Carrier (Cab, Bus, Billboard, etc)
The Advertisment (Continental Air, Elle Magazine, etc)
The Previous Advertisement (See notes below)
Date Advertisement Installed on unit to display
My boss wants to set this up so that once whoever is doing data entry enters
the advertiser carrier (these are all uniques by ID) the the field for the
previous advertisement will automatically populate with the last posted ad
campaign. This will not only reduce data entry time, but act as a quality
control check, verifying what is submitted by installers of the campaign ads
to what is in the database.
Someone told me that I would have to create a module for this, and that even
then it may not be what I want. Someone else told me that there was a
function you could do in the form that would create the desired results, but
couldn't remember how the procedure went.
I am using Access 2000 SP-3.
I really would appreciate input and assistance from you gurus out
there...that is, unless I have you all stumped!
Thanks
I just got this database dumped on me by my boss that a previous employee
created. While I am pretty good at databases, I am not good at VB codes.
This database deals with tracking advertising campaigns. On a daily basis,
there is a form that has data entered as follows:
Advertiser Carrier (Cab, Bus, Billboard, etc)
The Advertisment (Continental Air, Elle Magazine, etc)
The Previous Advertisement (See notes below)
Date Advertisement Installed on unit to display
My boss wants to set this up so that once whoever is doing data entry enters
the advertiser carrier (these are all uniques by ID) the the field for the
previous advertisement will automatically populate with the last posted ad
campaign. This will not only reduce data entry time, but act as a quality
control check, verifying what is submitted by installers of the campaign ads
to what is in the database.
Someone told me that I would have to create a module for this, and that even
then it may not be what I want. Someone else told me that there was a
function you could do in the form that would create the desired results, but
couldn't remember how the procedure went.
I am using Access 2000 SP-3.
I really would appreciate input and assistance from you gurus out
there...that is, unless I have you all stumped!
Thanks