Editing Access 2000 Program imported from Access97

[Jack Bleich]

I am only adding 1 field in a table to create a new Billing report. The
form I used had no trouble and placed it in the new table, but when I Write
the Query the table does not show the new (very crucial) field. Is there a
solution?
The rest of the table which I copied & renamed is all there.

 

[Jeff Boyce]

Jack

If you are working in a "front-end" and trying to modify a table that is
located in a "back-end", you won't succeed. Is the table "linked" or is it
actually located in the file you are opening?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jack Bleich]

Jeff,

I, originally, did this billing inventory in 2001. The user now has Access
2000. While I retired after I wrote it the guy is my next door neighbor! I
have Office 2002 for my own use. I converted the old program to an .mdb in
2000. I changed very little in the tables. I copied one table that was
already present and added one field. "Discount" (currency with 2 "0"s.)

The Query takes every field ,but "Discount" Naturally, that field is the
whole reason for creating the table. All the programming including my new
changes works okay.

Jack

 

[Jeff Boyce]

Jack

So, you're saying that the query can't "see" the new field?

Have you tried "SELECT *" in a new query to see if you get your new field?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jack Bleich]

Well the problem was me. 2 files tables with similar names. I don't have
any more tables like that. NOW, My problem is that objects I'm trying to
change in VBA at the CLOSE of a report to indicate those records have been
printed are not marking the Boolean Field "True". Throughout the so called
development of this project they have been doing it. Now they're not.
I expect it is a DAO - ADO problem but the help files don't give me a grip
on the code necessary. And it may be something else.
IU wrote this application, originally in Access 97 in 2002. I quit
programming, but got Office Pro 2002 with my new computer in 2003. Used
Access to store Recipes. If I finish this I will return to digital
photography, which I'm supposed to be doing now.
Jack


















eend of report

 

[wqw]

Well the problem was me. 2 files tables with similar names. I don't have
any more tables like that. NOW, My problem is that objects I'm trying to
change in VBA at the CLOSE of a report to indicate those records have been
printed are not marking the Boolean Field "True". Throughout the so called
development of this project they have been doing it. Now they're not.
I expect it is a DAO - ADO problem but the help files don't give me a grip
on the code necessary. And it may be something else.
IU wrote this application, originally in Access 97 in 2002. I quit
programming, but got Office Pro 2002 with my new computer in 2003. Used
Access to store Recipes. If I finish this I will return to digital
photography, which I'm supposed to be doing now.
Jack


















eend of report