Search results

I finally found a simple solution to this. It is a simple switch to the last line of code as I thought. Private Sub image5_Click() Dim sWHERE As String Criminal_Background.Value = "Yes" ''If the ID is a number, built the WHERE clause like this: sWHERE = "[ID] = " & Me.ID 'Open the form...

I am not sure what you mean by "Who is making the call"?

Thanks for the reply here4real. I am going to be honest I am a little lost when looking at your code. I can muddle through most code but I am not following what you have going on in this code. Is it possible to replace: Me.Criminal_History.Setfocus with [FormA]![Criminal_History].setfocus. I...

Hi all - I have a from that has information icons that opens a separate form to help users make the right choice on a form. With each information form users are able to choose "Yes" or "No" and then it returns them back to the form they started. I am great to this point however I am having...

You are a life saver!!!! Everything works like a charm!

Thanks pbaldy!!! so far everything is working great. I am only having issues with getting the break line between the paragraph, hyperlink, and paragraph. The code only seems to add a space but not add a "return" in order to create a blank line of text. Any suggestions?

Is there s simple way to convert hyperlinked emails to text? My fear is that if I do this they will convert but will include the unwanted #s. Is this true or am I overthinking it?

I do use hyperlink data type...this I in place because the users like the ability to click the email in order to send an email from other forms that does not have a specific message attached. If I simply type www.website.com where you have "hyperlink" will this automatically create a...

I am trying to create a form with a button attached to each record that would allow the user to click the button and it would automatically open outlook and fill in the TO:, SUBJECT: and BODY: fields. I am very close to this but I am running in to a few issues. Here is the code that I...

Perfect!!!

This is moving in the right track. I unfortunately can not get the Undo command to work. I have used the following: DoCmd.RunCommand acCmdUndo and Me.LASTNAME.Undo The first option brings back an error message and the second simply does not undo the correct. Any suggestions?

Hi all! I have a database in which users have the ability to search by last name...nothing fancy there. However, the users continue to forget to click the Find Client button and instead just type what name they are looking for in the LASTNAME control thus changing the record that they are...

I have made some adjustments to the code and it is now working one way. Meaning from FormA to FormB it will find the client information but from FormB to FormA it will not. Any suggestions on how to remedy this issue? FormA and FormB on Active event Private Sub Form_Activate() Me.Requery...

Thanks for the replies! I am new to this and trying to figure out the best way to maintain the database along with my actual responsibilities.

Currently the system where I work is set up so that everyone has their own front end on the local network. I would like to change this because updating all of them takes a lot of time for me and skill level for users is too low for me to trust them with updating it on there own. My question...

I continue to get invalid argument when I use .FindFirst(GetId). This is my first time using it so I am probably omitting something important, here is the updated code: Private Sub Form_Activate() Me.Requery With Me.RecordsetClone .FindFirst (GetId) If .NoMatch Then...

I keep getting Run-time error '3021': No current record. I have tried your code Royce and it is not working. I have tried to combine the two pieces of code and came up with this. Private Sub Form_Activate() With Me.RecordsetClone If GetId > Me.ID Then Me.Requery Else Me.Requery...

Thanks for the reply! Your solution is the closest that I have come. The only issue I am encountering is that because it is looking at the record no it is finding the record no on the next form. The problem with this is that names change record no position because of the querys that the forms...

I am not familiar with the get, let properties. Where are they located and how do I use them?

My problem seems simple but I have a feeling this is going to be a bigger issue that I think. Lets say, Form A has fields: ID, LN and FN ID LN FN 1 A F 2 B G 3 C H 4 D I 5 E J Form B has fields: ID, LN and TR ID LN TR 1 A Y 2...