Search results

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...

I am so glad I found this thread. I have been searching everywhere for an answer that made sense and was easy. Thanks a million.

Good morning everyone, I have a bit of code that I have recycled on a few buttons that all work fine. However this one bit of code associated with this particular button I cannot seem to get to work properly. As I said I have used code nearly identical to this on other buttons that works just...

Access 2007 should be able to open access 2010 files. Unless of course you meant access 2003. I have used some features in the new file format that are not available in 2003 and older versions of access.

Thanks for all the help. You have given me much to consider and work on. Total records are about 1200, it fluctuates some from about 1180 to 1250. I try to keep the database as up to date as possible. I used your earlier prompt about changing the qrycboCityFromCounty and it seems to...

Do you have any suggestions on fixing the problem? You mentioned that lookups at the table level are frowned upon, what would be the better way to go about accomplishing this? Any pointers on re-arranging the data? As I noted in my original post, I know enough about access to be dangerous. I...