Recent content by Banista

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?