Replies

Thanks, Hans. I will give them a try.

Yes, it has been set to “No”. Unfortunately I can’t check to see if that’s the problem right away because I have to go the site. The database is linked to data on an SQL Server, so I can only go into Design View on my copy of the database. I’ll let you know as soon as I can get to the site to see if that is the problem.

Okay. When I enter something in the TransactionSubReceipt, the TransactionSubReceipt still does not show up.

I can open it now. Thanks, Hans. You’re awesome!

Well, we finally located the .mdw file and I can get into the database now. Thanks so much guys! But now I’m having a problem opening one of the forms. I’m creating a new post for that right now.

Well, yes I can get into the database….if I’m at the school using the secretary’s computer. But the problem is when I copy the database file to take home I can’t open that copy. It just says that I don’t have permission to use that file. That is where the biggest problem lies right now. I can’t open a copy of the database to work on fixing the problem at home.

Yes, it is the Access database that I’m trying to fix (I think). A student at a school did up this database to keep track of payments. The student has now since left. The school then had its SQL Server crash, and since then the Access database hasn’t worked right. Everything seems to work right on the SQL Server. Whenever they create a new customer, the invoice/payment entry box doesn’t show up. It shows up on the customers that have already had payments. I’m just trying to figure out where the problem lies–in the Access database or SQL Server. The student has secured this so tight that we are having nothing but problems trying to figure out what the problem is. We have the student’s login, but with his login it just gives access to the Access database design–not the data itself which is on the SQL Server. The secretary at the school has access to the database and the data, but cannot get to the Access database design. And it seems that the security has been done through the SQL Server because we can’t find a .mdw file anywhere.

But the database is in Access–the data itself is on the SQL Server. Something has gone wrong in the database. The invoice entry box is not showing up on the customer screen, so I wanted to take it home to see if I can fix it. Is that not possible???

Wow, I learn something new every day! Thanks, Francois.

For some reason I’m having a complete brain blockage! How do I format the number in Word? I can’t seem to find anywhere where it formats numbers.

Got it to work. Thanks again, Hans.

What if I have the page numbering as “1 of 3”? How would I do the “of 3” part of the numbering? The first part of the numbering is working great now, by the way.

Okay, now that I’ve made those corrections you suggested my database is running tickety-boo. Thanks, Hans.

Thanks, Hans and Zave. Works great! I was just missing the reference to the column.

Jen

Oops! Sorry. Here’s the tables.