Recent content by Louislam

Thanks namliam, anyway I have used a stupid way to make it. Many thanks

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 lagbolt, I have made a demo for you review, My logic is: first, user will choose a picture, second, the vba will save the chosen picture as a copy to the stipulated folder with related unique number "Materials 0000" as name , Help to see what problem with this, many thanks

Oh, thanks lagbolt and spikepl, You are so brilliant, that finally works. Thanks millions:D:D:D

Hi lagbolt, User will have no chance to name the picture, it will save programmatically with related unique number like "0001" and so on

Hi Lagbolt, I tried to make them as comment but it doesn't work. In this way, it lose the multiple criteria function, that means I only have one criteria for searching By the way, here is the full code in my database,Private Sub SearchFor_Change() Dim strWhere As String Dim strWhere1...

Hi Lagbolt, It doesn't work, it say the object doesn't apply to such method when i change 3 to 2 By the way, here is a screen cut when i click the button using Application.FileDialog(3) Still not solve the problem!

Hi, namliam. Please see the pic, since the query that compares with the old table has no primary key, even though I create an unmatched query to find out the records, I can not delete them. What should I do?

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

Many Thanks namliam, I just read this link, like you say, It may work. office.microsoft.com/en-us/access-help/compare-two-tables-and-find-records-without-matches-HA010205132.aspx Now I have just created two unmatched queries for Append and for Delete purpose, but how to write the Append and...

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