Search results for query: *

I have a subform "frmEventsSub" as part of a mainform "frmeLogbook". From the main form I want to run a code to change the Recordsource of the Subform lets say from "query1" to "query2". I tried all different kinds of combinations to adress the RecordSouce of that Subform but I always get an...

That's the way I did it, but I wanted to avoid having twenty times this Sub Text1_Click ExecGlobalClickRoutine End Sub But I thought there is an way to sort of ignore the control click and execute the form click instead. Never mind anyway. Thx very much for taking your time.

Sorry for not being more specific. What I want to do is following: Everytime I click on one of the textboxes I want to run the same Sub. So in order not to put the same sub into all 20 txtbox1_Click to txtbox20_Click I thought I can give the Form click priority over the control click then I...

Hi all, I have a form with lets say 20 text boxes txtbox1 to txtbox20 and I would like to run the code under Form_Click or detail_Click instead of running the code for the control event. Does anyone have an idea hoew to do this Thx

Thanks for the posted link. Very much appreciated. Tom

I would like to do my own CD database in Access and therefore I need to read the file (tracks) - information from the Audio CD's in the CD-ROM drive. I want to read out the title and the time (length) of the song. I did not find anything in the forums which comes close to reading information...

Hi, I have a problem to open a form from another form by setting the Filter for the form to be opened. I want to open that form lets call it formB which depends on two variables 'songId' and 'songOffset'. I am using the following code in the form Load event of formB for one variable...

Hi Tony, Thanks for your help. I thought I had ticked the Object Library but apparently I hadn't. yesterday after your first post I was trying to find it again but I could not remember where to look it up and tick it. So again many thanks for your help. It will certainly make my users happy...

Thank you for your advice. I have been trying this before but it gives me an error that variable:wdGoToBookmark is unknown. Dim appWord As Object Set appWord = CreateObject("Word.Application") With appWord .Documents.Open Filename .Selection.Goto What:=wdGoToBookmark...

Thanks for your answer but when I try "Dim appWord As Word.Application" I get a compile error: "User deined Type not defined". I understood that it does not recognise the type Word.Application. Is here a way to teach Access that it should know about this application type ...

I have a Access Form which creates and opens a Word file via a Hyperlink.Follow command.Before the user enters any data in the Word file I ant to update certain areas (bookmark in a table) of this word file. I've been trying for months but I can't figure out how I can write data to a bookmrk in...

In Access I create a MS Word file by copying it from a Template then I open it with a Hyperlink (Follow...). This works fine. Then I would like to update some bookmarks in the new MS Word Document but I don't know how to do it. I already tried something like Dim appWord As Object Set appWord =...