Search results

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

I cannot split the application into front end and back end. This particular user group proceeded to do their own thing and had someone create it for them. We will not take responsibility for it. The same thing happens if only one person is in the application. It still hangs when doing searches...

I understand about splitting the database. I mentioned everything is in the same file for a reason, to say it has not been split. I also said it was working well for a long time. This would not help my issue. We are not going to assume responsibility for maintaining the database or change it. I...

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

Thanks! Never had to use that before. Way back when, with ODBC, I always used runsql, but since started using execute. But execute has always failed without that. Maybe ODBC is different.

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 & ",""" &...