Search results

Thanks for the response Goh. Will this also work for uploading/linking one single table? What i found was that it was adding all existing tables in my database onto Sharepoint again and adding a 1 to the name when they already existed, this made the previous tables redundant and I didn't...

Hi, I have a split database consisting of many forms and tables which is published on Sharepoint 2013. I need to add a new table to the Sharepoint which is to be updated by one of the forms. I have tried exporting to the Sharepoint which has added it but i'm unsure how to create the link so...

Managed to sort it. The issue related to the bound column not being set correctly which was preventing the query from working

Hi, I have a form called 'CustomerContact'. I have a table which holds a list of High Level Reasons called 'HighLevelDrivers'. A combo box named 'Highleveldriver' is used to select one of these high level drivers. The table is selected in the Row Source. In another table I have called...

You are correct. I added in 'oMail.Display' and that has prompted the email to appear. Thanks for your help

Tried the below code but still no joy...the record is added to the table but no email is opened Private Sub submitdispute_Click() Dim db As Database Dim rec As Recordset Dim oApp As Outlook.Application Dim oMail As MailItem rec.AddNew rec("Company") = Me.company rec("MonthNo") = Me.month...

I didn't put them in the same routine as there are variables in both codes and I wasn't sure if this would cause issues? I'm not familiar with the DoEvents code, could you share how this code would fit with my code? Thanks

I haven't added the send part of the code in yet as i'm just trying to get it working to open the outlook email and populate the details, however, the current code isn't opening the outlook email?

The update is in the code, i possibly stripped it out when copying it across. The update of the table is working fine, as for the opening outlook email and populating the details, i'm not getting any errors when running it but its not completing the action. The codes are working fine...

Hi, I've got a vba code written which adds data entered in an input form to a table. On the back of this I also require an email to be written and opended via outlook to a recipient value in a combo box. The issue i am having is linking the codes together, I've tried calling the other module...

Hi, I have a user input form and I need to prevent duplicate references being added. In the after update of the combo box selection I would like the form to flag if the reference chosen is a duplicate or whether it has not been entered. The difficulty I have is that I am checking 3 columns...

That's worked spot on. Cheers

Tried the below but getting an error, am i missing something? DoCmd.RunSQL ("DisputeWarehouse Query")

Hi, I have an SQL query which updates records in a table based on combo box entries within a form. I want to assign this SQL query to a button within the form, when this button is clicked I want the SQL query to be executed. Query is called 'DisputeWarehouse Query'. Tried this code but...

Worked great thanks

Sorry for the poor explanation.... What i'm basically doing is returning lots of different values from my table and pulling this back into the forn eg workstream being one, based on the 'caseid' entered. The complicated bit is that the case id selected could be from 1 of 5 different columns...

Apologies just to add to this....the red highlighted part of the formula needs to reference the workstate combo box (not the case id bit in green, this needs to stay as caseid) =DLookUp("Workstream","qadata","CaseID = '" & [caseid] & "'")

Hi, I'm trying to use a dlookup formula which references a combo box but unable to get it working. I have a combo box (called workstate) which has different types of work, eg CaseID, IR, URN. In other cells I have a dlookup formula which I need to reference this combo box. I am currently...

Hi, I'm currently running an access database on sharepoint 2013, both front and back end are stored on sharepoint (access 2010) The front end consists of a form which is linked to a data warehouse table stored in the back end. My question is, how can i stop users updating the data warehouse...

Thanks for the solution. Do i update the below in the form properties on the front end form? I updated this and saved the changes but it was still letting me edit the linked table?