Change to a new table

[jon57]

I am trying to get my Access Report to use a new table. In design view, I change the Record Source to the new table name. I also change the table name in the Order By field. But it won't let me save the change. What am I doing wrong?

[ajetrumpet]

But it won't let me save the change.

what exactly does that mean?

perhaps you'd care to humor us with specifics?

[jon57]

what exactly does that mean?

perhaps you'd care to humor us with specifics?

After making my changes in design-view, when I attempt to X-out to check the result of said changes, it asks "do you want to save your changes?" I click YES, the box disappears, I try to X-out, the box comes back "do you want to save your changes?"... the only answer it will accept to let me out is "NO". Result: It won't let me save my changes.

[ajetrumpet]

care to upload the file so we can see this in action??

[jon57]

care to upload the file so we can see this in action??

I'm afraid I would need some instruction on how to do that. I am not very familiar with using help forums. Whadda ya need me to do?

[ajetrumpet]

the rules here are the same ones found in this thread: http://www.access-programmers.co.uk/...d.php?t=140587

[jon57]

the rules here are the same ones found in this thread: http://www.access-programmers.co.uk/...d.php?t=140587

Ok, I should probably back up a little. Had a new hard drive installed recently and thus a new image of XP and of Office. My old version was Access 2000. The new one is Access 2003. I had my files backed up to a stick and just reloaded them to the new version. Since the new stuff, every time I load the data base I get a window that says:

"An error occured while loading "report name"! Do you want to continue loading the project?"

I have been ignoring the message and responding YES. The report still works the same as it used to. And yes, the report in the message is the one I am trying to change.

The reason I am reminded to tell you this now is because when I attempted to follow your upload instructions and do a Compact and Repair, the same error message was displayed 3 times.

[ajetrumpet]

the error message doesn't matter jon. just get the file uploaded, if you can.

that to me, sounds like the same multiple error messages you'll get when opening a database that has broken links to DLLs in it. e.g. - you'll see:

MISSING reference to DLL ....... (ENTER)
MISSING reference to DLL ....... (ENTER)
MISSING reference to DLL ....... (ENTER)
MISSING reference to DLL ....... (ENTER)
MISSING reference to DLL ....... (ENTER)
MISSING reference to DLL ....... (ENTER)
MISSING reference to DLL ....... (ENTER)

but there's only one problem. There's not 7 problems, even that says you'll be pushing ENTER 7 times. same is probably true for you.

[jon57]

the error message doesn't matter jon. just get the file uploaded, if you can.

that to me, sounds like the same multiple error messages you'll get when opening a database that has broken links to DLLs in it. e.g. - you'll see:



but there's only one problem. There's not 7 problems, even that says you'll be pushing ENTER 7 times. same is probably true for you.

Here it is. Ask away.

[jon57]

Here it is. Ask away.

I am a little apprehensive showing this to you. I am LESS than a novice with Access. I just play with it until something works, no training. I am certain I am probably doing things in very primative ways and not using it's full functionality.

[ajetrumpet]

which report is it?

[jon57]

which report is it?

"Experimental Region-1 Field Notes" but I've been working with
"Copy of Experimental Region-1 Field Notes" they are of course the same.

[jon57]

"Experimental Region-1 Field Notes" but I've been working with
"Copy of Experimental Region-1 Field Notes" they are of course the same.

I've been trying to change the record source from "count station table" to "Statewide-B" but... well, you'll see.

[ajetrumpet]

I won't be getting back to you until later tonight, Jon.

If you get this solved before then, pls let us know.

[jon57]

I won't be getting back to you until later tonight, Jon.

If you get this solved before then, pls let us know.

I will. Thank you for your help so far.