Search results

Hi I am using an extra PC & want the PC to stay awake while it runs a query. I thought I'd get the computer to hit the keyboard letter 'A' after 5 minutes to make sure it doesn't go turning off the monitor using the 'Sendkeys' method. So I've got a repeating timer procedure but I'm unsure...

OK, Ive got a couple of questions; I'm trying to understand what you're macro is built to do. If you start this code from the Start_Macro procedure, you are declaring the 'flag' as False, you then call the 'Rerun' procedure. 'Rerun' procedure runs 3 seconds from when it is called Rerun...

They are unbound controls (TextBoxes) that sit on the main form. The Click & After Update event on the subform textboxes passes their value (Number) to these textboxes & other subforms read them. The form & all subforms operate perfectly apart from this annoying behaviour, I can live with it...

Hi VbaInet No, no requerying happens. Just the pass value code prompts this behaviour somehow, if I remove this pass a value code, it behaves fine.

Hi sunshine076 To answer the question - Yes. You should be able to write a Select Case statement (or series of If Then Elses) that change the change the Visible property to True when the focus is on a certain cell containing the word.

Hi rsford31 I ran that piece of code & got an error on saving as. The yellow highlighted line of code couldn't run so your error is about the 'save as' line for the csv file. When I ran your code, the error I got was due to the csv workbook having more than one worksheet. (csv doesn't like...

Hi I have a form (main) containing a subform (question) with 2 text box controls (Q_1 & H_1). On every Click & After Update event on either of these textboxes values are passed to textboxes on the main form, these values ensure other subforms select the correct records pertaining to the...

Thanks to both for your help! It works fine, didn't know it was that easy, Cheers :)

Thanks ChrisO & GalaxiomatHome GalaxiomatHome, if I used the option to enter the path in a table in the db, wouldn't I need to add the UNC path name & not the normal path "G:\...." etc as it would fail? The db currently isn't split, it just sits on a shared Network Drive & if I add my path...

Thanks ChrisO I'll give it a try tomorrow at work, have you tried this successfully yourself?

Hi I have some modules that send Access Text to several Powerpoint presentation templates & I need to have all users be able to access these Powerpoint files. In the code, I've set the path as a Network drive path "G:\FilepathName\Filename.ppt" etc but this won't work for other users as they...

Hi I'd like to know if anyone has the actual answer to selecting a record from a form on a subform that sits within another form. Does anyone have the actual code answer to this? Pls check the last example db I've posted - I need to click on the 'tick' symbol of the 'frm_search' & have that...

Thanks I've seen that form & what I've got from it & other sites is that to reference a subforms control, use Forms! first, the Form you want to Open second, the container subforms name that the control in held in third & then the control name, hence; DoCmd OpenForm "frm_main" ...

Hi I have one more part to this question that I'm stuck with. Here's the code for the 'tick' control on the 'frm_search' form The other 2 forms, 'frm_main' & 'frm_project' are setup as the 'frm_main' with the subform 'frm_project'. I want the selected (tick) control on the 'frm_search'...

Here's the working example in case anyone needs it. Cheers

Hi vbaInet I posted a stripped down version on the first post & when I use your answer in this db it works fine. I think I need to look at why this isn't working in the full version (ie; what different), so thanks for your help & patience. : )

Yes the frm_project form has a Request_ID field & I've now commented out the Request_ID = Me.Request_ID line, still no record brought up on the frm_project form?

OK, so now the code reads as follows without the recordset lines; ---------------------- Private Sub cmd_Select_Click() Dim Request_ID As Integer Request_ID = Me.Request_ID DoCmd.OpenForm "frm_project", , , "Request_ID = " & Val(Me.Request_ID) End Sub...

Thanks vbaInet I've changed that line but am getting an error with not finding the frm_project form. ----------------------------------- Private Sub cmd_Select_Click() Dim Request_ID As Integer Dim rs As DAO.Recordset Request_ID = Me.Request_ID Set rs = Me.RecordsetClone...

Hi I have a db with 3 forms, main, project (a subform of main), & search (which has search results of the 'project' forms records). I need to click on the 'tick' cmd button on the search form & select that record from the project form (which sits on the main form). I've attached where I...