Search results

I built an Access 2000 database when I had Windows 95. I have recently been upgraded to Windows 2000. Now when I run the database, I keep getting "Program Error" messages (particularly when running or designing reports but not exclusively) and then Access shuts down. From looking around at...

I can't figure out why this isn't working. I have a form called frmBookItems with a combo box called cmbTitle. The NotInList event looks like this: Private Sub cmbTitle_NotInList(NewData As String, Response As Integer) Dim strNewTitle As String If NewData = "" Then Exit Sub...

Thanks again! You wouldn't happen to know the names of any of those websites would you? I looked for something like that before I first posted my question but couldn't find anything.

Thank you so much for all the information. That really helps. If I did charge an hourly rate, what do you think is reasonable?

I may have an opportunity to create a custom Access database for someone, but I have absolutely no idea how much to charge. I have created several, complex databases from scratch, but I have never charged anyone for it, so I guess in figuring how much to charge, I would have to say that I have...

Thanks!

Is there a way (with code) to "copy" a row of a recordset and then "paste" it as a new record in the recordset? For example, you could do the following: Dim rst as new ADODB.Recordset Dim cn as ADODB.Connection Set cn as CurrentProject.Connection rst.Open "Address", cn, adOpenKeyset...

Thank you both. I am using Access 2000. Once it got stuck, I let is sit there for 45 minutes, and the status bar never moved. There are no left over temp tables, but I tried importing all of the objects to a new db anyway, and it didn't help.

Not really. For example, one of them that fails has a lot of controls and code, but another one that fails doesn't.

I have numerous forms in my database, and I am trying to use the Documenter. It does most of the forms just fine, but it hangs on certain forms and won't ever finish. I have to Ctl+Alt+Del to get out. I have used Compact and Repair database, and it doesn't say there are any errors. I tried...

In case anyone is interested... I have now installed the Microsoft Jet 4.0 Service Pack 6, and that seems to have fixed the problem.

I posted a similar question yesterday and got no assistance. I've done some more testing now, so I have more information. I hope I can explain the problem well. I have a form with text boxes bound to a table. When a user changes a value in a text box, closes the form, then reopens the form...

Not quite the same I don't think my problem is quite the same as yours. I have done some experimenting, and the problem only occurs if there is more than one user using the database. If there's only one user, everything works fine. Also, the problem is not with the combo boxes, it is with...

I have a form with text boxes and combo boxes bound to a table. When data is changed in a text box or combo box, it is not getting saved. It doesn't even save if I go under the File menu and choose Save Record. It doesn't save when I move to another record and back nor does it save when I...

O.K. That sounds like a good start, but I have no idea what to do.

I have a form (called SearchResults) that displays the results of a search based on text entered by the user in a form called Find. I would like the text entered by the user to be highlighted on each record in the field on the SearchResults form. I know how to do it by clicking a button but...

Thank you very much. I will try that.

I am trying to make a fairly complicated report. I have seen where people have had similar problems, but not exactly the same, so I can't find a solution. Here's the situation: Our organization is divided into what we call Offices, which are divided into Divisions, which are divided into...

Thank you so much. That was exactly what I was looking for.

Yes. I am trying to automatically select a Division when I choose a Section. Sections are within Divisions. Sorry for not giving more details. I guess I was trying to be too general. Anyway, I got it to work. Thanks again.