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" <(E-Mail Removed)> wrote in message
news:B0120170-037D-4B36-9B17-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:B0120170-037D-4B36-9B17-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
news:41313952-04C4-4B83-9161-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:B0120170-037D-4B36-9B17-(E-Mail Removed)...
>> > 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
>> >>
>> >>
>> >>
>>
>>

The file you are writing is NOT the same file you are reading back. When you
open the file change the View to Detail before opening the file and check the
time stamp.

When you perform the SAVe to a SAVEAS and check the folder where the file is
being saved. then do a SAVEAS a 2nd time and again check the time stamp
before saving and see if the time stamp was correct for the file you saved.

"Gary Keramidas" wrote:

> 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" <(E-Mail Removed)> wrote in message
> news:41313952-04C4-4B83-9161-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
> >> news:B0120170-037D-4B36-9B17-(E-Mail Removed)...
> >> > 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
> >> >>
> >> >>
> >> >>
> >>
> >>
>
>

i've tried saving it to a new dbf file and that new file is always empty.
the timestamp is updated but there is no record in the dbf. there is no
record when i reopen it in excel, either.

what's weird is that if i save it, i get the dbf warning and then the save
dialog. then when i immediately click close, i get another warning before
another save dialog. since i saved it, excel should just close.

--

Gary Keramidas
Excel 2003


"Joel" <(E-Mail Removed)> wrote in message
news:C81157B5-8CF9-4151-B4D9-(E-Mail Removed)...
> The file you are writing is NOT the same file you are reading back. When
> you
> open the file change the View to Detail before opening the file and check
> the
> time stamp.
>
> When you perform the SAVe to a SAVEAS and check the folder where the file
> is
> being saved. then do a SAVEAS a 2nd time and again check the time stamp
> before saving and see if the time stamp was correct for the file you
> saved.
>
> "Gary Keramidas" wrote:
>
>> 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" <(E-Mail Removed)> wrote in message
>> news:41313952-04C4-4B83-9161-(E-Mail Removed)...
>> > 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" <(E-Mail Removed)> wrote in message
>> >> news:B0120170-037D-4B36-9B17-(E-Mail Removed)...
>> >> > 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
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>>
>>

I don't think I cann solve this problem. I would make sure you have all the
updates to the database software installed on your PC. Check for this
problem on the web or with the database manufacturer.

Go to Google.com and perform the following search

dbf not saving

"Gary Keramidas" wrote:

> i've tried saving it to a new dbf file and that new file is always empty.
> the timestamp is updated but there is no record in the dbf. there is no
> record when i reopen it in excel, either.
>
> what's weird is that if i save it, i get the dbf warning and then the save
> dialog. then when i immediately click close, i get another warning before
> another save dialog. since i saved it, excel should just close.
>
> --
>
> Gary Keramidas
> Excel 2003
>
>
> "Joel" <(E-Mail Removed)> wrote in message
> news:C81157B5-8CF9-4151-B4D9-(E-Mail Removed)...
> > The file you are writing is NOT the same file you are reading back. When
> > you
> > open the file change the View to Detail before opening the file and check
> > the
> > time stamp.
> >
> > When you perform the SAVe to a SAVEAS and check the folder where the file
> > is
> > being saved. then do a SAVEAS a 2nd time and again check the time stamp
> > before saving and see if the time stamp was correct for the file you
> > saved.
> >
> > "Gary Keramidas" wrote:
> >
> >> 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" <(E-Mail Removed)> wrote in message
> >> news:41313952-04C4-4B83-9161-(E-Mail Removed)...
> >> > 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" <(E-Mail Removed)> wrote in message
> >> >> news:B0120170-037D-4B36-9B17-(E-Mail Removed)...
> >> >> > 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
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >>
> >>
>
>

i may have this working. instead of adding the data to a new row at the end,
i insert row 2( row 1 are the dbf field names), paste the data in row 2 and
save it and it seems to be working.

--

Gary Keramidas
Excel 2003


