Recent content by vinwin06

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

yes I know I'm reaching around 1.5 GB now... its normal ms access database only. not SQL db.

I did that already while doing that only I am getting the error mentioned above.

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

I didnot get the desired answer but i am respecting their efforts. I dont know where to mark as solved.

Hi thanks for the link, but i am not sure how to run the module once its created .... i have created based on the code provided can you please tell me how i can execute that...

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

Private Sub Command0_Click() Dim blnObjectCreated As Boolean Dim objXLS As Object 'Excel Application Dim objWB As Object 'Workbook Dim strOriginalFileName As String Dim strNewFileName As String Dim strRecordsetDataSource As String strOriginalFileName = _ "F:\DB...

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 Pbaldy, yes i fixed the buliding path but the file saving command is not working.

Hi Steve, I got your code working but the problem i faced is i am getting compatibility checked while saving the file. I think the file format = 56 should be something different for excel 2007?

So other than that my codes are correct, because when i execute step by stpe also i can able to see the path but its not saving the excel file in the new name.

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

Actually i am looking for vice versa logic like linking excel file from access thorough access vba codes.

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