Search results for query: *

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...

I have tried everything now and am getting desperate. I am currently using the following in my where clause [ClientID]=[Forms]![Frm_ClientDetails]![ClientID] I am now getting the following error ...the object does not contains the following object ClientID...error 2766 But it does!! Both...

I have a web enabled Access 2010 database which is hosted on sharepoint. My opening sheet shows all clients and in order to open the specific client details I have a button next to each client. the embedded macro is an OpenForm macro but when I use the where clause below I receive an error...

I hope someone can help as this doesnt work for me. I had the code in the change tab event of the tab control as below Me.Controls("My_data_allclients").Form.Requery Me.Controls("Tbl_viewings subform").Form.Requery Me.Controls("My_data_hot_clients").Form.Requery...

OK I have reset the default print but still no luck. They are now just sitting in the priner queue. I guess this is obviously more of a system or printer issue than a MS Access isue but if anyone has any ideas please do let me know...

I am using the code at the buttom of this entry behind a button to print a report but when I choose it opens the report in one note instead. What did I do wrong... Please note that lstqueries is a list box within the form where the button resides that gives the user a list of different reports...