Search results

thank you, I'll try to edit DB that you sent me,

I saw your solution. But I need something like this. I edited my database and you can see it. It's almost working but I need to connect 2 tables and ID's. If you open it you can see tables, SOLUTION_EN there will be solutions in EN language, so title, desc, youtube link etc will be in English...

No there will be another languages, but this is test only, so now we are working only with 2 languages and we want to test it. Because we will import that on website in XML format.

Here is a file

Okey I opened Relationship and set a relationship on ID's, and what type of query I need to create ? Select or Update ? Okey I attach a file in minute

okey I changed the ID in DE table on long integer. And how can I sync them ?

Hello. I have created 2 tables, 1 table is for EN language and second is for DE language. It's a database with products so there is an ID, Name, Gallery, Description etc... I duplicated them and now I need sync them.So if I change something in first EN table, it change in DE table too. But not...

Thank you. I solved the problem, I created that by UPDATE QUERY and problem was that I set Gallery field as a short text field type so that's why is was not displaying correctly. Now it's working. I want to ask,I added to table one more column (it's only for information),and I don't want to...

Can I ask one more question ? I need to add one more column to table, but if I make an export I don't want to export this column in XML. It should be only information column inside table with product number. If it's possible to select in XML export which columns I want to export ? Thanks...

I fixed the problem by this, I'm not sure if it's good but it's working. I added & "|" & between URLs "mywebsite. com/images/" & CStr([ID]) & "/1.jpg" & "|" & "mywebsite. com/images/" & CStr([ID]) & "/2.jpg"

update1: I added a separator to quotation marks, but is showing it on frontend too

Thank you guys it's working. I created an update query with @Isaac command "website . com/images/" & cstr([ID]) & "/main.jpg" but I have another problem in my next column. There is a solution gallery column and there are 6 URL adresses of gallery images. I need in this field URLs of images...

What do you mean by concatenating ? I'm new in MS access.. I need create that only for XML export to my website. And my problem is only with that field. @The_Doc_Man in that column there always be same format. Only ID will change

Hello. I need to get ID variable from main column to my other column where is URL address. Bellow you can see what I need. In first column is ID and I need to get it to Mainimageforsolution column as a variable. Column "Mainimageforsolution" is set now for text. How can I do that ? Thanks a lot guys