Recent content by hewstone999

I have this update SQL query(See below). Tho it keep saying "Operation must use an updateable query". Any ideas on wats wrong with the code? Thanks UPDATE TEST_DOC SET TEST_DOC.DataSet = (Select IFF_Descriptions.DataSet FROM IFF_Descriptions WHERE IFF_Descriptions.Field1 = "MPI_CORE_IFF")...

Ok thanks for that.... Anyway of sorting an table without the select statement?

Yes this is what is sorted already in the database.... Im new to SQL so could someone please put me in the right direction of what SORT SQL statement to wirte? thanks

I currently have this data in the "tbl_Infor" Tbale Tlb_name RowNo Comments MPI 1 Username MPI 2 Forename MPI 5 Date MPI 3 Sex...

I want to add a buttom to Cell D1 using VBA.... I already have the code to create a button, i just need the code to move the button to the required cell. ANy help or ideas?

I’m currently using vba in access to export values to an Excel Spreadsheet. I have this query below but I cant seem to export the value the SQL statement gives to the correct field in the spreadsheet. n = 2 temp01 = xlSheet.Range("F" & n).Value temp02 = xlSheet.Range("B" & n).Value sql1 =...

I have two tables: “tmptable” and “CC_CODES” Both tables contain the same data; however the “tmptable” contains updated data. How can I compare both tables and remove all the duplicate in the tmptable, leaving only the updated data. I will be comparing the fields “IsMandatory” from both tables

I have the following code: a = "03-Patients-Data" How can i change the "03-Patients-Data" - to - "03_Patients_Data"

I have this following code: --------------------------------------------------------- a = "MPI_CORE_DATA" b = 'Need something here to get rid of the quotes in a DoCmd.RunSQL "CREATE TABLE " & b --------------------------------------------------------- How can i get rid of the...

I have this code (Access VBA) at the moment that uses Bookmarks to insert information into a word doc. Code: Private Sub Command0_Click() Dim Wrd As Object Set Wrd = CreateObject("Word.Application") Dim Mergedoc As String Mergedoc = Application.CurrentProject.Path Mergedoc = "C:\Documents...

I have a table called "MPI_CODE" it has 4 columns. How can I export this to Word? By creating a new document first (Using Save dialog) then exporting that table to the word doc. Mainly looking for the code to export the table into word. Thanks in advance for your help.

I point of my program is that a user can save/create a workbook anyway or i would of gone down that route of creating a existing one. And yes that is what to do imply.

I have an export function in Access that exports data into Excel. From Access i want to create a button in Excel and add some code to that button. Any ideas or help or any code i could use, thanks.

I have a Text Box called: VNo , and a table called: DocControl. The Table contains this information Name............Version................Date ------------------------------------------- GFD v0.1 09/03/2008 GFD v0.2 11/03/2008 GFD...

Thanks, i used this code in the end: Dim rs As ADODB.Recordset Dim sSQL As String Dim sValue As String sSQL = "SELECT * FROM ExportTables" Set rs = New ADODB.Recordset rs.Open sSQL, CurrentProject.Connection, adOpenDynamic, adLockOptimistic DoCmd.SetWarnings False rs.MoveFirst Do Until...