"Joel" <(E-Mail Removed)> wrote in message
news:C95D614F-3D1F-4181-821F-(E-Mail Removed)...
>I don't think I cann solve this problem. I would make sure you have all
>the
> updates to the database software installed on your PC. Check for this
> problem on the web or with the database manufacturer.
>
> Go to Google.com and perform the following search
>
> dbf not saving
>
> "Gary Keramidas" wrote:
>
>> i've tried saving it to a new dbf file and that new file is always empty.
>> the timestamp is updated but there is no record in the dbf. there is no
>> record when i reopen it in excel, either.
>>
>> what's weird is that if i save it, i get the dbf warning and then the
>> save
>> dialog. then when i immediately click close, i get another warning before
>> another save dialog. since i saved it, excel should just close.
>>
>> --
>>
>> Gary Keramidas
>> Excel 2003
>>
>>
>> "Joel" <(E-Mail Removed)> wrote in message
>> news:C81157B5-8CF9-4151-B4D9-(E-Mail Removed)...
>> > The file you are writing is NOT the same file you are reading back.
>> > When
>> > you
>> > open the file change the View to Detail before opening the file and
>> > check
>> > the
>> > time stamp.
>> >
>> > When you perform the SAVe to a SAVEAS and check the folder where the
>> > file
>> > is
>> > being saved. then do a SAVEAS a 2nd time and again check the time
>> > stamp
>> > before saving and see if the time stamp was correct for the file you
>> > saved.
>> >
>> > "Gary Keramidas" wrote:
>> >
>> >> 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" <(E-Mail Removed)> wrote in message
>> >> news:41313952-04C4-4B83-9161-(E-Mail Removed)...
>> >> > 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" <(E-Mail Removed)> wrote in message
>> >> >> news:B0120170-037D-4B36-9B17-(E-Mail Removed)...
>> >> >> > 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
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>>
>>

Did you find the solution at Google?

"Gary Keramidas" wrote:

> i may have this working. instead of adding the data to a new row at the end,
> i insert row 2( row 1 are the dbf field names), paste the data in row 2 and
> save it and it seems to be working.
>
> --
>
> Gary Keramidas
> Excel 2003
>
>
> "Joel" <(E-Mail Removed)> wrote in message
> news:C95D614F-3D1F-4181-821F-(E-Mail Removed)...
> >I don't think I cann solve this problem. I would make sure you have all
> >the
> > updates to the database software installed on your PC. Check for this
> > problem on the web or with the database manufacturer.
> >
> > Go to Google.com and perform the following search
> >
> > dbf not saving
> >
> > "Gary Keramidas" wrote:
> >
> >> i've tried saving it to a new dbf file and that new file is always empty.
> >> the timestamp is updated but there is no record in the dbf. there is no
> >> record when i reopen it in excel, either.
> >>
> >> what's weird is that if i save it, i get the dbf warning and then the
> >> save
> >> dialog. then when i immediately click close, i get another warning before
> >> another save dialog. since i saved it, excel should just close.
> >>
> >> --
> >>
> >> Gary Keramidas
> >> Excel 2003
> >>
> >>
> >> "Joel" <(E-Mail Removed)> wrote in message
> >> news:C81157B5-8CF9-4151-B4D9-(E-Mail Removed)...
> >> > The file you are writing is NOT the same file you are reading back.
> >> > When
> >> > you
> >> > open the file change the View to Detail before opening the file and
> >> > check
> >> > the
> >> > time stamp.
> >> >
> >> > When you perform the SAVe to a SAVEAS and check the folder where the
> >> > file
> >> > is
> >> > being saved. then do a SAVEAS a 2nd time and again check the time
> >> > stamp
> >> > before saving and see if the time stamp was correct for the file you
> >> > saved.
> >> >
> >> > "Gary Keramidas" wrote:
> >> >
> >> >> 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" <(E-Mail Removed)> wrote in message
> >> >> news:41313952-04C4-4B83-9161-(E-Mail Removed)...
> >> >> > 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" <(E-Mail Removed)> wrote in message
> >> >> >> news:B0120170-037D-4B36-9B17-(E-Mail Removed)...
> >> >> >> > 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
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >>
> >>
>
>