The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
30 views

RegEx (or RegEx-like) validation rules?

I've built my own (crude) version control system for Access and I'm looking to validate the version number in my update log table. The version number should match the regular expression ...
0
votes
1answer
20 views

Enforce referential integrity with linked table

I'm currently constructing and maintaining a number of MS Access databases intended to replace paper document systems where I work. As part of this work I'm using simple username/password combinations ...
0
votes
0answers
37 views

Access Query: Matching days up days of the week for past years

I have historic data in a table in Microsoft Access from seven years ago. I need to create a query with a column for each year and match up in each row the 1st Monday in 2007 with the 1st Monday in ...
1
vote
1answer
789 views

Resolving “The Office System Pack cannot be installed on this system because the languages are not the same.” installation error

I've inherited some software that runs on the Access 2002 Runtime. I am taking over development and support. The installer halts with the following error message (installing on Windows XP): ...
0
votes
1answer
134 views

How do I choose a data source in Microsoft Access 2002

I'm getting the following error when I try to open a form with Microsoft Access 2002 as a front end to an SQL Server 2000 Database. "ODBC --connection to 'data source name' failed." I made a new ...
1
vote
1answer
293 views

Restore Access 2002 default font setting

I'm using Access 2002, and since a few days ago, my default font settings in the options have been lost. I mean that literally - the combobox for "default font" is empty. How can I get it back?