Search results

Thank you so much for your help. It works

Hi, This is my code Private Function GetSelectedItemInfo() As String Dim SelectedItemInfo As String Dim i As Variant For Each i In Me.List13.ItemsSelected SelectedItemInfo = SelectedItemInfo & Me.List13.ItemData(i) Next i End Function I have set the...

Thank you so much. Sorry I didn't understand what you mean

Hello Guys, I have a list box and I have enabled Multi selection as Simple. I want to display the values I have selected from this List Box in to a Text Box. Is it possible? Thanks

Thank you so much. It works

Hello Guys, I want to display File Name from my Table tblFileBasic in to a Text in my Form frmFileRequest if the File Number in the text box of the Form matches the File Number in the Table. This is my Code: Dim db As Database Dim rst As Recordset Dim strsql As String strsql = "Select...

Thank you so much. It worked

Thank you so much It worked perfectly

Yes it is Unbound and the RowSource is Yes;No

Hello, I was trying to create a query based on the parameters a user enter. I have created a user form and when user select "Yes" I want to display all the records which are completed. The field Completed is a Check Box. In the Query design view when I enter Yes (without double quotes) query...

Thanks a lot it Worked

Hello, I have created a spreadsheet and now all my data from 5 main tables are saving in it. My Backup of database are saving like this on a button click: Is there any way I could apply this same method for Excel? What I mean to say is, when a user click on a command button, I want to...

Sorry. This is what happened when I blindly copy paste the code without knowing what does it means Changed my code DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, "tblMaster Table", "\\ABC\shared\ABCD\ABCDE\ABCDEF\Database Backup\Test.xlsx", True and it worked Thank you so much

Thank you so much. But I am getting This is my code DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel3, "[tblMaster Table]", "\\ABC\shared\ABCD\ABCDE\ABCDEF\Database Backup\Test.xlsx", True Thanks

No I will try. Let me google or if you have any links that would be highly appreciate We have 5 main tables and what I want is while taking the Backup daily (I am taking daily Backup in a button click event) I want the data of these 5 tables to paste in to an Excel sheet with 5 different Tabs...

Yes. Because just in case if Access is not working and we are not able to access any of the data in the tables, we must have a Backup in Excel. Currently I am taking daily Backup of my Access database. But if Access is not working we would not able to get any of the data in the Access database...

Hello, Can we create backup of Access Tables data in to an Excel file by using VBA code? Thanks

I tried it worked Thank You

Hi, This is my code to find the total number of Denials in an Application and I want to use Like =DCount("[strID]","[tblMaster Table]","[datDate Application Received] between DateSerial(Year(Date())-1,4,1) And DateSerial(Year(Date())+0,3,31) And [strStatus of Application] like "*" & 'Denied'...

Thank You