Search results

The following code throws up no errors, and should copy a file in location ( strpath ) to a different location ( strDest ) With wdApp .Documents.Open strPath .Documents(strPath).Activate strDest = "E:\New folder" & filnam .ActiveDocument.SaveAs Filename:=strDest...

Thank you to both contributors. There are some useful pointers in your responses.

I found the following code snippet, on an Excel VBA web-site, which I'm sure only needs some slight modification for use in Access. I'm getting an error on the method '.GetOpenFilename' associated with Application, ( for parsing the selected filename it appears, to a declared string variable...

Thanks for your interest pr2-eugin. I've now got the proc. working. I renamed the Command button ( by changing a couple of leters, then pasted in the code from the non-working, On_Click event ( for the same control ) this seems to have 'jogged' it into life. Thanks again. I'll need to be more...

that seesm to have been the 'sticking point' ( bad paramter use for proc. ) That's cleared up now, but one of my command buttons is not doing anything - I've put a breakpoint right on the Click_Event firts line of code, and eevn that doesn't get triggered ?

Thanks for the pointer pr2-enguin. You may be on to something. I've just added a proc. for opening a word document, with params. Let me run a couple of deductive tests around this.;)

procedure declaration does not match description of event or procedure having the same name. I'm getting this error, on Command buttons, which worked perfectly fine recently. I've not changed the Click event code, or name in any way, yet this error persists. Any ideas ?? Thanks.:banghead:

That's terrific pbaldy. Thank you, it works perfectly now.

The following line of code is triggered in a click_event on a subform. I know the syntax is correct, but it prompts me for a parameter value ( the value I pass in the 'WHERE' clause i.e. Crefid ) DoCmd.OpenForm "tblReferrals", , , "Referral_ID = " & Crefid When I type this in, it opens as...

I have an attachment field, for each 'Referral' we process. In it, go various .doc and .pdf files related to that particular record. The method of attaching these files to a given record, is to click on the relevant Attachment control ( paper clip ), and selecting the relevant files, then...

Once again Bob, you've been a 'godsend'. Works perfectly. The logic seems to be, that the 'hierarchical' command treats a subform and Main form in the same way for ordering. Thanks.

thanks boblarson, but I've read all those. I'm not explaining it well maybe. Imagine I don't have any Navigation Controls 'holding' my Main Form and subform. I can retrieve values from the main form, no problem, but it's a field value from the subform ( subform in the old sense of the word...

I'm having trouble referencing acontrol. Any advice much appreciated. Here is what my VBA reference would be, if I just went down through the 'hierarchy' using full-stops to get to the form with the value/control I want... With...

My sincere apologies. I've now overcome this, ( it helps if one adds a recordset.Movenext IN a loop, when going through a recordset - using the Do While Not(recordset.EOF ) and Loop - lest it becomes an infinite loop ) which is exactly what caused this 'lock'. Thanks for your interest.

That works well, but I can't figure out, how to pass a vaule from a field on a subform of that Form i.e I have a subform on the last Form referred to in your command Forms!frmNavigationLeft!NavigationSubform!NavigationSubform!sfrmReferrals.Referral_ID I have put a field, which is on the...

Thank you for your prompt and helpful response.

Is there a reliable reference, for referencing 'subforms' values/controls therein. The following doesn't work If Forms!frmNavigationLeft.Form!NavigationSubform.Form!frmClients.Cnam <> "" Then As you can see I'm trying to check a Public variable (Cnam) on a subform. I have a navigation form...

When I select an item in a combo box, it 'locks up' the whole form. I've tried putting my code, from the On_Click into the On_Change event. It updates a recordset/table, when item is selected - all standard stuff... or so I thought.:confused:

It IS Normalized, but I can't select these 3 pieces of related data, with the rest of the main form's recordset, as they are in seperate tables ( and selecting data from more than one table, makes the recordset READ_ONLY i.e not updateable ) This is EXACTLY which I have had to go to these...

I have 3 combo boxes, which are all output to, from a For ... Next loop. Here's the code - For i = 0 To 2 Set rst = db.OpenRecordset("SELECT " & tbl(i) & fld(i) & " FROM " & tbl(i) & " INNER JOIN tblPersonalInfo ON " & tbl(i) & fld(i) & "_ID" & "= tblPersonalInfo" & fld(i) & "_ID" & "...