Recent content by DanR

Thanks very much for your research, especially that other link. A big help - especially when you can go to sleep mulling over a problem, and wake up to the answer :) cheers Dan

Based on the number of columns after the form name, it should be a where condition to limit the range of records to be opened with the form. For example it could say Price < 50 or Status = "sold" Have a look at the help for docmd.openform which shows the syntax

I have an idea of transferring a scaled down version of an Access databse to a PDA. It currently has the usual array of tables, forms and VBA code. It doesn't need to be Access, although a familiar coding language would be nice. Does anyone have advice / experiences with db application...

Not with a regular message box I hope Scott's suggested code works. But it's worth mentioning (possibly obvious) that a standard message box doesn't let you choose fonts. You only have a basic set of display options.

It's hard to be sure without seeing the form, but here are two things you could try to remove that error Where it says try me.form.locked= true me.form.allowedits = false good luck Dan

Hello I'm using a dictionary object for the first time, and it's behaving rather weirdly. The aim is to add all of the records from a 2 column recordset into the dictionary: Here's the code: [SIZE="4"] There are about 9000 records in the recordset, but I get an error on the 2nd record...

Happy to say I've found my own solution. I'm posting it in case others have the same problem. :D It's easy to do using the DoCmd.TransferDatabase method. Quoting the online help in Access 2003: TransferDatabase Action You can use the TransferDatabase action to import or export data between...

Good question! I'm looking for a solution to this problem too. So that an Access 'front end' database can easily be redirected to point to a different ODBC Oracle back end. I've been trying to do it by editing the ADOX table properties like this: tabCurrent.Properties("Jet OLEDB:Link...

thanks Thanks Wayne This should be verry handy. I'm not sure, at a glance, how my code is non standard, but no doubt it will become clear. Dan

Pat I've just come to exactly the same problem while checking our Access 2000 software for upgrade to Access2003 That is, using [object]![object] to refer to controls on forms, subforms and reports. You say that it is important not to take shortcuts, and to make the code "correct". Now it's...

How would I get the connection object using this code? Getting the connection string is no problem, but not clear how I would extract a reference to the actual connection object from this code (Also this code raises the NO DSN error and shows the message: The User DSN for Oracle Tables were...

Thanks, but that's not quite the problem... Thanks Wayne That piece of code will come in handy, but if I understood it right, it doesn't deal with my current problem. I have no problem creating ODBC linked tables to work with Oracle. The issue is that when I use these linked tables, Access...

Hello Accessers I am looking for your advice on how to set an ADO connection object to use the very same ODBC - Oracle connection that Access 2000 opens for tables that are linked to an Oracle database. Rather than opening a new connection - eg cnnOracle.Open etc, I would like to access the...

Has anyone even seen this error before? Has anyone even seen this error before? Or knows under what circumstances it is trigered? thanks Dan

I haven't worked with web stuff, so your syntax is a little unfamiliar, but just a couple of suggestions. The query builder in Access is invaluable for getting your SQL right. You can build your query visually, check that it does what you want, then copy the code into your program You need to...