Search results

Indeed. I missed that too. Now it works. Thanks a lot

Hi, Thanks. I am trying to incorporate your code in mine, but I am getting an error: too few parameters, as attached.

Just one last thing. How can i format this part of the code to search multiple keywords in a row? If Me.txtObjectTags <> "" Then varWhere = varWhere & "[ObjectTags] Like '*" & Me.txtObjectTags & "*' AND " End If

I really appreciate it

Ah yes. Thank you so much

Hello, I am trying to implement a multiple criteria options to query my database, but I am getting the error "data type mismatch in criteria expression". I have checked through the code for syntax errors but can't spot any issue that I know of. What I want is any combination of the criteria...

Indeed, Allen's code is super easy to implement. I followed your tips and achieved what I wanted. Thank you so much to you all for the help. Best regards.

Thanks for sharing. In fact there is also this other code I found, which who suit my scenario, unfortunately it's giving some errors. I hope someone can update it: https://accessdeveloper.net/relinking-back-end-to-front-end-database-automatically-using-vba-code/

The folder contaning my BE and FE is on a movable drive which I carry along with me.

Hello, I am looking for a code to automatically re-link ms access tables. My front-end and back-end are both in the same folder, but the folder location ma changing machine locations. Google search found me this link links http://allenbrowne.com/ser-13.html but it's for old versions of ms...

Hello bastanu. Thank you for your advise and the module you just posted for me. However, let me confess to you that I have limited knowledge of VB programming. Please, see the attached copy of the the accdb file for your perusal.

Ah, sorry for not including more information earlier. I meant to say that the database would be mobile on a thumb drive, and so I would like to have all its folders and files in them to stay linked to the front-end within the same folder. The first time i tried to move the database on a thumb...

Ok that has been corrected and now images can be uploaded, What i need now is to only populate the table with a relative path contaning the images, not the full path. Right now i can only scratch my head wondering how to achieve that.

OK, please, I have attached the databse file for expert perusal, if you don't mind to look. Sorry i am a total amateur.

Actually, the error is pointing me to this part of the code:

Hi. From the code below, I want to programmatically copy and rename the files I am adding into the table tblObjects to be same as the primary key which is ObjectID, i.e. /Images/1.jpeg etc and then return the relative filepath containing all the images to be in a folder called "Images" within...

Ok. This is what I am doing now. Hopefully on the right track: Dim relativePath As String relativePath = "\Images\" & Me.txtObjectID & ".jpg" Me!ImagePath.Value = relativePath Thus far, I can see only the image named (i.e ObjectID) being populated into the table without the path. I hope I...

Oh yeah. Just not sure where to tweak that code and how to call the function. My bad!

Hello isladogs. I stumbled upon one of your code samples on how to properly save image path into a database table. Now I want the images folder and the split back-end data file within the project's path, so that it is portable. But I don't know how to do it. Below is the code: Private Sub...

Indeed! I see that now. OK, I will start from here. Thanks a lot.