Search results

  1. J

    Windows 2000/Access 2000

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

    Not in List Event

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

    Custom Access Database

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

    Custom Access Database

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

    Custom Access Database

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

    Copy Record

    Thanks!
  7. J

    Copy Record

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

    Documenter

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

    Documenter

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

    Documenter

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

    Please help

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

    Please help

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

    Records not saving

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

    Records not saving

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

    Select Text

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

    Select Text

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

    Problem with counting unique rows

    Thank you very much. I will try that.
  18. J

    Problem with counting unique rows

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

    Lookup

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

    Lookup

    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.
Back
Top Bottom