Search results

Hi guys, I think this is a really critical problem, since access can only save 2G data, what if the data volum exceeds this restriction? is there any solution for such problem? I am thinking to use access as front end for date mainpulation and enquery while using SQL as the back end database...

Hi, I have below code for maximum 3 criteria dynamic search: Private Sub SearchFor_Change() Dim strWhere As String Dim Criteria As String Dim i As Integer Dim A Dim strAdd As String On Error Resume Next strAdd = Me.SearchFor.Text Me.SearchFor.Value = strAdd...

Hi, I have below module to save picture under named folder: Option Compare Database Public Enum acFileType acPicture = 1 acFiles = 2 End Enum Public Function UploadFile(strDestinationPath As String, _ FileType As acFileType, _...

Hi, Since I am new here, I'd like to share a sample with you. This is a dynamic search textbox I made after learning several examples, Interface is like this: I thinks it's quite user-friendly a tool that you might consider to add into you own database. you can search similar spelling records...

Hi, Here is a problem frustrating me and I decide to look for help here: I attached a demo for your reference: The Relationship structure is like this: There is a query "Style_Color_Materials_New" functions as New data and a Table "Style_Color_Materials_Old" as old records. With a Form...