Search results

Hi, I am updating an table with Inner Joint, however it is not updating the column. UPDATE GDM_Structure INNER JOIN GDM_Structure_Temp ON GDM_Structure.Unique_ID = GDM_Structure_Temp.Unique_ID SET GDM_Structure.HOD = [GDM_Structure_Temp].HOD; When I am doing for check that selection query is...

Hi, I am New to Access so apologize if this is straightforward. I have 2 tables in DB. The intent is to update every field (67 in total) with tables "GDC_Structure" to "GDC_Structure_Copy" where the columns "Unique_ID" match. The fields in the "GDC_Structure" table and the Update Tables...

Hi, I am new Access I have a date column, and the data in this column is with date and hour and I want to completely remove hour part from that data. like below is the one in the date column, and I want to remove hour part. 08.07.2017 02:00:00 after removing the hour part the data will be...

Hi, I have a table in ms-access like below Associate_Name Region Domain Role Steve East DB BOA Jhonson East DB BIO Josh East DB EBOA Derek East DC BOA Haroon East DC EBOA Aman East DC BIO I want to take Associate_Name in recordset, and I am using below code Sub Fetching_Data() Dim rs...

Hi, I am trying to apply xlveryhidden from Access but it is not working properly, it is hiding sheets but bot veryhidden means it is showing those sheets in unhide window. Code my_excel.Sheets("BSI Feedback Data DB").Visible = xlVeryHidden my_excel.Sheets("Calculation Sheet").Visible =...

Hi, I have created a MS-Access based tool and I am adding below mentioned references at a form load event, it is working fine at my workstation but when I am running this tool in other system it is not working properly because like at my system calendar control version 10 and on that system...

Hi, I have a MS-Access Tool for Input Processing, and in this tool below mentioned reference added. Visual Basic For Applications Microsoft Access 10.0 Object Library OLE Automation Microsoft ActiveX Data Objects 2.5 Library Microsoft Office XP Web Components Microsoft Excel 12.0 Object...

Hi, I have a table like Access below Client TCO_FCO_Case Closed_in_5 Day WTD MTD QTD YTD 7538 1 1 0 0 1 1 1 7538 1 5 0 1 0 1 1 7538 0 1...

Hi, I have a update query named “Update_Table_2” and I assigned this query with a button click, when I click first time on butting it tell me an error message that can’t update due to data type conversion or etc… now when I click second time on that button or run manually that update query...

Hi I have table named Date and there is three columns Start_Date, End Date and Count_Sunday_Saturday. I want to count how may Sunday and Saturday between Date1 and Date2. date1 date2 Except_Sunday_Saturday 1/1/2012 1/25/2012 I am not able to do this. Please help it is very...

Hi, I have a student database in MS-Access, And I want to fetch some part of data from ms-access to excel.There is a macro in access where 20 to 25 queries in that macro, I want to hit macro first so macro will do all the calculation in ms-access, then at end final query will store result data...