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 sorry rob i dont know any more how to beter explain to you what i mean
last try
with a command button you can open a sub form and only show the a selective part of the data
to do this it ask's you which field in form 1 and the sub form are the same
(the wizard does al the work basicly) now i want this function to be activated when i double click the text box (instead of using an ugly button)
as for my previous question one
i did the lesson on append query (again) but it doenst explain me wat to fil in in the criteria if i only want to ad the new data
it like this i copied de data zo boths tables are the same
i start using my data base and new entrys come in
now i want to ad the new data that has been enterd in table to go to table 2 (this one already has the old and i only want to put in the new data) how doe i do this ??? note dat de data thaht has to go from 1 to two are hyperlins
sorry for the time im causing
if you still do'ny under stand than
thanks any way for your time (the problem with explaining is proberbly that im not englisch)
-------------------------
Followup To
Question -
hi ther thanks for the fast answer
oke the thing i did is in q2
if you have i have a tekst boxes in my form that display info from my table
if you go tho properties of the tekst box
and go to the event tab you can enter actions to clicking and double clickin etc.
now what i did is a made a macro that opens a 2nd form
i placed this macro under double clicking
so now if i double click the text box (in form mode) it opens the form
only it needs to open the form at the right record
[if you would do this with a command button you get a sreen asking witch items in the main form should be the same in the sub form so that it opens the right record]
now my question is wat do i do so that my double cliking action does the same
thanks again
-------------------------
Followup To
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.
Thanks
rob
Answer -
Hi
Have I go this right?
You want to open a form based on the current record in the current form by double clicking the text box?
When this second form opens you want it to open on a specific record?
rob
Answer Hi
I think I may have it now.
You want to move your macro action from the command button to the double click event of the text box?
If so, simply delete the command button and then click on the text box. Select properties and then the EVENT tab.
Go to the On Dbl Click and insert the macro name in the space provided.
As for Q2, what is the relating data between the two tables? You'll need to identify this before you can automatically open on a specified record.
