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

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

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

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

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

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

I found code on the MS TechNet website to programatically import XML data from a file into a table in the database. Here is that code: Const acAppendData = 2 Set objAccess = CreateObject("Access.Application") objAccess.OpenCurrentDatabase "C:\Scripts\Test.mdb" objAccess.ImportXML...

Hi all- I got this code off of a blog. What I want to do is make a .KML file based on the "address" field in the table "GoogleEarth". I do not understand, however, how to get this code to work for my needs. the first error I come across is that it tells me the script needs a End Sub to it...

If I have a Order Form with a subform for Order Details, can I have a append query that creates a log for each record in the subform? So far it will only create a record for the first entry in the subform. OrderForm= Name Address Date Notes Subform= Tool1 Tool2 Tool3 I want to click "Update"...

If I have a Order Form with a subform for Order Details, can I have a append query that creates a log for each record in the subform? So far it will only create a record for the first entry in the subform. OrderForm= Name Address Date Notes Subform= Tool1 Tool2 Tool3 I want to click "Update"...

I am trying to run a Query that searches for a single Tool ID Number and returns the transaction record that has the latest date. My query currently is this: SELECT LocationStatus.ToolID, LocationStatus.CurrentLocation, LocationStatus.DateofEvent FROM LocationStatus WHERE...

I have a Tool Tracking DB that keeps a history of tool movement and current location. I need to verify that a tool is truly available when I enter the tool number into a new contract. ::NARRATIVE STYLE::: Tool 42X was rented by John on Mar. 1. John returned tool 42X to the office Mar. 5...

If I send an HTML message to an individual and they reply back on Monday, can they still reply again on Tuesday to the same message and again on Wednesday, so on and so forth? Will this be adding multiple records to the table? Also, please consider the same situtation for an InfoPath email...

I have a form for tool repair that has the underlying table, repair details. I also have a table that updates that latest location for a given tool, transporttable. I have a table that stores all the tools' serial numbers. This is the recordsource for the "select tool" list box on the...

Howdy all! I am new to Access (only using 2 weeks) and have never taken a class. I am trying to update a DB for my company. []=Table {}=Field What needs to be done is as follows: When a new Purchase Order form is filled out each material ordered has a {ProductNumber} and has a {price}...