Search results

Thank you I thought I would have to use 'And' but I wouldn't have known you had to declare a variable

Hi I decided to use the first way where you only see one record. I currently make it open to a Time Reported field which will be unique for everyone. However I wanted to know if its possible to have two fields for the restriction to be based on. Just incase in the rare circumstance that two...

Thanks nice website btw What I was trying to do before was "my email"; "another email"; "yet another email" I didnt realise it all had to be in the quotes

Hi How do I add multiple recipients to the '.To' line in the code below? Dim appOutLook As Outlook.Application Dim MailOutLook As Outlook.MailItem Set appOutLook = CreateObject("Outlook.Application") Set MailOutLook = appOutLook.CreateItem(olMailItem) With MailOutLook .BodyFormat =...

Thank you. I just put the break point in and it said the value is null. I then realised that it was null because I had the code after DoCmd.GoToRecord acActiveDataObject, , acNewRec So txtDeperaent was actually null I changed it so that DoCmd.GoToRecord acActiveDataObject, , acNewRec was...

Hi, I have used the code below to send an email automatically when a new record has been created. However I recently added the If Then statement to the code as you can see. The problem is that the email wont send because it says "There must be at least one name or distribution list in the To Cc...

Thanks both of you, you both suggested the same thing but I used the link that pr2-eugin suggested

I have a continuous form that is based on a query. I would like to have an open button so that you can select a record on the form and that particular record opens up in a new form. How do I do this? If this cant be achieved would I be able to make a form open that shows a particular record...

Thank Wayne that was what I needed and thank you brian and jdraw fr trying to help solve my problem.

I use this 'WHERE ((OperationalRiskEventTable.DateReported)>=Forms!U pdateForm!UDateBegin And (OperationalRiskEventTable.DateReported)<=Forms!UpdateForm!UDateEnd)' in a query by form. The problem is that you have to enter a date in the between values for results to show. If I don't enter...

Thank you very much, it now works. Ignore what I said about the second option, at first I didn't realise that what you were describing was what I was doing.

Hi Brianwarnock would you be able to elaborate on the second option because maybe it would be better than the first option for me? I tried to do what Brianwariwcik told me to do in his first postbut I don't think I done it correctly because now every single record shows no matter what I enter...

I will try what Brianwarnock suggested and then reply telling you if I got it to work. Cronk yeah the error message was due to having a calculated field. I understand that I am using the first option and that nulls will return but it is not much of a problem for me. I didn't fully understand the...

Hi, I have a query by form that has the criteria Like [Forms]![FormName]![ControlName] & "*" for each field. However the problem is that if one of the records have at least one blank field then the whole record wont show up in the query results. For example if there is a record with Fullname...