Search results

A messy application I am now responsible for, was made mostly with macros and very little code. It's a huge, unnecessarily complex application with a vast number of forms. As time goes on, I rewrite and delete. There is a form that was opened through a macro. In past when I converted the macro...

A user group has an ms access application with forms in a front end and database in a back end. But the front end is a compiled accde and they don't have the original. They've been using this for several years. Because they have too much data we said we would upscale to sql server, and made a...

I have to use both access 2000 and 2010. If 2000 was used last, when 2010 starts it does an install. The install doesn't take long, but it's a nuisance. It's more than just which version owns the mdb file extension. Other registry info is involved. When on an XP machine and I had this problem I...

I have a windows 7 machine with Access 2000 installed. I need to link to some tables on an SQL server and "SQL Server" does not appear in the dropdown of available link types. I forgot how to fix this. I think a driver is missing. I did a clean install of Office 2000 and only selected MS Access...

I have an issue with users of an access database. They've been using the database with access 2000 in multi-user mode for a long time. Their workstations were updated to windows 7 and access 2010. The application has bound controls on forms. With their new workstations they can only use the...

I'm pointing an Access 97 app to an SQL Server backend. Connections are of course ODBC. Since people will want to see the code I'll post it: Dim IntakeKey&, InCase$ IntakeKey = 3409 InCase = "1311-059" CurrentDb.Execute "INSERT INTO Intake (InUnique,InCase) VALUES (" & IntakeKey & ",""" &...

For Access 97 and Access 2000, what is the method to extract text for a form at the project level? This is an alternative to using Lines and CountOfLines on the module. It may be undocumented, I don't remember. Thanks

Sometime ago I wrote a VB6 program to launch the correct version of MS Access, depending on what version a file was made with. The program grabs all the MS Access file types when it loads and after a delay does the same again. Upon clicking an MS Access file type, the program reads the first 176...