Search results

Hello, I have below codes on my form to restrict the user for data validation for entering the date. Dim strSQL As String strSQL = "SELECT Max([Requisition_table]![SAPRequisitionReleaseDate]) AS Max_Date" strSQL = strSQL & " FROM Master_data INNER JOIN Requisition_table ON...

Hi All, I need an help in creating auto number field in access database. Let me explain you further. I have an access database which 20 million records. When i am trying to add auto number field i am getting error "File sharing lock count exceeded". Then i did some google search and got...

Hi All, I need to export a set of 15 queries into excel for the specified range created in excel file. All these queries belongs to different criteria's and need to go separtely to their specified range. Is there is any way to export into excel using VBA codes in access. I have some knowledge...

Hi, When i am executing the below code then access starts automatically; Dim objXL As Object Dim strpath As String Dim Combo3 As Variant On Error Resume Next Set objXL = GetObject(, "Excel.Application") Set objXL = GetObject("C:\Apps\Monthly Download\KPI Data File Template.xlsx")...

Hi, I want to export a excel file from access and i want to save the excel file in the name based on my selection available in combo box . I am using the below mentioned code, but i am not getting the desired outout file saved in the path mentioned... Can you please anyone help me on this...

Hi, I want to know how i can export the data from Access to excel using Access VBA for the specified sheet using data linkage with access database. Like we used to do it manually in excel as external data from access. Like we have some codes for linking excel file to database mentioned...

Hi All, Can any one help me in creating query in MS access for the below formula; =IF(A2=A3,0,1) Example: The query has to match the first and second record if it matches then it will update as "0" in a new column. Can anyone tell how i can do that? Thanks in advance. Regards...