Recent content by kashif.special2005

Actually, I have database in place and in that database I have two tables and some query, updating query with join, append query with join and delete query, and I am adding the data in the temp table through Excel VBA and running those query from Excel VBA, some time it working fine and some...

Hi Pat Hartman, Thanks for reply, yes I checked and the Unique_ID is exists in both the table, and strange thing is that, when I opened and closed the database 2 or three times and again run the query it works fine, and some time when I tried to open the table it gives an error message "Not a...

Hi, The Unique_ID's number is available in both the table, and both are numbers My head is swimming why it is hapenning Thanks Kashif

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

Thank you so much mdlueck, Now it is working fine "SELECT Associates.Associate_Name FROM Associates WHERE Associates.[Region]='East' AND (Associates.[Role] Like '%BOA%' Or Associates.[Role] Like '%EBOA%') AND Associates.[Domain]='DB' ORDER BY Associates.[Associate_Name];" Thanks Kashif

Sorry forget to load the data Associate_Name Region Domain Role Steve East DB BOA Jhonson East DB BIO Josh East...

Hi, Thanks for reply just an fyi.... That when I am removing Like criteria from the sql query it is working fine Not Working "select [Associate_Name] from Associates where ([Role] like '*BOA*' Or [Role] Like '*EBOA*')" & _ "And [Domain]='" & Me.cmbdomian & "'" & "And [Region]='" &...

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 Trevor, Thanks for reply I have tried severl options for that I found the right option and that is xlsheetveryhidden below code is working fine my_excel.Sheets("BSI Feedback Data DB").Visible = xlSheetVeryHidden Thanks Kashif.

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