Replies

Well, guess what? I’m having the same problem again. I can’t see my students on my Invoices by Student form! I tried recopying, and that doesn’t work either. I don’t know what’s going on. You see, I’m copying my database to each of my schools on their own servers. I goto my WorkingCopy.mdb file and then I right click and select Copy. I then go to the school server and Paste into a folder. Then I open up the mdb file on their server and go to Tools, Database Utilities, Link Manager and direct the links to the tables on their server instead of my server. I’m doing that correctly, aren’t I?

I’ll email you a copy of the database if you like, just let me know–because it’s much bigger than 100k and it’s a very complex database.

Well, of all the *%@#&%$!!! I just recopyed the database (front end) to the folder, and now it works. Go figure. Computers…grrrrrrrrr!!! Anyway, I can manage the appending if I copy and paste, so I’m going to do it that way.

Well, of all the *%@#&%$!!! I just recopyed the database (front end) to the folder, and now it works. Go figure. Computers…grrrrrrrrr!!! Anyway, I can manage the appending if I copy and paste, so I’m going to do it that way.

I went ahead and ran the code and had it stop on the “Me.Bookmark = Me.RecordsetClone.Bookmark”. I then opened up the CTRL+G window and typed what you told me. The value it was looking for first is “null”. Why is it null?

I’ll try and do a stripped-down version of my database, can’t promise anything, though because it’s quite complicated. But if I could just get the problem of not seeing my students solved, then I can live with the append problem.

I went ahead and ran the code and had it stop on the “Me.Bookmark = Me.RecordsetClone.Bookmark”. I then opened up the CTRL+G window and typed what you told me. The value it was looking for first is “null”. Why is it null?

I’ll try and do a stripped-down version of my database, can’t promise anything, though because it’s quite complicated. But if I could just get the problem of not seeing my students solved, then I can live with the append problem.

I think I figured out how to stop the code. When I hold the cursor over the code where it stopped (Me.Bookmark = Me.RecordsetClone.Bookmark) it says “Me.Bookmark=”. What does this mean?

I think I figured out how to stop the code. When I hold the cursor over the code where it stopped (Me.Bookmark = Me.RecordsetClone.Bookmark) it says “Me.Bookmark=”. What does this mean?

Could my problem appending be because my database is split? So when I run the append query, it tries to append the Student table from the front end, not that back end.

Could my problem appending be because my database is split? So when I run the append query, it tries to append the Student table from the front end, not that back end.

Pardon my dumb question, but how do you do that. I can’t remember–I did it once a while back.

Pardon my dumb question, but how do you do that. I can’t remember–I did it once a while back.

StudID is a text field.

StudID is a text field.

Awesome! It works great! Thank you.

Awesome! It works great! Thank you.