Search results

SelLength not working is not working for a sub form. It will select all text me.Materials_SubForm.Form.MaterialDescription.SetFocus me.Materials_SubForm.Form.MaterialDescription.SelLength = 0

Thanks can I simply put this Java code into VBA module ? Is there no simple XML code to do that ? I'm using XML to interact google Maps. Learning JAVA is not my no.1 priority now :rolleyes:

I'm trying this code to get a list of files, but it's not working :( I get a Not Found response error - 404 Same response even if I remove the ID and password strXML = "https://www.googleapis.com/auth/drive/files" strXML = strXML & "&client-id=" & MyGoogleUserName@gmail.com strXML = strXML &...

But all their examples uses their ActiveX files, no ?

This link is not working, for me www.example-code.com/vbscript/

Do you have an example of some code ?

Anyone here managed to work with GoogleDrive ? I would like to upload files to GDrive, using VBA (XML) I do work with GoogleMaps, but can't understand the GDrive API :(

This one made my head spin :D:D:D I'll test it and let you know if it works. Thanks

Hi, Thanks Yes, I do need some help As I wrote in my last post I would like to "integrate" Q1 into the other, but have it all written as a single SQL. If this is not possible I will create Q1 as a built query. Thanks

What I'm trying to do is to put query Q1 into: SELECT [Products].[ProductID] FROM [Products] LEFT JOIN [q1] ON [Products].[ProductID] = [q1].[ProductID] WHERE [q1].[ProductID] Is Null Q1 query SELECT [Products_Materials].[ProductID] FROM [Products_Materials] INNER JOIN [Materials] ON...

Thanks I need products that has no MaterialType = 1 I think a left join is the right way

:D No it's not. It's for a project I'm working on

Thank you for the quick reply To be more exact I need to see all products, even those how has no MaterialType = 1 Actually those products are the most impotent for me Thanks

Hi I need some help creating am SQL query I have 3 tables tblMaterials - MaterialID, MaterialName. MaterialType tblProducts - ProductID, ProductName tblProductsMaterials - ProductID, MaterialID, MaterialPercent (This one is a Many to Many table) Now I need queries to sum data 1st query -...

what is the exact difference between: acViewNormal acViewPreview acViewReport

No, I tried the Report's Open, OnLoad... events This is even makes it easier for me as I don't have to change the reports, only the commands open them :) Thanks

Sorry error 2046 - The command or action 'Zoom200%' isn't available now

Not working :( I tried Report's Open, Load, Activate events

Thanks, but what about the window size ?

How can I set the report's Zoom on open, and set the window size to match the report's zoom?