Recent content by rexmorgan

Well it looks like I cannot save my database into a 2003 version. When I attempt to do so it get the following: 'You cannot save this database in a earlier version format, because it uses features that require the current file format. These features include attachments, multi-valued fields...

I have changed a number of things since this last post. I will attempt to clean up the latest version of the database into something usable. Is there a particular step you are having trouble with or were you simply hoping to take my database sample and modify it? Just curious. If you are...

Glad to help out. :D I really don't understand why Google Earth wants it that way in the kml file. Because is you open up Google Earth and type in coordinates it want the lat first then long. It is very strange to me why they have it differ like that.

jdraw have you had any luck? I thought I might try to explain further. The MyRS is a dynamic recordset. The recordset created is from a query titled 'MyQuery'. The SQL statement for the 'MyQuery' query is SELECT * FROM Spotter WHERE (((Spotter.[FirstName])='Rex')); This is just one...

OK jdraw. One thing I noticed right away is that you have your latitude first (in your generated kml file). I do not know why Google Earth wants the longitude first but, it does. I am going to include a snipped of a generated kml file from my application. <?xml version="1.0" encoding="UTF-8"?>...

Re: Multiple Layers I am calling Google Earth from access. I use some vba attached to a hidden command button. The hidden command button code is called from a visible command button. I will post the code below. I hope this helps you out. If not, reply back and I will try to help out...

Sorry I did not get back to you sooner. I am glad you were able to figure out your error.

Thanks a million! That worked like a charm. :D BTW what is the NZ for in the sql?

Could you give a better example of specifically what you want to have happen? What I mean is describe the table somewhat. If you use the OR function you could conceivably use something like SELECT * From tblSomeTable WHERE tblSomeTable.SomeField = "abc*" OR tblSomeTable.SomeOtherField = "a*"...

Hi I have some data that includes records for each day of the year. The records will change from time to time assuming a new record is reached for a particular date. I would like to be able to do a query using two combo boxes 1)cboMonth 2)cboDay and using these two comboboxes do a query using...

@Galaxiom- The reason for the code referring to a hidden button is that having the button visible does little to no good that I can determine. The code was written to be modular and works well for several other buttons on the same form. Perhaps if I include the code for both the visible and the...

@PNGBill- The code that does work is on the same form. So I am not sure what the problem is. I may still go through it again and see if I can find a typo or something.

@PNGBill- The the query runs just fine. The data displayed in the query is also just as expected. The problems lies somewhere when I am trying to create the kml file that Google Earth will read. For some reason the line in the code 'Set MyRS = MyDB.OpenRecordset(QryOrTblDef)' @Galaxiom- The...

Thanks for the reply Peter. The query is a dynamic query that is created in another piece of code. That code calls the above code to create the kml file based on the dynamic query called 'MyQuery'. The query itself runs just fine from the button click of cmdPlotQrycboCounty. When this runs...

Thanks for the reply. I had already tried adding the DAO but still without any luck. I am just not sure why this does not work. It works on several other buttons. The only difference between this one and the other is that this is using a combo box to determine the Query and the others simply...