Search results

Hi all! Stupid question I think but I have been going in circles for a while now. On a form there's a combobox that retrives AutoID and LocationName from the Location table. In the table underlying the form, the combobox named "Location" stores the autoID from the combobox. I would like the...

RG! Thanks for the link and the help. I went over that page and it was actually information that was discussed quite thoroughly in this forum (which basically has everything already!). I need some time (not at the end of the work day!) to process all that page says however. But.!.!.!.! in...

HA!! I posted my update ONE MINUTE after you put your code in. I will check it out too but it is exactly what I entered in I believe. Here is what I updated before you posted your code:

<BIG SHEEPISH GRIN> I don't actually know really what any of that is or what is to occur. I am searching for debug.print on the forum but I got like 20 pages to sort through. Might take a while... but thanks for the hint!! I thought maybe since text boxes need single quotes around them dates...

To begin: All appropriate form controls and table fields are set as Time/Date fields and in the format of Short Date. The code works fine except for this sticky issue: When the update is performed, rather than updating the date with DD/MM/YYYY (as it was originally stored), it gives me...

Problem Solved for all those interested. This code is for use when you need to import data from an XML file into tables with a Parent-Child relationship. This code works for all files in a directory and then moves them to an archive folder. The code imports XML into a temporary table. The...

ARRR! I know that this was working at one time, then I tried to tweak it and everything went to hell in a handbasket. Can I say that on this forum? Anyways, I am importing XML files into a temporary table (because the data must go into related tables and the import funtion is unable to handle...

Worked my way through it will *A LOT* of help from my friends (beatles tune in bg...). Thanks so much y'all I got it working now. I never knew about the Immediate window or even how to call a procedure. You learn something new everyday they say, so I guess I can go to sleep now! Thanks...

I was not clear. I searched through the list of unchecked references which was very long. There are only like 5 refs checked, the two in this thread, two that are in use, and OLE automation. Tried but DOH! Still asking for macro. All codes provided ask for macro. StepbyStep: I copy...

I appreciate all the help. I had enabled the two references before I posted so I diasbled them and tried again. No such luck. To be sure I checked the complete list of ref's- that thing is damn long. Microsoft ADO Ext. 2.8 For DDL and Security Microsof ActiveX Data Objects 2.1 Library are...

Access 2007 Does anyone know if this code works with Access 2007? When I click RUN in the VB Editor it asks me selecting a macro. Why is this? CG

I am using a fillable PDF form created using Adobe Live Cycle. Clicking a button on the PDF form, an XML file is created and emailed to the server. The server puts the file into a temporary directory and then when a user clicks the import button on a form in the DB, all XML files are imported...

Solution Posted datAdrenaline- I"m sure you're right that my table config could use some tweaking. i'm not sure where however. The solution was a two part query- the first being a union query called "union_noparam". The second part of the query is called "Tool history". running this...

OF course..... figured it out I figured it out of course shortly after I posted. I can post the solution if anyone likes. cg

Hi all- I have searched for a while and have seen some suggestions of using Max date queries and others. I have not found any solutions that I can implement into my DB. I am posting a copy of my DB in access 07. I want to return the latest known location for all tools in the tbl_tools...

Latest Updat I have compiled a new code that searches for all XML files in a directory and then imports them. Here's the code: Option Compare Database Public Sub Command0_Click() Dim strFile As String 'Filename Dim strFileList() As String 'File Array Dim intFile As Integer 'File Number Dim...

Here's the blog: http://seunet.blogspot.com/2006/11/export-access-to-google-earth.html

Hi all- I have come to a very sticky issue. We have a database that tracks tool rentals. The tools are maintained by servicemen (and women) that are geographically far from the home office. Many locations are very remote and the internet is inaccessible. However, I need data to be added to...

Multiple Layers Here is the finished code I have for using multiple layers (in this case four layers) in the KML file. Enjoy! Option Compare Database Private Sub Command33_Click() DoCmd.OpenQuery "qry_Layer1" DoCmd.OpenQuery "qry_Layer2" DoCmd.OpenQuery "qry_Layer3" DoCmd.OpenQuery...

1.) The XML file desingates which table the data will be appended to. 2.) It is an existing table. 3.) Maybe I need to check this again but it appears to read as the path is the c:\ drive.