having a problem adding a record to a dbf file, is this possible?

i gave code that opens the dbf, adds a row of data and when i save it as the
dbf, the record is not there. but if i open it, change an existing record
and save it, it works fine.

just wondering if i'm chasing my tail.

--

Gary Keramidas
Excel 2003

If you didn't get an error there is 3 possibilities

1) You didn't get to the line where you are actually writing the data to the
database. Put a break point in the macro where you are writing the new data
by clicking on the line of the macro and pressing F9. See if you get to the
line you are expecting.
2) You wrote the data but you are not seeing it in the table. The table may
be filtered. Look at the raw data in the database tool like opening up
Access.. Also check the entire file for the record because to may of gotten
sorted or filtered. do a search using the Access of the database tool to
make sure it is not there.
3) You saved the file to another location on your PC and you are looking in
an older file
"Gary Keramidas" wrote:

having a problem adding a record to a dbf file, is this possible?

i gave code that opens the dbf, adds a row of data and when i save it as the
dbf, the record is not there. but if i open it, change an existing record
and save it, it works fine.

just wondering if i'm chasing my tail.

--

Gary Keramidas
Excel 2003

it doesn't even work when i do it manually, let alone through the code. like
i mentioned, changing a record works, so the file is not in a different
location. the dbf only shows 1 record in the statistics, so i know another
record never got added.
--

Gary Keramidas
Excel 2003


"Joel" wrote in message
...
If you didn't get an error there is 3 possibilities

1) You didn't get to the line where you are actually writing the data to
the
database. Put a break point in the macro where you are writing the new
data
by clicking on the line of the macro and pressing F9. See if you get to
the
line you are expecting.
2) You wrote the data but you are not seeing it in the table. The table
may
be filtered. Look at the raw data in the database tool like opening up
Access.. Also check the entire file for the record because to may of
gotten
sorted or filtered. do a search using the Access of the database tool to
make sure it is not there.
3) You saved the file to another location on your PC and you are looking
in
an older file
"Gary Keramidas" wrote:

having a problem adding a record to a dbf file, is this possible?

i gave code that opens the dbf, adds a row of data and when i save it as
the
dbf, the record is not there. but if i open it, change an existing record
and save it, it works fine.

just wondering if i'm chasing my tail.

--

Gary Keramidas
Excel 2003

If it doesn't work manually then the file must be protected. try copyiong
the file to your local drive that you know you have write permission and
agin try changing it manually. When you add an item manually does it get
added but the changes do not get saved? the file must be write protected.

"Gary Keramidas" wrote:


it doesn't even work when i do it manually, let alone through the code. like
i mentioned, changing a record works, so the file is not in a different
location. the dbf only shows 1 record in the statistics, so i know another
record never got added.
--

Gary Keramidas
Excel 2003


"Joel" wrote in message
...
If you didn't get an error there is 3 possibilities

1) You didn't get to the line where you are actually writing the data to
the
database. Put a break point in the macro where you are writing the new
data
by clicking on the line of the macro and pressing F9. See if you get to
the
line you are expecting.
2) You wrote the data but you are not seeing it in the table. The table
may
be filtered. Look at the raw data in the database tool like opening up
Access.. Also check the entire file for the record because to may of
gotten
sorted or filtered. do a search using the Access of the database tool to
make sure it is not there.
3) You saved the file to another location on your PC and you are looking
in
an older file
"Gary Keramidas" wrote:

having a problem adding a record to a dbf file, is this possible?

i gave code that opens the dbf, adds a row of data and when i save it as
the
dbf, the record is not there. but if i open it, change an existing record
and save it, it works fine.

just wondering if i'm chasing my tail.

--

Gary Keramidas
Excel 2003

when i add a record manually, save the file it saves fine. i then open it
with the dbf app, the record is not there. if i open the same file, change
data, it saves fine and when i open the dbf, the data is changed.

the file is not write protected.

--

Gary Keramidas
Excel 2003


"Joel" wrote in message
...
If it doesn't work manually then the file must be protected. try copyiong
the file to your local drive that you know you have write permission and
agin try changing it manually. When you add an item manually does it get
added but the changes do not get saved? the file must be write protected.

"Gary Keramidas" wrote:


it doesn't even work when i do it manually, let alone through the code.
like
i mentioned, changing a record works, so the file is not in a different
location. the dbf only shows 1 record in the statistics, so i know
another
record never got added.
--

Gary Keramidas
Excel 2003


"Joel" wrote in message
...
If you didn't get an error there is 3 possibilities

1) You didn't get to the line where you are actually writing the data
to
the
database. Put a break point in the macro where you are writing the new
data
by clicking on the line of the macro and pressing F9. See if you get
to
the
line you are expecting.
2) You wrote the data but you are not seeing it in the table. The
table
may
be filtered. Look at the raw data in the database tool like opening up
Access.. Also check the entire file for the record because to may of
gotten
sorted or filtered. do a search using the Access of the database tool
to
make sure it is not there.
3) You saved the file to another location on your PC and you are
looking
in
an older file
"Gary Keramidas" wrote:

having a problem adding a record to a dbf file, is this possible?

i gave code that opens the dbf, adds a row of data and when i save it
as
the
dbf, the record is not there. but if i open it, change an existing
record
and save it, it works fine.

just wondering if i'm chasing my tail.

--

Gary Keramidas
Excel 2003