Search results

  1. B

    Polling the Google Maps API from VBA - possible?

    Hi all, I want to integrate Geocoding into an Access file, but I'm not sure if this is even possible. I honestly do not know much about Web programming, so I might be missing something fundamental. Here's a document detailing how to get geocoding information from Google Maps using HTTP...
  2. B

    preventing db user from printing forms

    Hi all, I'm currently working on a form to be used by people with limited to no PC experience. At the moment, if they press CTRL-P, the PC's default printer will happily commence to waste roughly 29,000 sheets of paper. I'd very much like to prevent this from happening by disabling certain...
  3. B

    changing table entry while form accesses it.

    Hi all, I have the following basic problem: I have a form with 2 fields, getting their value from a table. The form is pretty basic, you can navigate entries etc. Now the thing is, field2 is calculated from field1, but should also be stored in the db. The way I went about this is to write a...
  4. B

    updating references with VBA

    hello everyone, I'm trying to write a VBA module that changes referenced tables to different DBs in different folders, and takes the data for those references from a table. The main code is this part: Do Until RS_References.EOF For i = 0 To db.TableDefs.Count - 1 If db.TableDefs(i).Name =...
  5. B

    running complicated Excel commands from Access

    Hi everyone, I am currently writing an Access module that first exports a table to Excel, then uses an Excel object for further formatting inside Excel. After the file is exported and created (which works fine), I initialize an Excel object like this: Set xlAnw =...
Top Bottom