Search results

Hi, I applied a "password" input mask to a date field in a table, but the date value remains visible. The password mask works fine for text fields. Text values display as ***** when viewed in datasheet mode. Dates, on the other hand, display as asterisks as you are typing in a value, but as...

Greetings, Our company upgraded to Office 2010 about a year ago. Since then, both old and new databases become corrupt for no apparent reason. Various developers randomly receive the following error: "Unrecognized database format, database cannot be repaired or it is not a Microsoft access...

Hi All, I'm using Access 2010 to develop applications containing sensitive data. I would like to properly secure the data. I've created several applications with a front end (accde) linked to a back end (accdb). The back end databases are password protected. But...from all that I've read...

Greetings, I’ve linked to an Oracle table from an Access database (via ODBC). I would like to pull in the Oracle table ‘column comments’ into the Access table definition. I’m using Access 2010. In essence, I would like to populate the Access table column ‘description’ value with the...

I’m on a role. Another weird occurrence in Access. I’m attempting to use a form field as the source for a query filter criteria. Everything works fine if I simply use an “if equal” filter condition. As soon as I try a “like” condition, nothing works. I created a test table with just one...

Greetings, I’m trying to programmatically (without any user intervention) retrieve the “long path name” for a given file. It seems to me this should be a rather easy thing to achieve using Access VBA. I’ve tried using various FileSystemObject methods with no luck. I’ve Googled many variants...

Greetings, I created a query (in Access 2010) that joins several linked tables (to an Oracle database). The query runs in about 20 seconds when I filter with a “hard coded” date (e.g., #12/31/2014#). The Oracle table column I’m filtering on is defined as date/time. When I attempt to change...

Hi, I looked all over for a concise example of a DSN-less Oracle connection. I found many code snippets, some short, some quite lengthy, but nothing seems to work. I tried DAO, ADO, etc. I tried searching through Microsoft’s web sites and Access/Oracle user forums, but to no avail. What...

Hi, I've been working with Access for many years. I've hit just about every angle of the product. Most of my work has been in Access 2000/2003. I recently upgraded to Access 2010. I rely heavily on VBA (more flexibility/control). Jeff USA