Recent content by shaunacol

we have a 2016 MS access database thats a few years old it currently links to MS outlook and picks up some details such as email address and some detais from inside the email. The client now wants to use a new tool to bring together their outlook emails with other messages (like fb). This new...

I just tried Me.SubAdult.Form.available = 0 and it works! thank you thank you thank you!!

And ive even changed the subform name to be the same as the source object as I was worried about that, so they are both now SubAdult. But still get this error.

That's correct, the subform control name is "SubAdult" and the control name within that subform is "available". Can you see any reason why this doesn't work please? I'm at the end of my tether with it...

I am sure I must be doing something silly...I am just trying to set the value of a control in my subform to false (the code is embedded into my main form behind a button). I have tried numerous different syntax.... putting into square brackets, round brackets, referencing the subform directly...

I am sure I must be doing something silly...I am just trying to set the value of a control in my subform to false (the code is embedded into my main form behind a button). I have tried numerous different syntax.... putting into square brackets, round brackets, referencing the subform directly...

Thanks so much. Yes the emails are always exactly the same format. The problem I can foresee with these string functions is that they seem to require me to specify the exact number of characters. I'm not sure how I can specify that when I don't know how long or short the customer name is...

I have linked my MS Access 2016 dbase to my Outlook and the table is working. I now want to extract some information from the content of the emails. An example of the email is below. How can I extract the customer name, number of tickets please? Its been a few years since I programmed and am...

Hi I am OK now thank you the code below worked. Many thanks for the advice: Private Sub Status_AfterUpdate() Dim strSQL as String If Status = 4 then strSQL = "INSERT INTO Tbl_IF (ready) VALUES (true);" Elseif Status = 15 then strSQL = "INSERT INTO Tbl_viewing (ready) VALUES (true);" End...

yes it is selected but looks as though its a system error as i thought and printer needs reinstalling

Yr right, i will need to insert the ClientID in there too. It is so that when they choose a status of 'book flight' then the flight table gets a blank field ready for the admin lady and it pops up in her list ready to be booked, hope that makes sense.

I have just been into the trust center and added my own desktop as a trusted location, hopefully it will work! The thing that confuses me is that I assume I have to now add everybodys desktop location separatley? I am not familiar with how they have all been set up and am not currently at...

I am using MS access 2010 and would like to append a value into a table, i looked up the format but it does not work Private Sub Status_AfterUpdate() If Status = 4 Then INSERT INTO Tbl_IF(ready) VALUES (True) Else If Status = 15 Then INSERT INTO Tbl_viewing(ready) VALUES (True) Else: End If...

Well my front end resides on the desktop of eacch user because the system is not networked and my back end tables resides on sharepoint. How do I trust a desktop location?

Is there any way to stop the message bar popping up with the yellow header with the button to enable content? It prevents my custom log on screen from working properly. I thought it was something to do with security settings so have been into MS Access trust center but dont see anything. I am...