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

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

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

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

My front end database is in MS Access 2010 and my back end resides on sharepoint in office 365 as lists. It is all working well but I want to be able to open the database and run some code which checks who the current windows user is and then opens up the appropriate form. They are already...

I have a crosstab report which shows all the staff in the first column and the status of all their leads along the top. However, if no one has a lead with a particular status then the entire report does not run. The query works great but the report has hard coded in all the different statuses...

I have used this info http://www.utteraccess.com/forum/lofiversion/index.php/t1832739.html to write some code behind a button on a form which sends an email. However, my set up is slightly different as I am using frm_Email with a subform Frm_EmailCOntent. This is the only way I can think to do...

Is it possible to change the source data of a web enabled form? I created the form but now would like to base it on a query rather than the table I based it on so that I can use some criteria on one of the fields. Web enabled forms dont have properties like normal forms so I can see any way to...

I have a database where I have web enabled the back end onto sharepoint lists to allow everyone in the office to be able to access same data and the front end client is on thier machines. I need to be able to import data into one of the tables/lists but update and append queries are not...

I have a form (frm_DocsList) with a list box (lstQueries) which uses some SQL to pull in a list of some of my reports (the record source is set to SELECT MsysObjects.Name, Mid([Name],5) AS QueryName, Left([Name],4) AS Expr1 FROM MsysObjects WHERE (((Left([Name],4))="Rpts")) ORDER BY...

I import a list of new enquiries into a new table (Copy_of_table_client) on a daily basis. These enquiries come from different sources so it is possible that they contain duplicate leads. In addition before I add them into Tbl_client to be given to the salespeople I need to check that they are...

I am using MS Access 2010, my tables are now lists on Sharepoint (via Office 365) and my front end will reside on each users desktop. I am trying to list within my database all the communications relating to a user in one place. The different types are mainly, email, phone and face2face. I...

I am writing a database for an estate agency. I have a form call Frm_Client which has lots of details about a client and a tab control called tab_ClientDetails. One of the tabs in the control needs to be for appointments or Inspection flights (IF). If a client lives far away they will book an...

Golom and PSV kindly helped in a previous thread to get some code working which automatically allocates clients/leads to a salesperson dependent on the salesperson with the least amount of clients/leads already allocated (and whether that salesperson is avialable). However, I needed to make...

I have a log on facility which is working well but when the user chooses their user name from a combo box I want it to change the hidden fields in the form I have as well. So I have this code behind a button to log on Private Sub LogOn_Click() 'Check to see if data is entered into the...

I have imported some emails and now want to extract the name of a person and their email address from the contents of the email. Their Email address in the contents of the email occurs after the work E-mail so using the code below in a query looks as though it truend the value beautifully...