About Rob Henderson Expertise I can answer most MS Access design questions. I also welcome questions on database design and implementation and VBA programming questions.
I also have expierence in application design for all the Office components (Excel, Outlook, etc).
Question hi there im mitch im learning access but still a novice
i use XP (sp2) and office 2003
you helpt me before and now im back
im realy getting hooked to access
my 2 questions are these
im making a data base which is about video files
and mp3
i have 2 tabels both have ther own form
the to form are linked so that if you press a button on form 1 you get a sub form with more info on that record
the way the form recognice each other is becouse they both have a unnique hyper link to the file in them
this is wher im im stuck i want this
when i make a new record in form 1 and paste a nem hyperlink in it
i want form 2 to also make a new record that has the same record
i tried working with update and append query's
but i am doing somthing wrong
in the best case it keep adding and adiing no matter if the record is all ready there
what im i doing wrong wat should i doe ??
question 2 (other data base)
i have this tekst box and if i double click it it opens a form if come so far
but now it again has to open a form that is linked to the record that is curently open
if i do this withe a command button you can select wich fields must be the same in order to openm the richt record
how do i implement this action in to the dopuble clickin a tekst box ???
what i did is in the double click propertie i made a "open form" macro ....
thanks in advance mitch
Answer Hi
Q1
You could use an APPEND query to grab your information and append it inot your new table. Look at the Access help file for an example of an APPEND query.
Q2
Can you give more information as I don't understand the question.
