Search results

If all you needed was a protection against Null exceptions, it'd probably be overkill, but I find the RecordSet way a very convenient framework when tightly integrating table manipulation with actual code. Good look in your endeavours :)

what does the user input look like? In general, you can manipulate tables this way: 'Header: Dim DataDB As Database Dim RS_Article_Data, RS_results, RS_Control As Recordset set datadb = currentdb Set RS_results = DataDB.OpenRecordset("ABC_Results", dbOpenDynaset) Set RS_Input_Table =...

Hello Dave, thanks for your interest, and my apologies for answering so late. I was convinced I'd be notified by email about a new reply ;) Anyway, the basic idea is to visualize a supplier / customer network in Google Earth. The way I do this is to have a client table that looks like this as...

anybody with some input? Any thoughts on this matter would really be helpful for me at this point ;)

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

yeah I did, it didn't. However, I found a solution: I intercepted the KeyPress event on the form and disabled CTRL-P. Also disabled Page Down and Page Up while I was at it ;)

yeah, I'm afraid there's no control for keyboard shortcuts there :(

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

nevermind, turns out if I properly link all files to the table, updating the form fields saves the values there as well, and it's much less hassle to boot.

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

dirty, but it works, thanks a lot :)

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

thanks a bunch for your help guys, got it working now! :)

I was afraid it was a reference issue. That means anyone who I give the .mdb to has to set that reference as well right? Anyway around that? Thanks anyway for the huge help you guys have been so far! :)

hmm, both Dim xlApp as New Excel.Application and dim xlchart as excel.chart give me an error: user defined type not defined. Am I maybe missing something else entirely, which causes all these problems?

well, the thing is, the Access application is an firm-internal tool I'm developing, so any solution that requires anything done manually from another file is more or less infeasible, as I'll have a hell of a time telling people how to use the thing ;) The whole point of automatically creating...

It's actually pretty simple, you first assemble a String variable form the various fields in your form and other Strings, then use that variable in the Export function. The CStr() function is built-in in Access and converts almost anything to a String. Dim ee_filename as String ee_filename =...

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