Recent content by dmcdivitt

I think turning warnings on will be what fixes it. I didn't think of that.

This is what I think as well. Yes, warnings are turned off. I did experiment a bit following your suggestion. A form has a list. Double-clicking an item in the list opens the form I'm having an issue with. Before double-clicking I did F11 to open the database window. My debug form was off to...

It opens eight append queries, places the key to look up on the log in form so it can be referenced, opens the form, sets a bunch of values on the form, then runs a couple more update queries. When screwing with this in past I reduced the macro to just opening the form. The form would show when...

The form is bound to a recordset and all the fields are bound. It uses a bunch of text boxes, hidden on the log in form sitting at the bottom of the zorder. The sql has references to that form in the where clause. When the form opens it reads the correct record.

Unable to open from the database window since preparation must be done. But you have given me an idea. I can do the prep in code, then click on the form in the database window to see what happens. It probably will work, which won't help me any.

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...

You will need to download the registry files and add what additional file name extensions needed.

Attached is a vbscript to create a registry file for the active version of access. Save the file and rename the extension to .vbs.

Exported the following keys with 2000 active: HKLM\Access.Application.9, HKLM/Access.Application, HKLM\Access.MDBFile, HKLM\Access.MDEFile.9, HKLM\.mdb, HKLM\.mde, HKLM\CLSID\.{73A4C9C1-D68D-11D0-98BF-00A0C90DC8D9} Exported the following keys with 2010 active: HKLM\Access.Application.14...

I remote into an XP machine occasionally for access 97. Remoting into a machine takes longer than the install for 2010, so I'll stick with that. After seeing what registry keys need to be saved, I will post to this thread.

It is common practice to include columns in a table containing user ID and timestamp. These are easy to implement on a bound access form by adding hidden fields and setting their value with beforeinsert and beforeupdate events. With this information in the database a report can be made listing...

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 don't necessarily have to have SQL Server in the dropdown. I can link with code. But the driver is missing when I tried that. Cannot use ODBC in this case.

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...