Search results

I have a client file that has a BranchCode (Numeric) I have an open login form for the operator and when they log in their BranchCode they are related to is placed in a variable. I only want to display client records related to a branch code 7 if the operator belongs to Branch 7 Otherwise I...

Thanks everyone for your input. Thanks PBaldy - it worked CStr(Me.SendToEmailFld) :)

To Pbaldy, Not sure what you mean by the form reference - Which line Atrium

Yes SendToEmailFld = "silly@sam.com" (just a test email set up for this example) If I substitute "john@abc.com.au" for Me.sendToEmailFld it works perfectly? When it gives me the error and I select debug and move my cursor over Me.sendToEmailFld it has "john@abc.com.au" in it ???

We have upgraded from 2010 to Access 2016 and my email routine is not working. Getting a runtime error - 2147417851 (800 10105) Methos ".To' of object - _Mail Item Failed This is the code I have been using in 2010 Public Function SendPDFemail() Dim strEmail As String Dim strMsg As String...

Thanks for you input guys. I found the problem. I was changing the contents of a bound field which happen to be the client name. changed my field to an unbound field and all processing is perfect. Tested it about 20 different ways with mulitiple and different clients without errors. I actually...

The user can get to the Matter via 2 ways 1. Open the Parent (The Client) and select one of the related Matters that are listed in a tabbed subform on the Client form. The Client Form remains open and the Matter form appears on top. 2. Or they can search for the Matter directly to display the...

I have a project where I have Clients that have one to many Matters. When I update a Matter belonging to a client all seems OK and when I go onto the next Matter connected to another Client the second Clients name is now the same as the previous clients. Am I failing to clear out some variables...

Welcome Matt! This forum can be a life-line. There are so many talented people out there that are willing to help with any access issue

I have three variations of the values of Me.ClientIdFld and Me.MatterIdFld They are : 0,0 where I want the RecordSource = "APLoginActionTasksQry" 1,0 where I want the RecordSource = "APClientActionTasksQry" and 1,4902 where I want the RecordSource = "APMatterActionTasksQry" The values 1...

I have been using the Form_Load event with the following code. The Values of Me.MatterIdFld and Me.ClientIdFld are set using openargs and their values for this exercise are 0 I have tried using the code using the Form_Open event Dim strOpenArgs() As String If Not IsNull(Me.OpenArgs) Then...

Thanks heaps pbaldy all I needed was a push in the right direction. Used the File Copy and all is well Feel a bit of a dill for not thinking about it more clearly Thanks again:

I no longer have the problem. I no longer rely on the form variable. PROBLEM SOLVED Thank you to all those that gave it some thought' atrium

I need to use some vba to move a value into a bookmark during a merge operation with a word document in access. I can check if the bookmark exists on the document during the merge but I'm not sure how I can move a value into the bookmark The value I want to move in comes from a form variable. I...

Thanks Stopher your experience sounds just what I want - trouble free. Did you have any planned strategies when migrating any of the objects. I was thinking of creating a small version of our project and starting with that. Thanks again for your followup Atrium

I have a client document library created that holds an entry for each document created within the system relative to a client. I save the created documents outside of the database on another network drive. I also have the option to Add any other file to the Clients Document Library and...

I have saved pdf files and I need to use vba to print them, I have been able to do it for word and Excel but I haven't found any code to do it for PDF's Can anyone help please Atrium

Thanks Arnelgp, worked perfectly Thanks again

Thanks Arnelgp, I'll give that a shot Regards Atrium

I don't have any problems using the 'running sum' property But I'm having trouble trying to initiate the running total field with a opening balance. I have introduced the Opening Balance and displayed it in the header and called it OpeningBalFld. I have a CR, DR and a Balance heading in the...