Search results

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

I have a table (ExportTables) with the following data ExportTables -------------------- MPI_CODE MPI_IDS MPI_REFF REFFERALS NOK_AD -------------------- I want some VBA code that can loop through the table above one by one returning the value. The table data will change so i would like the code...

I’m really stuck on how to create: Check Boxes/Option button/Option Group in VBA. Could someone help on either all of them or some of them please? Thanks Richard

What I want is check boxes to appear on a form with the name of the tables. i.e. I Currently have 3 tables (there are more tables in my database but for this example I will only use 3) - MPI_CORE, MPI_IDS and REFF_DR. I want some code to put the table names as a check box i.e. [] MPI_CORE []...

haha sorry my programming isnt that good. Where would i insert this into the code above?

The code below imports the file Modified Time and Date into a table. However the value in the table = '39491.4423611111' , it should be: 13-Feb-2008 10:37:00. I've tried changing the data types to "Date/Time" and "Text" and still get the same value. How can i change it so it show the correct...