Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

converting from office 97


  • Please log in to reply
3 replies to this topic

#1 red_devil028

red_devil028

  • Members
  • 85 posts
  • OFFLINE
  •  
  • Gender:Male
  • Local time:08:28 PM

Posted 01 February 2016 - 02:53 PM

Hello, i am currently converting of a office 97 file, everything currently works flawlesly, except a older Right join Function

 

I don't know of this kind of coding differences that much as i am stuck with this one... the current acces97 code being

SELECT VLMmaand.Kat, VLMmaand.Lic, VLMmaand.Nr, VLMmaand.Naam, VLMmaand.Ptn, VLMmaand.Prijzen, VLMmaand.Criterium, VLMmaand.Kamp, VLMmaand.Plaats, VLMmaand.Datum INTO [cross-uitslagen]
FROM VLMmaand
WHERE (((VLMmaand.Prijzen)>0) AND ((RightJoin([VLMmaand]![lic],3))="VLM")) OR (((VLMmaand.Prijzen)>0) AND ((RightJoin([VLMmaand]![lic],3))="DAG")) OR (((RightJoin([VLMmaand]![lic],3))="MCLB"));


Current systems: CM STACKER Custom PC / MSI CX 620 / ACER Z5751 Touchscreen

Current role: PC Technician @ Computrac Belgium - Specialisation: Hardware.

BC AdBot (Login to Remove)

 


#2 JohnnyJammer

JohnnyJammer

  • Members
  • 1,117 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:QLD Australia
  • Local time:05:28 AM

Posted 01 February 2016 - 07:17 PM

So whats the RightJoin Function look like mate (Post that RightJoin function)? Also what version of office are you using this module/form in?


Edited by JohnnyJammer, 01 February 2016 - 07:18 PM.


#3 red_devil028

red_devil028
  • Topic Starter

  • Members
  • 85 posts
  • OFFLINE
  •  
  • Gender:Male
  • Local time:08:28 PM

Posted 11 February 2016 - 07:06 AM

So whats the RightJoin Function look like mate (Post that RightJoin function)? Also what version of office are you using this module/form in?

hello and yes, that is the part that i as well am trying to figure out, i am currently trying to install an xp and see what it does, 

 

This thing comes from office 97 and needs to be working in office 2016...

 

its a results file of a competition. Those that go under the "vlm" licence normally come sorted to the right, while "dag" and "MCLB" should be in a different table/column i think, whichever it is, when i try to change it to "right join" it also does not work, so it seems.

 

i am installing a win xp and i will try that this weekend to be able to show you what is there.


Current systems: CM STACKER Custom PC / MSI CX 620 / ACER Z5751 Touchscreen

Current role: PC Technician @ Computrac Belgium - Specialisation: Hardware.

#4 red_devil028

red_devil028
  • Topic Starter

  • Members
  • 85 posts
  • OFFLINE
  •  
  • Gender:Male
  • Local time:08:28 PM

Posted 14 February 2016 - 06:11 PM

I know this is a double post and i am sorry for such, i have failed to open the file in acces 97 as i seem to have the converted file already, i will drop pictures on how and what and details tomorrow, as i am desperately trying to find a solution and cannot find any at this moment.

 

regards. 


Current systems: CM STACKER Custom PC / MSI CX 620 / ACER Z5751 Touchscreen

Current role: PC Technician @ Computrac Belgium - Specialisation: Hardware.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users